Rainfrog – a database management TUI for Postgres
1–10 of 52 posts
Re: Rainfrog – a database management TUI for Postgres
#2since Wayland there are some issues with DBeaver; this project seems like a great way out!
Re: Rainfrog – a database management TUI for Postgres
#3Looks sleek! But I’m curious, what made you decide that gobang[0] wasn’t cutting it for you?
Re: Rainfrog – a database management TUI for Postgres
#4What 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.
Re: Rainfrog – a database management TUI for Postgres
#5What 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 editing rows is as easy as with a spreadsheet; of course hopefully you don't have to do this often...
- I can change common filters & sorts in the UI with a few clicks instead of having to change SQL; sure, the SQL would only require typing a few characters, but if it's 2 clicks vs. 8 characters, it's still a small win
Downsides are:
- the GUI has an interface for saving queries, but it refuses to let me save them to a subfolder of my project; it wants to save them all in some global location. This doesn't seem good for sharing queries
- if you are doing more complicated sorting or aggregation, it's still easier to just go to psql than to fiddle with the GUI
Re: Rainfrog – a database management TUI for Postgres
#6Looks sleek! But I’m curious, what made you decide that gobang[0] wasn’t cutting it for you? [0] https://github.com/TaKO8Ki/gobang
There are a bunch of these, like [1] and [2], probably a lot more.
--
Re: Rainfrog – a database management TUI for Postgres
#7Looking 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).
Re: Rainfrog – a database management TUI for Postgres
#8What 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…
For results formatting, line selection, etc simply installing pspg as your psql pager helps a lot.
Re: Rainfrog – a database management TUI for Postgres
#9Been 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.
Re: Rainfrog – a database management TUI for Postgres
#10Looking 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).
Agree that it would be nice to specify credentials a different way - however as a workaround: some bash-based shells support prefixing the command with a space as a way of not saving that command into history.
Ref: https://www.gnu.org/software/bash/manual/html_node/Bash-Vari...