Live data from Hacker News

Rainfrog – a database management TUI for Postgres

github.com

11–20 of 52 posts

Re: Rainfrog – a database management TUI for Postgres

#12

Looking forward to trying it, though would be nice if credentials could be specified in a different way than on the command line (whereby they'll get saved into your command line history).

`psql` allows for putting your credentials in a dotfile with a very simple syntax. Should be quick to add support for, and would create a seamless onboarding experience for people who are already using `psql`.

Re: Rainfrog – a database management TUI for Postgres

#13

What would you say are the key benefits of using this over psql? Is it mainly table metadata and properties? Asking because running queries, history, formatting of results etc. can be achieved by configuring psqlrc.

Not OP, but I personally put off using a UI for years before finally trying a few and eventually settling on Postico for Mac. I still jump to psql often, but for me it's an accumulation of small quality-of-life improvements: - results are formatted nicely by default; no more doing a first query, getting too many columns so results wrap unreadably, then changing the columns for a second query, and so on - manually edi…

would symlinks in that global location help, maybe?

Re: Rainfrog – a database management TUI for Postgres

#15
post #9

Been seeing lots of cool TUIs built with ratatui. Can anyone offer a comparison between ratatui and Golang https://github.com/charmbracelet/bubbletea ? I've been wanting to get into building a TUI but can't decide which library to pick.

I second this, could some also add C#'s "Spectre.Console" https://github.com/spectreconsole/spectre.console

Re: Rainfrog – a database management TUI for Postgres

#16
post #9

Been seeing lots of cool TUIs built with ratatui. Can anyone offer a comparison between ratatui and Golang https://github.com/charmbracelet/bubbletea ? I've been wanting to get into building a TUI but can't decide which library to pick.

I've been using both.

Charm/bubbletea toolstack, is very much focused on an ELM style architecture, I.e. message passing and deriving UI from state. You can still do immediate type UI if that is what you prefer, but it won't fit with any of the standard components. Bubbletea is a framework more or less, so even if you know Go, it will require you to learn how to build to its strengths.

Ratatui is by default not very opinionated about how to handle state and updates, which requires some development from you, or using a third party library to get an opinionated architecture around it. Ratatui is more of a collection of libraries, out of the box, it expects a certain interface for components, but it is up to you how you want to compose them together. Whether that is immediate-, stateful-, react-, or ELM style. Stateful is the default for all their examples.

Charms way of doing terminal UI is very much based around strings, which can sometimes give issues with spacing, as components can be fiddly to be constrained within a certain space.

Ratatui creates UI on top of a matrix of bytes, which makes it more difficult to do easy things, but allows you to more easily build complex uis.

Generally I prefer Ratatui, as you can really build robust and fast uis on top of it. It does take a bit more work to get started though. I am also biased by Rust tho.

Re: Rainfrog – a database management TUI for Postgres

#17
post #11
post #2

since Wayland there are some issues with DBeaver; this project seems like a great way out!

What are some of the issues?

popups are windows. selecting+copying text from the results-table does not work the first time. clicking in the left pane on a connection sometimes picks the wrong one (really weird this one as it is not consistent). i only see the standard wayland icon (not the worst).

Re: Rainfrog – a database management TUI for Postgres

#18
post #16
post #9

Been seeing lots of cool TUIs built with ratatui. Can anyone offer a comparison between ratatui and Golang https://github.com/charmbracelet/bubbletea ? I've been wanting to get into building a TUI but can't decide which library to pick.

I've been using both. Charm/bubbletea toolstack, is very much focused on an ELM style architecture, I.e. message passing and deriving UI from state. You can still do immediate type UI if that is what you prefer, but it won't fit with any of the standard components. Bubbletea is a framework more or less, so even if you know Go, it will require you to learn how to build to its strengths. Ratatui is by default not very…

Ratatui maintainer here. I'd agree with all of the above points.

The lack of opinionated approach stems from Ratatui being not a framework, but a library (you call us, we don't call you), and not having any of the event/input handling things included.

There's likely room for a framework or two on top of it.

Re: Rainfrog – a database management TUI for Postgres

#20
post #17
post #11

Earlier quoted context omitted.

What are some of the issues?

popups are windows. selecting+copying text from the results-table does not work the first time. clicking in the left pane on a connection sometimes picks the wrong one (really weird this one as it is not consistent). i only see the standard wayland icon (not the worst).

Sorry for the dumb question, but what is the significance of this issue, "popups are windows"? Has something changed in Wayland which makes child windows unworkable?
Post reply on HN