Comment by vemv | Hacker News Reader

Comment by vemv | Hacker News Reader

Parent Full thread

Like many developers, I've used postgresql unquestioningly for many years, say 10. But if you ask me, I've rarely have had to face stringent scaling or availability requirements.

Many deployments were a variation of AWS RDS or a similarly managed offering for HA. And they weren't exactly flawless.

So this article is good food for thought. Why are we using postgresql? Because of the features, developer-friendliness, and so on.

Does that align with actual customer requirements? Not necessarily.

This problem framing aligns well with other phenomena one can observe. i.e. many complexities in our industry are completely self-inflicted (some personal 'favorites': OOP, microservices, SPAs, graphql).

What if postgresql could be added to that list?

Note that I'm not necessarily questioning postgresql as a project, but instead, the hype process that can lead communities to unquestioningly adopt this or that product without making an actually informed assessment.

I think Postgres is great for many of the same reasons that people often (wrongly) tout NoSQL systems for. It's flexible, featureful, simple and quick to get started. And unlike most NoSQL systems, it has full ACID compliance and can scale well past MVP stage to the point that most businesses will never hit its limitations.

If you do hit really huge scale then you will need to start looking beyond Postgres to solutions like Cassandra, Scylla, etc. But hopefully by that point you have a large dev team capable of handling the extra complexity.

PostgreSQL is better at being MongoDB than Mongo is.

You can just add a JSON column and do queries on the content, index the table on individual values etc.

Postgres is a fantastic relational database but for storage, indexing and querying of JSON documents there is no comparison to MongoDB. MongoDB is built from the ground up as a JSON store (actually a binary encoding of JSON called BSON). I would encourage you to try it out I think you would be surprised by what is in the box.

One of the benefits of using Mongo is its horizontal scalability, not necessarily its ability to store documents.

That is somewhat missing the point of MongoDB. We start with easy to use document storage, querying, indexing, and dynamic schema. We end with horizontal scalability.

I wouldn't say postgresql is a self inflicted problem, like eg some argue micro services are, it is rather that choosing PostgreSQL optimizes for developer experience over things like flawless HA and zero downtime upgrades. So the tradeoff is between being able to build products faster and cheaper while sacrificing some reliability.

You have to put your data somewhere... are commercial database vendors or nosql solutions that much better?

I cannot make an expert assessment myself but for one thing mysql is occasionally picked precisely because of its HA story.

It was the case in a couple past jobs of mine, back then I didn't particularly appreciate it but now I might see it with different eyes.

Also commercial databases do have a better HA story - at least that's their reputation.

The current status quo is that everything should be free, but obviously that has a fundamental contradiction with being a professional software developer in the first place.

What do you make of Amazon Aurora?

Do you have any good examples of Graphql increasing complexity (as opposed to REST)? A dev at my work is pushing for it, and I am against it because it's another tech that isn't really solving any problems that we currently have (too much complexity is our number one problem). It would be good to have some examples to show them.

Reply on news.ycombinator.com