On Fri, 18 Feb 2005 10:13:25 -0500, Michael T. Tangorre <[EMAIL PROTECTED]> wrote: > > From: Damien McKenna [mailto:[EMAIL PROTECTED] > > What about PostgreSQL? > > Interesting you mention that. I was just about to ask the list about it... > who is using it... their impressions. I just downloaded it after reading > some articles on it last night.
I like PostgreSQL a lot, but until recently the fact that it didn't run reliably on Windows (I mean, cmon, installing under Cygwin?!!?) made it a hard-sell to replace MS-SQL Server, while MySQL has been running reliably on Windows for quite a while. PostgreSQL and MySQL are fundamentally different animals. MySQL originally came out of a data warehousing project as a replacement for msql (and old open source db) and is missing a number of features (transactions, views, stored procs, triggers) that have been slowly added in as it moves into more enterprise situations (and gains more mindshare). PostgreSQL was more of a direct replacement for Oracle, et al, and thus has had far better support for heavily OLTP-oriented applications. I personally keep both in my toolbox (and MS-SQL for some projects as well). Considering the nature of most web applications, I find MySQL handles just about everything that's necessary. Postgresql I think about more for serious enterprise applications where OLTP is far more crucial (though there's no inherent reason MySQL Innodb tables can't handle that). I think the cost issue is a moot point (over the course of a project, the difference between "free" and $5-10k/proc for a MS-SQL unlimited license), especially when you factor in *moving* to MySQL from MS-SQL and the related training and productivity costs. But if you're thinking of scaling out or distributing/selling an application, it's a lot easier to pay $495/server (for the optional commercial, supported license of MySQL) thatn $5k+/processor for MS-SQL. Of course there's other open source options like Firebird and Derby (formerly IBM Cloudscape) that are interesting to use as well.... -- John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195403 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54