SQLite and GUI Interfaces

Cross-posted from the Scimatic Blog

A number of our projects use the SQLite database as a backend store. While developing, it’s critical to be able to see what’s in the database.

I’ve used two GUI browsers for SQLite on Windows

  • SQLite Database Browser 2.0, which is a QT based cross platform GUI that was last updated in 2009,
  • SQLite Manager, which is a Firefox XUL based GUI, and in turn uses the base SQLite distributed with Firefox.

I prefer the SQLite Manager; it has more features and looks a bit better. Although it’s tied to Firefox, it can be run outside of the browser as an XULRunner application

The one thing that I didn’t like about the XULRunner implementation is that the icons didn’t show correctly in the toolbar, even when I followed the instructions to link in the chrome/ folder. So I tweaked the sqlite-manager.exe (which is just a shim copy of xulrunner.exe) with Resource Hacker to embed the correct .ico file into the executable. Now it shows correctly on my toolbar.

SQLite manager pinned to Task bar
SQLite manager pinned to Task bar

I’ve uploaded a sqlite-manager.zip file that you can grab if you want. Once SQLite Manager updates from 0.77 to a new version, you will have to tweak the files in this defaults/ folder, but you shouldn’t have to change the xulrunner or sqlite-manager.exe file.

SQLite and GUI Interfaces