[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