QuickLite is a Cocoa wrapper for SQLite, a C library that implements an embeddable SQL database engine. It's easy and powerful, object-oriented, offers full cursor access, datatype support (QLString, QLNumber, QLBoolean, QLDateTime, and QLContainer), distributed notifications, data file compaction, data integrity check, debugging facilities, includes introspection methods to access table names, column names, indexes, etc. Also 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. and more!
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
- 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.