Re: [sqlite] notify all processes of database modification

On Mon, 10 Feb 2020 at 12:53, Simon Slavin wrote: > On 10 Feb 2020, at 4:26am, Rowan Worth wrote: > > > See also PRAGMA data_version when it comes to polling the DB, the return > value of which changes when another process modifies the DB. IIRC the > implementation of this depends on a value in

Re: [sqlite] notify all processes of database modification

On 10 Feb 2020, at 4:26am, Rowan Worth wrote: > See also PRAGMA data_version when it comes to polling the DB, the return > value of which changes when another process modifies the DB. IIRC the > implementation of this depends on a value in the DB header page, so it may be > sufficient to only

Re: [sqlite] notify all processes of database modification

On Sat, 8 Feb 2020 at 04:02, Jens Alfke wrote: > > On Feb 7, 2020, at 6:23 AM, Kees Nuyt wrote: > > > > Anyway, SQLite doesn't have such a mechanism by itself. > > Maybe inotify is useful to you : > > > > https://en.wikipedia.org/wiki/Inotify < > https://en.wikipedia.org/wiki/Inotify> > >

Re: [sqlite] notify all processes of database modification

> On Feb 7, 2020, at 6:23 AM, Kees Nuyt wrote: > > Anyway, SQLite doesn't have such a mechanism by itself. > Maybe inotify is useful to you : > > https://en.wikipedia.org/wiki/Inotify > http://man7.org/linux/man-pages/man7/inotify.7.html >

Re: [sqlite] notify all processes of database modification

On Fri, 7 Feb 2020 00:13:00 -0700 (MST), you wrote: > The documents are no longer available, can you kindly share it to my mail. > I'll be extremely thankful to you. Mail is aliahmadqureshi...@gmail.com You are probably following up a posting of about 10 years ago. Most of us do not have that

Re: [sqlite] notify all processes of database modification

The documents are no longer available, can you kindly share it to my mail. I'll be extremely thankful to you. Mail is aliahmadqureshi...@gmail.com -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list

Re: [sqlite] notify all processes of database modification

(Arggg!!! Second try sending this; first attempt seems to have been truncated. If you don't see my signature at the end of this one, it got truncated again.) > Hi, > I have two processes connecting to a database. Both can modify database. When > some process modify database, I want the other

Re: [sqlite] notify all processes of database modification

> Hi, > I have two processes connecting to a database. Both can modify database. When > some process modify database, I want the other to be notified (so, it can > reload data). > Currently, I use unix sockets, so a process can notify all listener process > that something has changed. But I wonder

Re: [sqlite] notify all processes of database modification

> That is, other than polling, . Yep, that trick. (Why does everyone dismiss polling...don't we have any embedded programmers here? Hey Windows CE guy, don't raise your hand...) Roger summed it up, and labeled it correctly (crappy). But if it works sufficiently for him, why not

Re: [sqlite] notify all processes of database modification

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/15/2010 08:02 PM, Igor Tandetnik wrote: > That's just polling, really. SQLite's busy handler tries to access the > database, sleeps a little, tries again, sleeps again, and so on. It's not > "woken up" the way, say, a thread waiting on a mutex

Re: [sqlite] notify all processes of database modification

On Tue, Jun 15, 2010 at 09:47:23PM -0500, Jay A. Kreibich scratched on the wall: > On Tue, Jun 15, 2010 at 09:48:53PM -0400, Igor Tandetnik scratched on the > wall: > > Rich Rattanni wrote: > > > The creator of SQLite actually gave a talk about using an SQLite > > > database

Re: [sqlite] notify all processes of database modification

Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 06/15/2010 06:48 PM, Igor Tandetnik wrote: >> Well, what trick? There is no way I know of for another process to get >> notified of changes to the database. That is, other than >> polling, or a

Re: [sqlite] notify all processes of database modification

On Tue, Jun 15, 2010 at 09:48:53PM -0400, Igor Tandetnik scratched on the wall: > Rich Rattanni wrote: > > The creator of SQLite actually gave a talk about using an SQLite > > database as a means for IPC (it was available on youtube, maybe you > > can find it). If you want an

Re: [sqlite] notify all processes of database modification

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/15/2010 06:48 PM, Igor Tandetnik wrote: > Well, what trick? There is no way I know of for another process to get > notified of changes to the database. That is, other than polling, or a side > channel independent of SQLite. One way I have

Re: [sqlite] notify all processes of database modification

Rich Rattanni wrote: > The creator of SQLite actually gave a talk about using an SQLite > database as a means for IPC (it was available on youtube, maybe you > can find it). If you want an 'sqlit-ish' way, why not use that trick? Well, what trick? There is no way I know of

Re: [sqlite] notify all processes of database modification

The creator of SQLite actually gave a talk about using an SQLite database as a means for IPC (it was available on youtube, maybe you can find it). If you want an 'sqlit-ish' way, why not use that trick? One advantage of using SQLite is that debugging / backtracing becomes easier. Since your

Re: [sqlite] notify all processes of database modification

arno wrote: > I have two processes connecting to a database. Both can modify database. When > some process modify database, I want the other to be notified (so, it can > reload data). > Currently, I use unix sockets, so a process can notify all listener process > that something

[sqlite] notify all processes of database modification

Hi, I have two processes connecting to a database. Both can modify database. When some process modify database, I want the other to be notified (so, it can reload data). Currently, I use unix sockets, so a process can notify all listener process that something has changed. But I wonder if there's