Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Harlequin: SQL IDE for Your Terminal

github.com

Post reply on HN
Print view View original

51–60 of 89 posts

Re: Harlequin: SQL IDE for Your Terminal

#51

Post by sgarland »

sprash wrote: post #8
alberth wrote: post #7

Question: do people love TUI, because they love being in a terminal? Or ... is this a movement against application bloat, which has become all to common these days? EDIT: why the downvotes?

If you develop SQL you need to write code and view tables. A grid with monospace characters is perfectly suitable for that. But other than that, no, people don't love being in a terminal. It just happens that all open source portable toolkits like qt and gtk do not work via ssh and are in general total abominations for developers and users. The vt100 standard is 45 years old and turned out to be the lowest common den…

Me. I love being in the terminal. Full-screen nvim with split buffers. If I want a terminal I can spawn it from inside nvim as a new buffer, or use my terminal emulator (kitty)’s native split functionality. I can do git actions without leaving nvim, too.

Re: Harlequin: SQL IDE for Your Terminal

#52

Post by sgarland »

nicoco wrote: post #18
pmarreck wrote: post #15

Every time I notice something is a Python codebase I feel a letdown as it means it will likely break some other Python project from someone else I have on my dev machine which I may not have touched in a while but which I will find got silently broken when I most need it Especially if it's a nice TUI app like this looks EDIT: Guys, in my experience, virtual environments do not fix this problem in all cases . At least…

Install using pipx to avoid that. (or virtualenvs directly if you don't mind getting your hands dirty)

While I do like pipx, and am a diehard Python fan, if the interpreter used to install the project changes, I still have to reinstall the project, which is annoying.

I suppose I could get around that by installing a Python interpreter outside of brew, and only use that for packages.

Re: Harlequin: SQL IDE for Your Terminal

#53

Post by tconbeer »

patja wrote: post #4

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

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

#54

Post by tconbeer »

chrsig wrote: post #14
boomskats wrote: post #9

Earlier quoted context omitted.

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

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 ha…

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

#56

Post by tconbeer »

alberth wrote: post #7

Question: do people love TUI, because they love being in a terminal? Or ... is this a movement against application bloat, which has become all to common these days? EDIT: why the downvotes?

I originally wrote this because sometimes a CLI or TUI is just super convenient. I used to use the DuckDB and Sqlite CLIs a lot, but was frustrated by their limitations, especially for doing data analysis work (my background).

Re: Harlequin: SQL IDE for Your Terminal

#57

Post by andrewl »

alberth wrote: post #7

Question: do people love TUI, because they love being in a terminal? Or ... is this a movement against application bloat, which has become all to common these days? EDIT: why the downvotes?

I do a lot of work with SQLite, and I do sometimes use one of the GUI clients (specifically sqlitebrowser.org). However, I mostly use the command line client that comes with SQLite, not because of how many features it has (not a lot) but because I use Bash and everything that comes with it, across various sessions managed with Tmux, as part of what I do with SQLite. It’s the same reason I usually use Vim in a terminal session instead of the GUI version. Using the GUI version means stepping away from a lot of my best tools.

Re: Harlequin: SQL IDE for Your Terminal

#58

Post by alberth »

tconbeer wrote: post #55

Author here. Thanks for more love for Harlequin. I’ll be checking back and responding to feedback and questions for the next few hours.

Looks super impression. Congrats.

A few questions ...

a. what caused you to start working this?

b. any particular reason why you chose to implement it the way you did (e.g. I see you use Python + Textual as opposed to something like https://charm.sh/libs/)

c. any major functionality you feel it's missing?

d. any limitations (e.g. doesn't work with Oracle?)

e. any reason why someone should not use it?

Thanks in advance.

Post reply on HN