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.
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.
DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.
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.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With