5 ms·

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 clai

by patja 3y ago

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?)

garciasn 3y ago
Agreed. I found the current connectors in their docs here: https://harlequin.sh/docs/adapters https://harlequin.sh/docs/adapters I’m pretty pumped to try this seeing BigQuery is supported.
boomskats 3y ago
> 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.
- chrsig 3y ago
  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.
  - tconbeer 3y ago
    Author here. If that disappointment fuels a half day of dev time, anyone who knows Python can just create their own adapter.
deleted 3y ago
[deleted]
pmarreck 3y ago
> 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?
- Koshkin 3y ago
  > give me a fucking break No we won't :) https://pypi.org/project/pyodbc/ https://pypi.org/project/pyodbc/
tconbeer 3y ago
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.
- e12e 3y ago
  > 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-install-connect-docker?view=sql-server-ver16 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:117302132754070:::4:P4_REPOSITORY,AI_REPOSITORY,AI_REPOSITORY_NAME,P4_REPOSITORY_NAME,P4_EULA_ID,P4_BUSINESS_AREA_ID:803,803,Oracle%20Database%20Express%20Edition,Oracle%20Database%20Express%20Edition,1,0&cs=3gHks_8F924aSHIhBvP0MCOEexZZjXTOG7Q6s6897m4_ZDQ8UxLpZyvl_SU0guSc2W9sroWsZw3opuAspyRbK2w https://container-registry.oracle.com/ords/f?p=113:4:1173021... https://github.com/oracle/vagrant-projects https://github.com/oracle/vagrant-projects
- tconbeer 3y ago
  harlequin-odbc was released today. https://harlequin.sh/docs/odbc/index https://harlequin.sh/docs/odbc/index

by patja 3y ago

garciasn 3y ago

Agreed. I found the current connectors in their docs here: https://harlequin.sh/docs/adapters https://harlequin.sh/docs/adapters I’m pretty pumped to try this seeing BigQuery is supported.

boomskats 3y ago

> 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.

chrsig 3y ago
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.
- tconbeer 3y ago
  Author here. If that disappointment fuels a half day of dev time, anyone who knows Python can just create their own adapter.

deleted 3y ago

[deleted]

pmarreck 3y ago

> 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?

Koshkin 3y ago
> give me a fucking break No we won't :) https://pypi.org/project/pyodbc/ https://pypi.org/project/pyodbc/

tconbeer 3y ago

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.

e12e 3y ago
> 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-install-connect-docker?view=sql-server-ver16 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:117302132754070:::4:P4_REPOSITORY,AI_REPOSITORY,AI_REPOSITORY_NAME,P4_REPOSITORY_NAME,P4_EULA_ID,P4_BUSINESS_AREA_ID:803,803,Oracle%20Database%20Express%20Edition,Oracle%20Database%20Express%20Edition,1,0&cs=3gHks_8F924aSHIhBvP0MCOEexZZjXTOG7Q6s6897m4_ZDQ8UxLpZyvl_SU0guSc2W9sroWsZw3opuAspyRbK2w https://container-registry.oracle.com/ords/f?p=113:4:1173021... https://github.com/oracle/vagrant-projects https://github.com/oracle/vagrant-projects
tconbeer 3y ago
harlequin-odbc was released today. https://harlequin.sh/docs/odbc/index https://harlequin.sh/docs/odbc/index