QuickLite 1.5.6 review

QuickLite already includes SQLite, so there's no need to download and to configure.

License: Freeware OS: Windows Vista / 7 / 8 / 10 File size: 1822K Developer: Tito Ciuro Price: $0.00 Updated: 07 Nov 2005

0

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.

Here are some key features of "QuickLite":
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.

What's New:
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 they're 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.