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
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
-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
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
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
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
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
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
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
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"
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
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
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
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.
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:
15 matches
Mail list logo