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 <ratta...@gmail.com> 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 for another process to > > get notified of changes to the database. That is, other than polling, > > or a side channel independent of SQLite. > > Depends on the type of RPC. SQLite makes a pretty good message queue
Err... make that IPC. We all know SQLite for RPC doesn't work that well. > system, since clients can read/write/disconnect/reconnect at will, > and the transaction system makes it all safe and sound. > > > If polling produces acceptable speed, where one applicatoin can react > to changes made by the other in a 10 to 15 secnod window, the best > bet is likely to be PRAGMA user_version. > > http://www.sqlite.org/pragma.html#pragma_schema_version > > -j > > -- > Jay A. Kreibich < J A Y @ K R E I B I.C H > > > "Intelligence is like underwear: it is important that you have it, > but showing it to the wrong people has the tendency to make them > feel uncomfortable." -- Angela Johnson > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users