Re: [sqlite] High performance and concurrency

On 1 Mar 2018, at 7:24am, Shevek wrote: > What I think is happening is that either a pthread mutex or a database lock > is serializing the accesses, so each thread blocks the others. What journal mode are you using ?

[sqlite] High performance and concurrency

Hi, I would like to have truly concurrent access to an sqlite database, that is, the ability for multiple connections to read from the database simultaneously. I'm using Java with xerial's sqlite-jdbc, customized to let me mmap the entire database into RAM, and with additional debugging

[sqlite] BF Interpreter

Thanks to the help the other day with the strange concatentation result. I was referring to a BF interpreter I was working on, in pure SQLite SQL. Well, here it is, working. Hopefully no-one finds this useful, Gary WITH RECURSIVE program AS (SELECT

[sqlite] Help with json1 query?

Hi, I'm prototyping a little graph library using SQLite. My idea is to store vertices in a simple table like this: CREATE TABLE "vertex" ("key" TEXT NOT NULL PRIMARY KEY, "metadata" JSON); CREATE TABLE "edge" ( "id" INTEGER NOT NULL PRIMARY KEY, "src" TEXT NOT NULL, "dest" TEXT NOT

Re: [sqlite] SQL command not equal comparison within json content

On 2018/02/28 3:34 PM, tj5527 wrote: I create a table with the command `CREATE TABLE test1 (key text primary key, obj json);` with two records inserted # select * from test1; key1|{"a":1,"b":2,"c":{"x":99},"status":"done"} # record 1 key2|{ "key": key2 } # record 2 Now I want

Re: [sqlite] SQL command not equal comparison within json content

On 02/28/2018 08:34 PM, tj5527 wrote: I create a table with the command `CREATE TABLE test1 (key text primary key, obj json);` with two records inserted # select * from test1; key1|{"a":1,"b":2,"c":{"x":99},"status":"done"} # record 1 key2|{ "key": key2 } # record 2 The second

[sqlite] SQL command not equal comparison within json content

I create a table with the command `CREATE TABLE test1 (key text primary key, obj json);` with two records inserted # select * from test1; key1|{"a":1,"b":2,"c":{"x":99},"status":"done"} # record 1 key2|{ "key": key2 } # record 2 Now I want to retrieve the record that is not marked

Re: [sqlite] Database is locked

On 2/28/18 2:53 PM, Richard Damon wrote: > > On 2/28/18 6:59 AM, Frank Millman wrote: > > Hi all > > > > I am using Python 3.6.0 and sqlite3 3.20.1. I am getting the message > > ‘database is locked’ which, from reading the docs, I think is coming from > > an SQL_BUSY error. > > > > It does not

Re: [sqlite] not able to save log to sqlite

Abhijit Dass wrote: > > i want to logging exception details to sqlite database using > Nlog libraries, m okay when i store logging details by using > ado.net code but m not able to insert log details when i use > nlog.config. please help me out how can i insert logging > details by nlog.config. >

Re: [sqlite] Database is locked

On 2/28/18 6:59 AM, Frank Millman wrote: Hi all I am using Python 3.6.0 and sqlite3 3.20.1. I am getting the message ‘database is locked’ which, from reading the docs, I think is coming from an SQL_BUSY error. It does not behave in the way I expect. I tested using two concurrent connections

[sqlite] not able to save log to sqlite

hi, i want to logging exception details to sqlite database using Nlog libraries, m okay when i store logging details by using ado.net code but m not able to insert log details when i use nlog.config. please help me out how can i insert logging details by nlog.config. here is my

[sqlite] Database is locked

Hi all I am using Python 3.6.0 and sqlite3 3.20.1. I am getting the message ‘database is locked’ which, from reading the docs, I think is coming from an SQL_BUSY error. It does not behave in the way I expect. I tested using two concurrent connections – call them conn_1 and conn_2. 1. conn_1