You could write a virtual table extension that performs pre-image (in the xUpdate method) or after-image (in the xCommit method) logging of write transactions to a CSV file or even an SQL Logfile.
The biggest challenge would be writing the xBestIndex function to properly return an optimal execution plan. Parsing the result of "explain query plan" may or may not be an option. It also depends on the SQL statements used for updates. If you only use "UPDATE <table> SET <field-value-list> WHERE <primary key>" then it would be relatively simple. Gunter -----Ursprüngliche Nachricht----- Von: dd [mailto:durga.d...@gmail.com] Gesendet: Montag, 10. Dezember 2012 06:45 An: General Discussion of SQLite Database Betreff: Re: [sqlite] table backup Sometimes, sqlite databse corrupts. So, I want to take online backup of specific table. Not entire database. Any best solution? On Sun, Dec 9, 2012 at 11:29 PM, Roger Binns <rog...@rogerbinns.com> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 09/12/12 10:35, dd wrote: > > i mean, for every write operation in a table. > > You should specify some of your other constraints and exactly what it is > you are trying to achieve (*not* how you are trying to achieve it). > > The solutions range from implementing undo by using triggers to save old > values, through using a virtual table that backs up data somewhere else. > > The SQLite backup API only works on the whole database. > > Roger > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.11 (GNU/Linux) > > iEYEARECAAYFAlDE5poACgkQmOOfHg372QQI8gCeP6GfezJUWQ7M3pdfvvgc2FCp > J1QAoMSM/tbpxlicrrDpTbgjHAsWln1d > =mPMA > -----END PGP SIGNATURE----- > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -------------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: h...@scigames.at This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
