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

61–70 of 89 posts

Re: Harlequin: SQL IDE for Your Terminal

#61

Post by tconbeer »

alberth wrote: post #58
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 advan…

A. I was using the DuckDB CLI and kept hitting walls on analyses. Had a shower thought of “I wonder if anyone has used Textual for a DuckDB client” and decided to build one myself. B. This uses Textual, a python framework for TUIs. Python is my language of choice. C. Hoping for more db adapters soon. Canceling queries is a missing piece I have yet to figure out E. Maybe if you don’t use Python apps and do have another sql client you really like.

Re: Harlequin: SQL IDE for Your Terminal

#64

Post by MilaM »

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?

They are very convenient when I work on remote servers over ssh, even if it's just my server at home. Programs I use regularly (no specific order):

vim ncdu nnn mqqtui htop gitui tmux lnav lazydocker ctop

Re: Harlequin: SQL IDE for Your Terminal

#65

Post by zozbot234 »

Looks nice already, but a true "SQL IDE" should also strive for feature parity with existing database frontends like LibreOffice Base, or with old-style MS-DOS/TUI applications for database access which had a similar featureset. Meaning an integrated view of database design, data entry/inspection (with full-screen, form-like views for individual records where appropriate!), custom querying (including a more-or-less seamless integration of QBE and raw SQL) and report generation. Hopefully we're going to see some of this in future releases!

Re: Harlequin: SQL IDE for Your Terminal

#66

Post by xwowsersx »

tconbeer wrote: post #63
xwowsersx wrote: post #62

Looks great. Is it just DuckDB and SQLite for now? No Postgres?

You can install adapters for pg, MySQL, big query, and trino, with others coming soon. harlequin.sh for more info

Thanks. I must've missed it. I'll take another look.

Re: Harlequin: SQL IDE for Your Terminal

#67

Post by SlackingOff123 »

neverartful wrote: post #47
billowycoat wrote: post #46

Earlier quoted context omitted.

https://textual.textualize.io/

That's impressive! Anyone know if there are similar libraries available for other languages?

I like this one for .NET https://github.com/spectreconsole/spectre.console which I found in this list https://github.com/shadawck/awesome-cli-frameworks.

Re: Harlequin: SQL IDE for Your Terminal

#69

Post by tconbeer »

Fuzzwah wrote: post #68
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.

Is there a way to order the list of tables in the left hand pane?

Not yet. What order would you like to see?

Re: Harlequin: SQL IDE for Your Terminal

#70

Post by dang »

ChrisArchitect wrote: post #48

https://harlequin.sh/ There was a Show HN: from the author and this thread and discussion last year: https://news.ycombinator.com/item?id=37588526

Thanks! Macroexpanded:

Harlequin: DuckDB IDE for the terminal - https://news.ycombinator.com/item?id=37588526 - Sept 2023 (58 comments)

Post reply on HN