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] 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] INSERT is corrupting a database

2017-01-12 Thread Jens Alfke
> On Jan 12, 2017, at 3:52 PM, Kevin O'Gorman wrote: > > My opinion is that no user bug whatever should cause DB integrity problems > without raising an exception. That is a totally reasonable attitude … for programs running in a “safe” environment like an interpreter. However, in the world of

Re: [sqlite] INSERT is corrupting a database

2017-01-12 Thread Kevin O'Gorman
On Tue, Jan 10, 2017 at 7:52 PM, Simon Slavin wrote: > > On 11 Jan 2017, at 3:28am, Kevin O'Gorman wrote: > > > I have a modest amount of data that I'm loading into an SQLite database > for > > the first time. For the moment it contains just two tables and a few > > indices, nothing else. The

Re: [sqlite] INSERT is corrupting a database

2017-01-12 Thread Kevin O'Gorman
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 database is corrupt. > > Wh

Re: [sqlite] INSERT is corrupting a database

2017-01-10 Thread Clemens Ladisch
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 database is corrupt. What version? > If however, I split the program into two programs, one

Re: [sqlite] INSERT is corrupting a database

2017-01-10 Thread Simon Slavin
On 11 Jan 2017, at 3:28am, Kevin O'Gorman wrote: > I have a modest amount of data that I'm loading into an SQLite database for > the first time. For the moment it contains just two tables and a few > indices, nothing else. The first table loads okay, and if I stop the > process at that point,

[sqlite] INSERT is corrupting a database

2017-01-10 Thread Kevin O'Gorman
This is a problem I don't quite know how to report in a way that will be useful. I'm using Python 3.5 and its builtin sqlite package. I have a modest amount of data that I'm loading into an SQLite database for the first time. For the moment it contains just two tables and a few indices, nothing