Re: [sqlite] SQL logic error or missing database no such table

2016-05-24 Thread R.A. Nagy
We only use .commit when we are using transactions: If any type of "BEGIN TRANSACTION;" is underway, a failure to "COMMIT;" data will guarantee that data will not be in a database. Interestingly however, even when not committed our queries will still work - our data will simply not be available in

Re: [sqlite] SQL logic error or missing database no such table

2016-05-24 Thread Rajendra Shirhatti
Hi Randall, I was googling around and it seems like some people had the same issue where the data was lost after the connection was closed. In my case, the connection is a singleton which is used by multiple threads. I do not close the connection explicitly, let it close automatically when the serv