Re: [sqlite] load extension -- unload hook?

2009-08-30 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sub sk79 wrote: > 1. Is it possible to register a callback which is invoked on database close? There is a hacky way of finding out when a particular db is closed. Register a collation with an unused name (eg "_AX1") and provide an xDestroy

Re: [sqlite] ANN: SQLite 3.6.16.C#

2009-08-30 Thread Filip Navara
On Sat, Aug 29, 2009 at 9:51 PM, Yves Goergen wrote: > On 01.08.2009 16:19 CE(S)T, Noah Hart wrote: >> This is not a driver, dll, or wrapper.  This is a port of the underlying >> SQLite software. > > Hm, yes, but isn't the other C# SQLite assembly also the entire DB >

Re: [sqlite] BUG in SQLite? Still the rowid question

2009-08-30 Thread Wanadoo Hartwig
Am 30.08.2009 um 17:56 schrieb Kit: > 2009/8/29 Wanadoo Hartwig : >> The largest and last row id is 4. Why is SQLite returning 5? I think >> it has to do with the FTS3 module but still the trigger statement >> should shield the row ids from the trigger statement, or?

[sqlite] load extension -- unload hook?

2009-08-30 Thread sub sk79
Hi, When we load an extension it invokes sqlite3_extension_init(). Lets say, in addition to creating functions, the loaded extension library also does some internal data structure allocations, initializations etc here. Now, when the database is closed the loaded extension needs to do cleanup.

Re: [sqlite] BUG in SQLite? Still the rowid question

2009-08-30 Thread Kit
2009/8/29 Wanadoo Hartwig : > The largest and last row id is 4. Why is SQLite returning 5? I think > it has to do with the FTS3 module but still the trigger statement > should shield the row ids from the trigger statement, or? > Hartwig CREATE TABLE Simple (ID integer