3 ms·
Anybody who replaces the hoary old albatross of SQL without throwing out the relational algebra baby with the bathwater gets my support. I hope this goes far.
by Pxtl 1y ago
Anybody who replaces the hoary old albatross of SQL without throwing out the relational algebra baby with the bathwater gets my support. I hope this goes far.
- jauntywundrkind 1y agoI'm unconvinced the syntax makes a genuine difference. But always interesting to see what folks come up with! Some notable others: PreQL/Trilogy - https://github.com/trilogy-data/pytrilogy https://github.com/trilogy-data/pytrilogy https://news.ycombinator.com/item?id=40728938 https://news.ycombinator.com/item?id=40728938 Malloy -https://www.malloydata.dev/ https://www.malloydata.dev/ https://github.com/malloydata/malloy https://github.com/malloydata/malloy https://news.ycombinator.com/item?id=30053860 https://news.ycombinator.com/item?id=30053860 PRQL - https://prql-lang.org/ https://prql-lang.org/ https://github.com/PRQL/prql https://github.com/PRQL/prql https://news.ycombinator.com/item?id=36866861 https://news.ycombinator.com/item?id=36866861
- anonzzzies 1y ago> I'm unconvinced the syntax makes a genuine difference Syntax not, but datalog (-ish) does. It's a more natural way (imho of course) to query data. Far more complex queries with less mental overload.
- pbowyer 1y agoEdgeQL - https://www.geldata.com/showcase/edgeql https://www.geldata.com/showcase/edgeql
- Pxtl 1y agoSQL's shortcomings aren't just syntax and the convention of SCREAMING KEYWORDS. There's the lack of algebraic types (particularly galling given the bizarre three-value boolean algebra created by its strange null-handling), the poor composability (why is creating a reusable predicate filter so hard?), the lack of any coherent module system, etc. The fact that something as simple as a tree is such a nuisance in a "relational" database is ludicrous.