Re: [sqlite] Check if the new table has been created

Hi, again, This page: https://www.sqlite.org/threadsafe.html, says that the default mode for SQLite is "Serialized". It is also said that in this mode it is safe to use SQLite in multiple threads. I am planning to do the polling in the secondary thread and SQLite was compiled with the default

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

On Thu, 21 Jun 2018, Dennis Clarke wrote: Running "gmake" I see a few oddball warnings again : "sqlite3.c", line 20826: warning: implicit function declaration: localtime_r (E_NO_IMPLICIT_DECL_ALLOWED) "sqlite3.c", line 52491: warning: statement not reached (E_STATEMENT_NOT_REACHED)

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

On Jun 21, 2018, at 2:53 PM, Dennis Clarke wrote: > > n0$ diff Makefile.backup Makefile > 70c70 > < TLIBS = -lz $(LIBS) > --- > > TLIBS = -lz -lrt $(LIBS) > n0$ Actually, you want this: Index: configure.ac == --- configure.ac

Re: [sqlite] [SQLite3] [Mono] [Linux] "db is locked"

On 21 Jun 2018, at 10:01pm, Phani Rahul Sivalenka wrote: > When we do a read operation and write/update operation on the SQLite DB, > the write operation gets timed out saying the “db is locked”. [...] > - Busy Timeout : 30sec > - Default Timeout : 30sec I'm going to assume you're doing

[sqlite] [SQLite3] [Mono] [Linux] "db is locked"

Hello, We have an ASP.NET Web application running with Mono on Linux. Uses System.Data.SQLite library with an interop generated with a specific set configuration to interact with the SQLite file. When we do a read operation and write/update operation on the SQLite DB, the write operation gets

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

On 06/21/2018 04:53 PM, Bob Friesenhahn wrote: On Thu, 21 Jun 2018, Richard Hipp wrote: . sqlite3.c: "sqlite3.c", line 20826: warning: implicit function declaration: localtime_r (E_NO_IMPLICIT_DECL_ALLOWED) According to my manpage for localtime_r(), the only header file required is , which

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

On Thu, 21 Jun 2018, Richard Hipp wrote: . sqlite3.c: "sqlite3.c", line 20826: warning: implicit function declaration: localtime_r (E_NO_IMPLICIT_DECL_ALLOWED) According to my manpage for localtime_r(), the only header file required is , which you can clearly see is found on line 20342, above

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

On Jun 21, 2018, at 5:28 AM, Dennis Clarke wrote: > > So I then read ext/async/README.txt and took a look around whereupon > I see these use "sched_yield" : > > ./ext/async/sqlite3async.c > ./src/test4.c > ./src/test7.c > ./test/crashtest1.c > ./test/threadtest1.c > ./test/threadtest2.c >

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

On 06/21/2018 12:06 PM, Richard Hipp wrote: On 6/21/18, Dennis Clarke wrote: Seems to compile fine and yet "gmake test" failed with a less then helpful "Error 2" : . . . sqlite3.c: "sqlite3.c", line 20826: warning: implicit function declaration: localtime_r (E_NO_IMPLICIT_DECL_ALLOWED)

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

On 6/21/18, Dennis Clarke wrote: > > Seems to compile fine and yet "gmake test" failed with a less > then helpful "Error 2" : > > > . > . > . > sqlite3.c: > "sqlite3.c", line 20826: warning: implicit function declaration: > localtime_r (E_NO_IMPLICIT_DECL_ALLOWED) According to my manpage for

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

On 06/21/2018 10:04 AM, Dan Kennedy wrote: On 06/21/2018 02:34 PM, Dennis Clarke wrote: Seems to compile fine and yet "gmake test" failed with a less then helpful "Error 2" : . . . sqlite3.c: "sqlite3.c", line 20826: warning: implicit function declaration: localtime_r

[sqlite] which building sqlite-src-3240000 I was surprised to see "make test" fail

Seems to compile fine and yet "gmake test" failed with a less then helpful "Error 2" : . . . sqlite3.c: "sqlite3.c", line 20826: warning: implicit function declaration: localtime_r (E_NO_IMPLICIT_DECL_ALLOWED) "sqlite3.c", line 52491: warning: statement not reached (E_STATEMENT_NOT_REACHED)

Re: [sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

On 06/21/2018 02:34 PM, Dennis Clarke wrote: Seems to compile fine and yet "gmake test" failed with a less then helpful "Error 2" : . . . sqlite3.c: "sqlite3.c", line 20826: warning: implicit function declaration: localtime_r (E_NO_IMPLICIT_DECL_ALLOWED) "sqlite3.c", line 52491: warning:

Re: [sqlite] How to use WHERE clause in UPSERT's conflict target

On Wed Jun 20, 2018 at 05:26:19PM -0400, Richard Hipp wrote: > On 6/20/18, Jonathan Koren wrote: > > > > The grammar & documentation > > shows a WHERE > > clause can be given in the "conflict target" of the UPSERT, but the > > documentation does not

[sqlite] building sqlite-src-3240000 I was surprised to see "make test" fail

Seems to compile fine and yet "gmake test" failed with a less then helpful "Error 2" : . . . sqlite3.c: "sqlite3.c", line 20826: warning: implicit function declaration: localtime_r (E_NO_IMPLICIT_DECL_ALLOWED) "sqlite3.c", line 52491: warning: statement not reached (E_STATEMENT_NOT_REACHED)