[CLUE-Tech] PostgreSQL News

[Jeffery C. Cann]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

All,

Interbase (http://www.borland.com/interbase) supports outer joins.  Interbase 
fully supports the ANSI SQL 92 spec, unlike MySQL and Postgres  Possibly with 
7.1 of PG, it is now fully ANSI SQL 92 complete.

I have used Interbase to build a production web application environment and I 
would recommend it.  Another advantage over PG is that Interbase runs on NT 
(not something most Linux users care about, but when you have clients that 
will only run NT, what can you do?)

Jeff

On Wednesday 21 February 2001 12:57, Grant Johnson wrote:
> As some of you may know, my open source database of choice is
> Postgres.  Before everyone goes off on a MySQL rant, let me tell you that I
> chose it for transactional support (rollbacks) and the ability to use
> cursors.  MySQL is not bad, it just does not support all that I want.
>
> Neither does Postgres, but it is closer.  Most noteable, it does not
> support outer joins.  This is really annoying, but you can program around
> it, and make your software do the join pretty easily by just doing another
> select.
>
> Here is the news:  As of version 7.1, currently in beta, Postgres will
> support outer joins.  Yeah!!!!!
>
> There is now only one reason to use any of the proprietary databases,
> transaction logging, so you can recover things since the last
> backup.  However, with Postgres you can do hot backups with data
> consistency, since it uses a concurrency model that uses a snapshot of the
> database when the transaction started.  This means that if you don't mind
> the load on the server, you could run constant backups, starting each
> immediately when the prior one finishes.  That could be cool.
>
> _______________________________________________
> CLUE-Tech mailing list
> CLUE-Tech at clue.denver.co.us
> http://clue.denver.co.us/mailman/listinfo/clue-tech
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAjqVay0ACgkQw3/GBQk72kBlZgCdHlUxZjQcus3YgVGGp7WyYkJR
O6sAoJRGG6I58EOusrh+AOoBEp8G2fez
=xUYh
-----END PGP SIGNATURE-----