Sq.io: jq for databases and more
1–10 of 134 posts
Re: Sq.io: jq for databases and more
#2Dang, I wish I had this while I still had SQL databases.
Re: Sq.io: jq for databases and more
#3I love the idea of pushing JQ and other DSLs close to the database.
I've written jq extensions for SQLite [0] and Postgres [1], but my approach involves basically embedding=pushing the jq compiler into the db. So you can do `select jq(json, jqprogram)` as an alternative to jsonpath.
Trying to understand: Is the main purpose of this to use jq-syntax for cataloging-like functionality and/or cross-query? I mean it's quite a few lines of code, but you inspect the database catalogs and offer a layer on top of that? I mean, how much data is actually leaving the database?
[0] https://github.com/Florents-Tselai/liteJQ [1] https://github.com/Florents-Tselai/pgJQ
Re: Sq.io: jq for databases and more
#4This is neat but I'm not really seeing anything I can't do with standard SQL and CLI tools like psql. Seems like you'd learn more reusable things using standard SQL too.
Re: Sq.io: jq for databases and more
#5Related is Google’s pipe syntax for SQL https://research.google/pubs/sql-has-problems-we-can-fix-the...
Re: Sq.io: jq for databases and more
#6More tools are always great! Even if it doesn't become the mainstream, it's always great to see people explore new ways of dealing with databases!
Re: Sq.io: jq for databases and more
#7I love sq. It's handy for quickly performing simple operations on DBs and outputting that as CSV or JSON. Though my one wish is that the sq query language (SLQ) supported substring matching like SQL's `... LIKE "SOME_STRING%"`. Though you can just invoke SQL manually with `sq sql`
Re: Sq.io: jq for databases and more
#8More tools are always great! Even if it doesn't become the mainstream, it's always great to see people explore new ways of dealing with databases!
More good tools are always great. But I don’t think random clutter is always good.
Fortunately we don’t have to see it so it’s not like it blocks my vision.
But I just wanted to note that the idea of “anything is good” is not really true and I don’t like its spread as there’s opportunity cost. I think we need to spend more attention on evaluation and quality and making good things than the idea that even creating lots of bad things is good in some way.
Re: Sq.io: jq for databases and more
#9Sorry but I am pronouncing that as 'ess-cue` and there is nothing anyone can do about it.
Looks kinda neat for when I don't want or need anything more than bash for a script.
Re: Sq.io: jq for databases and more
#10At some point, why not package Python into a single executable, and symbolic link applications and modules into it for Unixy-ness?
Another POV is all the developers I know who thrive the most and have found the most success: they rate aesthetic concerns the lowest when looking at their tools. That is to say that the packaging or aesthetic coherence in some broader philosophy matters less than other factors.