Re: [sqlite] Null returned from NOT NULL column thanks to undetected corruption

2017-01-13 Thread Rowan Worth
On 13 January 2017 at 22:59, David Raymond wrote: > My view is that the general thinking of the program here is simply: "just > don't make things worse." It can't help what pragmas (ie > ignore_check_constraints, writable_schema etc) others may have turned on > for their connections, or what sort

Re: [sqlite] does integrity check ever modify the db file?

2017-01-13 Thread Rowan Worth
On 14 January 2017 at 03:51, Adam Smith wrote: > Hey all, > can 'pragma integrity_check' ever modify the file? For instance in case > of a journal file laying around (which was journal file of the same schema > db but a bit different data)? > > The following is what I think happened: > > a.db a

Re: [sqlite] Insert into with Id...

2017-01-13 Thread hfiandor
Dear Mr. Simon Slavin: I have implemented the lectura of a csv file in my program as "import". I have followed yours instructions (the last one and others previous) . Thanks for your instructions. The program works fine with csv files of one or two rows, but when I try to read a file with 9 ro

[sqlite] Multiple sessions, page sizes and cache

2017-01-13 Thread Kim Gräsman
Hi all, We have an application with multiple databases of different page sizes. We keep a few long-running sessions, but also open transient sessions occasionally. In an effort to reduce memory usage/fragmentation, we're trying to configure SQLite to allocate as much memory as necessary up-front

[sqlite] does integrity check ever modify the db file?

2017-01-13 Thread Adam Smith
Hey all, can 'pragma integrity_check' ever modify the file? For instance in case of a journal file laying around (which was journal file of the same schema db but a bit different data)? The following is what I think happened: a.db and b.db are two sqlite dbs of size ~5mb which have same schema

[sqlite] SQLite installation query

2017-01-13 Thread Saurabh Sukhani
Dear Members, I am trying to install SQLite in my Windows 10 machine. I want to use SQLite database for my project. The target framework is .net 4.0 and am using VS 2010. SQLite .NET download page has the following: Setups for 64-bit Windows (.NET Framework 4.0) *sqlite-netFx40-setup-bundle-**x6

[sqlite] subscribe

2017-01-13 Thread Adam Smith
___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] extension to run bash

2017-01-13 Thread James K. Lowden
On Thu, 12 Jan 2017 01:54:28 + Roman Fleysher wrote: > From bash script, make list of rows, run commands, load results to > sqlite. Or > > From sqlite, use extension to run commands for each row. > > Both have issues. You will find your shell script faster. The more files, the more it mat

Re: [sqlite] Problem with compiled dll on Windows

2017-01-13 Thread James K. Lowden
On Wed, 11 Jan 2017 10:46:51 -0800 Random Coder wrote: > Normally, I'd say this is toolset knowledge, and really doesn't > belong in those sort of directions. But since you're not the first > person to hit this problem Having dealt with the problem of other-system support on a smaller scale for

Re: [sqlite] Null returned from NOT NULL column thanks to undetected corruption

2017-01-13 Thread James K. Lowden
On Fri, 13 Jan 2017 11:17:11 +0800 Rowan Worth wrote: > I wonder if this is something sqlite could catch in normal operation > and return SQLITE_CORRUPT? Or are there reasons/history which would > render this conclusion inaccurate? Not without cost. In general, it's difficult for any program

Re: [sqlite] INSERT is corrupting a database

2017-01-13 Thread Kevin O'Gorman
On Fri, Jan 13, 2017 at 3:34 AM, Clemens Ladisch wrote: > Kevin O'Gorman wrote: > > On Tue, Jan 10, 2017 at 11:29 PM, Clemens Ladisch > wrote: > >> Kevin O'Gorman wrote: > >>> If I go on to the second table, it appears to finish normally, but > when I > >>> try to look at the database with sqlit

Re: [sqlite] Null returned from NOT NULL column thanks to undetected corruption

2017-01-13 Thread David Raymond
My view is that the general thinking of the program here is simply: "just don't make things worse." It can't help what pragmas (ie ignore_check_constraints, writable_schema etc) others may have turned on for their connections, or what sort of junk was there when it arrived. In its head it's goin

Re: [sqlite] INSERT is corrupting a database

2017-01-13 Thread Clemens Ladisch
Kevin O'Gorman wrote: > On Tue, Jan 10, 2017 at 11:29 PM, Clemens Ladisch wrote: >> Kevin O'Gorman wrote: >>> If I go on to the second table, it appears to finish normally, but when I >>> try to look at the database with sqlite3, a command-line tool for >>> interacting with SQLite, it says the dat

Re: [sqlite] Exiting SQLite3 from within a (.bat) file

2017-01-13 Thread tbuck...@frontier.com
Thank you.That works great.Tom... On Friday, January 13, 2017 9:46 AM, Kees Nuyt wrote: On Fri, 13 Jan 2017 08:12:33 + (UTC), "tbuck...@frontier.com" wrote: > Hello,I have a batch (.bat) file that runs a C program to > pre-process a text file to a clean .csv file.  > Then the batc

Re: [sqlite] Exiting SQLite3 from within a (.bat) file

2017-01-13 Thread Kees Nuyt
On Fri, 13 Jan 2017 08:12:33 + (UTC), "tbuck...@frontier.com" wrote: > Hello,I have a batch (.bat) file that runs a C program to > pre-process a text file to a clean .csv file.  > Then the batch file runs SQLite3 -init to execute dot (.) > commands.  Everything works great except the last dot

[sqlite] Exiting SQLite3 from within a (.bat) file

2017-01-13 Thread tbuck...@frontier.com
Hello,I have a batch (.bat) file that runs a C program to pre-process a text file to a clean .csv file.  Then the batch file runs SQLite3 -init to execute dot (.) commands.  Everything works great except the last dot command ".exit" or ".quit" to close the SQLite3 program out.  I always have to