| ▲ | jauntywundrkind 4 days ago | |
I'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://news.ycombinator.com/item?id=40728938 Malloy -https://www.malloydata.dev/ https://github.com/malloydata/malloy https://news.ycombinator.com/item?id=30053860 PRQL - https://prql-lang.org/ https://github.com/PRQL/prql https://news.ycombinator.com/item?id=36866861 | ||
| ▲ | Pxtl 3 days ago | parent | next [-] | |
SQL'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. | ||
| ▲ | anonzzzies 4 days ago | parent | prev | next [-] | |
> 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 4 days ago | parent | prev [-] | |