Words from Giovanni
https://github.com/giovapanasiti/sqlite_dashboard
I am a big fan of SQLite with Rails. It works great, it’s cheap for me and my clients, it’s easy to backup and restore and for most of real world usecases I’ve worked on it’s more than enough.
But it comes with some downside.
Once you are running it in production browse the database file is pretty annoying, you must ssh in the server and use the sqlite CLI to browse data, or you need to fire up a rails console and use that one.
It’s not the best experience you have.
I have a client that asked me to access the database and I built for them a UI to allow them to browse the database and do all the queries they need to do.
Giving them ssh access and ask them to use the CLI was not a walkable path.
Then something started to come to my mind, I wished I had that same feature everywhere else. I already knew this feeling. It was time to build an engine just as I did for active_storage_dashboard. So I started building sqlite_dashboard.
Yes, feel free to say I am obsessed with dashboards, lol.
A mountable Rails engine that turns your SQLite databases into something you can actually browse and query through your web browser.
Think of it like the Sidekiq dashboard, but for your databases. Your production environment should be observable without jumping through hoops.
It's just a Rails engine. Mounts in your routes. Uses SQLite3 and CSV from stdlib. CodeMirror and Bootstrap from CDN.