Can someone recommend a simple sqlite database browser

[notinmybackyard]

I'm looking for something that isn't too complicated. In fact the easier it is the better.

[BigFurry]

Have you tried https://sqlitebrowser.org/ ?

[notinmybackyard]

Originally Posted by BigFurry

Have you tried https://sqlitebrowser.org/ ?

I've never used one before so I've got to say nope. But I'll check this one out

[Paul&John]

Originally Posted by BigFurry

Have you tried https://sqlitebrowser.org/ ?

Using this as well

[shake]

I'd avoid using sqlite if you can avoid it. There are better options like Postgres or even mySQL. Unless you really need just local storage only.

[notinmybackyard]

Originally Posted by shake

I'd avoid using sqlite if you can avoid it. There are better options like Postgres or even mySQL. Unless you really need just local storage only.

I'm just trying to resurrect some lost emails. So I really don't need anything too complicated.

[Klen]

Originally Posted by shake

I'd avoid using sqlite if you can avoid it. There are better options like Postgres or even mySQL. Unless you really need just local storage only.

I have a lot of experience with sqlite so i can give precise instructions when to use and when not to use it.

So, first when not to use it:
1.If you have multi-user app/script . I made a mistake by using sqlite for my tracker script, and as result i had often deadlocks which caused script to be unresponsive and lost some $$$ due that until i finally switched to mysql.

When to use it:
1.If you have single user app/script. For example, i have script which i developed 10 years ago and i am only user and so far it works without any bug/error.

And advantages of sqlite compared to mysql -
1. Does not require username/password
2. Easy to backup/have only one file
3. It can be encrypted easily for free