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? Tim
Using a DB as backend storage for Zope is much, much slower than using filestorage. You should really think about if you want to do this. -aj --On Donnerstag, 15. Januar 2004 9:22 Uhr +0100 Tim Terlegård <tim@se.linux.org> 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?
Tim
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Tim Terlegård wrote at 2004-1-15 09:22 +0100:
... I've read some about APE and Sybase DA. APE doesn't seem to support Sybase (only mysql and postgresql?)
I think it would be too difficult to make an APE-Sybase gateway (deriving from the APE-PostgreSQL gateway). -- Dieter
On Thu, 15 Jan 2004, Dieter Maurer wrote:
Tim Terlegård wrote at 2004-1-15 09:22 +0100:
... I've read some about APE and Sybase DA. APE doesn't seem to support Sybase (only mysql and postgresql?)
I think it would be too difficult to make an APE-Sybase gateway (deriving from the APE-PostgreSQL gateway).
Why isn't APE based on ODBC instead? Tim
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."
participants (4)
-
Andreas Jung -
Dieter Maurer -
J. Cameron Cooper -
Tim Terlegård