[sqlite] Multithreaded SQLite

On Tuesday, 8 March, 2016 22:00 +07:00, Philippe Riand said: > I?m a bit lost with the multi-threaded concurrent access errors I?m > getting, and looking for an advise on the best solution. > Basically, I have a desktop/mobile app (single user) that embeds a tiny > local http server. The UI is

[sqlite] Creating & Dropping memory databases

On 03/08/2016 09:14 AM, Simon Slavin wrote: > On 8 Mar 2016, at 2:10am, Stephen Chrzanowski wrote: > >> Out of curiosity, from a memory management standpoint, if I create a memory >> database, populate simple tables and such, to what falls the responsibility >> with cleaning up the memory used?

[sqlite] File Locking Status

On 8 Mar 2016, at 6:50pm, Denis Burke wrote: > Is it possible to tell if SQLite has a database file locked? Not through > OS tools, but from System.Data.SQlite? Can't answer your question but these seem relevant:

[sqlite] CTE for a noob

On 2016/03/08 5:02 AM, Stephen Chrzanowski wrote: > Now I'll have to use USING a bit more often to get the drift and get out of > this multi-call thing. I sort of see what is going on here, but practice > is whats needed. "USING" has three uses in SQLite, first to enlist a virtual table,

[sqlite] Creating & Dropping memory databases

On 8 Mar 2016, at 4:35pm, Dan Kennedy wrote: > I don't think it does that. sqlite3_shutdown() is for embedded platforms to > shutdown sub-systems initialized by sqlite3_initialize(). Calling it with > open connections will usually either leak resources or crash. > > More here:

[sqlite] File Locking Status

> Is it possible to tell if SQLite has a database file locked? Not through > OS tools, but from System.Data.SQlite? If you can execute BEGIN EXCLUSIVE TRANSACTION and get back SQLITE_OK then there were no locks on the database. Of course you will then need to ROLLBACK. Note that this

[sqlite] compile switches: SQLITE_OMIT_ATTACH & SQLITE_OMIT_VIRTUALTABLE

hello, when I compile the amalgation with these compile switches:SQLITE_OMIT_VIRTUALTABLEorSQLITE_OMIT_VIRTUALTABLE the amalgation fails to compile: the implementation of some functions are removed but the definition + call to these functions still exist. I use VS 2010 to compile. This is the

[sqlite] sqlite3 3.11 and 3.11.1 fail to build with ...

Hi, downloading this sqlite-autoconf-3110100.tar.gz and compiling with ./configure CFLAGS="-DUSE_PREAD -DSQLITE_OMIT_DEPRECATED -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_TRACE -DSQLITE_OMIT_EXPLAIN" fail with the following error: sqlite3.c:16183:28: warning: 'sqlite3OpcodeName' used but

[sqlite] File Locking Status

Thank you Simon - that is helpful. I would still be interested if anyone can provide any further info regarding locking as seen through System.Data.SQlite. -Denis -- On 8 Mar 2016, at 6:50pm, Denis Burke wrote: > Is it possible to tell if SQLite has a database file locked? Not

[sqlite] CTE for a noob

Have you seen this tutorial? https://blog.expensify.com/2015/09/25/the-simplest-sqlite-common-table-expression-tutorial/ -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From:

[sqlite] File Locking Status

Is it possible to tell if SQLite has a database file locked? Not through OS tools, but from System.Data.SQlite? I would like my application to be able to understand if its use of SQLite has the file locked at a given moment. (and yes I know other processes/apps could also lock the file).

[sqlite] Default of "PRAGMA synchonous" for WAL mode

On Tue, 8 Mar 2016 at 13:25, Reinhard Max wrote: > On Tue, 8 Mar 2016 at 12:46, Richard Hipp wrote: > >> Documentation bug. Fixed at >> https://www.sqlite.org/docsrc/timeline?c=3540d6 > > Thanks, but https://www.sqlite.org/pragma.html#pragma_synchronous > still says: "NORMAL is the default

[sqlite] Default of "PRAGMA synchonous" for WAL mode

On Tue, 8 Mar 2016 at 12:46, Richard Hipp wrote: > Documentation bug. Fixed at https://www.sqlite.org/docsrc/timeline?c=3540d6 Thanks, but https://www.sqlite.org/pragma.html#pragma_synchronous still says: "NORMAL is the default when in WAL mode." cu Reinhard

[sqlite] [sqlite-dev] Changing the default page_size in 3.12.0

On Fri, Mar 4, 2016 at 7:48 AM, Richard Hipp wrote: > The tip of trunk (3.12.0 alpha) changes the default page size for new > database file from 1024 to 4096 bytes. I have noticed that the OSX sqlite library seems to use default page_size of 4096, and default cache_size of either -2000 or 500.

[sqlite] How to read data from WAL?

Sairam, Just in case it's useful and you've not see it, Simon Slavin pointed out this "rqlite" project for replicated sqlite in an email from 25 Feb. Donald Simon Slavin slavins at bigfraud.org via

[sqlite] Default of "PRAGMA synchonous" for WAL mode

Hi, the documentation for "PRAGMA synchronous"[1] says that the default for databases in WAL mode is NORMAL (1). But when I open a database in WAL mode or switch an open database to WAL mode, querying PRAGMA synchronous returns 2 (checked in 3.8.6, 3.8.10 and 3.11.1). Is this a bug in the

[sqlite] [sqlite-users] RBU Bit Level Diff

Hello, I'm KiWong. recently I'm looking for a sqlite update method using something. so I found the rbu extension. (https://www.sqlite.org/rbu.html) and tested that diff two sqlite3 dbs with rbu option. but I have a problem of big diff size. this db has the BLOB Data in one column and bit level

[sqlite] Default of "PRAGMA synchonous" for WAL mode

Thanks. New changes checked in. On 3/8/16, Reinhard Max wrote: > > On Tue, 8 Mar 2016 at 13:25, Reinhard Max wrote: > >> On Tue, 8 Mar 2016 at 12:46, Richard Hipp wrote: >> >>> Documentation bug. Fixed at >>> https://www.sqlite.org/docsrc/timeline?c=3540d6 >> >> Thanks, but

[sqlite] [sqlite-users] RBU Bit Level Diff

On 3/7/16, ??? wrote: > > but I have a problem of big diff size. this db has the BLOB Data in one > column and bit level data. found the rbu diff function in 'sqldiff.c' file > and i knew that this function will do byte level diff method. > > therefore, I want to use a RBU custom delta format and

[sqlite] Default of "PRAGMA synchonous" for WAL mode

On 3/8/16, Reinhard Max wrote: > Hi, > > the documentation for "PRAGMA synchronous"[1] says that the default > for databases in WAL mode is NORMAL (1). But when I open a database in > WAL mode or switch an open database to WAL mode, querying PRAGMA > synchronous returns 2 (checked in 3.8.6,

[sqlite] Creating & Dropping memory databases

On 8 Mar 2016, at 2:10am, Stephen Chrzanowski wrote: > Out of curiosity, from a memory management standpoint, if I create a memory > database, populate simple tables and such, to what falls the responsibility > with cleaning up the memory used? > > Will SQLite handle :memory: databases