Hacker News new | ask | show | jobs
by cube2222 2310 days ago
As people always do in such threads, I’d too like to chime in with alternatives I’ve been a co-author of, as this is an area I’m very interested in.

The first one, which is definitely close in spirit to this project is OctoSQL[1]. We too are trying to query all the things with SQL, including JSON, though we extended the idea to supporting more data sources and file formats, with the ability to mix and match in joins and subqueries. Curious what direction this project will take though, as we’re now heading for streaming sources (like Kafka) in pure SQL!

A totally different one is jql[2] where I’ve been exploring more of a lispy continuation passing style based approach to a JSON query language, as I didn’t really feel like the current ones are ergonomic.

If you like this, make sure to check them out too! (And all the others people will be posting, as I think they all are fascinating! This is a big area with lots of space for innovation left.)

[1]: https://github.com/cube2222/octosql

[2]: https://github.com/cube2222/jql

3 comments

OctoSQL looks very nice and I’ll check it out soon. Do you have Scala bindings for it?
No, though people have contributed R and Python bindings already. So one may hope :) though Go is fairly unfriendly to binding from other languages (because of the runtime overhead).

We ourselves mainly work on the command line interface and concentrate on it.

Ah, I get it - it’s an uber ORM!
Nah, really just a command line sql query tool. Though could probably be used as an uber orm.
This is cool, thanks for sharing. Octosql reminds me of Prestosql but as a CLI.
Indeed, presto has been one of our main inspirations!
Have you explored supporting Parquet?
There’s a WIP pull request for it, so it should be here soon.