Show HN: Querying JSON documents using SQL-like language in Scala

Re:Show HN: Querying JSON documents using SQL-like language ... by cube2222 on Tuesday February 25, 2020 @04:52PM (#22417874)

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

[ Parent | on HN ]

Re:Show HN: Querying JSON documents using SQL-like language ... by mmalek06 on Tuesday February 25, 2020 @05:15PM (#22418070)

OctoSQL looks very nice and I’ll check it out soon. Do you have Scala bindings for it?

[ Parent | on HN ]

Re:Show HN: Querying JSON documents using SQL-like language ... by cube2222 on Tuesday February 25, 2020 @05:23PM (#22418147)

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.

[ Parent | on HN ]

Re:Show HN: Querying JSON documents using SQL-like language ... by mmalek06 on Tuesday February 25, 2020 @05:17PM (#22418084)

Ah, I get it - it’s an uber ORM!

[ Parent | on HN ]

Re:Show HN: Querying JSON documents using SQL-like language ... by cube2222 on Tuesday February 25, 2020 @05:47PM (#22418354)

Nah, really just a command line sql query tool. Though could probably be used as an uber orm.

[ Parent | on HN ]

Re:Show HN: Querying JSON documents using SQL-like language ... by ecnahc515 on Tuesday February 25, 2020 @06:51PM (#22418830)

This is cool, thanks for sharing. Octosql reminds me of Prestosql but as a CLI.

[ Parent | on HN ]

Re:Show HN: Querying JSON documents using SQL-like language ... by cube2222 on Wednesday February 26, 2020 @12:37AM (#22420593)

Indeed, presto has been one of our main inspirations!

[ Parent | on HN ]

Re:Show HN: Querying JSON documents using SQL-like language ... by eatonphil on Tuesday February 25, 2020 @06:09PM (#22418542)

Have you explored supporting Parquet?

[ Parent | on HN ]

Re:Show HN: Querying JSON documents using SQL-like language ... by cube2222 on Wednesday February 26, 2020 @12:36AM (#22420588)

There’s a WIP pull request for it, so it should be here soon.

[ Parent | on HN ]