On Wed, Jun 5, 2013 at 4:51 PM, Warren Young wrote:
>
> Bottom line, I suspect there is a bug in SQLite here. It shouldn't be using
> backslashes in a Cygwin build.
I think the problem is that the Cygwin distribution has the wrong
version of SQLite, one built for unix. I downloaded a Windows
exe
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 close.
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
> successful?
>
> Thank you, Richard. I didn'
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
complicated. It's poss
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 "C" interface, op
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 *
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
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 writes (since the row count woul
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 t
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
create
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
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(*) f
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 Export files are
- 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:
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. Richard Hipp
d...@sqlite.org
__
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
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
http://spserver.googlecode.com/files/spmemvfs-0.1.src
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 Database"
>
> Sent: Thursday, June 06, 2013 1:45 PM
>
> Subject: Re
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 object :)
>
> I maintain a legac
>
> 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 it may be time to
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).
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 this mailing list to a
- 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, Philip Bennefall wrote:
I have a bunch of data structures in memory that
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
http://sqlite.org:8080/cgi-bin/mailman/list
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 the data into a
> memor
- 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, Philip Bennefall wrote:
Since I don't believe that Windows for example h
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 one of the file-based V
- 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? Why do you need this?
I am asking because maybe it helps thinking alternate s
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: ; "General Discussion of SQLite Database"
>
> Sent: Thursday,
- 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 bit,
What is the problem of using sqlite3_backup again?
Hi Paolo,
I would
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 Database"
>
> Sent: Thursday, June 06, 2013 12:15 AM
>
> Subject: Re:
- 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, Philip Bennefall wrote:
On 5 Jun 2013, at 8:32pm, Petite Abeille wrote
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 terminated with a ";"
33 matches
Mail list logo