> 1) Have migrations (except they're going to be some scary ad hoc nodejs script that loop through your document store and modify fields on the fly).
Unless you have never written migrations in SQL before you would know that they are even scary and a big bunch of sql. What is even worse is that, despite nobody here acknowledging it, must SQL databases are used with an ORM. Now in your migration script you have to hack SQL and language-based ORM commands together into a big pile of shit.
> 2) Have schemas (except they'll be implicit and undocumented)
Actually they can be just as explicit and documented. Mongo even has schemas now I think. But you can see the schema in the class definitions of your code. Once again, most people use an ORM and do this anyway.
> 3) Constraints (except they'll be hidden inside your app logic, and violating them will cause data corruption).
Errr... SQL constraints are very limited and literally every application has additional constrains embedded in the code.
The PostgresSQL propaganda on this forum is such bullshit. None of you have any idea what you are talking about even though you are supposed to be hackers.
Unless you have never written migrations in SQL before you would know that they are even scary and a big bunch of sql. What is even worse is that, despite nobody here acknowledging it, must SQL databases are used with an ORM. Now in your migration script you have to hack SQL and language-based ORM commands together into a big pile of shit.
> 2) Have schemas (except they'll be implicit and undocumented)
Actually they can be just as explicit and documented. Mongo even has schemas now I think. But you can see the schema in the class definitions of your code. Once again, most people use an ORM and do this anyway.
> 3) Constraints (except they'll be hidden inside your app logic, and violating them will cause data corruption).
Errr... SQL constraints are very limited and literally every application has additional constrains embedded in the code.
The PostgresSQL propaganda on this forum is such bullshit. None of you have any idea what you are talking about even though you are supposed to be hackers.