GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   Can someone recommend a simple sqlite database browser (https://gfy.com/showthread.php?t=1322217)

notinmybackyard 01-18-2020 01:58 PM

Can someone recommend a simple sqlite database browser
 
I'm looking for something that isn't too complicated. In fact the easier it is the better.

BigFurry 01-18-2020 02:19 PM

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

notinmybackyard 01-18-2020 02:37 PM

Quote:

Originally Posted by BigFurry (Post 22596008)

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

Paul&John 01-18-2020 03:36 PM

Quote:

Originally Posted by BigFurry (Post 22596008)

Using this as well

shake 01-18-2020 04:25 PM

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 01-18-2020 04:38 PM

Quote:

Originally Posted by shake (Post 22596054)
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 01-19-2020 10:54 AM

Quote:

Originally Posted by shake (Post 22596054)
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


All times are GMT -7. The time now is 01:32 PM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123