Re: [sqlite] sluggish performance in MacOS 10.4

On Fri, 2 Dec 2005, C C wrote: >On 12/2/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >> The added risk in going from synchronous=FULL to synchronous=NORMAL >> is minimal. You only run into trouble [when] you select >> synchronous=OFF. > >you've piqued my interest... Does sqlite implement

Re: [sqlite] sluggish performance in MacOS 10.4

Christian Smith wrote: On Fri, 2 Dec 2005, C C wrote: On 12/2/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: The added risk in going from synchronous=FULL to synchronous=NORMAL is minimal. You only run into trouble [when] you select synchronous=OFF. you've piqued my interest... Does

[sqlite] Crash - How can I tell if sqlite is compiled threadsafe?

Greeting, I'm using sqlite 2.8.16 in a threaded programs.We have been seeing crashes when opening databases, and it looks like two threads are trying to open databases at the same time. We know that whoever compiled sqlite was told to define THREADSAFE, but we do not know if that was done.

Re: [sqlite] Crash - How can I tell if sqlite is compiled threadsafe?

"Henry Miller" <[EMAIL PROTECTED]> wrote: > Greeting, > > I'm using sqlite 2.8.16 in a threaded programs.We have been seeing > crashes when opening databases, and it looks like two threads are > trying to open databases at the same time. We know that whoever > compiled sqlite was told to

Re: [sqlite] Crash - How can I tell if sqlite is compiled threadsafe?

On 12/6/2005 at 15:29 [EMAIL PROTECTED] wrote: > >This assertion failure inside of sqliteOsEnterMutex indicates >that the program was probably not compiled THREADSAFE. That >assert() statement was put there specifically to catch this >kind of problem. (Good thing you didn't compile with

[sqlite] A newbie question

Hi all, so I have a (not) simple question. Is it possible to insert into blob field content of the file? How to = manage it in C++? Regards WojciechW

Re: [sqlite] A newbie question

Hello erw2, This is how I do it. HRESULT hr = Compile("INSERT OR IGNORE INTO Files_V1" "(" "FileOrder," "Filename," "Length," "Signature," "Date," "Topic, "

[sqlite] how can I import CSV file into SQLite quickly

I have a very large CSV file with 1 rows and 100 columns.and the file looks like the following: "a","b","c","d", "1","2","1","3" , "3","2","2","1", .. If I use .import,It seems I have to set the variable names manually . Is there any way to import the whole data file into SQLite quickly?

Re: [sqlite] how can I import CSV file into SQLite quickly

I create an SQL file that has contents like this: [EMAIL PROTECTED] elections]$ cat insert_precinct.sql BEGIN TRANSACTION; INSERT INTO "precinct" VALUES(1, 'Community Center 15 Crescent Road', 3, 'Greenbelt', 'Maryland', 0); INSERT INTO "precinct" VALUES(2, 'Police Station 550 Crescent Road',

Re[2]: [sqlite] how can I import CSV file into SQLite quickly

Hello All, Wouldn't it make sense to write a program that reads it in, one line at a time, splits and inserts the data into the proper tables? Even creating the table on the fly? That's what I'd do, a little command line utility. It's basically the "convert to SQL" technique you suggest where

Re: [sqlite] how can I import CSV file into SQLite quickly

Someone somwhere must have a simple Perl script which does what you want. JS Robert L Cochran wrote: I create an SQL file that has contents like this: [EMAIL PROTECTED] elections]$ cat insert_precinct.sql BEGIN TRANSACTION; INSERT INTO "precinct" VALUES(1, 'Community Center 15 Crescent Road',