RE: [sqlite] .import problems

W Antarctic Astrophysics Group > -----Original Message----- > From: Balthasar Indermuehle [mailto:[EMAIL PROTECTED] > Sent: Dienstag, 21. März 2006 18:11 > To: sqlite-users@sqlite.org > Subject: [sqlite] .import problems > > Hi all, > > I'm trying to import a rather large

[sqlite] .import problems

Hi all, I'm trying to import a rather large file with the .import command into a version 3 sqlite DB file. I have created the table named data, all fields are numeric, I type ".import data.csv data" and I get the sqlite3 error "Error: No such table: data;" Any ideas anyone? thanks

RE: [sqlite] sqliteOsEnterMutex() and sqliteOsLeaveMutex()

to a microwave as well, no? Balthasar Indermuehle Inside Systems GmbH http://www.inside.net "The wireless music box has no imaginable commercial value. Who would pay for a message sent to nobody in particular?" David Sarnoff's associates in response to his urging for investment in

RE: [sqlite] Is using max(rowid) instead of count(*) safe?

ers Balthasar Indermuehle Inside Systems GmbH http://www.inside.net "Louis Pasteur's theory of germs is ridiculous fiction." Pierre Pachet, Professor of Physiology at Toulouse, 1872 . -Original Message- From: Cesare D'Amico [mailto:[EMAIL PROTECTED] Sent: Monday, March 2

RE: [sqlite] Is using max(rowid) instead of count(*) safe?

In some tests I did, autoincremented primary keys did not produce sequential numbers. Of a 100 records inserted, I'd get anywhere between 102 and 110 as the highest index, but never the correct number... cheers Balthasar Indermuehle Inside Systems GmbH http://www.inside.net "Louis Past

[sqlite] Multiuser experience under win32 anyone?

Hi all, Has anyone been doing some testing on how sqlite performs in a networked multiuser environment? Cheers Balthasar Indermuehle Inside Systems GmbH http://www.inside.net "Louis Pasteur's theory of germs is ridiculous fiction." Pierre Pachet, Professor of Physiology at Toul

[sqlite] performance tester for SQLite

Hi all, I programmed a little performance tester for SQLite. Check this page to download: http://www.inside.net/sqlite/ Feedback welcome (in particular comparisons with the Linux version). cheers - Balthasar Indermuehle All science is either physics or stamp collecting. Ernest Rutherford

[sqlite] Autoincrement not sequential

it doesn't produce sequential numbers. Sometimes it skips 1 or 2 numbers. There are no triggers associated with that table. Is that normal? Cheers - Balthasar Indermuehle All science is either physics or stamp collecting. Ernest