Hacker News new | ask | show | jobs
by marcosdumay 4569 days ago
When you remove non-local constrains (like foreign keys) you gain scalability, that enables companies like Google to query their data better.

Now, if you are doing anything more mundane (like, for example, logging every bank operation in a country) that's overkill, and non-local constrains are a great thing to have. Thus, I'd advise not using it unless you have a clear necessity.

And always keep in mind that changing yor data is hard, whatever technology you are usig. Relational databases making the change itself hard, while schemaless databases make maintaining the software that reads it hard. Schemaless does give you a small upfront benefit, for a huge cost later.