[Qt-interest] Sql Driver: support for backup and restore SQL-Lite commands

[Asa Ben-Tzur]

Hi,

I am porting code from TCL/Tk to Qt. The code uses sqlite database in-memory (using ":memory" special name). The code loads/stores the in-memory database to file using the sqlite TCL API commands "backup" and "restore". This commands are also available in sqlite shell (".backup" and ".restore"). However, they seem to be missing in Qt sqlite driver implementation.
So, how do I load/store the in-memory DB from/to sqlite file? Note that using the on-file DB at run time is very slow when the sqlite file resides on the network.

One option I have considered is extending the sqlite driver provided with Qt distribution to support backup/restore, and the using it as a custom driver. Any other suggestions ?

Thanks
  Asa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20100608/ab3c14c2/attachment.html