[Zope] Which database?

[Heiko Stoermer]

here are my thoughts... (you wanted them  :)    )
I've been working with MySQL for the last 2 years now, and I pretty much
liked it for the ease of use. (good PERL module, loads of tools).
For our current project however, we switched to postgresql because we
simply wanted to try it out. And I must say that I found postgresql no
harder to use, especially the database grants are even easier to
handle. It has many more functions (e.g. transactions), but I think if
you are experienced in MySQL you will be able to work with postgresql
within two days or so.
Concerning Oracle, Informix etc.: I have no experiences with these,
because for me they seem too bloated for web use. There was never even
one reason to use a database that costs you $ 200,000 for unlimited web
use  ;) so I didn't even get in touch with them.
There might be an alternative DB called "Adabas D" by the german
Software AG, which seems to be right in the middle between freeware
postgres and expensive Oracle concerning price and features. However,
I'm not informed about DA status for Zope interaction. But you might
want to check that out.

Hope this helps,
Heiko

Suder Steen SFS wrote:

> Hi,
>
> I'm implementing a little Zope 2 solution here in my IT
> dept. and we're having discussions on which database to use.
>
> Scenario:
> 4-5 adms/real users, upto 250 client users.
> Adms will enter PC regs., user regs and so on.
> Clients will enter suppport issues, follow their issue's
> progress and browse diff. IT support info.
>
> So it's no big thing at all.
> We plan to run the thing on RedHat Linux 6.0.
> Hardware is a PII 400, 256MB RAM, RAID5 for data etc.
>
> I'd like to use MySQL because of it's integration with Zope
> and web in general... and then it's a nice product too.
>
> My collegeague is obsessed with security so he on the
> PostgreSQL wagon. Main issue for him is transaction control.
> I say: heavy hardware and light usage means no need for
> transaction control in my world.
>
> My boss says: go with Oracle or Informix. Our company
> already has licenses for these products.
> I think they are too heavy, too big and too closed. That's
> bad.
>
> I'd like some thoughts on this issue.
>
> Best regards,
> Steen Suder
> IT tech. apprentice
>
> _______________________________________________
> 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 )

--
Heiko Stoermer
MIG Augsburg