Re: MS SQL features for new version - Mailing list pgsql-hackers

From Keith Bottner
Subject Re: MS SQL features for new version
Date
Msg-id 014301c3efe8$ab66ad70$7d00a8c0@juxtapose
Whole thread Raw
In response to Re: MS SQL features for new version  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List 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@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Merlin Moncure
Sent: Tuesday, February 10, 2004 7:19 AM
To: shridhar@frodo.hserus.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@postgresql.orgso that your     message can get through to the mailing list cleanly 



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Current-stream read for psql's \copy
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] Current-stream read for psql's \copy