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, 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
- Updated with SQLite 3.0.7
- 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
- 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
More info here: QuickLite Overview page
QuickLite 1.0 Features
- 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
You can download the latest version here.