-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Yeah it's a real toss up between the two. I find that the implementation of InnoDB or BerkeleyDB is real klugy in MySQL, but Postgres provides you with Industrial Strength, excellent uptime, and generally good performance DB. It's not as fast as MySQL, I don't think may DBs are actually.
Adding to this Postgresql simply doesn't have a solid native Windows build, so if you're looking to run on windows, forget it. MySQL seems to run on just about anything under the Sun.
There are however excellent tools to manage both if you look at third party apps for your platform... One of them being Druid... weird enough :-)
R
Jason Pyeron wrote: | MySQL is designed to be efficient at the sake of loss of ANSI 92 | comliance. | | PostGreSQL is a great DATABASE but thats about it, poor admin, not that | fast when it really matters. | | | | On Mon, 17 Nov 2003, Robert J Celestino wrote: | | |>As far as ease of use with ojb, all are equal. |> |>So the following is just about preference, but take this with a grain of salt since I am, by no means, a database "expert" (could that be why I am using OJB? :-) ). |> |>I have used both postgresql and mysql on real production products. The impression I get from most DB types, is that mysql is a "toy database" and postgress is more "industrial strength". This may have been true 5 years ago, but I don't think that is true anymore. |> |>I find that mysql has nicer tools. |> |>Given my experience I would vote for mysql. I find it up to any task I throw at it. |> |>---------------------------------------------------------------- |>Bob Celestino |>SAS Research and Development |>919 - 531 - 9425 |>[EMAIL PROTECTED] |> |>SAS - The Power to Know |> |> |> > -----Original Message----- |> > From: Jewett, Diane C [mailto:[EMAIL PROTECTED] |> > Sent: Monday, November 17, 2003 3:35 PM |> > To: OJB Users List |> > Subject: Which database to use - PostgreSQL or MySQL? |> > |> > |> > What is the best and most reliable open-source database to use? |> > |> > Is one easier to use with OJB? |> > |> > ------------------------------------------------------------ |> > --------- |> > To unsubscribe, e-mail: [EMAIL PROTECTED] |> > For additional commands, e-mail: [EMAIL PROTECTED] |> > |> > |> |>--------------------------------------------------------------------- |>To unsubscribe, e-mail: [EMAIL PROTECTED] |>For additional commands, e-mail: [EMAIL PROTECTED] |> | | -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE/uUeC+cV9vuB27SARAgevAJ4ut9E5jrkz2KlrVRY3xoqbmkzUaQCdHF8R CojCUSv2DPK+d9DMkR8y1b4= =ARkv -----END PGP SIGNATURE-----
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
