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 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
