Re: Experiences with PostgreSQL?

I had to troubleshoot a postgresql issue with a bomain key. That turned out
to be several nights of grief. There's very little documentation and help
for these sorts of issues. MySql on the other hand is a bit more mature in
documentation and forum help.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET - MS Press
Professional VSTO 2005 - Wrox/Wiley
OWC Black Book www.lulu.com/owc

<PSiegmann@xxxxxxx> wrote in message
news:1186911002.647764.35490@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello newsgroup,

We are hosting (and developing) an asp.net application on a dedicated
server, as database MS SQL Server Express 2005 is used.

We are currently happy with Express 2005, but, since the project will
grow, the 4 GB limit on the database will be a problem. This project
is currently too small to afford a pricey MS SQL 2005 standard edition
Server, so we are thinking about a migration to MySQL or PostgreSQL.

Now, MySQL is much more popular, but I am more symphatic towards
PostgreSQL, since stored procedures, Views, Triggers etc. are built in
since years into PostgreSQL, and are not an "afterthought" like in
MySQL.

But, I am still unsure what to take... I am the guy responsible for
the DB.. and to be honest, I don't have much experience with both,
MySQL and Postgre.

So, does anyone runs a asp.net site with postgreSQL here? How are your
experiences with it? Any problems? How is the performance on windows
server 2003?



.

Relevant Pages

  • Re: PostgreSQL or MySQL ?
    ... Did 4.0 not have documentation? ... MySQL and PostgreSQL. ... MySQL does not support deferred constraint checks. ...
    (comp.databases)
  • Re: Data Redundancy
    ... MySQL & PostgreSQL each have database-specific replication options. ... For non-database files, ... I have a server that i need to mirror elsewhere for data redundancy ...
    (Debian-User)
  • Re: Newbie and Debian.
    ... There is no "the Linux equivalent", ... you want to achieve you could use MySQL or PostgreSQL as I said earlier. ... of PostgreSQL and SQL Server. ...
    (alt.os.linux)
  • Re: Newbie and Debian.
    ... >you want to achieve you could use MySQL or PostgreSQL as I said earlier. ... but lacks some of the advanced features ... >of PostgreSQL and SQL Server. ...
    (alt.os.linux)
  • Re: How about MySQL in 64bit Debian?
    ... How about MySQL server in 64bit Debian? ... We also use PostgreSQL, which I happen to prefer, also no problems. ... I'm new to PostgreSQL and MySql, which database server should i use ...
    (Debian-User)