Hi Andrew,<br><br><div class="gmail_quote">On Thu, Feb 5, 2009 at 5:02 PM, Andrew Berry <span dir="ltr"><<a href="mailto:andrewberry@sentex.net">andrewberry@sentex.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Has anyone looked into version compatibility between the different versions of sqlite? For example, on the same ISP, one server I checked has sqlite2, the other has sqlite3. Neither server has both drivers installed. Neither server actually has the sqlite binaries installed, though I assume that isn't common, but worth checking on other SQLite supporting hosts.</blockquote>
<div><br>Drupal 7 only supports SQLite 3, that is the only version supported by PDO.<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
The SQLite site mentions using the command line tools to dump and restore the DB, and I haven't found anything about doing that from pure PHP. This probably wouldn't be an issue for caches and such, since an incompatible DB can just be recreated. I could see it causing headaches for "Drupal Lite" scenarios.</blockquote>
<div><br>Pure-PHP solutions (like the Backup and Migrate module) should work in that scenarios. This module is easy enough to install.<br><br>Damien<br></div></div><br>