Re: MS SQL features for new version

From: "Keith Bottner" <kbottner(at)comcast(dot)net>
To: "'Merlin Moncure'" <merlin(dot)moncure(at)rcsonline(dot)com>, <shridhar(at)frodo(dot)hserus(dot)net>
Cc: "'PostgreSQL-development'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: MS SQL features for new version
Date: 2004-02-10 15:15:07
Message-ID: 014301c3efe8$ab66ad70$7d00a8c0@juxtapose
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Yes MS tools for MS SQL have always been there strong point. Easy to get
started and get things going quickly. I on the other hand have never ran
into a lack of flexibility with the client APIs or the stored procedure
syntax.

In all cases I have encountered we have turned away from MS SQL because the
scalability and high availability options have been weak to non existent.

Keith

-----Original Message-----
From: pgsql-hackers-owner(at)postgresql(dot)org
[mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Merlin Moncure
Sent: Tuesday, February 10, 2004 7:19 AM
To: shridhar(at)frodo(dot)hserus(dot)net
Cc: PostgreSQL-development
Subject: Re: [HACKERS] MS SQL features for new version

Most of the new features are new database tools, etc. That has always been
a strong point with SQL server. IMO, the weak point of the database (aside
from the vendor and the price), is a lack flexibility of the client APIs and
the stored procedure syntax.

The interesting features are the xml querying, recursive querying, and
'multiple active results sets'. I think MS is laying down a more relational
foundation which would allow for such features. They have been working on
this product for years and years...it will be fun to see how it turns out.

Merlin

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-02-10 15:16:14 Re: [PATCHES] Current-stream read for psql's \copy
Previous Message Tom Lane 2004-02-10 15:10:22 Re: [PATCHES] Current-stream read for psql's \copy