3 ms·
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
by cube2222 7y 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 https://github.com/cube2222/octosql
[2]: https://github.com/cube2222/jql https://github.com/cube2222/jql
- mmalek06 7y agoOctoSQL looks very nice and I’ll check it out soon. Do you have Scala bindings for it?
- mmalek06 7y agoAh, I get it - it’s an uber ORM!
- cube2222 7y agoNah, really just a command line sql query tool. Though could probably be used as an uber orm.
- cube2222 7y agoNo, 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.
- eatonphil 7y agoHave you explored supporting Parquet?
- cube2222 7y agoThere’s a WIP pull request for it, so it should be here soon.
- ecnahc515 7y agoThis is cool, thanks for sharing. Octosql reminds me of Prestosql but as a CLI.
- cube2222 7y agoIndeed, presto has been one of our main inspirations!