Ask HN: Have you ever chosen Postgres over Mongo and regretted it?

Re:Ask HN: Have you ever chosen Postgres over Mongo and regr... by nulagrithom on Tuesday July 10, 2018 @01:09PM (#17500079)

> What is wrong with writing a raw SQL for such a simple thing?

Mostly query composition. I run in to this a lot. Say I need to write a less-than-simple query and reuse it with several different WHERE clauses.

Sometimes I think I just want migrations, not so much an ORM. I want to define views and stored procs in my repo and have them move to prod automatically, but I still want to write in straight SQL.

[ Parent | on HN ]

Re:Ask HN: Have you ever chosen Postgres over Mongo and regr... by ntqz on Friday July 13, 2018 @01:41PM (#17524996)

Although the majority of what I do is in Python, I've taken to using Flyway for DB migrations.

A lot of what I do is using some of the more esoteric features of PG (think domains, custom aggregate functions, etc), so the ability to run migrations as direct SQL is great.

[ Parent | on HN ]

Re:Ask HN: Have you ever chosen Postgres over Mongo and regr... by sanderjd on Tuesday July 10, 2018 @03:46PM (#17501450)

This resonates with me.

But the other super critical thing (which was the first part of my original comment, and which nobody has really highlighted here) is a mature query construction library that knows how to properly protect against injection.

[ Parent | on HN ]

Re:Ask HN: Have you ever chosen Postgres over Mongo and regr... by ris on Tuesday July 10, 2018 @04:09PM (#17501636)

In all fairness a properly used sql connector library will hopefully do this too.

[ Parent | on HN ]