There are quite a few Sqlite GUI applications listed here:
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
some appear to be incomplete, buggy, not maintained, etc. Do you have any recommendations?
High write volumes: SQLite allows only one write operation to take place at any given time, which significantly limits its throughput. If your application requires lots of write operations or multiple concurrent writers, SQLite may not be adequate for your needs.
Really, you don't have to close database connection. You can save database as a field in Application object. Official documentation doesn't say anything about time of database closing.
If you just want to work with SQLite, DB Browser for SQLite and SQLiteStudio are good choices. Both tools offer similar features for the casual user and do not require any preparation to access your database. The more you want to do, the more I suggest you use SQLiteStudio.
Below are some more reasons on why should you use SQLite: SQLite uses SQL, so it has all the features of a standard SQL database. Some developers require databases which can scale and provide support for concurrency. SQLite, with its rich feature, can be linked with any application in production.
I use the SQLite manager plugin for Firefox.
It seems pretty stable to me.
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