Re: Free alternatives to SQL Server

news.microsoft.com wrote:
> Hi,
>
> There are a few free databases that can be used with .NET, like
MySQL,
> PostgreSQL and Firebird (and others?). I would like to know which one

> you would prefer, and why.

Ingres and MaxDB (formally called SAP DB)

PS: don't even think of MySQL :)

>
> It would be a pre if the SQL syntax would resemble SQL Server's
syntax
> because I'm already a bit familiar with that. The database should
> support stored procedures, triggers and transactions. I know MySQL
> supports stored procedures in 5.0 (beta). The database has to support

> Windows OS, but the ones I mentioned all do.
>
> Also I would like to know more about the quality of the available
..NET
> data providers (free and commercial) for these databases.
>
> I guess these questions have been asked before, so in that case links
to
> those discussions, FAQ's or websites are also welcome.

As I know none of these DBs have syntax similiar to Transact-SQL.
PostgreSQL's seems to be PL/SQL-like, but Firebird's syntax is rather
weird and its statement terminator is confusing (partially due to its
almost-unusable CLI).

All of PostgreSQL, Firebird, Ingres, and MaxDB support sp, triggers and
transactions.

PostgreSQL supports a lot of cool features such as inheritance and
Python binding; Firebird has some very good GUIs (ex: IB Expert); dunno
about Ingres and MaxDB... They both are Oracle-like terrible things.

I had used Firebird's ADO.NET provider for several weeks, not bad.

.

Relevant Pages

  • Re: Python does not play well with others
    ... MySQL, I want PostgreSQL, he wants Firebird, they want an interface to ... straightforward OS, language package, web server, and db installed. ...
    (comp.lang.python)
  • Re: [PHP] Re: Getting last record ID created from DB
    ... There in lies the biggest problem with LAMP, and that's MySQL. ... They use PostgreSQL and we do have a auto incremented unique id ... but rather a sequence value. ... I guess maybe most databases support the notion of "auto number" in some ...
    (php.general)
  • Re: Looking for a database
    ... >> The obvious choices on fedora will be MySQL and postgresql ... > If I was to chose between Postgresql and another free database it would ... > be between Postgresql and Firebird, ...
    (Fedora)
  • Re: MySQL,PostgreSQL and dbm.
    ... MySQL is a pseudo-relational database. ... PostgreSQL is a relational database that's a little bit more resource ... choice for very large scale databases and if you need very specific ...
    (comp.os.linux.development.apps)
  • Re: OT: MySQL book recommendation for a newbie?
    ... I know nothing about databases and I'd like to start somewhere. ... > how to use it and how to interface with it for a project that I need to do, ... This is PostgreSQL, which has transaction support and other very useful ... MySQL and PostgreSQL, so you have to choose which is best for you - ...
    (comp.unix.bsd.openbsd.misc)