On Wednesday 22 June 2005 04:09 pm, Eloff wrote: > Hi Paul, > >You're doing what every serious database implementation needs to do ... > >Are you sure you don't want to just use an RDBMS? > > It was considered, but we decided that abstracting the data into tables > to be manipulated with SQL queries is substantially more complex for > the programmer and way too expensive to the system since the average > action would require 20-100 queries.
I realize you've probably already made a decision on this, but this sounds like a classic argument for using an *object DBMS*, such as ZODB: It certainly does support transactions, and "abstracting the data into tables" is a non-issue as ZODB stores Python objects more or less directly (you only have to worry about ensuring that objects are of "persistent" types -- meaning either immutable, or providing persistence support explicitly). -- Terry Hancock ( hancock at anansispaceworks.com ) Anansi Spaceworks http://www.anansispaceworks.com -- http://mail.python.org/mailman/listinfo/python-list