QuickLite is a Cocoa wrapper for SQLite, a C library that implements an embeddable SQL database engine.
QuickLite already includes SQLite, so there's no need to download and to configure. It provides the developer with a SQL database without running a separate RDBMS process. QuickLite is not a client library used to connect to a big database server. QuickLite is the server, reading and writing directly to and from the database files on disk.
QuickLite 1.5 is here!
Since version 1.0 was released in May 2004, a lot of effort has been made to improve QuickLite's feature set. Work has been done on all fronts: cleaning up the API, improving performance, decreasing memory footprint and adding cool new features.
New features in QuickLite 1.5
- Mac OS X 10.4 Tiger compatible
- Updated with SQLite 3.2.2
- New transaction support: Deferred, Immediate and Exclusive modes
- Data integrity check provided by SQLite
- Datatype support includes QLString, QLNumber, QLBoolean, QLDateTime, and QLContainer
- Better data caching: CacheAllData, CacheOnDemand, or DoNotCacheData
- QuickEdit: add, edit, and remove rows without a single SQL statement, the OOP-way
- In-cursor data matching finds rows matching specific values
- Set operations on cursors: union, minus and intersection
- Support for attached databases
- Save and revert supported, database-wide and on a cursor-by-cursor basis
- Distributed notifications, Fast User Switching-aware, sent when a commit action takes place
- Debugging facilities to observe all SQL statements executed, as well as tracing QuickLite methods
- Lots of optimizations
• Objected-oriented
• Easy to use
• Just 3 classes to deal with: QuickLiteDatabase, QuickLiteCursor, and QuickLiteRow
• Data file compaction
• Includes introspection methods to access table names, column names, indexes, etc.
• Includes utility methods to create and drop tables, add and remove columns, insert data, and more!
• Access to SQLite's last error ID and associated error string
• BLOB support
New QuickLite mailing list
A mailing list has been set up for asking questions and for open discussion of problems and issues by the QuickLite user community. Please join this mailing list by visiting the QuickLite Users page.
