Firebird vs Postgres

[Robert Munro]

> -----Original Message-----
> From: musicbrainz-admin at musicbrainz.org
> [mailto:musicbrainz-admin at musicbrainz.org]On Behalf Of Robert Kaye
> Sent: 22 April 2002 18:00
> To: musicbrainz at musicbrainz.org
> Subject: Firebird vs Postgres
>
>
> OK, I'm fed up with MySQL. I really want foreign keys and solid
> transactions. So my choices are Postgres or Firebird. The docs
> for firebird a still pretty slim and its hard to find speed comparisons
> between then. As far as I can see firebird doesn't support views, which
> postgres does. Other than that, for the things that I need they seem
> equally capable.

It does support views!

> Given that I'm looking for proven stability, I'd be inclined to go with
> Postgres. Rob M: Why would I want to use Firebird over postgres?

Firebird, in one sense, is very mature and stable, being based on InterBase,
that has been around for about 15 years.
http://www.ibphoenix.com/ibp_news_art2.html It has many users, some in
mission critical situations, for example Motorola used it to build 911
despatch systems for Police forces.

> On Fri, 2002-04-19 at 02:05, Johan Pouwelse wrote:
> > Firebird vs. MySQL vs. Postgres comparison:
> > http://www.geocities.com/mailsoftware42/db/dbs.html.
>
> This is more like a mysql vs postgres comparison. The author seems to
> know very little about firebird. I'd like to see a speed comparison
> between firebird and postgres... Anyone have any pointers?

I haven't seen any speed comparisons recently. All I know is that everyone
who knows anything about databases seems to say take speed comparisons with
a pinch of salt - they are often fairly meaningless.

Robert Munro

Ps. FireBird is quite well documented as it's previous incarnation -
Interbase 6. The best set is here:
http://firebird.sourceforge.net/index.php?op=doc&id=userdoc
You want the interbase 6.0 manuals. These contain most of the information
required, except a few new features added to FireBird only. All the
reference information is still correct.

_______________________________________________
Musicbrainz mailing list
Musicbrainz at musicbrainz.org
http://www.musicbrainz.org/mailman/listinfo/musicbrainz