Re: [Zope-dev] Transactions support on MySql
Ping wrote:
1. From what I read, Zope supports transactions. If I want to use MySql as my backend database, can Zope still support atomic operations since MySql does not support transactions?
Evan wrote: Zope will still support transactions on *Zope objects*. Your MySQL database will not participate in the transaction, so all SQL statements executed will remain in effect even if the Zope transaction aborts. You might be able to handle this with explicit logging in MySQL, if the changes aren't too complicated.
Another alternative I have in mind is using ZODB to store my business objects. Has anyone used ZODB as the backend? How stable is it? In terms of doing query, does Zope have a similar SELECT statement in RDBM? Regards, Ping
On Mon, 27 Sep 1999, Ping Lau wrote:
Another alternative I have in mind is using ZODB to store my business objects. Has anyone used ZODB as the backend? How stable is it?
Very stable (I have used it for more than 2 years). In terms
of doing query, does Zope have a similar SELECT statement in RDBM?
No it does not have a SELECT statement or any other relational constracts. However depending on the structure of your site you might not need many queries (for instance if your model is hierarchical, it will map nicely on ZODB). If you do, you can always use ZCatalog to 'index' your objects depending on whatever criteria you choose and then you can query for given attributes/contents Pavlos
Ping Lau wrote:
Ping wrote:
1. From what I read, Zope supports transactions. If I want to use MySql as my backend database, can Zope still support atomic operations since MySql does not support transactions?
...
Another alternative I have in mind is using ZODB to store my business objects. Has anyone used ZODB as the backend? How stable is it? In terms of doing query, does Zope have a similar SELECT statement in RDBM?
If you can choose your DB, then why not use one that has transactions ? Have you checked PostgreSQL (http://www.postgresql.org/), it has more complete SQL support, including transactions. It is slower than MySQL on simple queries, about same or faster on more complex ones. ------ Hannu
participants (3)
-
Hannu Krosing -
Pavlos Christoforou -
Ping Lau