RE: [sqlite] Segmentation fault on large selects

I had something similar a while back on a 64bit HPUX box compiled with gcc. I was getting a core dump / seg fault on big table select when I did count(*)'s and sum()'s in the query. It wasn't all queries but it was consist ant and repeatable. I was able to get the queries to work with SQLite

[sqlite] difference between sqlite3_reset() and sqlite3_clear_bindings()

Can someone please explain the difference between sqlite3_reset() and sqlite3_clear_bindings() and when would I use one over the other. I've read the 3.2.2 docs and it's not 100% clear to me. Thanks

Re: [sqlite] using sqlite as a temporary database to process lots of data

I am currently using SQLite to process @ 400 million records (and climbing) a day by reading files, importing them into SQLite, and summarizing. The summed data goes into Oracle. This is a production application that is very stable. Holding the data in SQLite in memory as opposed to a C struct

[sqlite] PRAGMA page_size problems

This is related to a posting and also bug report (ticket 1230, I since closed) from last week. First: HPUX 11.11 64bit rp4440 server, 6 CPUs, 8 gig of RAM, tcl 8.4.9, sqlite 3.2.1 I was having problems inserting into a :memory: database using tclsqlite last week. First I create a table, then

Re: [sqlite] BLOB read/write in chunks?

Ran across this this morning ... removed in 3.0 (10) Are there any known size limits to SQLite databases? As of version 2.7.4, SQLite can handle databases up to 241 bytes (2 terabytes) in size on both Windows and Unix. Older version of SQLite were limited to databases of 231 bytes (2

Re: [sqlite] how to COPY FROM stdin in 3.x?

Is this also true for for in memory databases? - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Wednesday, May 04, 2005 5:03 PM Subject: Re: [sqlite] how to COPY FROM stdin in 3.x? On Wed, 2005-05-04 at 13:49 -0700, Darren Duncan

Re: [sqlite] OT: General SQL Question

ey" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Saturday, April 30, 2005 7:36 AM Subject: Re: [sqlite] OT: General SQL Question well audititems has a field parentauditid which links into audits. Audits has a supplierid field which is the key on suppliers.. From

Re: [sqlite] OT: General SQL Question

It is possible depending on the make up of the tables. post the table structures and index / keys and I'll help - Original Message - From: "Dan Keeley" <[EMAIL PROTECTED]> To: Sent: Saturday, April 30, 2005 6:38 AM Subject: [sqlite] OT: General SQL Question

Re: [sqlite] does sqlite run on 64 bit?

This is HPUX 11.11 and I'm using the tcllib. gcc 3.4.3. - Original Message - From: "Ulrik Petersen" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, April 29, 2005 6:32 PM Subject: Re: [sqlite] does sqlite run on 64 bit? Hi Patrick, Patrick

[sqlite] does sqlite run on 64 bit?

Has anyone been successful running SQLite on a 64 bit platform? If so, what platform? Using C libs or TCLSQLite? I am having limited success and need guidance. Thanks

[sqlite] memory fault in TCLSQLLite on HPUX 11.11 64 bit creating table

Hello, I am consistantly getting a memory fault in sqlite both through the tclsqlite shared library and the sqlite3 executable when I try to create a table. I have tried both sqlite 3.2.1 and 2.8.16. The TCL Versions tried are 8.4.6 and 8.4.9. I have had success on 32bit HPUX 11.11 but when