Re: [sqlite] Can write to database using API but get an error on writing with sqlite3.exe

Em qui, 27 de set de 2018 às 00:59, Luiz Américo escreveu: > > > Em qui, 27 de set de 2018 às 00:30, Keith Medcalf > escreveu: > >> >> Have you checked to make sure the ID that you are using (interactively) >> is permitted read/write access to the

Re: [sqlite] Can write to database using API but get an error on writing with sqlite3.exe

Em qui, 27 de set de 2018 às 00:30, Keith Medcalf escreveu: > > Have you checked to make sure the ID that you are using (interactively) is > permitted read/write access to the directory containing the db files and to > the files themselves? I mean *actually* checked that you have permission, >

[sqlite] Can write to database using API but get an error on writing with sqlite3.exe

I have a 1GB database configured to use WAL mode. It's accessed by short lived CGI processes, under windows 2008 server. Each process usually opens the database, execute a select or update/insert, close the connection and finishes. It uses c api (sqlite3_open, sqlite3_prepare, sqlite3_step) of

Re: [sqlite] Mailing list shutting down...

How about using https://www.discourse.org/ ? Open source projects can use for free Luiz Em qua, 13 de jun de 2018 14:37, John Long escreveu: > On Wed, 2018-06-13 at 21:42 +1000, Gary R. Schmidt wrote: > > > > > > This is an increasing problem, and has been discussed on the Mailman > > mailing

[sqlite] [AGAIN] SQLite on network share

Em 13/11/2015 15:29, "A. Mannini" escreveu: > > Hi, > > i read SQLite FAQ and understood that use of SQLite on network share CAN > corrupts database file. > Fo me, it isn't clear if there is a way to safely use SQLite on a > network share in contests with few clients (max 5 for ex) and low read /

[sqlite] Handling the whole select query from an index

Em 19/09/2015 11:13, "Rob Willett" < mail.robertwillett.com at postfix.robertwillett.com> escreveu: > > Ryan, > > Thanks. We?ve got 100 requests a second which may be enough. We?ll keep looking though for any time. > Have you considered to implement the service using a compiled language,

[sqlite] First test of json and index expressions, not so good

Em 04/09/2015 17:09, "Domingo Alvarez Duarte" escreveu: > > Hello ! > > This is my first test with json and index expressions ! > > How to make usage of the expression index on queries ? > > Why is json_extract so slow ? Just for information Is json_extract from