Sq.io: jq for databases and more • Hacker News Board

Re: Sq.io: jq for databases and more

#131

Post by syndicatedjelly » Wed, Oct 09, 2024, 5:26 AM UTC

neilotoole wrote: post #91

remon wrote: post #49

Earlier quoted context omitted.

HN is inundated with posts announcing paper thin abstractions on top of existing technology or utilities that just move the goalpost of what you knowledge you need to be effective. It's a weird trend that seems almost entirely motivated by people wanting open source projects in their resume, or seek funding if its a startup.

> It's a weird trend that seems almost entirely motivated by people wanting open source projects in their resume Developer here. I can't speak to what you see as the weird trend, but I can speak about sq's history: - I created the first version of sq circa 2013 as my own personal dev tool to address some pain points (amongst other things: getting JSON out of various DBs from the command line in a consistent manner, a…

Thank you for creating a composable, simple to grok Unix tool. sq is an example of what is so great about the Unix philosophy.

Personally, I can see a spot for sq in my developer toolbox. Instead of reaching for DBeaver’s bloated interface, or psql’s perplexing TUI, I like the idea of picking up an sq multitool to answer some simple questions quickly about my databases.

Thanks again!

Re: Sq.io: jq for databases and more

#132

Post by peter_d_sherman » Wed, Oct 09, 2024, 2:26 PM UTC

First there was shell scripting, then grep, then sed, then awk, later Perl... well, now there's 'sq'!

Looks like an absolutely great (and necessary!) utility, which will automate many future workflows and dataflows, save countless hours of time collectively for many people en masse, and therefore change the world (allow more people to get more done in less time!) much like Unix, shell scripting, grep, sed, awk and Perl gave the world...

Congratulations on writing what no doubt will become one of the major Unix/Windows/MacOS/Other OS/Linux shell scripting commands in the future, if it isn't already!

Well done!

Re: Sq.io: jq for databases and more

#133

Post by EGreg » Wed, Oct 09, 2024, 6:30 PM UTC

EGreg wrote: post #111

fforflo wrote: post #76

Earlier quoted context omitted.

Paraphrasing Spencer: Those who don't understand SQL are doomed to reinvent it, poorly

Actually, when it comes to SQL specifically, it almost demands using a language one higher up. Any language that features the ability to embed/interpolate unescaped quotes is not secure enough to be used directly by professional developers. Just not worth it to track down all the potential injection attacks. And if an abstraction lets you understand the structure of queries (eg for sharding them) and even writes the…

I did it -- posting it here: https://github.com/Qbix/Db

Re: Sq.io: jq for databases and more

#134

Post by Hugsun » Thu, Oct 10, 2024, 11:07 AM UTC

EGreg wrote: post #111

fforflo wrote: post #76

Earlier quoted context omitted.

Paraphrasing Spencer: Those who don't understand SQL are doomed to reinvent it, poorly

Actually, when it comes to SQL specifically, it almost demands using a language one higher up. Any language that features the ability to embed/interpolate unescaped quotes is not secure enough to be used directly by professional developers. Just not worth it to track down all the potential injection attacks. And if an abstraction lets you understand the structure of queries (eg for sharding them) and even writes the…

There's no reason not to post it.