Everyone has played around with the database classes built-in to REALbasic and most of us have complained. Don't take me wrong, they do the job and they do it well, but I think we're in need of a new Database API. Easier to use and better integrated into RB.
With that said, we have started work on a new Database API. We've got the base class down (CFDatabaseBase) and we've also started work on a subclass to be used with MySQL (CFMySQL).
Here are some of the cool things about this new API:
- Very easy to subclass and implement for other databases (in plugins or rb).
- Uses delegates instead of events (More about this in the download).
- Has a built in threaded and non threaded querying system.
- No RecordSet or DatabaseField. We use db.ResultCount and db.ResultAtIndex.
- Tuples are returned as dictionaries of Column/Value.
- lot's more...
Take it for a spin and tell us what you think.
Plugin available below.
Download CFDatabasePlugin 0.1 (804KB)