Live data from Hacker News

Sq.io: jq for databases and more

sq.io

101–110 of 134 posts

Re: Sq.io: jq for databases and more

#101
post #48

Sometimes I wonder if it wouldn't be more efficient for people to just learn SQL instead of trying to build tools or layers on top of it that introduce more complexities and are harder to search for.

I tend to agree! but this seems to have a subtly different use case. It's actually very cool. I can see this being a good addition to my toolbox.

Re: Sq.io: jq for databases and more

#102

It is great, I installed it, only thing I'd suggest, probably minor, is to also extract the commands to install from the bash script, and put them in the `Install` section directly, I don't run .sh script, especially if they need privileges, so I went through the bash script to take the commands for debian, they're there, probably could also be outside for other kind of people

You can already install sq using several of the common package managers, or build from (Go) source if you prefer.

https://sq.io/docs/install

Re: Sq.io: jq for databases and more

#103
post #7

I 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`

Developer here. Thanks for the kind words.

Substring matching is on my short list (also totally open to a PR!).

Re: Sq.io: jq for databases and more

#104
post #53

Though I respect and applaud the effort that went into creating this and successfully releasing it, It has fewer features than duckdb supports at the moment. Duckdb supports both Postgres, Mysql, SQLite and many other extensions. Postgres: https://duckdb.org/docs/extensions/postgres MySQL: https://duckdb.org/docs/extensions/mysql SQLite: https://duckdb.org/docs/extensions/sqlite You can try this yourself. 1. Clone th…

Duckdb is different, though. Not having tried SQ but it seems like a better tool for quick declarative data-munges/parsing/etc, while Duckdb is more of a real project tool with real SQL.

https://duckdb.org/docs/api/cli/

Re: Sq.io: jq for databases and more

#105
post #56

Earlier quoted context omitted.

For me this feels like the complaints about error handling in Go. People who work with it all the time, don't even think about it past the first week. If you are starting out it might bother people because they are not used to it. Personally I really like working with SQL and find it quite elegant, I always encourage people to use it as it really is a job-superpower if you can just dig up issues directly in the DB qu…

I like Go a lot and can work with it's error handling paradigm, but I still often wonder if the same semantics could be accomplished with less verbosity in a way that makes the underlying algorithm more clear when reading the code.

I've always felt the "verbosity" is a feature.

Verbosity is in the eye of the beholder; To me, it's the verbosity of error handling that makes the algorithm clear. Of course I recognize with others that opinion probably changes depending on whether the person reading a given bit of code views error handling as part of the algorithm.

Re: Sq.io: jq for databases and more

#107
post #48

Sometimes I wonder if it wouldn't be more efficient for people to just learn SQL instead of trying to build tools or layers on top of it that introduce more complexities and are harder to search for.

Sometimes I wonder why these SQL standards cost so much to burn a hole in a millionaire's pocket.

Re: Sq.io: jq for databases and more

#108

Earlier quoted context omitted.

Unless you're the GP your guarantee about the persons motivation is as meaningless as the post you're replying to.

I think his point is that we should treat something given freely, charitably

Charitably?

This! Is! HN!

Re: Sq.io: jq for databases and more

#109
post #48

Sometimes I wonder if it wouldn't be more efficient for people to just learn SQL instead of trying to build tools or layers on top of it that introduce more complexities and are harder to search for.

Yeah. Alternatives to long-established and useful technologies have to meet a high bar before their option pays for their disruption.

Things that seem potentially worth it to me:

* seL4

* Google's SQL syntax tweak

* Rust

* GraalVM

* systemd

* Tree sitter

* LSP

* CMake

* Bazel

These all get you a step change improvement in comprehensibility, safety, or something else important.

Things that seem like more churn than they're worth:

* Noise protocol (relative to TLS)

* JMAP (compared to good old IMAP)

* Nim/Zig/etc.

* Wayland (fait accompli now, but still)

* Varlink

* Fish shell

* YAML/TOML

* Sq?

* Meson

I wish we, as an industry, invested more in improving existing technologies instead of continually abandoning and replacing working solutions.

Re: Sq.io: jq for databases and more

#110
post #107
post #48

Sometimes I wonder if it wouldn't be more efficient for people to just learn SQL instead of trying to build tools or layers on top of it that introduce more complexities and are harder to search for.

Sometimes I wonder why these SQL standards cost so much to burn a hole in a millionaire's pocket.

[deleted]
Post reply on HN