[Plone-IT] RelStorage
luigi scarso
luigi.scarso a gmail.com
Lun 26 Gen 2009 13:15:09 UTC
Presso
http://wiki.zope.org/ZODB/RelStorage
Q: Can I perform SQL queries on the data in the database?
A: No. Like FileStorage <http://wiki.zope.org/ZODB/FileStorage> and
DirectoryStorage <http://wiki.zope.org/ZODB/DirectoryStorage>,
RelStorage<http://wiki.zope.org/ZODB/RelStorage>stores the data as
pickles, making it hard for anything but ZODB to
interpret the data. An earlier project called Ape attempted to store data in
a truly relational way, but it turned out that Ape worked too much against
ZODB principles and therefore could not be made reliable enough for
production use. RelStorage <http://wiki.zope.org/ZODB/RelStorage>, on the
other hand, is much closer to an ordinary ZODB storage, and is therefore
much safer for production use.
Questo e' chiaro:
si usa postgres per lo storage pickles, ma solo ZODB lo capisce;
un agente esterno che non conosce nulla di ZODB probabilmente legge garbage.
Ma piu' sotto , verso la fine, si parla di
CouchDB
e la risposta mi sembra del tipo "si puo' fare anche in plone" :
So, once ZODB objects (pickles) are stored as native
PostgreSQL<http://wiki.zope.org/ZODB/PostgreSQL>data types, indexing
is already there, in several forms, ready for access
via PostgreSQL <http://wiki.zope.org/ZODB/PostgreSQL>'s native SQL API.
That, plus PostgreSQL <http://wiki.zope.org/ZODB/PostgreSQL>'s native array
data type, is an invitation to reveal what true Object Publishing is all
about.
Add PostgreSQL <http://wiki.zope.org/ZODB/PostgreSQL>'s clustering /
replication, and
CouchDB?<http://wiki.zope.org/ZODB/RelStorage/createform?page=CouchDB>has
somewhat less to offer as a "unique" solution.
just another $.02 Jerry S.
con riferimento implicito
http://blog.melhase.net/articles/2006/06/06/a-tale-of-postgresql-types-and-python
Qualcuno ha esperienza su RelStorage ?
--
luigi
-------------- parte successiva --------------
Un allegato HTML è stato rimosso...
URL: <http://lists.plone.org/pipermail/plone-plone-it/attachments/20090126/0a428347/attachment.html>
Maggiori informazioni sulla lista
Plone-IT