Re:We Can Do Better Than SQL
by jeltz on Tuesday August 11, 2020 @07:35AM
(#24119256)
Not parent poster but I love relational algebra. But so far I have yet to use an alternative to SQL which is less bad. Most of them seem to be designed by people who do not understand SQL.
[ Parent
| on HN ]
I agree with you, I haven't found an alternative that is less bad. But that doesn't mean that I like SQL. It is so inconsistent and uncomposible, with too many awkward ways to do different things.
I love the idea of a functional algebra for querying a database, and while SQL is acceptable, it is far from great in my opinion.
Take a look at Suneido. As a product, it's a weird thing that kinda stands by itself, and isn't particularly useful because of that. But the database and the query language is straight up relational algebra.
https://suneido.com/info/suneidoc/Database/Queries/Syntax.ht...