[Zope] Sybase as storage

J. Cameron Cooper jccooper at jcameroncooper.com
Fri Jan 16 11:23:19 EST 2004


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."





More information about the Zope mailing list