Show HN: MistQL, a mini-language for querying JSON-like structures

anyfactor4y ago· 3 in thread

I love it but I do wonder if there is anything out there that is syntactically similar to SQL for querying JSON.

tehlike4y ago

Linqjs is not similar but better :)

beamatronic4y ago

Couchbase N1QL

anyfactor4y ago

I hoped there would be a standalone opensource version of this.

1 more reply

convolvatron4y ago· 3 in thread

i dont really like the pipes as a model

but congratulations on working to break out of the existing flawed paradigms like sql. at least you have composition.

evinismOP4y ago

i'd love to hear more about your thoughts on pipes. Any particular reason they don't sit right with you?

convolvatron4y ago

oh, its not the end of the world. thinking on this is I think its that its procedural (how not what). I guess I still really like the notion of programming as unification for this kind of thing.

adamius4y ago

I like the pipes approach. Clear syntax makes a difference.

SahAssar4y ago· 1 in thread

The comparison section should probably include JSONPath, which for example PostgreSQL uses for this.

eatonphil4y ago

And jsquery, an extension for searching nested jsonb objects/arrays in postgres.

https://github.com/postgrespro/jsquery

gigatexal4y ago

Very cool. Going to play with this. Thank you! I couldn’t wrap my head around jq so this is lovely.

ogazitt4y ago

This is pretty sweet! I always have to look up jq docs if I want to do anything complex, but your pipe model seems more intuitive. Also, I love that there's both a library and a CLI.

thefounder4y ago

I think some SQL subset for json would just suffice...easy to read and well known as well.

Show HN: MistQL, a mini-language for querying JSON-like structures (opens in new tab)

Show HN: MistQL, a mini-language for querying JSON-like structures (opens in new tab)

14 comments

14 comments