Yes, I know that an sqlite layer has already been written. This was also the key factor why I've chosen to use Drupal over Mambo (or whatever else). I've built my first site on 4.5.0+sqlite (www.planinsko-drustvo-ng.si). Now I think it's time to upgrade. The old .sqlite.inc doesn't work with 4.7, so I'm trying to rewrite it. My original question was not about sqlite, but "why db_encode_blob() is not used". I know there are a lot of queries in core which are sqlite unfriendly :) (even more in contrib...). The problem in cache_set() was the first one to appear. I'm just asking if this was done on purpose (http://drupal.org/node/10796, http://drupal.org/node/41335) Tadej Karoly Negyesi pravi:
On Sun, 05 Mar 2006 12:16:43 +0100, Tadej Baša <tadej.basa@gmail.com> wrote:
I'm trying to write sqlite support for Drupal and I noticed, that fields of type blob don't get encoded with db_encode_blob, e.g. in bootstrap.inc: function cache_set. Is this OK (because it's causing problems for sqlite) ? Regards Tadej
Hi!
SQLite support for Drupal is done -- I have written the first one to understand the DB layer more. However... which SQLite? 2.x is not good enough (SELECT x FROM y JOIN z will return x.y instead of x) and 3.x has only PDO support which is PHP core only since 5.1. This has been raised over and over.
Also, while writing database.sqlite.inc is definitely possible, there is the issue of maintanence..
Regards
NK