Live data from Hacker News

Who wants to discuss about MySQL vs PostgreSQL?

news.ycombinator.com

11–12 of 12 posts

Re: Who wants to discuss about MySQL vs PostgreSQL?

#11
post #9

PostgreSQL versus MySQL: an unbiased comparison: http://www-css.fnal.gov/dsg/external/freeware/pgsql-vs-mysql.html We could spend all day on this, though.

However, it is quite out of date: for example, PostgreSQL has had a native Win32 port for several years, and the "--enable-locale" / "--enable-multibyte" configure options have not been necessary (or supported) for even longer. "Large row" (TOAST) support has been around since 7.1. etc.

Re: Who wants to discuss about MySQL vs PostgreSQL?

#12
post #8

PG writes in the Viaweb FAQ that they (and Yahoo) did not use any database, just files. It makes sense... Is there something fundamentally different about your app, so that a DB is obviously a better choice?

I think something is different about databases since then. You can, for free, install a database in part of an afternoon that has excellent library/framework support and tools. That makes a big difference. If you're going to use Ruby on Rails, for example, you will have to justify why you don't want to use database software.

Basically, databases have been well-commoditized, like Unix, HTTP servers, and hosting. If your needs fit their common usage scenarios, you should just go ahead and use them.

Post reply on HN