Re: [sqlite] How to interrupt a long running update without roll back?

> No, in my case user does not touch the DB - he can only add or delete > items, > but all DB modifications are done by my app and I have a full control over > all the values. All I need is to find the most efficient way to do that. > > Therefore, I do not believe that I need any triggers. I

Re: [sqlite] How to interrupt a long running update without roll back?

From: jhnlmn To: sqlite-users@sqlite.org Sent: Friday, June 21, 2013 3:20 PM Subject: Re: [sqlite] How to interrupt a long running update without roll back? Alas, none of the above answered my original question "How to interrupt a long running update without roll back". But,

Re: [sqlite] How to interrupt a long running update without roll back?

Ryan Johnson writes: > So if I understand correctly, you start out with only C2, use C2 to > drive an expensive/slow computation that derives all other fields in the > row, and set C1 != NULL when the derivation completes? And you don't > want a trigger because that would pin

[sqlite] Newbie startup problems

I am trying to learn SQLite due to attempting to code my first Windows 8 app, which seems to use no other database but SQLite.. Also due to W8 apps needing to use async in a somewhat new style of async, the only tutorial I found on it was from Channel 9..

Re: [sqlite] How to interrupt a long running update without roll back?

On 21/06/2013 2:29 PM, jhnlmn wrote: Ryan Johnson writes: Q1: Is C1 *always* NULL in a newly-inserted row, or does the application sometimes insert some arbitrary value? Q2: Does the transition from NULL to calculation(C2) mean something special to the application? ...

Re: [sqlite] How to interrupt a long running update without roll back?

> Ryan Johnson writes: > Q1: Is C1 *always* NULL in a newly-inserted row, or does the application > sometimes insert some arbitrary value? > Q2: Does the transition from NULL to calculation(C2) mean something > special to the application? ... > Scenario 3: C1=NULL has a

Re: [sqlite] False Error 'no such collation sequence'

> > I wonder, though, if there may still remain a problem for other shells > (SQLite managers?) that do not support loadable extensions, e.g., free > versions of SQLite Expert, SQLite Developer, ... You are mistaken. The free version of SQLite Expert supports loadable extensions. Bogdan Ureche

Re: [sqlite] False Error 'no such collation sequence'

Richard Hipp drh at sqlite.org Fri Jun 21 00:15:56 EDT 2013 wrote: Can you not compile your custom collation sequences into a loadable extension (a DLL or shared library), then load that extension into your SQLite shell? http://www.sqlite.org/loadext.html - Tom replies: With Ralf's

Re: [sqlite] How to interrupt a long running update without roll back?

On 21/06/2013 2:55 AM, jhnlmn wrote: Ryan Johnson writes: histo = list(conn.execute('select min(rowid) lo, max(rowid) hi, count(*) n from lineitem group by rowid/1' order by lo)) ... a,b,n = buckets[-1] Thank you for your reply. You code is not very correct ("a"

Re: [sqlite] How to select from a temp table with same name as a main table.

Thanks to everyone. I have always prefixed table names with the db name when I have attached dbs myself but I didn't appreciate that the temp database was 'attached' as such as well. In a nutshell then, if you only use one database then you can refer to tables with no prefix (although you can

Re: [sqlite] Deadlock with multiple connections

I have two versions of this; this being a set of tables for tracking options. Version 2 uses auto incrementing keys, and does slightly different operations when setting values, Version 4 uses GUID keys, so every value is created before inserting, and I don't need last_insert_id() sort of thing.

Re: [sqlite] inserting record datinto mutliple tables with a composite primary key

I have more or less completed this project, so I thought I would post the final script. The script is in ruby and accepts the name of an input file and the name of the database, ruby loader.rb inputFilename databaseName The input file uses metadata rows to identify the database table that the

Re: [sqlite] How to interrupt a long running update without roll back?

Simon Slavin writes: > Nevertheless, this is the way the problem should be solved according to the design of SQLite. What you are > doing is searching for NULL entries in a table. > The way you speed up a search is to create an index I do not mind adding indexes to columns, which

Re: [sqlite] How to interrupt a long running update without roll back?

> Ryan Johnson writes: > histo = list(conn.execute('select min(rowid) lo, max(rowid) hi, count(*) > n from lineitem group by rowid/1' order by lo)) ... > a,b,n = buckets[-1] Thank you for your reply. You code is not very correct ("a" always remain 0), but I got your