3 ms·
You must always pay the development complexity piper. SQL databases start off difficult but pay dividends on the back end. NoSQL databases start of easy but be
by jacques_chester 14y ago
You must always pay the development complexity piper.
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.
- yen223 14y agoTANSTAAFL = "There ain't no such thing as a free lunch", for those who are wondering.
- neya 14y agoThanks! I actually was really wondering what it meant :D
- liotier 14y ago> 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.