PackageDescription: StoreForSqlite(Bundle)


Store For Sqlite

Last published: June 29, 2004 by 'gjdvgj'


Convenience bundle for Sqlite, Sqlite.Exdi and Sqlite.Store

(c) 2003, 2004 by Juergen Gmeiner. Licensed under the LGPL

Inspect 'Gjdv.LesserGnuPublicLicense instance license' for license terms.

Thx to Brucer Badger for PostgreSQLServerBroker and PostgreSQLDriverLicense

---------------------------------------------------------------------------------------------------------------------
WARNING:

this works for me with sqlite 2.8.6. there was a very strange bug
with 2.8.13 + 2.8.14. basically, max(rowid) + 1 consistently returns
'000' for tables with 99 rows or more. i switched to using
max(rowid + 1) to generate primary keys for the store db.
this is slower for big databases, but works.

weirdest of all is i cannot reproduce this behaviour with
an equivalent c program.

personally, i am still running my store database with 2.8.6.
---------------------------------------------------------------------------------------------------------------------

Install instructions/current versions may be found at:

http://www.gjdv.at/v2/en/oss/vwsqlite.xhtml

---------------------------------------------------------------------------------------------------------------------

TODO:

- SqliteAssist has some DDL helpers (add column!) that will have to be coded as
(analyse table, copy table, drop table, re-create with added column)