I am a Mac person, but will be traveling this coming week with a Windows 10 laptop, and I want to be able to work on on my current Xojo project which is SQLite based.
On the Mac I mainly use the (now defunct) FireFox plugin “Sqlite Manager” (Firefox changed architecture and no longer supports it.
I like how it supports views Like tables (being able to see the fields in the tree) and make it easy to edit them . I also like how it has Table searching without SQL in addition to doing SQL queries, and the option for exporting query results.
Of course I also use it to test queries I am coding into my app.
So any recommendations for free SQLite tools with at least these capabilities (more is OK ) that are easy to use?
I like SQLiteStudio because you can save multiple databases that are show in the tree view when it opens. (And it’s free) https://sqlitestudio.pl/index.rvt
I like DB Browser for it’s simplicity although I don’t use it much anymore. (And it’s free) http://sqlitebrowser.org/
My favorite now is Valentina Studio. It can connect to many types of databases. It has a nice SQL editor. It can show records from linked tables in a split screen. Also i like the fact you can edit data in the grid and the database is updated when focus is lost.
It’s free and the free version really does all I need. I do have the pro version $150 because it came with the omega bundle. https://valentina-db.com/en/valentina-studio-overview
if you like the CLI you can load SQLite itself on your windows machine and do things that way. If you are not a big CLI person or a big SQL person, I would use one (or more) of the above mentioned ones.