[andrewl]

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.

It does a lot, but stays out of your way.

[1] https://sqlitebrowser.org

[vdemedes]

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.

[toastercat]

I love DB Browser for SQLite. Wish there was something similar for Postgres.