QuickLite 1.5.6

QuickLite already includes SQLite, so theres 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.
Main features:
- Updated with SQLite 3.2.2
- Data integrity check provided by SQLite
- Datatype support includes QLString, QLNumber, QLBoolean, QLDateTime, and QLContainer
- Better data caching: CacheAllData, CacheOnDemand, or DoNotCacheData
- QuickEdit: insert, edit, and remove rows without a single SQL statement, the OOP-way
- In-cursor data matching
- Set operations on cursors
- 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.
Enhancements:
QuickLiteDatabase
- New: Added a new convenient class method + (NSString*)escapeQuotesFromString:(NSString*)string;
- Modified: Removed the following methods:
- - (NSArray*)columnsForTemporaryTable:(NSString*)table;
- - (NSArray*)indexedColumnsForTemporaryTable:(NSString*)table;
Now theyre merged with the following calls:
- - (NSArray*)columnsForTable:(NSString*)table
- - (NSArray*)datatypesForTable:(NSString*)table
- - (NSArray*)indexedColumnsForTable:(NSString*)table
- - Bug fix: - (BOOL)updateValues:(NSArray*)values forColumns:(NSArray*)columns withRowUID:(NSNumber*)rowUID inTable:(NSString*)table now accepts NSNull as a possible value
QuickLiteCursor
- - Modified: - (NSString*)description display a brief summary of the cursor
- - New: - (NSString*)fullDescription shows a more detailed report about the entire cursor
- - New: - (NSString*)fullDescription:(unsigned long)numberOfRows shows a more detailed report for the first n rows
- - Bug fix: The cursor always registered itself as modified when calling - (BOOL)setValue:(id)value forColumn:(NSString*)tableAndColumn, even though no changes may have occurred.
Other
- - Better error checking
- - More code cleanup.