[sqlite] Sudden error 26 / 11

2016-06-23 Thread Jim Borden
I’m having an issue with a library I am writing. This has not happened before in the 1 ½ years I have been developing the library, but for some reason now it’s rearing its ugly head from time to time. The library will be happily running along and then suddenly a SELECT statement will return

Re: [sqlite] File is encrypted or is not a database problem

2016-07-25 Thread Jim Borden
, but gone upon later inspection on the command line). Jim Borden Software Engineer jim.bor...@couchbase.com ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sudden error 26 / 11

2016-06-30 Thread Jim Borden
if anything comes to mind. Jim Borden Software Engineer jim.bor...@couchbase.com On 6/24/16, 4:25 AM, "sqlite-users-boun...@mailinglists.sqlite.org on behalf of Richard Hipp" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of d...@sqlite.org> wrote: >On Thu, Jun 23, 2016 at

Re: [sqlite] Sudden error 26 / 11

2016-06-30 Thread Jim Borden
on the special thread but being executed on others. I read something that indicated that SQLite is never safe to be used from two threads at once, but it was labeled as outdated and seems to be contradicted by the newer information. I am only using one process in the program. Jim Borden Software

Re: [sqlite] Sudden error 26 / 11

2016-07-01 Thread Jim Borden
the database corrupted approximately 19 times in 147 runs). Jim Borden Software Engineer jim.bor...@couchbase.com On 6/30/16, 9:38 PM, "sqlite-users-boun...@mailinglists.sqlite.org on behalf of Jim Borden" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of jim.bor...@couchba

Re: [sqlite] Database malformed after 6000 Inserts?

2016-10-04 Thread Jim Borden
I had a problem similar to this before. What is the threading model for access to the database and how is the native library compiled and configured? Jim Borden (Sent from a mobile device) > On 4 Oct 2016, at 19:12, Werner Kleiner <sqlitetes...@gmail.com> wrote: > > Hello, >

[sqlite] Regarding the effects of the COMMIT keyword

2016-09-29 Thread Jim Borden
. Really I’d just like to know if I’m barking up the wrong tree here trying to explain why this odd behavior occurs. Jim Borden Software Engineer jim.bor...@couchbase.com ___ sqlite-users mailing list sqlite-users@mailinglists.sq

Re: [sqlite] Regarding the effects of the COMMIT keyword

2016-09-29 Thread Jim Borden
to other connections from that point forward? Jim Borden Software Engineer jim.bor...@couchbase.com On 2016/09/29 16:52, "sqlite-users on behalf of Simon Slavin" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of slav...@bigfraud.org> wrote: On 29 Sep 2016, at 8:

Re: [sqlite] Regarding the effects of the COMMIT keyword

2016-09-29 Thread Jim Borden
executes a few SELECT statements) returns 404. To me it seemed obvious that it was seeing an old state, but the question was why is it seeing an old state? PRAGMA synchronous is 2 (NORMAL, I believe?) Jim Borden Software Engineer jim.bor...@couchbase.com <http://www.couchbase.com/conn

Re: [sqlite] Regarding the effects of the COMMIT keyword

2016-09-29 Thread Jim Borden
compiled together (the listener, the storage API, the app, etc), and written all in C# with interop calls to C. Thanks for your input. The clarification about COMMIT was enough for me to focus my attention elsewhere and has been helpful. Jim Borden Software Engineer jim.bor...@couchbase.com

Re: [sqlite] Regarding the effects of the COMMIT keyword

2016-09-29 Thread Jim Borden
quickly after the GET when in reality it was another starting and the previous one finishing. Jim Borden Software Engineer jim.bor...@couchbase.com On 2016/09/29 18:09, "sqlite-users on behalf of Clemens Ladisch" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of clem.

Re: [sqlite] bug? suggestion? add full version number to files, so tools can warn of forward-incompatibility

2016-12-30 Thread Jim Borden
database files as "not a database" as far as I know. Furthermore the file format itself is compatible with future versions, but certain features are not if I am not mistaken. You can compare bytes 96-100 with the SQLITE_VERSION_NUMBER of the tool you are using to achieve the effect you w

Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Jim Borden
Oh, you are talking about WinCE? I don’t think you should be thinking in terms of “ARM vs non-ARM” but rather “X platform vs Y platform.” As others have noted, sqlite obviously runs on ARM and the issue is not with sqlite but with the way you are trying to compile it or the platform you are

Re: [sqlite] SQLite does not support ARM platform?

2017-03-20 Thread Jim Borden
That error has nothing to do with SQLite, really. SQLite is deployed on ARM platforms and ships as a system library on iOS. It sounds like you are running into this -> https://stackoverflow.com/questions/11151474/can-arm-desktop-programs-be-built-using-visual-studio-2012 Keep in mind that

Re: [sqlite] SQLite list spam from raypoker79

2017-09-12 Thread Jim Borden
For what it is worth, those messages reached my inbox twice on two different threads at least. Jim Borden Software Engineer jim.bor...@couchbase.com On 2017/09/13 9:02, "sqlite-users on behalf of Simon Slavin" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of slav...

Re: [sqlite] Database Encryption (System.Data.SQLite)

2019-04-01 Thread Jim Borden
From looking at the System.Data.SQLite source (someone please correct me if I am wrong) It would use whatever cipher was provided to it via the native library that it was deployed with. It's designed with sqlite encryption extension in mind but I suppose in theory it would work with any

[sqlite] sqlite3AtoF giving incorrect results

2019-02-27 Thread Jim Borden
results in a false infinity. Would this be considered a bug, or is precision not guaranteed to the same level as strtod because of other factors? Jim Borden Senior Software Engineer e: jim.bor...@couchbase.com t: @borrrden Privacy Policy<http://www.couchbase.com/privacy-policy> M

Re: [sqlite] sqlite3AtoF giving incorrect results

2019-02-27 Thread Jim Borden
out how to trigger it that way, I just put in a call to strtod alongside the call to sqlite3AtoF inside of codeReal and compared the results. Jim Borden On 2019/02/28 8:50, "drhsql...@gmail.com on behalf of Richard Hipp" wrote: On 2/27/19, Jim Borden wrote: > >

Re: [sqlite] sqlite3AtoF giving incorrect results

2019-02-27 Thread Jim Borden
Basically a variant of the final idea you had is what we went with. Thanks for the suggestions! Jim Borden Privacy Policy<http://www.couchbase.com/privacy-policy> Marketing Preferences<http://info.couchbase.com/unsubscribe-or-manage-pr

[sqlite] SEE Temp Files

2019-01-28 Thread Jim Borden
hand on the version of our product that uses SEE. Thanks, Jim Borden Privacy Policy<http://www.couchbase.com/privacy-policy> Marketing Preferences<http://info.couchbase.com/unsubscribe-or-manage-preferences> ___ sqlite-users mailing list

Re: [sqlite] SEE Temp Files

2019-01-28 Thread Jim Borden
I see. That complicates things a bit. What happens to SQLite temp files when they are "done being used" (if such a concept exists). Are they deleted or simply left there for the OS to clean up? Jim Borden On 2019/01/29 8:35, "sqlite-users on behalf of Richard