[Zope] Database choice

[Alexander Staubo]

As for PostgreSQL I can't say, but Sybase on Linux is quite good.

Specifics: It lacks the wonderful management tools, great query
optimizer, and automatic memory/disk tuning features of MSSQL 7.0, but
beyond that it's very functional. Fast? That depends. But given that
Sybase 11.3 for Linux is free and if you know Transact SQL well, and
you're able to configure your databases through its ISQL interface, it's
excellent value for money. But let's just say that if Zope had supported
DB2 (which also has a free Linux version) I'd probably have switched
right away.

The problem with Sybase right now is Zope support. Brian Hooper's DA has
a number of bugs and quirks (which I've reported to him), and Digital
Creation's DA has even more bugs (which I've also reported). I went back
to Brian's DA after testing the DC DA, as Brian's bugs proved more
endurable. Right now I can't recommend the DC DA as it is too buggy for
even a testing environment, unless you're a very casual user.

(I have patched Brian's Python code to fix some odd quirks, I can send
the the fixes on request to anyone who wants them.)

-- 
Alexander Staubo             http://www.mop.no/~alex/
"He won a first at Oxford, squandered three fortunes, made love to a
thousand women, imbibed strange drugs, sold his soul for Rock 'n' Roll,
almost pipped Einstein for the Nobel Prize, was barred from every
Chinese
noodle parlour in West London and died penniless, at a Hastings
boarding-house in his ninetieth year."
--Robert Rankin, _The Book of Ultimate Truths_

>-----Original Message-----
>From: Tom Deprez [mailto:tom.deprez@uz.kuleuven.ac.be]
>Sent: 11. august 1999 16:58
>To: zope@zope.org
>Subject: [Zope] Database choice
>
>
>Hi all,
>
>This is an off-topic question, but I wonder if somebody can 
>help me decide.
>
>What database should you use? SyBase or PostGresSql? Both are free...
>
>Regards, Tom.
>
>_______________________________________________
>Zope maillist  -  Zope@zope.org
>http://www.zope.org/mailman/listinfo/zope
>
>(To receive general Zope announcements, see:
>http://www.zope.org/mailman/listinfo/zope-announce
>
>For developer-specific issues, zope-dev@zope.org -
>http://www.zope.org/mailman/listinfo/zope-dev )
>