[ANN] Objective-SQL, january 28th release

FROM : Martin-Gilles Lavoie
DATE : Tue Jan 28 18:30:01 2003


What is MObjectiveSQL

MObjectiveSQL is a simple set of classes that provide high-level,
flexible SQL database storing and retrieval services.

In short, it makes any Objective-C class derived from MObjectiveSQL a
SQL table that's automatically handled in a SQL database.

WHAT'S NEW:

The original piece of code, at the origin of the open-sourced version,
was merged with the open-sourced Objective-SQL package. Now, the very
same source file set is used to build the sample code (provided in this
package) and a private (larger) project.

In previous releases, the package assumed a single SQL Transport,
SQLite, although it could be used with multiple ones. This was due to
the ObjectiveSQLDatabase class actually assuming (and using) a local
on-disk database file.

Check out the SampleDB source files for sample code that makes use of
an on-disk database (using SQLite as transport mechanism). The base
class, ObjectiveSQLDatabase, queries it's descendant to know weither or
not it needs to create the SQL tables in the database, with the

   - (bool) theDBExists;

method. A default implementation is provided (returning NO), but it's
probably not what you want if you're accessing this database for the
first time (aka, creating it). The ObjectiveSQLDatabase class will take
care of calling your subclass to create the SQL tables as appropriate.

Objective-SQL now has true separation of it's SQL transports from the
database.

Enjoy!

Bulk of the features:

   - High-level classes for even simpler setup and operation
   - Transport-neutral architecture
   - Derived classes are automatically exported as SQL tables
   - Search functions returning NSArray* of your class instances from
corresponding
   SQL table;
       + Single specific object (first match)
       + Array of objects that match criteria
       + Object ranges
   - Object proxy ID generation and retrieval through NSString category
       (aka, fully relational cross-table references)
   - Per-class (aka, per table) object cache
   - Hassle-free, complete no-download distribution (all you need is
included)
   - Global, per-table manual object cache

The Objective-SQL package is, regardless of it's smallness, is a solid
package. I am using it successfully as part of a much larger project.

Where

   You can obtain the original archive at this address:

       http://homepage.mac.com/mouser/

   You can reach me directly at

       <email_removed>

   for questions, comments or else.

Enjoy!

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Martin-Gilles Lavoie
<email_removed>