Re: [sqlite] Understanding transactions

Igor Tandetnik wrote: > On 2/3/2014 3:21 PM, Yuriy Kaminskiy wrote: >> Igor Tandetnik wrote: >>> On 2/3/2014 1:07 PM, Baruch Burstein wrote: 1) How does a transaction affect SELECTs? If I start a transaction and do an UPDATE/DELETE/INSERT, what data will a SELECT in the same

Re: [sqlite] Understanding transactions

On 2/4/2014 5:23 AM, Yuriy Kaminskiy wrote: How sqlite is supposed to behave when *) there are read-only transaction; *) there are update transaction on other connection; *) cache space is exhausted by update transaction; *) sqlite was not able to upgrade RESERVED lock to EXCLUSIVE due to

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

Joe, The 1.0.91.0 beta you gave me works perfect in my scenario. Thanks so much! Any plan for when the final will be out? Eric On Mon, Feb 3, 2014 at 3:12 PM, Joe Mistachkin wrote: > > Eric Schultz wrote: > > > > I can't seem to build the Interop.SQLite.dll files

Re: [sqlite] sqlite3_column_name() issue with views

On Tue, Feb 4, 2014 at 2:52 AM, Richard Hipp wrote: > There is no "intended" behavior. > http://www.sqlite.org/c3ref/mark/column_name.html?If+there+is+n*fied i assume the broken image at the top of that page qualifies as "unintended behaviour" ;)

Re: [sqlite] sqlite3_column_name() issue with views

On Tue, Feb 4, 2014 at 11:34 AM, Stephan Beal wrote: > On Tue, Feb 4, 2014 at 2:52 AM, Richard Hipp wrote: > > > There is no "intended" behavior. > > http://www.sqlite.org/c3ref/mark/column_name.html?If+there+is+n*fied > > > i assume the broken image at

Re: [sqlite] Understanding transactions

Igor Tandetnik wrote: > On 2/4/2014 5:23 AM, Yuriy Kaminskiy wrote: >> How sqlite is supposed to behave when >> *) there are read-only transaction; >> *) there are update transaction on other connection; >> *) cache space is exhausted by update transaction; >> *) sqlite was not able to upgrade

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

Eric Schultz wrote: > > The 1.0.91.0 beta you gave me works perfect in my scenario. Thanks so much! > Any plan for when the final will be out? > The release is currently scheduled for Monday, February 10th (give or take a day or so). -- Joe Mistachkin

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.91.0 have begun...

If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to this coming Friday, February 7th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] Understanding transactions

On 2/4/2014 11:57 AM, Yuriy Kaminskiy wrote: Phew. Do you speak C? Enjoy. printf("insert...\r"); fflush(stdout); for(i = 0; i < 1000; i++) { rc = sqlite3_bind_int(ins_sth, 1, i); assert(rc == SQLITE_OK); rc = sqlite3_step(ins_sth); assert(rc ==

Re: [sqlite] Understanding transactions

Igor Tandetnik wrote: > On 2/4/2014 11:57 AM, Yuriy Kaminskiy wrote: >> Phew. Do you speak C? Enjoy. >> >> printf("insert...\r"); fflush(stdout); >> for(i = 0; i < 1000; i++) { >> rc = sqlite3_bind_int(ins_sth, 1, i); >> assert(rc == SQLITE_OK); >> rc = sqlite3_step(ins_sth);

Re: [sqlite] Understanding transactions

On 4 Feb 2014, at 8:49pm, Igor Tandetnik wrote: > If it is unable to promote the lock, then the in-memory cache will be left in > an inconsistent state and so the error code is promoted from the relatively > benign SQLITE_BUSY to the more severe SQLITE_IOERR_BLOCKED. This

Re: [sqlite] Understanding transactions

On 2/4/2014 5:51 PM, Yuriy Kaminskiy wrote: Igor Tandetnik wrote: On 2/4/2014 11:57 AM, Yuriy Kaminskiy wrote: Phew. Do you speak C? Enjoy. printf("insert...\r"); fflush(stdout); for(i = 0; i < 1000; i++) { rc = sqlite3_bind_int(ins_sth, 1, i); assert(rc == SQLITE_OK);

Re: [sqlite] Understanding transactions

Igor Tandetnik wrote: > On 2/4/2014 5:51 PM, Yuriy Kaminskiy wrote: >> Igor Tandetnik wrote: >>> On 2/4/2014 11:57 AM, Yuriy Kaminskiy wrote: Phew. Do you speak C? Enjoy. printf("insert...\r"); fflush(stdout); for(i = 0; i < 1000; i++) { rc =

Re: [sqlite] Understanding transactions

On 2/4/2014 6:43 PM, Yuriy Kaminskiy wrote: I've checked on 3.8.2, 3.8.1, 3.7.14, 3.7.7; results was exactly same. I've added sqlite3_libversion() output, and it matches expected version in all cases. This is on linux/i386/32-bit. Well, 3.5.9 on Windows 7 works to spec. That's all I know. You