January 14th, 2010New features:
· Busy handlers support added (-r768).
· Support of temporary and in memory databases added (-r842).
· Support of virtual tables in schema added (-r847).
· SqlJet OSGi bundle and source tarball available from the web site (-r876).
API changes:
· New runtime prerequisite added: all cursors must be opened within active transaction (-r709).
· New method SqlJetDb.refreshSchema() added to the public API (-r698).
· SqlJetTransaction mode enum and ISqlJetMutex interface moved to the public API (-r858, -r852, -r845).
Bugfixes:
· Database is locked only when it is actually needed, not on opening (-r773).
· Performance improvements (-r846).
· Schema: Quoted identifiers are properly processed now (-r819, -r848).
· Schema: NULL column constraint supported (-r818).
· Calling SqlJetDb.open(...) after SqlJetDb.close() didn't work, fixed (-r842).
· Javadoc updates (-r839, -r845).
· Better error message on schema parsing failure (-r844).
· Exception is thrown now on lexer error when parsing schema (-r854).
November 26th, 2009New features:
· DB schema: IF NOT EXISTS statement support added (-r631, -r648)
· DB schema: ALTER statement support and corresponding API methods added (-r677)
· Affinity mode for column types (issue #75) (-r653)
· New ISqlJetCursor methods to get row count, current row and go to row (issue #92) (-r652)
· New ISqlJetCursor.setLimit(...) method (issue #92) (-r701)
· New insert and update methods with ON CONFLICT statement logic support (-r702)
· Performance optimizations.
Bugfixes:
· Fields size was stored in db schema as x.x (float numbers), fixed (-r637)
· NPE in SqlJetMemPage.clearCell fixed (issue #112) (-r649)
· Problems using case mismatching names of tables and indices fixed (-r674, 679, 700)
· Table and indices names with '$' was not supported, fixed (issue #116) (-r765)