RE: [sqlite] executing sql on a sqlite from the cmd line

"). -dave -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 22, 2007 2:48 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] executing sql on a sqlite from the cmd line --- "Gauthier, Dave" <[EMAIL PROTECTED]> wrote: > Bu

[sqlite] sqlite.init ???

Hi: I found nothing on the official sqlite website (sqlite.org) regarding the sqlite.init file. Did I miss something? Are there other (better) documentation resources other than the documentation link on sqlite.org? SPecifically, I'm trying to either point sqlite3 to a specific sqlite.init (no

RE: [sqlite] executing sql on a sqlite from the cmd line

-- From: James Dennett [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 22, 2007 12:04 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] executing sql on a sqlite from the cmd line > -----Original Message- > From: Gauthier, Dave [mailto:[EMAIL PROTECTED] > Sent: Wednesday, Aug

[sqlite] executing sql on a sqlite from the cmd line

On Linux... How can I execute a sql command against a sqlite DB straight from the command line. Somethign like sqlite3 foo.sqldb -e "select * from mytable" or... sqlite3 foo.sqldb < "select * from mytable" (only these don't work) Also, can I prefix with a setup option (li

RE: [sqlite] Data structure

valgrind -Original Message- From: Lloyd [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 12:26 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Data structure Would anybody suggest a good tool for performance measurement (on Linux) ? On Wed, 2007-04-11 at 10:35 -0500, John Stanton

RE: [sqlite] storing the tables in separate files

If you want to store tables in different files, you may want to consider a heavier relational db , like Postgres, MySQL, Oracle, SQLServer... -Original Message- From: Guilherme C. Hazan [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 11, 2007 3:10 PM To: sqlite-users@sqlite.org Subje

RE: [sqlite] Data structure

There are many important variables to consider. What kind of data? How many tables (if a relational DB approach even makes sense)? How many records in each table? How will this data be queried? Many different, often unperdicatable ways? Or just a couple static ways? There's nothing faster th

RE: [sqlite] Data structure

I'm not sure I understand the question, but I'll take a stab at it anyway. If the data is to be loaded by and queried from the same program execution, you may wnat to consider using a temporary table as opposed to a regular (permanent) one that will go to disk. The time you might save has to do w