Re: [sqlite] Useful - A Portable Class Library (PCL) for low-level (raw) access to SQLite

2014-04-10 Thread mm.w
Hello, may you tag your message withC#, as far as I know [[a Portable low-level (raw) access to SQLite]] that's already named sqlite itself as per see, written in a portable "low-levelable" language named C, I might be mistaken thu. Best. On Thu, Apr 10, 2014 at 2:16 PM, Mike Parsons wrote: >

Re: [sqlite] cannot set connection while a datareader is active

2014-04-10 Thread Joe Mistachkin
Stefano Ravagni wrote: > > The code run from 4 years over Access, MySql, PostgreSQL and no trace > about a similar error or datareader still open message. > So i'm confused using SQlite and receive this error. > > I confirm that i use only one datareader in the project, and while > receive err

[sqlite] Useful - A Portable Class Library (PCL) for low-level (raw) access to SQLite

2014-04-10 Thread Mike Parsons
Thought some of you would find this useful ... https://github.com/ericsink/SQLitePCL.raw ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

2014-04-10 Thread Joe Mistachkin
Stefano Ravagni wrote: > > Hello, i use this code for a function wich run in all database except > Sqlite.. > I've written a test case and added some comments to the ticket, here: http://system.data.sqlite.org/index.html/info/d0116ee2c3 Meanwhile, could you please post the code for th

Re: [sqlite] Database corruption issue

2014-04-10 Thread Richard Hipp
On Thu, Apr 10, 2014 at 12:04 PM, Grzegorz Sikorski wrote: > Hi, > > We developed an application which base on SQLite3. It is running on ARM > processor with Linux 2.6.37 (no, there is no easy way to upgrade it). We > put our database on microSD card (industrial grade, very reliable) > formatted

Re: [sqlite] Database corruption issue

2014-04-10 Thread Simon Slavin
On 10 Apr 2014, at 5:04pm, Grzegorz Sikorski wrote: > The problem is we occasionally observe database corruption and whole database > becomes rubbish. The problem is very rare and occurs only (as far as we were > able to confirm so far) if there is a power lose during write to the database. A

[sqlite] Database corruption issue

2014-04-10 Thread Grzegorz Sikorski
Hi, We developed an application which base on SQLite3. It is running on ARM processor with Linux 2.6.37 (no, there is no easy way to upgrade it). We put our database on microSD card (industrial grade, very reliable) formatted with ext4 partition. The database is used in WAL mode with default