Re: [sqlite] Question about threadsafe

On 13 Feb 2018, at 3:49am, Nick wrote: > is it OK to use "threadsafe=2 and > 2 connections" in my apps if the 2 threads may write at the same time? Yes. "When compiled with SQLITE_THREADSAFE=2, SQLite can be used in a multithreaded program so long

Re: [sqlite] Question about threadsafe

Thank you Keith. And there are something I want to make sure. >THREADSAFE=1 means that the sqlite3 library enforces the re-entrancy requirements via mutexes attached to the CONNECTION object. This means that the library will serialize access to the sqlite3 engine for you so that only one call (en

Re: [sqlite] calculated columns in views

Simon Slavin wrote: > On 12 Feb 2018, at 6:00pm, Istvan Heckl wrote: >> Because of this bug at the moment SQLite can not be used with Entity >> Framework if calculated columns are involved. > > SQLite does not have calculated columns. I guess he means something like this (which works fine in plai

Re: [sqlite] calculated columns in views

On 12 Feb 2018, at 6:00pm, Istvan Heckl wrote: > Because of this bug at the moment SQLite can not be used with Entity > Framework if calculated columns are involved. SQLite does not have calculated columns. There is no such feature in SQLite. Therefore there can't be a bug in it. Comments ne

[sqlite] calculated columns in views

Hi! I use Visual studio with SQlCeToolbox. First I thought I found an error in the SQlCeToolbox but the author said " As suspected, this is a bug deep down in System.Data.SQLite" The error is detailed in: https://github.com/ErikEJ/SqlCeToolbox/issues/612 Because of this bug at the moment SQLite

Re: [sqlite] About to know that Table-Level Encryption is possible in SQLite or not.

On 12 Feb 2018, at 8:03am, crest iOS wrote: > I want to know that Table-Level Encryption is possible in SQLite or not. It is a bad idea to do table-level encryption in SQLite because indexes are stored separately from the table. Your data in the table might be encrypted but data in index co

Re: [sqlite] About to know that Table-Level Encryption is possible in SQLite or not.

On 2/12/18, crest iOS wrote: > Hi Sir, > > I want to know that Table-Level Encryption is possible in SQLite or not. > The SQLite Encryption Extension [1] encrypts an entire database. There is no option to encryption some tables and not others. This is because SEE operates at the pager layer and

[sqlite] About to know that Table-Level Encryption is possible in SQLite or not.

Hi Sir, I want to know that Table-Level Encryption is possible in SQLite or not. Thanks, Sachin Patil ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question about threadsafe

THREADSAFE is about re-entrancy control. It has nothing to do with connections or transactions or how many/which threads can make sqlite3 calls (except in the case of THREADSAFE=0). TRANSACTIONS are an attribute of a CONNECTION. All operations on a CONNECTION (and statements derived/prepared

Re: [sqlite] Question about threadsafe

I ran several multi-threads tests these days and I want to get a confirmation that my understanding is correct. I use WAL mode and I think whether or not use the same connection with THREADSAFE=1, 2 is the key to my question. Mode 1, threadsafe=2 + multiple threads use the same connection: It is