3 ms·
I think the solution is to upgrade SQL the language. There's a very low complexity threshold after which you have to trade readability/composability for decent
by weberc2 9y ago
I think the solution is to upgrade SQL the language. There's a very low complexity threshold after which you have to trade readability/composability for decent performance (in other words, there are a lot of cases where a human can notice a permissible optimization, but a database can't because it might break correctness for some odd edge case). We're solving that problem with programming languages (notably Rust); I'm not convinced that there's something inherently different about relational databases.
- lgas 9y agoProject M36 is a database that implements a relational model and corresponding query language (TutorialD) based on (among other things) the ideas from Date and Darwen's Third Manifesto. TutorialD solves many of the problems present in SQL, especially around composability. https://github.com/agentm/project-m36 https://github.com/agentm/project-m36
- weberc2 9y agoI've heard of tutorial D before, but I haven't taken the time to learn it as I'm off the impression it isn't widely deployed. :( I'd love to hear any first hand experiences though!