3 ms·
Actually, there is a subtlety you've missed. We don't use relational databases. We use SQL, and endless variants thereof. I'd be a lot less grumpy about relatio
by jerf 17y ago
Actually, there is a subtlety you've missed. We don't use relational databases. We use SQL, and endless variants thereof. I'd be a lot less grumpy about relational databases if there was a relational-but-not-SQL way of using them. Thought this grumpiness has nothing to do with the "NoSQL" issues, I just hate being stuck on 1970s syntax.
(No, this is not a complaint about "sets". It is in fact the opposite, that it doesn't support the truly relational style of programming anywhere near well enough!)
"When they come out with statements like "SQL doesn't scale" I look at RDBMSs storing >100T of data and/or handling >10,000 COMMITs/sec and I very quickly figure out who has actual experience and who doesn't."
And you're gliding right over the question of what is being stored, how it is being accessed, on what timeframe it is being accessed, what is being done with it, and how much it costs vs other options which is something I rather made a point of pointing out. A $10 million dollar solution to something that could have been solved with $0 and five hundred developer hours is not an acceptable solution. The fact that the expensive solution works isn't even relevant, really.
You know, all those pesky engineering details that SQL, sorry, RELATIONAL-uber-alles advocates always conveniently forget about. Nothing is free.
- gaius 17y agoWe don't use relational databases. We use SQL, and endless variants thereof. I'd be a lot less grumpy about relational databases if there was a relational-but-not-SQL way of using them. Have you tried LINQ? uber-alles advocates always conveniently forget about. Nothing is free That is what I mean when I say sharding is just reimplementing features you get "for free" with a real database (in the sense that they're built in). There is also the cost of reinventing the wheel...
- jerf 17y agoLINQ, so far as I know, backs to SQL, and thus inherits the inadequate relational aspects of SQL. The syntax is nicer, though, and also goes a long way towards demonstrating my point about the annoying inadequacies of SQL. Especially as I dig deeper into the functional world, the inability to meaningfully compose SQL statements is really getting annoying. I am in the weird position of being both a relational snob and thinking that relational databases aren't the solution to everything.