Live data from Hacker News

Rainfrog – a database management TUI for Postgres

github.com

41–50 of 52 posts

Re: Rainfrog – a database management TUI for Postgres

#41
post #21

Nice work! Would be cool to have a plugin system that could allow for interfacing with other DBs like sqlite etc.

thank you! support for other DBs is planned, starting with mysql and sqlite. no set timeline yet though

Nice! I see DBeaver and DataGrip implementing connection layer through JDBC.

Not sure if that would be a viable option in Rust.

Re: Rainfrog – a database management TUI for Postgres

#42

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

I didn’t learn this until recently but in psql you can use \e or \editor to open the current line in $EDITOR. It helps a lot.

Re: Rainfrog – a database management TUI for Postgres

#43
post #35

Looks pretty cool. I could see this being useful for some of my coworkers. I might try it with read-only access. I pretty much always use DataGrip or pgcli and don't see that changing, but will keep an eye on this.

Yeah. Reminds me of k9s.

Lazydocker too. I'm not affiliated, just in love

Re: Rainfrog – a database management TUI for Postgres

#45

This looks excellent, with one potential caveat: does it support slash commands (e.g. \dt)?

it does not unfortunately; open to suggestions about common slash commands ppl would like to see included as shortcuts!

All of them would be great, but if not, the most common ones IME are:

    \c
    \d
    \di
    \dt
And the variants (e.g. \dti+)

Re: Rainfrog – a database management TUI for Postgres

#48
post #36
post #20

Earlier quoted context omitted.

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?

Why dumb? Just a question to me, I gladly elaborate. If I loose a connection I used to get a little popup in the bottom right corner when I try to execute a query, explaining why it's not executing. They now popup in the middle of the screen and are much larger. I remember I had to close them by hand at some point, but maybe I'm wrong because I just reproduced it and they closed themselves quickly. Only this little p…

Ah, I understand - this is happening as part of Apples' crusade to rid the world of popup menus. Thanks for the details - I encounter little fiddly issues like this with my own apps, so its good context.

Just to confirm - this happens with the older version of DBeaver, running on the newer version of MacOS, right? You didn't upgrade DBeaver, meanwhile, I assume?

Re: Rainfrog – a database management TUI for Postgres

#49

Earlier quoted context omitted.

nope :)

on a more serious note, the library i used for the query editor, tui-textarea [0], is very well done, and the other db tui i drew inspiration from, gobang[1], is a great example of a ratatui app. would recommend checking those out [0] https://github.com/rhysd/tui-textarea [1] https://github.com/TaKO8Ki/gobang

Looks great! I'll be watching your progress with great interest.

What do you use for the DataTable widget? Is there a Rust/Ratatui equivalent of DataTable (https://textual.textualize.io/widgets/data_table/) used by Harlequin?

Re: Rainfrog – a database management TUI for Postgres

#50
post #49

Earlier quoted context omitted.

on a more serious note, the library i used for the query editor, tui-textarea [0], is very well done, and the other db tui i drew inspiration from, gobang[1], is a great example of a ratatui app. would recommend checking those out [0] https://github.com/rhysd/tui-textarea [1] https://github.com/TaKO8Ki/gobang

Looks great! I'll be watching your progress with great interest. What do you use for the DataTable widget? Is there a Rust/Ratatui equivalent of DataTable ( https://textual.textualize.io/widgets/data_table/ ) used by Harlequin?

yep! ratatui has the Table widget: https://docs.rs/ratatui/latest/ratatui/widgets/struct.Table....
Post reply on HN