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 >

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] 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 scenario. With tradi

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 > s

[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 h

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. Note

[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 http://sq

[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 v

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

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 details. -- D. R

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 your code. I hope one of

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 "