[sqlite] Closing database connection after each transaction?

Hello SQLite users, I was wondering, if closing the database connection after each transaction is a good idea. Possibly I've missed the thread concerning this topic. If this is true, please supply me with this link. Otherwise, can anybody give a reliable advice to do it in this or that way. I

Re: [sqlite] Closing database connection after each transaction?

Discussion of SQLite Database Betreff: Re: [sqlite] Closing database connection after each transaction? On Tue, Nov 12, 2013 at 8:06 AM, Stelling Carsten < carsten.stell...@goerlitz.com> wrote: > Hello SQLite users, > > I was wondering, if closing the database connection after e

[sqlite] Is there something like PHPAdmin for SQLite

If you work with Linux, you can use sshfs to mount the remote file system on your local file system. Doing so, you can use the Firefox SQLite Manager plugin. I don't know, if you can find similar tools for Windows. __ Carsten Stelling F Hardware / R

[sqlite] Caveats using Sqlite on JFFS2 ?

Additionally, to prevent early wearout of your persistent storage, make sure to configure SQLite, such that temporary files are stored in RAM rather than Flash. Compile with SQLITE_TEMP_STORE=3 or use PRAGMA temp_store (https://www.sqlite.org/tempfiles.html). In an embedded system, you should