Live data from Hacker News

Rainfrog – a database management TUI for Postgres

github.com

21–30 of 52 posts

Re: Rainfrog – a database management TUI for Postgres

#23

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

Generally if you put a space before your command it'll bypass the history, though depending on your *nix you might need to set `HISTCONTROL=ignoreboth` in your bashrc or similar if it's not already.

Re: Rainfrog – a database management TUI for Postgres

#24
post #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

I found it but great in handling interactivity compared to https://github.com/gui-cs/Terminal.Gui

Re: Rainfrog – a database management TUI for Postgres

#25
post #3

Looks sleek! But I’m curious, what made you decide that gobang[0] wasn’t cutting it for you? [0] https://github.com/TaKO8Ki/gobang

main reason was that it hadn't been updated in a while. i also wanted the query editor to be more flexible / not limited to just filtering

Re: Rainfrog – a database management TUI for Postgres

#26
post #8

Earlier quoted context omitted.

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…

For results formatting, line selection, etc simply installing pspg as your psql pager helps a lot.

oh wow, if i had known about pspg beforehand i might not have made this, it looks great!

Re: Rainfrog – a database management TUI for Postgres

#27

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.

a big one for me is being able to jump between/search for tables and preview their rows, columns, and indexes quickly; especially when there are many tables/schemas and i don't remember their names

another one is a more comfortable editing experience for queries

Re: Rainfrog – a database management TUI for Postgres

#30

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

that makes sense, thank you for opening an issue!
Post reply on HN