Hi Ken,
Yes, so far, it's overlap, but the direction I want to take is
different, I hope I can elucidate this clearly:
My goal is not to build a wide, flexible, powerful library for
experts, like libdb, that extends the Rev DB functions, but instead,
to build a narrow library framework (only for MySQL), that dictates
exactly how the programmer should set up cards and controls, so that
80% of data-intensive app development is much faster and easier.
Then, customize to taste with libdb or write custom handlers.
It's main functions will be:
1. CRUD
2. repeating groups
The next step to complete is a process like the following:
1. drag controls onto a card
2. right click each control, and a popup stack lets you point and
click (to assign custom properties to each field) that map that field
to the database, (e.g., table name, row name)
3. Then, edit/update/delete functions are automatically added
4. Then, you define a rectangle, and the record group repeats in a
big scrolling group if desired.
Really, I am looking to emulate FileMaker's "Layout" view.
I also want to make the process of building multi-table join queries
visual and intuitive.
The problem with my jjSQL library so far, and libdb, is you still
have to fill in the variables manually and feed them to the handlers,
I am looking to automate this part of the process also.
Eventually, I would like to race a FileMaker developer to put
together a basic multiuser, multitable data app and tie or come in
very close!
Okay, why not just use FileMaker you ask?
1. Well, last time I checked (years ago), the process of getting the
database on a remote server so anyone could access seemed like a real
pain, I can set up a fast MySQL db in a minute or two and it's ready
to go. MySQL is multi-threaded and handles tens of millions of
records and users easily (maybe FM does this now too, not sure!) (And
MySQL's free!)
2. Along with data, if you also want other functions, like ftp,
graphic and video functions, and to build a standalone app, Rev is
much better than FM.
The reason I am posting this early in my dev process is that I'm
still very slow and if a few other folks wanted the same thing, we
could team up and work together on it, I need help on some simple
ways to do things, I am still doing some things the long way 'round!
I will post more on this when I can, in the meantime, if anyone else
wants to collaborate on a library for this purpose, email me off list.
Thanks,
Josh
On Jun 19, 2006, at 10:45 PM, Ken Ray wrote:
On 6/19/06 1:29 PM, "Josh Mellicker" <[EMAIL PROTECTED]> wrote:
I am working on a library of handlers that I hope will make the
process of creating a Revolution client that interacts with a remote
MySQL database as easy and quick to code as possible, and eventually
add some elements making working with Rev similar to FileMaker.
Josh, I don't mean to throw any water on your efforts, but have you
looked
at Trevor Devore's libDatabase? It sounds to me like there's a lot of
overlap:
http://mangomultimedia.com/developer/revolution/
Just a thought...
Ken Ray
Sons of Thunder Software
Web site: http://www.sonsothunder.com/
Email: [EMAIL PROTECTED]
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
