I have inherited a ton of data from some unknown database, but I was able to migrate it into SQLite.
Now I will need to do a ton of work with it to figure out all the relationships and test. While I can obviously write all the code to do this, I want to save some time.
Has anyone on this list made a SQLite database tool (commercial or free) that is worth evaluating?
For working with SQLite databases that are encrypted I use https://sqlabs.com/sqlitemanager but it has no dark mode so I don’t use it for anything else.
I use DBeaver. Not free but it can handle multiple database types. Sql and postgres are the ones I use it for. It has a lot features but is easy to use. The cost $99 or $199? might seem high but for all of the features combined with the time savings make it worth it. Will not open xojo password protected dbs though.
It do not wanted to open my .sqlite file; I changed the file extension to sql and it stopped at “Near “SQLite”: syntax error” (and highlight if I can say that SQLite format 3 (3 in red).
I’m cheating a little here… because I mainly use postgres, my app is almost complete for it,
but is missing a lot of features for sqlite… like making foreignkeys.
I have to make them using a sql query. or use some free tool for it. or delete the table and make it again. sqlite is really lacking a lot of structure methods.
if I could get all my users to just use Postgres, I’d be a happy man. Alas there are a ton of SQL Server people out there too, and SQLite is perfect for stand-alone solutions.