jjSQL handlers

Josh Mellicker josh at dvcreators.net
Tue Jun 20 14:19:57 EDT 2006


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" <josh at dvcreators.net> 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: kray at sonsothunder.com
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution




More information about the use-livecode mailing list