At 04:13 PM 10/15/2002 +0800, Jon Perez wrote:

> >
> > True; and it's more the case that PG developers have been working hard
> > over the past two years to try and mimic IB/Fb features.
>
>Interesting, which IB/FB features would these be?

Multi-version concurrency for one.

> I was
>always under the impression that PostgreSQL had slightly
>more advanced features.

Postgres has a lot of nifty object type features. Firebird
has a bunch of extensions like events, arrays, & blob
filters. Stonebreaker writes an interesting database.
So does Starkey.

> > Yea, as to the manner born. Gbak -t on one platform, restore on
> > another. Log in and carry on.
>
>I tried copying a .gdb straight between Windows and Linux
>(shutting down the server first) and it worked. Is there
>something to recommend against using this approach?

Firebird uses native alignment and data representation -
big or little endianness, floating point on Vaxen - so if
you copy a database between Solaris on Sparc and Linux on
Intel, bad things will happen. As it happens, the Intel
Linuxes I've used have the same alignment as Windows so
there's no problem with copying - providing, of course,
that the database is shut down.

>... choose between one of them for an 'enterprise-wide'
>system.

1) If Windows is important, I'd use Firebird.

2) If system administration costs are important I'd use Firebird

3) If you need to define data types, store and analyze geographic
data, or define new operations, I'd use PostgreSQL.


Regards,

Ann
www.ibphoenix.com
We have answers.