Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why does sqlite database browser freeze instead of give an error?

Tags:

sqlite

When using the SQLite Database Browser if I don't use the right syntax the whole program freezes instead of provides an error message. Is anyone else running into this and if so is there some way around this? The only way around it is for me to force quit the whole application and start over again.

Otherwise is there a better free sqlite query browser I could use for simple queries?

Thanks.

like image 627
jroyce Avatar asked Mar 05 '12 04:03

jroyce


People also ask

Why does SQLite lock?

Cause of the error Normally, the error occurs when two users try to run transactions on the same tables and change the content. SQLite engine finds it abnormal and locks the database. Now, the user cannot run more transactions.

Is DB browser for SQLite good?

DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.

Can SQLite get corrupted?

An SQLite database is highly resistant to corruption. If an application crash, or an operating-system crash, or even a power failure occurs in the middle of a transaction, the partially written transaction should be automatically rolled back the next time the database file is accessed.

Does SQLite lock entire database?

However, SQLite read locks are shared locks that lock the whole database, so another application cannot update the database until Uniface has released its read locks.


1 Answers

Ok, the assumed answer is that the SqLite Database Browser sucks and it not fully operational. I will try some of the other free sqlite browsers and press my luck.

like image 200
jroyce Avatar answered Sep 28 '22 02:09

jroyce