News for hackers. Stuff that matters.
Re:We Can Do Better Than SQL by smabie on Tuesday August 11, 2020 @03:19AM (#24117959)
Do you love SQL, or do you love relational algebra? Because actual SQL, the language, is pretty shitty.

Perhaps the best querying language I've ever used is Q-SQL, integrated into kdb+/q. Unlike SQL, it's actually part of the language (q/k) and, most importantly, it's modular and more expressive than SQL.

If you're interested in how we can do a lot better than sending strings to remote databases using an inexpressive and non-turing complete language, check it out: https://code.kx.com/q4m3/9_Queries_q-sql/

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.
Re:We Can Do Better Than SQL by kevincox on Wednesday August 12, 2020 @01:44PM (#24134662)
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.

Re:We Can Do Better Than SQL by int_19h on Tuesday August 11, 2020 @11:54PM (#24128457)
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...