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

#1

Post by evinism » Sat, Oct 30, 2021, 5:39 PM UTC

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

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

#2

Post by gigatexal » Sat, Oct 30, 2021, 5:44 PM UTC

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

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

#3

Post by convolvatron » Sat, Oct 30, 2021, 8:51 PM UTC

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.

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

#4

Post by evinism » Sat, Oct 30, 2021, 9:43 PM UTC

convolvatron wrote: post #3

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.

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

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

#5

Post by adamius » Sat, Oct 30, 2021, 10:51 PM UTC

evinism wrote: post #4

convolvatron wrote: post #3

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.

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

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

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

#6

Post by ogazitt » Sat, Oct 30, 2021, 11:03 PM UTC

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.

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

#7

Post by anyfactor » Sun, Oct 31, 2021, 12:17 AM UTC

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

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

#8

Post by tehlike » Sun, Oct 31, 2021, 12:24 AM UTC

anyfactor wrote: post #7

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

Linqjs is not similar but better :)

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

#9

Post by thefounder » Sun, Oct 31, 2021, 2:58 AM UTC

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

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

#10

Post by beamatronic » Sun, Oct 31, 2021, 5:59 AM UTC

anyfactor wrote: post #7

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

Couchbase N1QL