I am rewriting an application for my company which requires a database. We are currently using SQL Server 8 and I will be updating the database. My question is which database to use. I have been looking at both SQL Server 2008 r2 and PostgreSQL 9.
The database will be hosted on a Windows Server 2008 box and will be used for both the stand-alone app and an associated website written in .NET.
Some of my points of concern are:
- Cost (obviously PostgreSQL wins out here).
- Is it ready for primetime? I have read somethings about it being as good as SQL but would like some input from those using it.
- Ease of use. I am very comfortable with SQL Server. I have been experimenting with PostgreSQL and while it is different than SQL Server I am getting the hang of it.
- Speed. Is PostgreSQL as fast as SQL Server?
- Can I use ADO.NET (.NET 4.0) with PostgreSQL and get the same functionality as Using SQL Server (will be using Linq or Entity Framework)?
I will NOT be converting our old database in SQL Server 8 to the new database so I am not concerned with any conversion.
I would be interested in peoples opinion of the two and if PostgreSQL is an acceptable solution for a business application given the above.
TIA
Brian