[sqlite] Importing a CSV file

Dear list, I am willing to try sqlite, but I am stuck at the very beginning : I can not import my data. The reason seems to be that when I create a table with 23 columns, it treats it as if it had 24 : I created a table with the following instruction : CREATE TABLE All_Chr_CxCb_atleast1

Re: [sqlite] Re: sqlite performance variationin linux and windows

Hi, Thanks for the quick response and the interest you're showing, I am testing the performance of linux and windows using a. same testing data for both. b. db schema is common for both. c. though the test is conducted on two different machines but the machine configurations are similar. Only

Re: [sqlite] Re: sqlite performance variationin linux and windows

On 25 Feb 2005 at 9:38, Neelamegam Appadurai wrote: > Could anyone please give me reason for variation in performance > between linux and windows. How are you testing this performance? Do you have a program written in windows and another written for linux? If so, the code/mechanism of DB

[sqlite] Re: sqlite performance variationin linux and windows

Hi all, Thanks for your replies, I had changed the page_size to 4096 and followed the doc "performance tuning for windows" and made changes as per the doc. Though there was increase in performance, but the performance in windows when compared to linux is much low. Could anyone please give me

RE: [sqlite] BLOB problem

> Actually I can read 10 MByte from an Oracle DB (on another machine) > via ODBC in less than 2 seconds... I don't know if that's good or bad > though, you tell me ;) Pretty good! That works out to 5 megabyte per second. That's gotta be gigabit ethernet. I don't think the 10 meg stuff will

RE: [sqlite] BLOB problem

Actually I can read 10 MByte from an Oracle DB (on another machine) via ODBC in less than 2 seconds... I don't know if that's good or bad though, you tell me ;) Anyway, the key idea I have for using SQLite is in the case I cannot reach the main (Oracle) database. Then I want to use SQLite as a

Re: [sqlite] Can SELECT queries lock the database for writing?

I'm not sure I understand exactly what's in your table; there are no integrity constraints, so it's hard to infer anything. I added a row to cover a case you didn't mention; maybe you think it can never happen, but there's nothing in your schema that prevents it. select * from history order by

RE: [sqlite] BLOB problem

Thanks Richard, Ah, I see. Well I did use those functions in the ODBC driver to make writing a blob work. However, my current problem is reading the blob. As long as there is no null bytes it works. But I'm very unsure of the calling sequence. Ok, say I got a table: create table

RE: [sqlite] Write issues on some computers?

What if the database was not closed properly on exit, would that be enough to set the database to read-only? Luc Vandal Edovia Technologies Inc. [EMAIL PROTECTED] www.edovia.com -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: February 24, 2005 11:43 AM To:

[sqlite] Questions

Hi *, Where I can find the list of the internal functions? for example: datetime() strftime() Where I find the documentation on as I can make in agreement INSERT/UPDATE the type of column (BOOLEAN/DATE) tks -- Marco Antonio J. Victor Fone: 11 6977-5406 Fax: 11 6973-9772 www.tactor.com.br

RE: [sqlite] Write issues on some computers?

Luc Vandal said: > Today a user told me that everything was fine yesterday and since today he > can't write to the database. What could cause that? The software closes > the > database on exit. I guess that the db is busy but what could cause the db > to > be busy for a large amount of time? You

Re: [sqlite] more syntax errors ?

Richard Nagle said: > sqlite> Create Table Company ( >...> Company Name Character (50) NOT NULL, >...> Contact Name Character (35), >...> Address1 Character (30), >...> Address2 Character (30), >...> City Character (30), >...> State Character

Re: [sqlite] more syntax errors ?

On Thu, 2005-02-24 at 10:40 -0500, Richard Nagle wrote: > It would appear, the sqlite does not follow the sql rules of syntax ? > or is there something I'm doing wrong? > SQLite follows standard syntax rules. I think you have a typo. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] more syntax errors ?

Richard Nagle wrote: fastmac:/applications/sqlite rn$ ./sqlite contacts SQLite version 2.8.13 Enter ".help" for instructions sqlite> Create Table Company ( ...> Company Name Character (50) NOT NULL, ...> Contact Name Character (35), ...> Address1 Character (30), ...> Address2

Re: [sqlite] more syntax errors ?

Are there spaces in [Company Name] and [Contact Name] field names? Regards, Witold - Original Message - From: "Richard Nagle" <[EMAIL PROTECTED]> To: Sent: Thursday, February 24, 2005 4:40 PM Subject: [sqlite] more syntax errors ? fastmac:/applications/sqlite

Re: [sqlite] tricky date time problem

Dennis, syntax error somewhere. 'group by minute union select 0, 0 where not exists (select * from event_data)' Lloyd - Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: Sent: Thursday, February 24, 2005 1:31 AM Subject: Re: [sqlite] tricky date

[sqlite] more syntax errors ?

fastmac:/applications/sqlite rn$ ./sqlite contacts SQLite version 2.8.13 Enter ".help" for instructions sqlite> Create Table Company ( ...> Company Name Character (50) NOT NULL, ...> Contact Name Character (35), ...> Address1 Character (30), ...> Address2 Character (30),

Re: [sqlite] Syntax error ?

So you must have the PATH set first?, then start the sqlite with a syntax: $sqlite contacts ( this would make a new database called contacts? .database 0 main 1 temp 2 contacts ? Richard Ulrik Petersen <[EMAIL PROTECTED]> wrote: R>ichard Nagle wrote: Sorry, let me get this

Re: [sqlite] Syntax error ?

Richard Nagle wrote: Sorry, let me get this straight: WHAT syntax command do I use ? sqlite> Make new database ? sqlite>contacts; The problem there is no Contacts database created ? I would have to make a database first, before creating tables? please explain. You don't make the database

Re: [sqlite] BLOB problem

I use the api sqlite3_bind_blob. Albert

Re: [sqlite] Syntax error ?

Sorry, let me get this straight: WHAT syntax command do I use ? sqlite> Make new database ? sqlite>contacts; The problem there is no Contacts database created ? I would have to make a database first, before creating tables? please explain. Richard Please not using any C or C++ programing (

[sqlite] BLOB problem

Hmmm... what is this? When using sqlite3_get_table it goes through sqlite3_exec which extracts values from columns with sqlite3_column_text (!!!). What about blobs? A blob can actually contain a number of null bytes! What is the recommended procedure to extract a blob if sqlite3_exec doesn't

Re: [sqlite] sqlite performance variationin linux and windows

Hi, Neelamegam Appadurai wrote: Can anyone please help me how to increase the performance on windows enviroment One thing you can do is to increase the page size from 1024 to 4096. That seems to match either Windows' swapfile-pagesize or the default page size of NTFS (there is disagreement

[sqlite] Functions

Hi *, Where I can find the list of the internal functions? for example: datetime() strftime() tks -- Marco Antonio J. Victor Fone: 11 6977-5406 Fax: 11 6973-9772 www.tactor.com.br

[sqlite] ODBC problem

Hi, I'm using the SQLite 3 ODBC driver at http://www.ch-werner.de/sqliteodbc/ and DTL (http://dtemplatelib.sourceforge.net/) and all works fine until I try to store a BLOB. I've debugged it so far that when the SQL C type is SQL_C_BINARY, no memory is allocated in SQLPutData and of course