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.
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.
Is this the same "Deductive Database" mathematical programming language of Google DeepMind mentioned in the latest 3b1b guest video by Aleph0 (where they say the language doesnt have a name yet)
This is what? The third logic/datalog family query language Google launched? What's the internal story? Does each department have their own query engine?
"This is not an officially supported Google product." For all we know, this is just some people having fun, but because they're having their fun at Google, it needs to be open-sourced under the Google umbrella.
I think it's even worse, even stuff they do in their freetime have to be under the Google umbrella if they want to open-source it, just because they work during the daytime at Google.
Readit News
Some notable others:
PreQL/Trilogy - https://github.com/trilogy-data/pytrilogyhttps://news.ycombinator.com/item?id=40728938
Malloy -https://www.malloydata.dev/https://github.com/malloydata/malloyhttps://news.ycombinator.com/item?id=30053860
PRQL - https://prql-lang.org/https://github.com/PRQL/prqlhttps://news.ycombinator.com/item?id=36866861
The fact that something as simple as a tree is such a nuisance in a "relational" database is ludicrous.
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.
https://youtu.be/4NlrfOl0l8U?t=4m8s
Are there any notable implementations of plain Datalog? If not, what’s the reason? Does vanilla Datalog have major limitations? Just curious.
But iirc datomic came with a quite vanilla datalog implementation.
I think it's even worse, even stuff they do in their freetime have to be under the Google umbrella if they want to open-source it, just because they work during the daytime at Google.
I know of PathQuery[0], but that one doesn't have an open source implementation and is much more inspired by Graph query languages than SQL.
[0]: https://arxiv.org/abs/2106.09799