4 ms·
Show HN: MistQL, a mini-language for querying JSON-like structures
- SahAssar 5y agoThe comparison section should probably include JSONPath, which for example PostgreSQL uses for this.
- eatonphil 5y agoAnd jsquery, an extension for searching nested jsonb objects/arrays in postgres. https://github.com/postgrespro/jsquery https://github.com/postgrespro/jsquery
- gigatexal 5y agoVery cool. Going to play with this. Thank you! I couldn’t wrap my head around jq so this is lovely.
- convolvatron 5y agoi 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.
- evinism 5y agoi'd love to hear more about your thoughts on pipes. Any particular reason they don't sit right with you?
- convolvatron 5y agooh, 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.
- adamius 5y agoI like the pipes approach. Clear syntax makes a difference.
- ogazitt 5y agoThis 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.
- anyfactor 5y agoI love it but I do wonder if there is anything out there that is syntactically similar to SQL for querying JSON.
- tehlike 5y agoLinqjs is not similar but better :)
- beamatronic 5y agoCouchbase N1QL
- anyfactor 5y agoI hoped there would be a standalone opensource version of this.
- beamatronic 5y agoWell, there's this... https://github.com/couchbase/query https://github.com/couchbase/query
- thefounder 5y agoI think some SQL subset for json would just suffice...easy to read and well known as well.