Using the Amalgamation DLL, I'd like to know if there is a function that is exposed when any WRITE function to the database happens on a per connection basis, a call back to my program (Delphi - Tokyo and Berlin) will happen and I can act on the results. I don't think I'll be concerned about the kind of write (Insert vs Delete for example) as I'll need to change the database anyways to prepare for this kind of functionality.
I'm *DREAMING* for a way to allow for an application level notification system that when a write to the database is performed from anywhere in my code, the application will eventually perform a dump of differences, then transmit those differences a server (If available). When clients 'call home' they get the differences and apply the changes locally. The wrapper I use has no knowledge of SELECT vs INSERT, it just passes on the command. The goal I want to attain is I can take my application to an 'offline' mode of sorts, or, use it 'online' and changes are reflected in clients that are also 'online'. When that 'offline' machine comes back, it pushes its changes to a server, and the other 'online' clients catch up. If there is no such function right now, no problem. I can probably come up with another route instead of a call back function. - I'm not opposed to building my own DLL if there's a compile directive required to turn this on, just prefer not to as then I'd have to build an infrastructure to build the newest releases. (To be honest, been kind of looking to do that anyways, that might be the push) - I'm fully aware that I'll have to work through sync issues (IE: I delete a record while online, and the 'offline' machine tries to write information about that record, etc). _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
