Re:SQL Databases Are An Overapplied Solution
by silentbicycle on Friday July 10, 2009 @01:59PM
(#698090)
Not if you factor in the amount of code necessary for ACID transactions, etc. If you make an informed decision that you don't need that level of consistency, sure, but it's probably reasonable to be overly cautious with data by default.
(If you're going to the database and back for every page view, you could probably be using caching more effectively, e.g. memcached.)
ACID transactions have nothing to do with RDBMS, non relational db's can be and are ACID compliant as well. Look at any object database, you'll generally find MVCC and ACID compliance.
The issue is whether your data fits well into tables and rows, or not, and whether it's worth cramming it into tables and rows and continually reconstructing it to get the benefits relational db's generally provide over the alternatives... which are enforced data integrity, language neutrality, and a generic fixed structure capable of allowing flexible querying. To get those, you trade speed and ease of development.
Re:SQL Databases Are An Overapplied Solution
by silentbicycle on Friday July 10, 2009 @03:56PM
(#698260)
I think we fundamentally agree, but we've been a bit loose with terminology along the way, and have been arguing with misreadings of each others' points.
Have a nice weekend.
Yes, it's less work. The introduction of a databases nearly always more than doubles the complexity of a program and the amount of code written. There's a reason developers like in memory prototypes and persistent hash tables, they require less code than any other solution and don't force you to tear apart your model and try and stuff it into tables and put it back together again on every page view.