| |||||||||||||
Hstore and transactionsHstore and transactionsPosted Sep 22, 2010 19:39 UTC (Wed) by gera (guest, #43819)Parent article: PostgreSQL 9.0 arrives with many new features
I've never really used Postgres, so this might not be a very intelligent question to those who have - but do transactions work with Hstores?
As in:
- can a multiple Hstore changes be bundled in a transaction with the usual transaction semantics (rollbacks etc.)?
- can a transaction contain usual relational as well as Hstore changes?
If so, this is a big deal. IIRC none of the other document databases or key-value stores provide transactions.
(Log in to post comments)
Hstore and transactions Posted Sep 22, 2010 20:27 UTC (Wed) by schabi (subscriber, #14079) [Link]
AFAICS, hstores are "just another plug-in datatype" like so many others (XML datastore and PostGIS geometries, for example).
So the hstore column is like a string, text or anything else part of the normal transaction mechanism.
Hstore and transactions Posted Sep 23, 2010 9:48 UTC (Thu) by gera (guest, #43819) [Link]
Thanks. I'll try out Postgres soon then!
Hstore and transactions Posted Sep 25, 2010 22:41 UTC (Sat) by mfedyk (guest, #55303) [Link]
"If so, this is a big deal. IIRC none of the other document databases or key-value stores provide transactions."
couchdb does have ACID capability. you just need to model your data so each transaction is one document. a document is either there or not there.
|
|||||||||||||