News for hackers. Stuff that matters.
Re:Databases have failed the web by dom0 on Thursday April 06, 2017 @11:06AM (#14051170)
Fully agreed. The observation that SQL still works as well as it does today as it did in the 70s suggests that it's a good and valueable abstraction.
Re:Databases have failed the web by ganonm on Thursday April 06, 2017 @12:23PM (#14051990)
Yes, and the fact that a relational model is such a convenient way to represent lots of data problems means that even if SQL disappeared, the concept and usefulness of a relational database would long outlive it.
Re:Databases have failed the web by hive_mind on Thursday April 06, 2017 @11:35AM (#14051498)
Lindy Effect.
Re:Databases have failed the web by YCode on Thursday April 06, 2017 @12:13PM (#14051891)
I can't tell if you're describing or disputing the comment you replied to.

Are you saying SQL survived only because people have used it for so long and therefore its sustained use isn't an indicator of value?

Re:Databases have failed the web by hive_mind on Thursday April 06, 2017 @01:21PM (#14052566)
If you read up on what Taleb writes about Lindy Effect, you should be able to understand.

OP said that it's probably good because it has lasted so long. I would agree.

Re:Databases have failed the web by geon on Thursday April 06, 2017 @12:09PM (#14051849)
> SQL still works as well as it does today

Or... It sucks as badly now as it did back then.

Re:Databases have failed the web by dasil003 on Thursday April 06, 2017 @12:16PM (#14051928)
Well, no. There were a zillion databases competing and SQL is what survived. The NoSQL movement has created a bunch of useful DBs for specific scaling workloads, and of course there are graph DBs and other special purpose DBs, but SQL still dominates, and with good reason: it's the right balance of performance, flexibility, structure and integrity that makes it an excellent hedge for the early phases of application development when you're not yet sure what exactly the workload is going to look like.
Re:Databases have failed the web by geon on Thursday April 06, 2017 @12:44PM (#14052211)
HTML and CSS "won" on the web. No one in their right mind would call them good or even suitable for their main use case.
Re:Databases have failed the web by dasil003 on Thursday April 06, 2017 @12:48PM (#14052252)
Of course they are. Most things on the web are documents. The fact that it is abused for SPAs means that yes they are contorted and abused, but that is inevitable because Gall's Law.

It's easy sit in an armchair and point out all the warts on specific tech, but if you were to build a better solution to broad technology segments like this, and magically get adoption, you'd find that you only understood 5% of the application space, and your better version is subject to whole swaths of criticism that you didn't anticipate. Better to find one small/simple thing you can do well and build from there.

Re:Databases have failed the web by YCode on Thursday April 06, 2017 @10:08PM (#14056519)
What's more suitable for their main use case? What is their main use case?
Re:Databases have failed the web by lastyearman on Thursday April 06, 2017 @03:30PM (#14053822)
Every time I have to glue together pieces of SQL at runtime I have to agree. It seems crazy to me that there is no "native" way to query relational DB's (yes, there are some SQL factories for certain languages)
Re:Databases have failed the web by dragonwriter on Friday April 07, 2017 @04:49PM (#14063393)
SQL is the native way query RDBMS.