[sqlite] how to detect when a table is modified ?

I just have a question about the function : void *sqlite3_update_hook( sqlite3*, void(*)(void *,int ,char const *,char const *,sqlite3_int64), void* ); what is the last void* ? is it a pointer to a user data structure ? regards, Nicolas J.

[sqlite] how to detect when a table is modified ?

Hi Roger Binns and R. Smith, > Is the database being modified from within the same process, or from > outside? for that program I consider within the same process. > > The update hook will tell you (most of the time) about changes within > the same connection (ie if you are making the changes):

[sqlite] SQLite crash

I observed the sqlite command shell version 3.8.11.1 to crash (exit to the OSwithout an error message) while running in a Cygwin shell under Windows 7 when I tried to create anindex.? The source was compiled by gcc 4.9.2. ?The same type of crashhappened when I tried the operation from a Lua

[sqlite] how to detect when a table is modified ?

Hi, I'm writing a program using sqlite3 and gtk to screen a database, there is a way to get a signal from sqlite3 when something is modified inside a database (values, add/delete row...), in the way to update what the program has to screen ? otherwise, any idea how I can do something similar ?

[sqlite] how to detect when a table is modified ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/07/2015 04:23 PM, Nicolas J?ger wrote: > I'm writing a program using sqlite3 and gtk to screen a database, > there is a way to get a signal from sqlite3 when something is > modified inside a database (values, add/delete row...), in the way > to

[sqlite] MMAP performance with databases over 2GB

On 08/07/2015 12:35 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 08/06/2015 09:27 AM, Dan Kennedy wrote: >>> Is it using more CPU cycles in mmap mode or just taking longer? >>> If the former, does [time] attribute them to "user" or "system"? > It is taking

[sqlite] MMAP performance with databases over 2GB

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/07/2015 02:55 AM, Dan Kennedy wrote: >> http://www.sqlite.org/src/info/3a82c8e6cb7227fe > >> Does that improve performance any in your case? I tested 3a82c8e6 (fix above) against e596a6b6 (previous changeset), in both cases starting with an

[sqlite] Determine query type

Hi Stephan Ben and all, by the way: checking the column count only applies to SQLite. Other databases (Postgres, Oracle) support the insert into returning or update ... returning syntax, resulting in statements that change the database and have columns at the same time. This is a feature

[sqlite] Read data from database slow the first time but then very fast thereafter. How can I improve the speed for the first time read?

On Thu, 6 Aug 2015 10:17:43 -0500, John McKown wrote: > Too bad that SQLite does not implement updatable views. Sometimes a similar construct as updatable views can be obtained with an INSTEAD OF trigger. -- Regards, Kees Nuyt

[sqlite] MMAP performance with databases over 2GB

On 08/06/2015 09:53 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > In my testing I am finding that using SQLite's mmap support with > larger databases (final db size is ~10GB) to create the database (WAL > mode) is considerably (about three times) slower than no mmap.