Version 1.5.6 - November 6, 2005

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

Version 1.5.5 - June 30, 2005

QuickLiteCursor:
- Bug fix: using QuickEdit, setting a column value on a row without RowUID would raise an exception. This has been fixed.
- Bug fix: if SQLite returned a <null> value for a QLDateTime column, QuickLite would raise an exception. This has been fixed.

Version 1.5.4 - June 21, 2005

General
- Mac OS X 10.4 Tiger compatible
- Updated with SQLite 3.2.2
- Full column support is now enforced. For more info, check this message.
- Code cleanup.


QuickLiteDatabase:
- New: '(NSString*)sqliteVersion' returns the SQLite version being used.
- New: '(NSString*)databaseEncoding' returns the database encoding being used.
- New: '(NSArray*)tableInfo:(NSString*)table' returns information about each of the columns in the named table, including the column name, data type, whether or not the column can be NULL, and the default value for the column.
- Bug fix: BLOB encoding fixed.
- Bug fix: QLString columns are now enforced to be of type TEXT. For more info, check this message.
- Modified: We now use NSProcessInfo to get process info.


QuickLiteCursor:
- Bug fix: using QuickEdit, a newly inserted row which hadn't been yet saved could not be modified. It's now fixed.
- Bug fix: BLOB encoding fixed.

Version 1.5.3 - December 14, 2004

QuickLiteDatabase:
- New: - (NSDictionary*)allTables. Returns all tables per available database, including QuickLite's.
- New: - (BOOL)deleteRowsWithValue:(id)value forColumn:(NSString*)column inTable:(NSString*)table;

- Modified: In SQLite version 3, when a schema change occurs, SQLite automatically rereads the schema, and tries again. Therefore, there is no reason to reopen the database as was needed in version 2. Other processes listening to the notification sent by QuickLite will update the schema cache automatically.
- Modified: - (NSNumber*)lastRowInserted. It used to return an NSString.
- Modified: - (BOOL)deleteRowWithUID:(NSNumber*)rowUID inTable:(NSString*)table. RowUID is now an NSNumber.
- Modified/Bug fix: - (NSArray*)datatypesForTable:(NSString*)table. This fixes the accidental schema reordering which made copyTable: fail.

- Bug fix: - (NSArray*)columnNamesForTable:(NSString*)table.
- Bug fix: - (BOOL)copyTable:(NSString*)src toTable:(NSString*)dst. Now works with in-memory databases.
- Bug fix: The following methods didn't allow to set values as [NSNull null]:
- (BOOL)insertValues:(NSArray*)values forColumns:(NSArray*)columns inTable:(NSString*)table;
- (BOOL)insertRowWithValues:(NSArray*)values forColumns:(NSArray*)columns;


QuickLiteCursor:
- New: - (BOOL)boolValueForColumn:(NSString*)tableAndColumn andRow:(unsigned long)rowIndex;
- New: - (BOOL)removeAllRowUIDsAtIndexes:(NSArray*)rowIndexes. Removes *all* UIDs referenced in the row at the specified indexes. The indexes must be objects of type NSNumber.
- New: - (NSDictionary*)deletedRowUIDs. Obtain the deleted rowUIDs. It returns a dictionary with the affected tables (key) and a unique set (value) with all rowUIDs marked for deletion.

- New: Matching rows family of methods. You can find the first match for a given column starting at a given index, or obtain a series of row indexes which contain a given value in a given column. The new methods are:
- (unsigned long)matchingRowWithValue:(id)value forColumn:(NSString*)tableAndColumn;
- (unsigned long)matchingRowWithValue:(id)value forColumn:(NSString*)tableAndColumn startAtIndex:(unsigned long)index;
- (unsigned long)matchingRowWithValue:(id)value forColumn:(NSString*)tableAndColumn startAtIndex:(unsigned long)index comparisonMethod:(unsigned)method;
- (NSArray*)matchingRowsWithValue:(id)value forColumn:(NSString*)tableAndColumn;
- (NSArray*)matchingRowsWithValue:(id)value forColumn:(NSString*)tableAndColumn comparisonMethod:(unsigned)method;
- (NSArray*)matchingRowsWithValues:(NSArray*)values forColumn:(NSString*)tableAndColumn;
- (NSArray*)matchingRowsWithValues:(NSArray*)values forColumn:(NSString*)tableAndColumn comparisonMethod:(unsigned)method;

- New: Perform set operations between two cursors.
*** IMPORTANT ***:
1) Only one table must be referenced in any of the two cursors
2) The same table must exist in the two cursors
3) The ROWUID column must be present in the two cursors
If the result set is empty, an empty cursor is created. Otherwise, a new cursor is created with the ROWUIDs referenced. In an error occurs, nil is returned. The new methods are:
- (QuickLiteCursor*)unionCursor:(QuickLiteCursor*)cursor;
- (QuickLiteCursor*)unionCursor:(QuickLiteCursor*)cursor cacheMethod:(QLCacheMethod)cacheMethod;
- (QuickLiteCursor*)minusCursor:(QuickLiteCursor*)cursor;
- (QuickLiteCursor*)minusCursor:(QuickLiteCursor*)cursor cacheMethod:(QLCacheMethod)cacheMethod;
- (QuickLiteCursor*)intersectCursor:(QuickLiteCursor*)cursor;
- (QuickLiteCursor*)intersectCursor:(QuickLiteCursor*)cursor cacheMethod:(QLCacheMethod)cacheMethod;

- Bug fix: - (NSArray*)valuesForColumn:(NSString*)tableAndColumn.
- Bug fix: Queries with result sets involving non-schema columns didn't return the results properly. Example: such as 'Select count(*) from address;'.
- Bug fix: RowID columns are correctly instantiated as NSNumber now.
- Bug fix: QuickEdit didn't allow to set values as NULL.


QuickLiteRow
- New: - (BOOL)boolValueForColumn:(NSString*)tableAndColumn;


Miscellaneous
- Modified: Better support for dates. The NSCalendarDate now contains the sub-second info. Be careful when comparing dates. For more info, see: http://developer.apple.com/documentation/Cocoa/Conceptual/DatesAndTimes/Tasks/ComparingDates.html
- Updated source comments.
- Improved error reporting.

Version 1.5.2 - October 26, 2004

Updated with SQLite 3.0.8
BLOBs are now stored in a SQLite-compliant form.
Added '- (BOOL)close' to QuickLiteDatabase. When closing the database, it will save or discard the changes, depending on the settings. See also the method 'setSavesChangesWhenClosingDatabase'. The method '- (BOOL)closeSavingChanges:(BOOL)flag' is still available for backward compatibility reasons.
Added '- (void)setSavesChangesWhenClosingDatabase:(BOOL)flag' and '- (BOOL)savesChangesWhenClosingDatabase' to QuickLiteDatabase. It allows to specify whether any changes made through QuickEdit should be saved when closing the database. By default the value is 'YES'.
Added three new methods to support DEFERRED, IMMEDIATE, AND EXCLUSIVE transaction modes, introduced in SQLite 3.0.8:
- (BOOL)beginDeferredTransaction
- (BOOL)beginImmediateTransaction
- (BOOL)beginExclusiveTransaction
The original method - (BOOL)beginTransaction' is still available for backward compatibility reasons and calls 'beginDeferredTransaction'.
Fixed a deallocation bug, which is related to a bug found in QuickLiteCursor as well.
Added support for empty cursors. Valid SELECT and PRAGMA queries returning no matches will generate an empty cursor. This allows the developer to start with an empty cursor and use QuickEdit to insert data directly into the cursor.
Changed the signature of the following method for consistency reasons:
Before: - (BOOL)insertRowWithValues:(NSArray*)values andColumns:(NSArray*)columns
After: - (BOOL)insertRowWithValues:(NSArray*)values forColumns:(NSArray*)columns.
Fixed a bug that didn't correctly detect when a transaction was in effect. Performance in 'save' operations (both via QuickLiteDatabase and QuickLiteCursor) has been vastly improved.
Updated QuickLiteCursor and QuickLiteRow '- (NSString*)description' to recognize empty cursors.
More code cleanup.
Better error reporting.
A couple of memory leaks found and fixed.

Version 1.5.1 - October 12 + 1, 2004

Removed the 'QLDatatype' typedef from QuickLiteGlobals, since it's intended for private use.
Added '- (NSArray*)columnsForTable:(NSString*)table' to QuickLiteCursor, which obtains a list of all columns of a table referenced in the cursor.
Added the following methods to QuickLiteCursor:
- (int)intValueForColumn:(NSString*)tableAndColumn andRow:(unsigned long)rowIndex;
- (long long int)longLongValueForColumn:(NSString*)tableAndColumn andRow:(unsigned long)rowIndex;
- (double)doubleValueForColumn:(NSString*)tableAndColumn andRow:(unsigned long)rowIndex;
- (const unsigned char*)textValueForColumn:(NSString*)tableAndColumn andRow:(unsigned long)rowIndex;
If the cursor has been created using DoNotCacheData, the following methods can be used to quickly access their scalar values, effectively avoiding the creation of NS-type objects. If CacheDataOnDemand has been used to create the cursor, the object may be already in the cache. In this case the scalar is returned from the cached object.
Fixed the following bugs in QuickLiteDatabase:
- (NSArray*)valuesForColumn:(NSString*)tableAndColumn
- (NSDictionary*)valuesForRow:(unsigned long)rowIndex
Both methods didn't return the proper values when using 'DoNotCacheData'.
Added '- (QuickLiteCursor*)performQuery:(NSString*)sqlQuery cacheMethod:(QLCacheMethod)cacheMethod;' to QuickLiteDatabase, which allows to specify the cursor's cache method that could be generated from the query. This method differs from '- (QuickLiteCursor*)performQuery:(NSString*)sqlQuery;', which honors the cache method set at the time the database was opened. Please note that if the query doesn't involve a PRAGMA or SELECT, the cache method is ignored because it is irrelevant in this case.
Added '- (NSString *)QLP_UUIDString', a wrapper around CFUUID. You can use this method to create your own unique UUID.
Added the following methods to QuickLiteRow:
- (int)intValueForColumn:(NSString*)tableAndColumn;
- (long long int)longLongValueForColumn:(NSString*)tableAndColumn;
- (double)doubleValueForColumn:(NSString*)tableAndColumn;
- (const unsigned char*)textValueForColumn:(NSString*)tableAndColumn;
If the cursor has been created using DoNotCacheData, the following methods can be used to quickly access their scalar values, effectively avoiding the creation of NS-type objects. If CacheDataOnDemand has been used to create the cursor, the object may be already in the cache. In this case the scalar is returned from the cached object.
More optimizations and code cleanup.

Version 1.5 - September 30, 2004

Updated with SQLite 3.0.7, considered stable and ready for production use.
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.

Replaced the remaining sqlite3_exec() calls with sqlite3_prepare/sqlite3_step/sqlite3_finalize.
Depending on the query, QuickLiteCursor was duplicating the data set (in memory, not on disk). This bug has been fixed. For more info, check the thread '[QuickLite] Re: Left outer join return duplicates in SQLiteManagerX'.
Moved sqlite3_finalize() around so that it's only called after sqlite3_prepare() has returned SQLITE_OK.
QuickLiteRow has a new accessor: (unsigned int)index, to find out the cursor index which the row represents.
Fixed a bug in QuickLiteDatabase: -(NSArray*)datatypesForTable:(NSString*)table, which could lead to a crash.
Fixed a bug in [QuickLiteDatabase insertValues: forColumns: inTable] which could report the wrong column when a column's datatype doesn't match with the incoming datatype.
Since QuickLite 1 treated all data elements as strings (remember, SQLite version 2 is type-less), I used to treat ROWIDs as strings too. Moving to QuickLite 1.5, I forgot to treat it as a number. Now, the ROWID is instantiated as an NSNumber.
Queries such as 'SELECT * FROM Files, Folders where Files.FolderID = Folders.ROWID;' were not working as expected. For more info, check the thread '[QuickLite] Re: Left outer join return duplicates in SQLiteManagerX'.
A new accessor has been added to QuickLiteDatabase: -(BOOL)isInDebugMode;
SQLiteManagerX's results tableView was not displaying data in columns after encountering a column with a null value in it. This has been fixed: when NULL is obtained from the database, it is cached (if it applies) as an NSNull. So, calling any flavor of 'valueFor...' or 'valuesFor...' will always return valid objects. To test against NULL, you'll have to compare it with [NSNull null].
SQLiteManagerX has been updated with two new controls: 'Debug' and 'Send SQL statements'. These two settings can be applied on-the-fly, that is, without having to reopen the database. Remember that 'Send SQL statements' setting works in conjunction with QuickListener, also found in the Examples folder.
Cleaned up a bit more. Removed old, obsolete code.

For more info, check the QuickLite Overview page. QuickLite 1.5 is officially out, so please join the QuickLite mailing list and share your comments, ideas, bugs or hints! Your input is greatly appreciated.

Version 1.0.1 - May 30, 2004

Version 1.0 - May 26, 2004

Initial public release.

Acknowledgements

	- Kolbjørn Aambø
	- Jens Alfke
	- Jason Bell
	- Aaron Burghardt
	- Dan Grassi
	- Colin Gray
	- Amy Kurtzman
	- Josh Morris
	- Demitri Muna
	- Philip Riggs
	- Eric Tremblay