[development] RE: [Drupal feature] Sqlite port

Tadej Baša tadej.basa at gmail.com
Wed Aug 2 23:03:40 UTC 2006

tachyonxv at psiforum.co.uk pravi:
> I have a test site at http://atlantean.5gigs.com running what should be the latest version of this. I have been busy with non-Drupal stuff and maintaining Drupal installs. It might be an idea to dump all failed queries via trigger_error() into the log for SQL debugging purposes.
> @I've put some effort into modifying/adopting jenseng's [1] ALTER TABLE support for sqlite. The code is a mess and I still have to check if it can actually run a Drupal database update, but it's a start...
> [1] http://code.jenseng.com/db/
> I've seen that code mentioned before and that’s about the only way to do it, due to the lack of any alter table support.
> I think the cache gets corrupted under some circumstances, though I am not sure what does that.
> The majority of the SQL should be working, or at least enough to make it useable. I did do as test run on a local install with apache bench and with a few simultaneous clients Sqlite is noticeably slower than MySQL, though it is still reasonably responsive.
> If you have any ideas or test code, I might be able to test it locally. I am not intending on taking this into core, unless its works correctly and its performance is decent.
> TachyonXV

I'm currently in the process of rewriting all the updates. I'll post 
patches or at least some success reports when I'm done.


More information about the development mailing list