[sqlite] Announcing SQLite3/SML binding v0.1

2007-02-17 Thread Wesley W. Terpstra
I've finished writing a binding for SQLite3 to SML. It can be found at http://terpstra.ca/sqlite3-sml/sqlite3-sml-0.1.tar.gz svn://mlton.org/mltonlib/trunk/ca/terpstra/sqlite3-sml It covers the entire non-experimental SQLite3 interface and I find it convenient to use. I've put the glue

Re: [sqlite] retrieval speedup help requested

2007-02-17 Thread P Kishor
On 2/17/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: Where does one get "analyze"? man, its pretty much a standard SQL command (at least all the dbs I've used thus far). Check out http://www.sqlite.org/lang.html. Most questions answered. -Original Message- From: RB

Re: [sqlite] Disk corruption?

2007-02-17 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Anderson, James H (IT) wrote: > Is this likely to just be a hardware error. > > database disk image is malformed(1) at dbdimp.c line 398 It could also not be a SQLite file. There is a list of how to corrupt your database files in section 6 at

RE: [sqlite] retrieval speedup help requested

2007-02-17 Thread RB Smissaert
http://www.sqlite.org/lang_analyze.html RBS -Original Message- From: Anderson, James H (IT) [mailto:[EMAIL PROTECTED] Sent: 18 February 2007 01:15 To: sqlite-users@sqlite.org Subject: RE: [sqlite] retrieval speedup help requested Where does one get "analyze"? -Original

RE: [sqlite] retrieval speedup help requested

2007-02-17 Thread Anderson, James H \(IT\)
Where does one get "analyze"? -Original Message- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: Saturday, February 17, 2007 5:25 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] retrieval speedup help requested Try running: analyze city_loc after adding the index. RBS

[sqlite] Disk corruption?

2007-02-17 Thread Anderson, James H \(IT\)
Is this likely to just be a hardware error. database disk image is malformed(1) at dbdimp.c line 398 jim NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of

[sqlite] Bug: sqlite3_finalize in authorizer breaks step of another query

2007-02-17 Thread Wesley W. Terpstra
Compile the attached C program and run it in a directory with the attached test.db. kiwiw:~/sqlite3/x terpstra$ ls -l bug.c test.db -rw-r--r--1 terpstra terpstra 976 Feb 18 00:09 bug.c -rw-r--r--1 terpstra terpstra 6144 Feb 18 00:09 test.db kiwiw:~/sqlite3/x terpstra$ gcc -Wall

RE: [sqlite] retrieval speedup help requested

2007-02-17 Thread RB Smissaert
Try running: analyze city_loc after adding the index. RBS -Original Message- From: Tom Shaw [mailto:[EMAIL PROTECTED] Sent: 17 February 2007 22:16 To: sqlite-users@sqlite.org Subject: [sqlite] retrieval speedup help requested In sqlite 3 I have two tables. city_loc has 156865 entries

[sqlite] retrieval speedup help requested

2007-02-17 Thread Tom Shaw
In sqlite 3 I have two tables. city_loc has 156865 entries and city_block has 1874352 entries: CREATE TABLE city_loc (loc_id INTEGER PRIMARY KEY, cc TEXT, region TEXT, city TEXT, postalCode TEXT, lat REAL, lon REAL, areaCode TEXT); CREATE TABLE city_block (start INTEGER UNSIGNED NOT NULL, end

Re: [sqlite] How do you combine two SQLite databases?

2007-02-17 Thread Kees Nuyt
On Sat, 17 Feb 2007 15:27:25 -0500, you wrote: >Hello, > >I have two SQLite database files, stuff1.db and stuff2.db. Each has three >tables within. I want to combine the two so I have one database file, >stuff.db, with 6 tables. How could I combine the databases? I am aware of >the "attach"

[sqlite] How do you combine two SQLite databases?

2007-02-17 Thread Neil McLeod
Hello, I have two SQLite database files, stuff1.db and stuff2.db. Each has three tables within. I want to combine the two so I have one database file, stuff.db, with 6 tables. How could I combine the databases? I am aware of the "attach" command, but this just seemed to create a file with two

Re: [sqlite] [patch] cleanup cross-compiling logic

2007-02-17 Thread Mike Frysinger
On Friday 16 February 2007, Joe Wilson wrote: > The sqlite autoconf stuff has been neglected for a while... ive merged my changes to CVS and i'll take a look at the open issues -mike pgpUTe4GZT41c.pgp Description: PGP signature

Re: [sqlite] [patch] cleanup cross-compiling logic

2007-02-17 Thread Mike Frysinger
On Friday 16 February 2007, Joe Wilson wrote: > The sqlite autoconf stuff has been neglected for a while... > > http://marc.10east.com/?l=sqlite-users=116760371614235=2 i dont have a problem tackling these issues if my fixes would get merged ... i know autotools is a huge headache for a lot of

Re: [sqlite] Question regarding REPLACE INTO and last row ID

2007-02-17 Thread Dan Kennedy
On Sat, 2007-02-17 at 00:38 -0800, Tom Olson wrote: > Hello, > > If a REPLACE INTO statement is executed and the there is an existing row > that is replaced will sqlite3_last_inserted_rowid return the rowid of the > record that was changed? REPLACE INTO doesn't change records. It replaces them.

[sqlite] Question regarding REPLACE INTO and last row ID

2007-02-17 Thread Tom Olson
Hello, If a REPLACE INTO statement is executed and the there is an existing row that is replaced will sqlite3_last_inserted_rowid return the rowid of the record that was changed? -- View this message in context: