Re: Which one is better, Oracle or SQL server

From: Guido Stepken <stepken_at_little-idiot.de>
Date: Mon, 18 Aug 2003 14:05:12 +0200
Message-ID: <bhqfga$8cd$06$1@news.t-online.com>

Ryan Gaffuri wrote:

>>PostgreSQL has MVCC, multi versioning concurrency control. No writes, 
>>updates, reads block each other. You can program PostgreSQL in that way
>>as:

>
>
> thats not good. user A does an update and does not commit, user b does
> an update and commits... lets say the update looks like this.

MVCC does not exclude the possibility to lock, if needed.

> how robust is postGre SQLs procedural languagE? can you do stored
> procedures, triggers, etc... ? Just curious. If not, then you really
> dont want to do anything high end with it. Implementing business logic
> in C or Java and accessing the database leads to slow development
> times and long debug sessions.

Robustness of pl/pgSQL, pl/PHP, pl/JAVA, pl/TCL, pl/PYTHON ? your choice ! PostgreSQL has triggers, SP,...

> BTW, what platforms do postGre SQL and Informix port to? Isnt informix
> dead? IBM bought it and are shutting it down right?

yes, there will be 9.50 and 9.60 and then Informix ends.

regards, Guido Stepken Received on Mon Aug 18 2003 - 07:05:12 CDT

Re: Which one is better, Oracle or SQL server - clear answer !