Hacker News new | ask | show | jobs
by joedrumgoole 2132 days ago
1. Debatable, but my (biased) experience is the ease of change in an agile project favours databases with a flexible schema.

2. Reliability is not a pure function of whether you use SOL or NoSQL

3. ORMs hide but do not remove the need for schema management in SQL dbs. They often create more problems than they solve.

4. SQL databases support JSON because it my accurately reflects the programming model that programmers want to use. This is making an argument for NoSQL.

5. Which NoSQL you use is a matter of personal choice in many cases. I prefer MongoDB (I would say that though, I work there). Cassandra has some challenges as it is eventually consistent by design (and default). MongoDB is strongly consistent by design (and default) which makes reasoning about your programs easier.

1 comments

1. As cludgy as SQL is, having to reimplement basic SQL queries ala reinventing wheels isn't very smart imo. It's worse than having an inflexible schema

2. I was only referring to mongo and not to NoSQL as a whole. Cassandra worked just as a advertised.

3. You don't have to use an ORM with a relational database just as you don't have to for mongo. There are other alternatives

4. JSON is no longer an advantage for NoSQL since it's supported by relational databases. It also means that relational databases as a whole can adapt to the market.

5. Which NoSQL you use and for what purpose matters, and it's not just "personal choice". NoSQL in general aren't the generic swiss army knives that relational DBs are. Each NoSQL project has different use cases, which in turn also have different levels of reliability and performance.