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