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

2018-09-26 Thread Luiz Américo
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, >

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

2018-09-26 Thread Keith Medcalf
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, since I doubt that the CGI process is running with the same ID you

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

2018-09-26 Thread Luiz Américo
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] DB To DB Transfer Time

2018-09-26 Thread dmp
Hello, Thank you for the responses, Stephen and Dominique. I was generally looking for an idea if the transaction time seemed reasonable, given a low end MariaDB server, standard 100Mb LAN, and mid range user processing desktop machine. I realize that the question as answered is; Hard to say!

Re: [sqlite] downloading older versions

2018-09-26 Thread Chris Brody
From https://www.sqlite.org/chronology.html you should be able to click on the date, then click on the check-in hash number, then click the link after "Downloads:" to download a ZIP, TAR, or SQLAR of the older version. Keep in mind that this gives you a snapshot of the source tree, you would have

Re: [sqlite] downloading older versions

2018-09-26 Thread David Raymond
I think you've got the right idea, but where are you seeing that there was ever a 3.8.6.1? I don't see it anywhere on https://www.sqlite.org/changes.html, and 3.8.5 was in 2014 -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of

[sqlite] downloading older versions

2018-09-26 Thread Mark Wagner
I'm trying to download older versions of sqlite to check the behavior of various bugs but I'm having trouble finding them. For example to get SQLite version 3.8.6.1 2017-07-21 03:23:38 I have tried: https://www.sqlite.org/2017/sqlite-tools-linux-x86-3080601.zip Should that have worked? Note

Re: [sqlite] DB To DB Transfer Time

2018-09-26 Thread Dominique Devienne
On Tue, Sep 25, 2018 at 8:41 PM dmp wrote: > The result for the 50K file db test of SQLite was 370.184 > seconds. Is this a reasonable transfer speed, given the conditions noted? > As Stephen already wrote, impossible to say. Start by contrasting this DB-copy you wrote to other methods: 1)

Re: [sqlite] integrity_check failure on 3.26 with expression indexes (wrong # of entries)

2018-09-26 Thread Deon Brewis
Sorry, false alarm. That corruption far predates the 3.26 changes (occurred under 3.24). The tool I was using to test didn't show the errors on the old version of the database but a newer tool shows them. Thanks! - Deon -Original Message- From: sqlite-users On Behalf Of Dan Kennedy

Re: [sqlite] integrity_check failure on 3.26 with expression indexes (wrong # of entries)

2018-09-26 Thread Dan Kennedy
On 09/26/2018 01:14 PM, Deon Brewis wrote: I am receiving an integrity check failure on 3.26 on the 9/19/2018 drop. It's not everywhere and it may be coincidental, but it may also be related to the new change where expression indexes aren't updated if their columns aren't modified. I'm

[sqlite] integrity_check failure on 3.26 with expression indexes (wrong # of entries)

2018-09-26 Thread Deon Brewis
I am receiving an integrity check failure on 3.26 on the 9/19/2018 drop. It's not everywhere and it may be coincidental, but it may also be related to the new change where expression indexes aren't updated if their columns aren't modified. I'm getting these integrity check failures: wrong #