Re: why postgresql over other RDBMS

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

On 05/24/07 12:48, Alexander Staubo wrote:
> On 5/24/07, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> wrote:
>> > [2] Nobody else has this, I believe, except possibly Ingres and
>> > NonStop SQL. This means you can do a "begin transaction", then issue
>> > "create table", "alter table", etc. ad nauseum, and in the mean time
>> > concurrent transactions will just work. Beautiful for atomically
>> > upgrading a production server. Oracle, of course, commits after each
>> > DDL statements.
>>
>> Rdb/VMS and CODASYL DBMS (both Oracle, formerly DEC, products) also
>> have transactional DDL.
>
> Not exactly mainstream databases, and Codasyl isn't even a relational
> database as far as I remember.

True, they are "legacy systems", but are still actively developed by
Oracle, for Alpha and Itanium VMS. (The VAX products still are
actually maintained, but only for bug-fixes.)

And yes, DBMS uses the network model. (Since both it and Rdb use
the same back end and on-disk structures, it's not that much extra
effort to also keep on actively developing DBMS.)

>> Interbase/Firebird probably also has transactional DDL.
>
> Apparently. I'm surprised, given how InterBase and Firebird otherwise
> feel so awfully ancient.

InterBase was devloped by a man who worked for DEC at the same time
that Rdb was in the works. His DECisms are still apparent in Firebird.

God, I'm going to hate it when we migrate to Oracle...

> All right, so not unique, but very rare.

- --
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGVdNvS9HxQb37XmcRAkK4AKCxilH8XRM9es1RZ/Vma/AUrLoVnACfaGgP
VSce0lLj/mw2Vj435EDEaII=
=Gkbz
-----END PGP SIGNATURE-----