Monday, May 04, 2026

DB GUI 0.4.0 Remember SQL Command History (useful w/ Ruby on Rails DBs)

DB GUI is a Database querying desktop app built in Ruby. It supports PostgreSQL to start. Version 0.4.0 added support for remembering SQL command history. I needed that feature at my job to be able to easily re-run certain SQL queries in our Rails web application, so I added it very quickly, thanks to the awesomeness of Ruby!

GitHub: https://github.com/AndyObtiva/db-gui

RubyGem: https://rubygems.org/gems/db-gui

Here is an animated gif demonstrating how the app works (by the way, you only need to configure the database settings once; afterwards, the app remembers the db config every time you start it, and now also remembers your SQL command history):


You can always open the app code if you are curious how it was built in Ruby (below is a link to the app's entry point View component):

https://github.com/AndyObtiva/db-gui/blob/master/app/db_gui/view/db_gui_application.rb

P.S. I am aware there are countless DB desktop apps out there. I have used many in the past. This project started as a fun learning exercise in Ruby, but now I maintain it to provide examples for others of how to build desktop apps in Ruby, and I like the challenge of extending it. 

No comments:

Post a Comment