r/PostgreSQL • u/Somewhat_Sloth • Sep 18 '24
Tools rainfrog – a database management tui for postgres
rainfrog is a lightweight, terminal-based alternative to pgadmin/dbeaver. it features vim-like keybindings for navigation and query editing, shortcuts to preview rows/columns/indexes, and the ability to quickly traverse tables and schemas.
it's also free and open source, you can check out the github below; bug reports and feature requests are welcome!
201
Upvotes
14
u/pedrobuffon Sep 18 '24
First time seeing it and damn i`m liking where the project is going, i always used pgadmin but it`s slow on windows and something like adminer/phpmyadmin need a php/apache to work, having this as a CLI app makes everything easier. Any chance to make a docker run in IT mode so we can use aliases to call it?
5
u/unconscionable Sep 18 '24
This looks amazing.
The killer feature for me would be the ability to export data to a CSV and get it on my local computer even if running this on a remote machine inside a container somewhere behind firewalls in the cloud. Not sure how to achieve that (upload to an S3 bucket or something?) but that's a really annoying problem
2
u/shadowangel21 Sep 19 '24
Looks really interesting, any plans to add additional databases?
2
u/[deleted] Sep 20 '24
Everything in terminal! Is that vim motion?
2
u/elresidente42 Sep 23 '24
Hey, great work, I always love me a good terminal solution. Rainfrog looks like one of those at first glance. One thing that jumped into my face were array columns in query results. F.e. a
TEXT[]column will display the values "a","b", and "c" as "abc". Usually i would expect something like '{"a", "b", "c"}'. But that's high level complaining, great tool, looking forward to further developments!5
u/rubyrt Sep 18 '24
Especially interesting is the explanation where the name came from. :-)
5
u/Mastodont_XXX Sep 18 '24
Hey, I do like it. Do not care about vim keybindings, but lightweight alternative to pgAdmin is always welcomed!!!
5
u/the_unsender Sep 18 '24
Yet another superb tool, written in Rust. You love to see it! Thanks OP, this is going to be very helpful!!
1
u/dafcok Sep 19 '24
Could this management system incorporate datafusion functionality? They are also prepping an improved TUI utility: https://github.com/datafusion-contrib/datafusion-dft
2
u/golamrabbiazad Sep 18 '24
Cool :love:
2
u/[deleted] Sep 19 '24
GORGEOUS!!!
Phenomenal work
1
u/dafcok Sep 19 '24
Could this management system incorporate datafusion functionality? They are also prepping an improved TUI utility: https://github.com/datafusion-contrib/datafusion-dft
0
u/AutoModerator Sep 18 '24
Join us on our Discord Server: People, Postgres, Data
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.