Tim Terlegård wrote:
I'd like (read the company would like) to store all data in a Sybase database instead of using zodb. What solutions are there?
I've read some about APE and Sybase DA. APE doesn't seem to support Sybase (only mysql and postgresql?) and to use Sybase DA I have to rewrite all code to use Z SQL methods.
Is this information correct? Are there other alternatives or is it impossible to have Zope store all data in a Sybase RDBMS without rewriting all products to use Z SQL methods?
If you use Plone/CMF then Archetypes can store its data in an RDBMS. Dunno if Sybase is among them, but it probably is if you can get a DA for it. Or you could go and make APE deal with Sybase. You can also make your own products proxy for a database in your mutators and accessors (and possible use ComputedAttribute.) ExtZSQL would be handy for this. Otherwise: yes, you have to code explicitly to the database. --jcc -- "My point and period will be throughly wrought, Or well or ill, as this day's battle's fought."