3 ms·
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-
by smabie 6y ago
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/ https://code.kx.com/q4m3/9_Queries_q-sql/
- jeltz 6y agoNot 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.
- int_19h 6y agoTake 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.htm https://suneido.com/info/suneidoc/Database/Queries/Syntax.ht...
- kevincox 6y agoI 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.