News for hackers. Stuff that matters.
Re:Harlequin: SQL IDE for Your Terminal by patja on Friday January 05, 2024 @03:12PM (#38884200)
Suggestion: under "works with your database" consider naming the databases rather than only offering a list of icons.

Also seems to be a bit of hubris to claim a SQL IDE "works with your database" when SQL Server and Oracle, two of the database products with the largest market share, are not supported (yet?)

Re:Harlequin: SQL IDE for Your Terminal by garciasn on Friday January 05, 2024 @03:16PM (#38884260)
Agreed. I found the current connectors in their docs here: https://harlequin.sh/docs/adapters

I’m pretty pumped to try this seeing BigQuery is supported.

Re:Harlequin: SQL IDE for Your Terminal by boomskats on Friday January 05, 2024 @03:34PM (#38884518)
> SQL Server and Oracle, two of the database products with the largest market share

Agree on the first point, but is 'market share' - a metric comparing commercial sales revenue which by definition excludes open source software, really that relevant when critiquing a tagline for a FOSS tool implicitly targeting FOSS databases at a time when FOSS dominates?

If this wasn't an MIT licensed project without a single hint of a commercial offering I'd get it, but come on.

Re:Harlequin: SQL IDE for Your Terminal by chrsig on Friday January 05, 2024 @03:43PM (#38884634)
It's relevant in that they're prolific databases, so there's a nontrivial chance that a user of one of them will:

- stumble across the tool

- read that it "works with their database"

- hopefully read the actual list of supported databases

- become disappointed to learn that it does not in fact work with their database

In the case that hopes are not met, the user actually downloads the application and discovers the hard way that it does not work with their database.

So market share does seem relevant to the frequency of disappointment though. Is it going to be a frequent enough occurrence to be worth spending any time doing anything about? I don't know.

Re:Harlequin: SQL IDE for Your Terminal by tconbeer on Friday January 05, 2024 @05:39PM (#38886011)
Author here. If that disappointment fuels a half day of dev time, anyone who knows Python can just create their own adapter.
Re:Harlequin: SQL IDE for Your Terminal by pmarreck on Friday January 05, 2024 @04:33PM (#38885272)
> SQL Server and Oracle

Alright so first off, for 90% of SQL Server's existence, Microsoft was openly open-source-hostile, so give me a fucking break with this. Microsoft used to be way worse than even Apple about keeping everything in their ecosystem- at least Apple is built on BSD underpinnings and was therefore also always compatible with POSIX stuff.

Oracle... last I checked on that monstrosity it had about 20 different clients all written at different times for different use cases over the long course of Oracle's history. So, which of these 20 different clients should one write a TUI for?

Re:Harlequin: SQL IDE for Your Terminal by Koshkin on Friday January 05, 2024 @04:51PM (#38885455)
> give me a fucking break

No we won't :)

https://pypi.org/project/pyodbc/

Re:Harlequin: SQL IDE for Your Terminal by tconbeer on Friday January 05, 2024 @05:38PM (#38885998)
Fair enough (author here). I just launched support for any databases other than DuckDb and published a guide to create adapters for new dbs. I’m expecting the community to step up here, since I’d rather spend my time adding features to Harlequin. ODBC should be coming shortly. The hard part is honestly just having access to a DB server for testing.
Re:Harlequin: SQL IDE for Your Terminal by e12e on Saturday January 06, 2024 @01:24PM (#38893783)
> The hard part is honestly just having access to a DB server for testing.

Fwiw Microsoft SQL server is available as a Linux Docker build:

https://learn.microsoft.com/en-us/sql/linux/quickstart-insta...

Oracle is available as a container and vm:

https://container-registry.oracle.com/ords/f?p=113:4:1173021...

https://github.com/oracle/vagrant-projects

Re:Harlequin: SQL IDE for Your Terminal by tconbeer on Tuesday January 09, 2024 @06:20PM (#38933765)
harlequin-odbc was released today. https://harlequin.sh/docs/odbc/index