Re: [sqlite] Not reading data in the -wal file? (Not Reproducible)

On 6/6/2013 6:04 PM, Jerry Krinock wrote: • Launch Process 2. • Launch Process 1. • Add a record in Process 1. Possibly does not COMMIT. • Launch Process 3. • In Process 3, run the query, then terminate. New record is PRESENT. • In Process 2, open database, run the query, checkpoint, and

Re: [sqlite] Not reading data in the -wal file? (Not Reproducible)

On Thu, Jun 6, 2013 at 6:04 PM, Jerry Krinock wrote: > > On 2013 Jun 06, at 13:28, Richard Hipp wrote: > > > My guess is that App1 never actually committed the transaction. Are you > > sure that you ran COMMIT? And are you sure that the COMMIT was >

Re: [sqlite] Not reading data in the -wal file? (Not Reproducible)

On 2013 Jun 06, at 13:28, Richard Hipp wrote: > My guess is that App1 never actually committed the transaction. Are you > sure that you ran COMMIT? And are you sure that the COMMIT was successful? Thank you, Richard. I didn't have a scope on App 1, and it's much more

Re: [sqlite] Not reading data in the -wal file? (Not Reproducible)

On Thu, Jun 6, 2013 at 4:12 PM, Jerry Krinock wrote: > I just spent a couple hours on a really strange problem that went away. > > • Ann sqlite database had 13 rows in one of its tables. > • In App 1, which uses the "C" interface, add a new row. > • In App 2, which also uses the

[sqlite] Not reading data in the -wal file? (Not Reproducible)

I just spent a couple hours on a really strange problem that went away. • Ann sqlite database had 13 rows in one of its tables. • In App 1, which uses the "C" interface, add a new row. • In App 2, which also uses the "C" interface, open that database with sqlite3_open(), then run query "SELECT *

Re: [sqlite] select count(*) does not use primary key??

On 6/6/2013 11:26 AM, Gabriel Corneanu wrote: Again sorry for count(a), I wrote too fast. I understand of course about null values. Otherwise by rowid I mean the autogenerated primary key. In my actual case, I have a field as alias. CREATE TABLE t(id integer primary key, a); explain query plan

Re: [sqlite] select count(*) does not use primary key??

On Thu, Jun 6, 2013 at 11:26 AM, Gabriel Corneanu wrote: > > 2. Is there NO WAY to quickly get the row count WITHOUT full scan if I > only have the auto primary key?? > The b-tree structures in the SQLite file format do not store the row count, as that slows down

Re: [sqlite] select count(*) does not use primary key??

Gabriel Corneanu wrote: > I was surprised to find that simple query "select count(*) from table" took > too much time, and found that it does NOT use the primary key index?? In SQLite, indexes are stored as B-trees, ordered by the indexed columns. Tables are _also_ stored as B-trees, ordered by

Re: [sqlite] select count(*) does not use primary key??

Again sorry for count(a), I wrote too fast. I understand of course about null values. Otherwise by rowid I mean the autogenerated primary key. In my actual case, I have a field as alias. CREATE TABLE t(id integer primary key, a); explain query plan select count(*) from t -> scan table

Re: [sqlite] select count(*) does not use primary key??

OK I understand, then it remains the question why it does not use the primary key?? Thanks, Gabriel ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] select count(*) does not use primary key??

On Thu, Jun 06, 2013 at 04:52:12PM +0200, Gabriel Corneanu scratched on the wall: > I was surprised to find that simple query "select count(*) from table" took > too much time, and found that it does NOT use the primary key index?? > e.g. > CREATE TABLE t(a); > explain query plan select count(*)

Re: [sqlite] Request to register Application-ID

On Thu, Jun 6, 2013 at 3:04 PM, Richard Hipp wrote: > I encourage you to "claim" and use that application ID. This kind of > thing is what the application-ID was created for. > > However, I think it will be best to delay adding this ID to the official > list until PayMaster V8

Re: [sqlite] Serialize an in-memory database

- Original Message - From: Donald Griggs To: phi...@blastbay.com ; General Discussion of SQLite Database Sent: Thursday, June 06, 2013 3:13 PM Subject: Re: [sqlite] Serialize an in-memory database Hi Philip, Maybe neither of these two thoughts are helpful, but fyi:

Re: [sqlite] select count(*) does not use primary key??

On Thu, Jun 6, 2013 at 10:52 AM, Gabriel Corneanu wrote: > Strange is, count(*) uses the cover index for a but "select count(a)" does > NOT use the same cover index... > count(a) has to check for NULL values of a, which are not counted. count(*) does not. -- D.

[sqlite] select count(*) does not use primary key??

I was surprised to find that simple query "select count(*) from table" took too much time, and found that it does NOT use the primary key index?? e.g. CREATE TABLE t(a); explain query plan select count(*) from t I get : SCAN TABLE t (~100 rows) If I use CREATE TABLE t(a unique), then it uses

Re: [sqlite] Serialize an in-memory database

Hi Philip, Maybe neither of these two thoughts are helpful, but fyi: 1.* Licensing for existing memory vfs.* Regarding this memory vfs implementation referenced earlier: http://article.gmane.org/gmane.comp.db.sqlite.general/46450

Re: [sqlite] Serialize an in-memory database

If you accept the slowdown of .dump you can directly use the backup option... On Thu, Jun 6, 2013 at 2:10 PM, Philip Bennefall wrote: > > - Original Message - From: "Simon Slavin" > > To: ; "General Discussion of SQLite

Re: [sqlite] Request to register Application-ID

On Thu, Jun 6, 2013 at 8:29 AM, Dennis Jenkins wrote: > I just read the Sqlite mail list exchange between Eduardo Morras and Dr. > Hipp ("Header Application-ID list"). I was unaware that such a feature > existed. Now that I know, I feel compelled to chase a shiny

Re: [sqlite] Header Application-ID list

> > On Thu, Jun 6, 2013 at 8:15 AM, Richard Hipp wrote: > > Ideally, this content would be picked up by unix "file" command and be > distributed to all unix systems. However, my repeated emails to the > maintainer Christos Zoulas about this have gone unanswered. > > Sounds like

[sqlite] Request to register Application-ID

I just read the Sqlite mail list exchange between Eduardo Morras and Dr. Hipp ("Header Application-ID list"). I was unaware that such a feature existed. Now that I know, I feel compelled to chase a shiny object :) I maintain a legacy proprietary payroll processing system (from the 1980s! Yeah).

Re: [sqlite] Header Application-ID list

On Thu, Jun 6, 2013 at 8:05 AM, Eduardo Morras wrote: > > Hi, > > Is there an official list of assigned application id sqlite header? If > exist, How can I register my application-id? > The official list is here: www.sqlite.org/src/artifact/f2b23a6bde8f Send a request to

Re: [sqlite] Serialize an in-memory database

- Original Message - From: "Simon Slavin" To: ; "General Discussion of SQLite Database" Sent: Thursday, June 06, 2013 1:45 PM Subject: Re: [sqlite] Serialize an in-memory database On 6 Jun 2013, at 10:45am,

[sqlite] Header Application-ID list

Hi, Is there an official list of assigned application id sqlite header? If exist, How can I register my application-id? Thanks --- --- Eduardo Morras ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Serialize an in-memory database

On 6 Jun 2013, at 10:45am, Philip Bennefall wrote: > I have a bunch of data structures in memory that I am looking to replace with > an SqLite database, primarily for the purpose of avoiding reinventing the > wheel with various sorts etc. I would then like to serialize

Re: [sqlite] Serialize an in-memory database

- Original Message - From: "Simon Slavin" To: ; "General Discussion of SQLite Database" Sent: Thursday, June 06, 2013 10:51 AM Subject: Re: [sqlite] Serialize an in-memory database On 6 Jun 2013, at 9:01am,

Re: [sqlite] Serialize an in-memory database

On 6 Jun 2013, at 9:01am, Philip Bennefall wrote: > Since I don't believe that Windows for example has tmpfs (seems to be a Unix > thing), would the idea of constructing a vfs that just reads and writes a > huge memory block be doable? Doable ? Yes. Use the code from

Re: [sqlite] Serialize an in-memory database

- Original Message - From: "Paolo Bolzoni" To: ; "General Discussion of SQLite Database" Sent: Thursday, June 06, 2013 10:33 AM Subject: Re: [sqlite] Serialize an in-memory database What is you use case?

Re: [sqlite] Serialize an in-memory database

What is you use case? Why do you need this? I am asking because maybe it helps thinking alternate solutions... On Thu, Jun 6, 2013 at 10:05 AM, Philip Bennefall wrote: > > - Original Message - From: "Paolo Bolzoni" > > > To:

Re: [sqlite] Serialize an in-memory database

- Original Message - From: "Paolo Bolzoni" To: ; "General Discussion of SQLite Database" Sent: Thursday, June 06, 2013 10:02 AM Subject: Re: [sqlite] Serialize an in-memory database Sorry I am missing a

Re: [sqlite] Serialize an in-memory database

Sorry I am missing a bit, What is the problem of using sqlite3_backup again? On Thu, Jun 6, 2013 at 10:01 AM, Philip Bennefall wrote: > > - Original Message - From: "Simon Slavin" > To: ; "General Discussion of SQLite

Re: [sqlite] Serialize an in-memory database

- Original Message - From: "Simon Slavin" To: ; "General Discussion of SQLite Database" Sent: Thursday, June 06, 2013 12:15 AM Subject: Re: [sqlite] Serialize an in-memory database On 5 Jun 2013, at 8:38pm,

Re: [sqlite] Change of behavior dealing with invalid views

On Wed, Jun 5, 2013 at 12:02 PM, Dominique Devienne wrote: > But that brings up the question about why the create view itself does not > fail? > > C:\Users\DDevienne>sqlite3 > SQLite version 3.7.15.2 2013-01-09 11:53:05 > Enter ".help" for instructions > Enter SQL statements