Re: [sqlite] SQLITE_LOCKED means "database table is locked"?

Am 19.06.2019 um 16:47 schrieb Igor Tandetnik: On 6/19/2019 10:39 AM, Carsten Müncheberg wrote: Is there really something like a table lock? Yes there is: https://sqlite.org/sharedcache.html Thanks, I wasn't aware of that. -- Carsten Müncheberg Software Developer Native Instruments GmbH

[sqlite] SQLITE_LOCKED means "database table is locked"?

I'm puzzled by the error strings for SQLITE_BUSY and SQLITE_LOCKED. The documentation for both is very clear and precise, but these too strings which are returned by sqlite3_errmsg() are misleading in my opinion, especially "database table is locked". Is there really something like a table

Re: [sqlite] -wal and -shm files left behind by libsqlite3.dylib

Am Mo., 28. Jan. 2019 um 20:01 Uhr schrieb Richard Hipp : > On 1/28/19, Carsten Müncheberg wrote: > > When loading and using /usr/lib/libsqlite3.dylib (3.19.3) which is > shipped > > with MacOS 10.13.6 I noticed that the -wal and -shm files are not deleted > > when clo

[sqlite] -wal and -shm files left behind by libsqlite3.dylib

When loading and using /usr/lib/libsqlite3.dylib (3.19.3) which is shipped with MacOS 10.13.6 I noticed that the -wal and -shm files are not deleted when closing the last connection to a database. I tested this with the sqlite3 command line tool. It does not happen when I compile and link SQLite

Re: [sqlite] SQLite linked to plugin binary

Am Mi., 23. Jan. 2019 um 18:23 Uhr schrieb Jens Alfke : > > > > On Jan 23, 2019, at 8:27 AM, Carsten Müncheberg < > carsten.muencheb...@gmail.com> wrote: > > > > A host application (which is a black box for me I cannot change) is > loading > > my plu

[sqlite] SQLite linked to plugin binary

I am running into a problem with the following use-case: A host application (which is a black box for me I cannot change) is loading my plugin binaries which each have SQLite linked statically. When two plugins now access the same database file from the process of the host application none of the

[sqlite] Exclusive transactions and Select statements

Hi, I am experimenting with EXCLUSIVE transactions today, and was confused that after one connection began an EXCLUSIVE transaction, another one could still execute a SELECT statement, because quoting from https://www.sqlite.org/lang_transaction.html "After a BEGIN EXCLUSIVE, no other

[sqlite] How to migrate from UTF-16 to UTF-8

Hi, I have a database which is UTF-16 encoded and 80% of its data is strings. To save disk space and ideally also increase performance, I would like to migrate it to UTF-8. As far as I know there is no straight forward way to do this, since you cannot ATTACH a database which has a different