[development] SQLite and Drupal 7 -- third coming

[Karoly Negyesi]

Hi,

Every morning, I am distilling the discussion.

*) SQLite is not supported. If you have Drupal 5.2 and PDO which are
already requirements then you have SQLite unless it's explicitly
disabled and so far noone was able to answer the challenge at
http://drupal4hu.com/node/177 . It's embedded into PHP so "supporting"
it is like supporting the SimpleXML extension. Unlike MySQL where you
need to run a separate server, here we have an embedded SQL engine
right inside PDO. Also note that if we want (and I think we want)
easier and more powerful install profiles then we will require SQLite
for the install anyways.

*) Deployment and rebuild. As it stands, now I believe that Drupal
should be able to boot up enough to be able to copy the tables from
MySQL to SQLite. I am not saying I am expecting it to be functional.
After the tables are copied back into SQLite, it should either restart
the bootstrap process or reload at the same URL. This solves
deployment.

*) Why do I want this? Once again, nicer code, especially for caching.
Various pluggable subsystems (cache, session and path being the
biggest wins here)  will just work instead of ugly hacking. But in
general, instead of trying to figure out during bootstrap coding "do
we have a DB connection yet" the answer is always yes.

Kind regards

NK