Jim Dodgen wrote: > On Fri, Jul 10, 2009 at 9:16 PM, Bill Harris < > bill_har...@facilitatedsystems.com> wrote: > > > I have to coordinate a task list between two sites, and my only > > convenient connection between the two is email. MS Access 2007 offers > > an email insert and update feature, but it's not quite doing what I > > need. > > > > Is there a way to update / synchronize an sqlite database between two > > sites successfully using email? I could even see having a copy at both > > sites and periodically emailing the slave version to the master and then > > running a merge of some sort, but I'm not sure that would do what I > > need. > > > > Thoughts? > > Thanks, > > Bill > > not beyond the realm of possibilities. I back up via email, a nice > protocol. > > I dump > tar > gzip > and email a small but important database to 6 people > each day via a cron job. > > I don't remember exactly how but on unix boxes I have created user accounts > that receive emails automatically > and then process them. I think this was done with .forward files.
you could also send individual sql statements via email but email doesn't always arrive. that is a major problem. you would need an acknowledgement and retry mechanism. perhaps there's an april fool's RFC for implementing TCP/IP via email :) once you've got that sorted, you'll need to make sure that the updates are digitally signed and probably encrypted and verify the signatures at the recipient's end. and i'm only half joking :-) cheers, raf p.s. i think .forward files only forward all messages. procmail is probably what you need to invoke arbitrary commands to process messages matching your criteria. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
