Re: Database choices
Re: Database choices
- Subject: Re: Database choices
- From: Q <email@hidden>
- Date: Tue, 30 Oct 2007 09:01:40 +1000
MySQL is a lot better than it was 10 years ago, but it still has a
habit of playing fast and loose with certain types of input
validation, silently discarding or changing certain types of data and
allowing invalid queries. It still has a brain damaged query
optimiser and the query analyser is next to useless compared to many
other databases. Their clustering is still a poor mans solution, and
doesn't scale to large databases. That said, we still use it for
several, non WO, systems and provided you know the long list of
caveats and avoid the issues they pose it works very well as a basic db.
I really, really like PostgreSQL, it has almost everything you could
possible need, save for a few very advanced features only available
in top dollar systems, the query planner is extremely good, and the
various inbuilt analysis features are very useful, but what it really
lacks is a solid, two phase commit, clustering solution.
FirebirdSQL is actually extremely good for something with such a
small footprint, however it lacks deferred constrain validation,
which makes it a little difficult to utilise constraints fully with
WO, but there are people using it with WO. It also lacks a non-
commercial clustering solution. It is also very resilient to crashes
and unexpected shutdown. I would rank it higher than MySQL.
Frontbase is just rock solid, a perfect match for WO. It's clustering
is the best I have seen. Unfortunately it flies below the radar of
most people, but then so does WO.
Until postgresql gets a solid clustering solution, frontbase comes
out in front in my opinion.
None of them are bad choices.
On 30/10/2007, at 3:40 AM, Mike Schrag wrote:
You know, I have thought this same thing of MySQL for years, but I
think it's because I'm evaluating it based on its feature set from
1998 and not giving it a fair shake. I've read a lot of stories
on, for instance, highavailability.com about huge sites that use
it. I'm not too keen on the restriction that clustering is in-
memory only, but it actually seems like a legitimate database these
days (ONLY with InnoDB). It's on my list of things to evaluate
more fairly :)
ms
On Oct 29, 2007, at 1:16 PM, Chuck Hill wrote:
I am with Mike on this. If you just need free, FrontBase is hard
to beat. If you must have open source, PostgreSQL. MySQL has
some nice features, but... I dunno, it is still MySQLToy to me.
Chuck
On Oct 29, 2007, at 9:52 AM, Mike Schrag wrote:
I prefer FrontBase ... It's trivial to setup, runs very well, and
it's free. MySQL and PostgreSQL are obvious other choices as well.
ms
On Oct 29, 2007, at 10:23 AM, Ken Foust wrote:
Using Leopard > Eclipse > WOLips - which is the database of
choice. I have heard postgres is the best of the opensource
ones. But which one works best with replacement tool for
EOModeler?
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40mdimension.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net
This email sent to email@hidden
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve
specific problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40gmail.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden