I have two applications that access the same database and that can run
at the same time. If changes are made to the database by one
application, I would like the other application to update its display
to reflect the change. The total_changes() function only works from a
single connexion so
On Fri, 13 Dec 2013 23:19:55 + (UTC)
Will Parsons varro@nodomain.invalid wrote:
I have two applications that access the same database and that can run
at the same time. If changes are made to the database by one
application, I would like the other application to update its display
to
On 13 Dec 2013, at 11:19pm, Will Parsons varro@nodomain.invalid wrote:
The total_changes() function only works from a
single connexion so doesn't help here, and it appears there is no API
to access to the file change counter that's kept in an SQLite3 database.
You're right. There's no good
On Sat, Dec 14, 2013 at 5:46 AM, Simon Slavin slav...@bigfraud.org wrote:
On 13 Dec 2013, at 11:19pm, Will Parsons varro@nodomain.invalid wrote:
The total_changes() function only works from a
single connexion so doesn't help here, and it appears there is no API
to access to the file
On 14 Dec 2013, at 10:57am, Richard Hipp d...@sqlite.org wrote:
More complicated than that: The change counter in the header does not get
updated in WAL mode.
Ah. Would there be a way to do it in WAL mode ? An analogous counter in the
WAL journal file ? Or perhaps it could be implemented
http://sqlite.org/faq.html#q1
CURRENTLY:
(If the largest possible integer key, 9223372036854775807, then an unused
key value is chosen at random.)
SUGGESTED FIX:
(If the largest possible integer key 9223372036854775807 is in use, then
an unused key value is chosen at random.)
On Sat, Dec 14, 2013 at 7:00 AM, Kevin Benson kevin.m.ben...@gmail.comwrote:
http://sqlite.org/faq.html#q1
CURRENTLY:
(If the largest possible integer key, 9223372036854775807, then an unused
key value is chosen at random.)
SUGGESTED FIX:
(If the largest possible integer key