Re: [sqlite] Support for concurrent transactions

On Jun 26, 2014 4:06 AM, "Simon Slavin" wrote: > > Of course, you do get the increased time (it takes time to open and parse the database file) and memory overhead. One could setup a simple connection pooling mechanism in order to minimize _open() overhead. Standard

Re: [sqlite] SQLite performance with NOR FLASH

Hello Simon, Code looks like this: /* move content */ sqlite3_backup *pBackup; pBackup = sqlite3_backup_init(destDBHandle, "main", sourceDBHandle, "main"); if(pBackup) { int sqlErrno; if ((sqlErrno = sqlite3_backup_step(pBackup, -1)) !=

Re: [sqlite] Sequential numbers

> >-Ursprüngliche Nachricht- >Von: RSmith [mailto:rsm...@rsweb.co.za] >Gesendet: Mittwoch, 25. Juni 2014 21:54 >An: sqlite-users@sqlite.org >Betreff: Re: [sqlite] Sequential numbers > > >On 2014/06/25 21:38, Dave Wellman wrote: >> Hi Petite, >> Many thanks fo rthsuggestion, it works a

Re: [sqlite] Sequential numbers

Hi Dave,   You can of course also calculate a new sequence number based on the row ids. Just count the number of records with a smaller or equal rowid. This way it doesn't matter if rowid starts at 1 or if there are any gaps in the range.   Example:   CREATE TABLE aaa (i, seqnr); INSERT INTO

Re: [sqlite] SQLite performance with NOR FLASH

On 26 Jun 2014, at 7:42am, Vivek Ranjan wrote: > Code looks like this: Thanks. I was wondering whether you called _step() with strange value but you're calling it with -1, which seems to be the best thing to do in your case. And I don't see anything else wrong with

Re: [sqlite] How to get access to SQLite Test Harness #3(TH3)

On Thu, Jun 26, 2014 at 1:55 AM, Kishore Reddy wrote: > > *Richard Hipp,* > I am planning to use SQLite library in *Avionics Level B software*. > SQLite is developed using a DO-178B compatible process. The 100% MC/DC testing is just one aspect of that. Contact our office for

Re: [sqlite] Sequential numbers

Op 26 jun 2014, om 10:32 heeft Rob Golsteijn het volgende geschreven: Hi Dave, You can of course also calculate a new sequence number based on the row ids. Just count the number of records with a smaller or equal rowid. This way it doesn't matter if rowid starts at 1 or if there are any

[sqlite] affinity critical problem with 3.8.5 - IN single value optimisation

Hi, It seems there's a problem with 3.8.5 and its affinity behavior. It's quite critical. --- CUT --- sqlite> CREATE TABLE T (v text); sqlite> insert into T values('1'); sqlite> insert into T values('2'); sqlite> select v from T where v=1; 1 sqlite> select v from T where v='1'; 1 sqlite> select

[sqlite] Merge join in SQLite

Hi, I've seen that SQLite supports the "SorterOpen" Op, to do merge sorting. So based on that, does SQLite support merge joins when both inputs of the join are sorted? Kind regards, l. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Merge join in SQLite

On Thu, Jun 26, 2014 at 11:41 AM, Eleytherios Stamatogiannakis < est...@gmail.com> wrote: > Hi, > > I've seen that SQLite supports the "SorterOpen" Op, to do merge sorting. > So based on that, does SQLite support merge joins when both inputs of the > join are sorted? > No, not at this time.

[sqlite] detect database/table/field use

I work with a C++ application that embeds the SQLite source and executes user-supplied queries against SQLite database(s). I'd like to record which databases/tables/fields are accessed. Is there any not-too-difficult way of doing this? Poking around in the source, it seems like a fundamental

Re: [sqlite] Sequential numbers

> Example: > > > CREATE TABLE aaa (i, seqnr); > INSERT INTO "aaa" VALUES(10,NULL); > INSERT INTO "aaa" VALUES(20,NULL); > INSERT INTO "aaa" VALUES(50,NULL); > INSERT INTO "aaa" VALUES(30,NULL); > INSERT INTO "aaa" VALUES(20,NULL); > > UPDATE aaa SET seqnr=(SELECT count() FROM aaa smaller where >

Re: [sqlite] Data visibility problem

OK, thank you all for your support. On Thu, Jun 26, 2014 at 3:22 AM, Igor Tandetnik wrote: > On 6/25/2014 8:48 PM, João Ramos wrote: > >> Now that you mentioned the WAL, shouldn't this actually help prevent this >> scenario? >> > > Quite the opposite - WAL helps enable this

Re: [sqlite] detect database/table/field use

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 26/06/14 12:58, Nelson, Erik - 2 wrote: > I'd like to record which databases/tables/fields are accessed. Is > there any not-too-difficult way of doing this? The authorizer interface will address your issue. You can just record what it tells you,

Re: [sqlite] detect database/table/field use

Roger Binns wrote on Thursday, June 26, 2014 5:38 PM > >On 26/06/14 12:58, Nelson, Erik - 2 wrote: > > I'd like to record which databases/tables/fields are accessed. Is > > there any not-too-difficult way of doing this? > > The authorizer interface will address your issue. You can just record >