Re: [sqlite] Threading issues in SQLite

After several experiments and tests, I ended up using one SQLite connection in several threads. This certainly doesn't currently work in SQLite natively, but if you properly use some locking mechanism (CriticalSections in my case), it works fine. Jiri

Re: [sqlite] sqlite3_open function

Perform an "access" or equivalent instruction before calling sqlite3_open. fred238 wrote: hello, Is there a way to not create a database while the db file is not found with the sqlite3_open function ? Why don't just create a create_table function instead of ? regards, fred.

Re: [sqlite] ~/sqliterc example/documentation avaible?

--- Brickl Roland <[EMAIL PROTECTED]> wrote: > where can i find information about how the config-file should look like and > what is possible? You can put any command seen in ".help" in the sqlite3 shell or any SQL command in ~/.sqliterc, such as: select 'no place like home'; .mode column

Re: [sqlite] ~/sqliterc example/documentation avaible?

On 8/11/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > You can put any command seen in ".help" in the sqlite3 shell > or any SQL command in ~/.sqliterc, such as: ...and of course, I would completely forget about the shell. Oops.

Re: [sqlite] Help with performance...

Not much you can do. You could examine the output of EXPLAIN QUERY PLAN for those statements. Hard to know without knowing the schema, but try making the "id" an INTEGER PRIMARY KEY, assuming it's appropriate for your data. Try to have as few indexes as possible on the table being inserted

Re: [sqlite] ~/sqliterc example/documentation avaible?

--- Trevor Talbot <[EMAIL PROTECTED]> wrote: > On 8/11/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > > > You can put any command seen in ".help" in the sqlite3 shell > > or any SQL command in ~/.sqliterc, such as: > > ...and of course, I would completely forget about the shell. Oops. As always,

Re: [sqlite] SQLITE_CORRUPT: database disk image is malformed

If you recompile sqlite3 with -DSQLITE_DEBUG=1, run sqlite3 in a debugger, and set a breakpoint on sqlite3Corrupt you can get a stack trace showing what led up to SQLITE_CORRUPT. But although this will show you roughly where the file is corrupt, it probably won't help you with why. If your OS

[sqlite] sqlite3 datatype

hello, Is necessary to set column datatype in sqlite3 ? Is better to use class storage in sqlite3 (TEXT, NUMERIC, INTEGER, REAL, NONE) ? regards, fred. - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] sqlite3 datatype

fred238 wrote: hello, Is necessary to set column datatype in sqlite3 ? Is better to use class storage in sqlite3 (TEXT, NUMERIC, INTEGER, REAL, NONE) ? Check out http://www.sqlite.org/datatype3.html and ask again here if yu have further questions. Gerry

Re: [sqlite] sqlite3 datatype

Gerry Snyder a écrit : fred238 wrote: hello, Is necessary to set column datatype in sqlite3 ? Is better to use class storage in sqlite3 (TEXT, NUMERIC, INTEGER, REAL, NONE) ? Check out http://www.sqlite.org/datatype3.html and ask again here if yu have further questions. Gerry

Re: [sqlite] sqlite3 datatype

fred238 wrote: Gerry Snyder a écrit : fred238 wrote: hello, Is necessary to set column datatype in sqlite3 ? Is better to use class storage in sqlite3 (TEXT, NUMERIC, INTEGER, REAL, NONE) ? Check out http://www.sqlite.org/datatype3.html and ask again here if yu have further questions.

[sqlite] SQLite extension

Hello SQLite community I am doing an investigation about Text Categorization based on N-Grams at my University. The main goal of the project is to offer a inexpensive way to categorize texts based on previous "learn". The categorization could not only be done as the language of the text,

[sqlite] any way to find out how many current connections to db?

is there any way (in c/c++) to find out how many current connections there are to a database that i am connected to? i'd like to do some housekeeping on the database every so often, but only if there's no one else connected to it at the time. any ideas? thanks. - chase