There are great apps out there, but all of them are too complicated and too powerful. What I wanted is to have a nice minimalistic app where I could collect all my queries that I often use for debugging various stuff. That's why I won't add things like data editing or schema changes to Rosefinch. If you need extensive features like that, you'll definitely be better of with SQLiteStudio or alternatives ;)
SQLite is a big part of our tool chain, and has been very good to us. We’ve been using DB Browser for SQLite[1] for several years. It runs on Windows, Mac, and Linux.
Rosefinch looks nice, but I’m not seeing a real use case. If I had a bunch of queries I was always running, I’d probably just make them views, available to me in any client, including the command line. (Sometimes the command line is best.)
If I didn’t want to go that far, DB Browser for SQLite lets you save a work session. Whatever tabs of SQL you have open are preserved, and can be run again at will, the same as Rosefinch. You can also rename them from their default names, which are just SQL 1, SQL2, etc.
That's cool, if that app works for you, keep using it.
I'm not trying to convince anyone to switch or use Rosefinch anyway. I built it because I needed it exactly like this and shared it here in case there's someone else who wants something like this too.