[horde] VFS inoperable when changing from SQL to NoSQL driver

Arjen de Korte arjen+horde at de-korte.org
Wed Sep 11 18:37:24 UTC 2013


Citeren Michael M Slusarz <slusarz at horde.org>:

> Quoting Arjen de Korte <arjen+horde at de-korte.org>:
>
>> I was just wondering if there was something obvious I forgot to do.  
>> Apparently not. Since the SQL backend is working fine here, I'm in  
>> no hurry to switch to NoSQL, so I'll leave it alone. I just vaguely  
>> remember that NoSQL was suggested to be a better option for VFS  
>> than SQL (can't remember the reason), so I figured I might try that  
>> out.
>
> NoSQL datastores are explicitly designed to handle this kind of  
> large, blob-ish data.  In a sense, NoSQL was sort of designed as a  
> "smarter" filesystem - i.e. data storage that allows for more  
> complex queries in retrieving.
>
> SQL was designed more on the principles of relational calculus.   
> Storage of large data is sort of an afterthought add-on (and varies  
> widely between the database providers).  SQL's advantage when it  
> comes to complex queries across multiple tables.

That was indeed what I remembered from a message to the mailinglists  
(can't remember which) a couple of months ago. Having said that, the  
problem seems to have been resolved by magic. I just tried changing  
VFS from SQL to NoSQL again and this time it worked without a hitch.  
Weird.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 308 bytes
Desc: PGP digitale ondertekening
URL: <http://lists.horde.org/archives/horde/attachments/20130911/ac804418/attachment.bin>


More information about the horde mailing list