Free Sqlite tool for Windows?

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 :wink: ) that are easy to use?

Thanks,

  • Karen

Well its not free… but my Tadpole tool should be quite up to the task.
For $34.95 you get 3 licenses and these can be any mix of macOS or Windows

A free demo is available
www.rdS.com/tadpole

Maybe SQLiteStudio will help you. I don’t know if it has all the features that you want/need.

smartdata-for-sqlite-now-freet
Both mac and windows

You might check out http://www.sqliteexpert.com/. There is a personal edition that is free.

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.

I use sqlitebrowser from http://sqlitebrowser.org/ . Free & easy.

Thanks All!

I will give some of these a try on my trip.

  • Karen

BAD test:

I loaded a small .sqlite file that have a Picture Column (with two or three Records filled with ID photo).

Nice.

I exported the data as csv and get the csv with the Photo IDs.

But what am I awaiting from a multi purpose tool ?

Of course, my csv export (in my project) does not embed the Pictures (as binary in the text file).

Valentina Studio remains free on Windows, MacOS and Linux, and supports SQLite.

I use SQLite studio too. It’s lightweight and powerful enough. It only lacks a graphical designer.