I am a long-time Microsoft .NET developer. ASP.NET/MSSQL/IIS has been my bread & butter over the past 6 years.
Now, I'm getting fond of the "lightweightness" of Ubuntu 10.xx server. I'm also loving SSH-ing it from my Windows 7 PC and installing apps using the awesome "apt-get" command.
I've also been using HeidiSQL with MySQL now and loving it. It feels like Management Studio. However, i've read that PostgreSQL "may" be better than MySQL, and I did experience some MySQL overloads in my Moodle box (but this can be just a poor tweaking in my part).
My question is, would it be a good idea to run this configuration?
ASP.NET 4.0
PostgreSQL (the latest one I can apt-get!)
Ubuntu 10.10 with Mono running on Apache
Also, I assume I would be using Npgsql for Mono as my connector from ASP.NET to PostgreSQL?
Best Answer
I personally use MySQL as a database system for ASP.NET MVC based applications running on Mono, but I guess PostgreSQL is fine too. My experience is that MySQL has a better support for various tools (for example Workbench) and writing stored procedures is much more simpler (take it as subjective experience).
Exactly.