> On Mar 26, 2017, at 11:37 PM, Hick Gunter <h...@scigames.at> wrote: > > I think this kind of problem (transfer of information between cooperating > processes) is best solved using the tools designed for inter-process > communication and not attempting to abuse a DB system designed to isolate > processes from unfinished changes.
Generally I agree … but to play devil’s advocate: SQLite already has a degree of interprocess communication using shared memory (the “-shm” file). It might be simple to extend this to provide a very lightweight change counter, by atomically incrementing an integer field in this shared memory. A process could then poll this with almost no overhead. (I’m sure the answer is “implement it and send a patch”, which is as it should be. I don’t have any experience with the SQLite source base, though, so it would probably take me longer to get up to speed on that, than it would for me to reach for an IPC tool I already know how to use, like CFNotificationCenter. Oh well.) —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
