[development] db_encode_blob

[Tadej Baša]

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 at 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
>