Important

Changed from subversion to mercurial.

Get involved

Looking for developers. Please send any report or improvenment.

SQLite is a small & beautifull sql engine. Also, is the choice for store & manage data on iPhone SDK projects.

With chibi-ORM is possible to have a object-relational layer for your database in Objective-c.

You are not force to use this ORM for everything. Go down to direct SQL acces if your wish.

FMResultSet *rs = [db load:@"SELECT 1"];

With the limitations on the iPhone plataform, is important have freedom to off-load hevy data manipulation on your database.

You are free to desing the database almost as you wish. The chibi-ORM layer only ask you to:

All tables that are to be mapped must have a autonumeric field called 'Id'.
All tables that are to be mapped must have a date field called 'timeStamp'.
For one-to-many, call the field like 'IdCustomer' (ie: Id + table name of the many side)
If wanna soft-deletes, add a BOOL field 'isDeleted'

That's all.

Add your views, triggers and anything you like freely.

Take a look: tutorial

ChibiORM is use in http:///www.bestsellerapp.com, a iPhone/iPad point of sale (POS) with flexible & fast syncronization support to almost any ERP.