[sqlite] Cache all pages

Hello, I have a SQLite database which has got 60 pages. For performance reasons, I am thinking of making SQLite cache all of this 60 pages, so for further queries no disk read will be performed. I believe when all pages are cached, SQLIte just has to read the cached pages and would be faster. To d

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

On Mon, May 07, 2012 at 01:34:13PM -0400, peter korinis wrote: > So, if I use gawk to change my comma separated file to | (pipe) delimiter . > will it work? If you use gawk, you can easily change your comma separated file to the series of correct SQL INSERT statements (besides ensuring validit

Re: [sqlite] max(userID) .. WHERE userID IS NOT NULL returns NULL But... WHERE <> '' returns value

Oh that is interesting !! When I created the table I had the following column declarations: recordID INTEGER PRIMARY KEY, userID INTEGER UNIQUE, name CHAR, email CHAR I thought I read that sqlite 2.8 does recognize INTEGER and then stores those as numeric values, and not strings. But am won

Re: [sqlite] max(userID) .. WHERE userID IS NOT NULL returns NULL But... WHERE <> '' returns value

> Your database doesn't contain the data you think it does. Unassigned userId > values are not NULL, but empty strings. By SQLite rules, any string is > compared greater than any number. Igor, Probably this is not true in this SQLite version: >> I'm running php 5.2 that has sqlite 2.8.17 Pavel

Re: [sqlite] max(userID) .. WHERE userID IS NOT NULL returns NULL But... WHERE <> '' returns value

On 5/8/2012 9:58 PM, Shorty wrote: I've got a database that users can request to join the mailing list. After they add their name and email address, I'll assign them a userID number. The database looks like this: recordID userID name email 1 1 John j...@somewhere.com 2 2 Mike m...@example.com 3

[sqlite] max(userID) .. WHERE userID IS NOT NULL returns NULL But... WHERE <> '' returns value

I've got a database that users can request to join the mailing list. After they add their name and email address, I'll assign them a userID number. The database looks like this: recordID userID name email 11Johnj...@somewhere.com 22Mikem...@example.com 33Bill

Re: [sqlite] two table update question

On 9 May 2012, at 2:20am, YAN HONG YE wrote: > alter table myref add stkcode varchar(30); > update myref set stkcode = dzhhq.stkcode; > > this sql command couldn't run in my sqlite. It does not know which row from the table dzhhq it is meant to use. Simon.

[sqlite] two table update question

alter table myref add stkcode varchar(30); update myref set stkcode = dzhhq.stkcode; this sql command couldn't run in my sqlite. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite Tcl Extension

Does the version number for the TCL Library for SQLite match the version of the core SQLite product? Thanks, Jerry Disclaimer This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presen

Re: [sqlite] SQLite via TCL Question

Ok, I appreciate the information! Thanks, Jerry -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Tuesday, May 08, 2012 8:20 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite via TCL

Re: [sqlite] SQLite via TCL Question

On Tue, May 8, 2012 at 7:40 PM, Tilsley, Jerry M. wrote: > I have set the timeout now and will monitor this change, on the note of > using WAL I do have a question. The database is accessed by SQLite 3.6.4 > from a vendor's application, but on command-line I used 3.7.9; am I asking > from trouble

Re: [sqlite] SQLite via TCL Question

I have set the timeout now and will monitor this change, on the note of using WAL I do have a question. The database is accessed by SQLite 3.6.4 from a vendor's application, but on command-line I used 3.7.9; am I asking from trouble? Should I go through the effort to force the vendor's applica

Re: [sqlite] SQLite via TCL Question

I appreciate the suggestion and have implemented the timeout feature, and will continue to monitor to see how this affects the database activity. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Tuesday, May

Re: [sqlite] SQLITE_BUSY exceptions

On 9 May 2012, at 12:15am, Cyndy Koobs wrote: > I am using SQLite with hibernate 4.1.0 (multithreaded but not heavily > loaded). I am frequently getting SQLITE_BUSY exceptions. Have you set a SQLite timeout ? The default is zero, which means that any contention will immediately trigger _BUSY

[sqlite] SQLITE_BUSY exceptions

I am using SQLite with hibernate 4.1.0 (multithreaded but not heavily loaded). I am frequently getting SQLITE_BUSY exceptions. When the database is created, is the journal mode default WAL? What is the default size of the journal? What is the default threading mode when compiled? If I want/nee

Re: [sqlite] SQLite via TCL Question

On 8 May 2012, at 9:51pm, "Tilsley, Jerry M." wrote: > This is probably a newbie question so please bear with me. I'm accessing a > SQLite database through TCL and periodically I get a "Database Locked" error. > This is a multi-thread process that writes to the DB, do I need to enable > WAL

Re: [sqlite] SQLite via TCL Question

On 5/8/12 1:51 PM, "Tilsley, Jerry M." wrote: >This is probably a newbie question so please bear with me. I'm accessing >a SQLite database through TCL and periodically I get a "Database Locked" >error. This is a multi-thread process that writes to the DB, do I need >to enable WAL for this, if

[sqlite] SQLite via TCL Question

All, This is probably a newbie question so please bear with me. I'm accessing a SQLite database through TCL and periodically I get a "Database Locked" error. This is a multi-thread process that writes to the DB, do I need to enable WAL for this, if so, do I do this from the TCL side or the co

Re: [sqlite] sqlite-users Digest, Vol 53, Issue 8

Peter, I think you're the perfect candidate for using one of the many sqlite gui admin tools out there. There are lots of them and they all do a good job of getting you off the ground when you are a newcomer to sqlite, but I have to shamelessly promote my own tool, SQLiteAdmin. I think it would h

Re: [sqlite] sqlite3 3.7.11 on FreeBSD 9.0-RELEASE amd64 (ports) segfaults with memstatus compiled in _pthread_mutex_init_calloc_cb

On Mon, May 7, 2012 at 9:51 AM, Jerry Lundström wrote: > Hi, > > I've been trying to track a segfault in sqlite3 (3.7.11, ports package) > when I use OpenDNSSEC 1.3.7 and SoftHSM 1.3.2. > > I don't know if the issue is related to sqlite3 or to something in FreeBSD > libc but it can be replicated b

Re: [sqlite] sqlite3 3.7.11 on FreeBSD 9.0-RELEASE amd64 (ports) segfaults with memstatus compiled in _pthread_mutex_init_calloc_cb

Hi, Apparently deselecting MEMSTATUS did not fix every fault: (gdb) bt #0 0x000801e35400 in _pthread_mutex_init_calloc_cb () from /lib/libc.so.7 #1 0x000801e3dad5 in free () from /lib/libc.so.7 #2 0x00080130208e in sqlite3HashClear (pH=0x80255e0a0) at sqlite3.c:22278 #3 0x0008

[sqlite] sqlite3 3.7.11 on FreeBSD 9.0-RELEASE amd64 (ports) segfaults with memstatus compiled in _pthread_mutex_init_calloc_cb

Hi, I've been trying to track a segfault in sqlite3 (3.7.11, ports package) when I use OpenDNSSEC 1.3.7 and SoftHSM 1.3.2. I don't know if the issue is related to sqlite3 or to something in FreeBSD libc but it can be replicated by installing SoftHSM and OpenDNSSEC and then running "make check"