> SQL databases start off difficult but pay dividends on the back end. NoSQL databases start of easy but begin to extract their costs later.
Funny - I feel it is the other way around : NoSQL yield scalability to the high end but I find SQL incredibly more convenient because the database does most of the work for me... We all have our bias and mine is thinking in a relational way.
SQL databases start off difficult but pay dividends on the back end. NoSQL databases start of easy but begin to extract their costs later.
Similarly, a well-normalised database is tuned to write-and-store performance, but the cost of joins can crush you at query time.
What's usually missing from discussions like these is highlighting the difference between OLTP and OLAP.
You favour one or the other. TANSTAAFL.