Hacker News Reader

Comment by debacle | Hacker News Reader

I love Postgres, but I'm building something for OSS use and most unzip-and-deploy devs don't know how to set up Postgres.

Any additional information that you might be able to give me that might convince me?

View on HN

I'd look into Postgres more first. They have some features that give you some of the convenience of a document DB. I'm not an expert but from what I've heard stuff like JSON/XML tables and customized column types that can store things like arrays and other structured data instead of just scalar data.

It sounds pretty powerful and I've been told it is rock solid. That being said, don't buy into the anti-mongo hype so easily either. It's been overstated and for a large portion of the middle-ground on scalability and performance mongo is great.

Its not difficult to setup - included in most package managers; EnterpriseDB produces installers for desktops / workstations; a straightforward build process from source.

The perceived "ease" at which MySQL is available, thus a lack of actual understanding about how to work with an RDBMS, is why MySQL is so widespread yet such a maligned platform.

Ah. If your target is people who aren't going to be reading docs, I don't think any DB is really preferable. :)

Any more details about the project, or is it under wraps?

It's basically a simple blogging platform, going to be released OSS.

Most devs know how to get MySQL running without too much thought, but many don't even know what Postgres is.

It might be worthwhile educating them. It shouldn't be that much harder to show them how to setup Postgres than MySQL :-)

If it's only a simple blogging platform, it might well be that MySQL will do the job just fine though.

Well with Postgres you can include an installation in your distribution, with MySQL you cannot.

Reply on news.ycombinator.com