[sqlite] How to determine if a column is autoincremented?

Hi all, I'm writing a SQLite adapter for a code generation tool. I'm a little stumped on how you query SQLite to determine if a column is autoincremented. I've tried PRAGMA table_info('my_table'); which returns all the columns for the table including a flag to tell if the column is

[sqlite] Multithreading (& C#) question

I have read that SQLite doesn't suport well multithreading... I have the following problem and wonder if anyone could provide me some guidance. I have a GUI application using SQLite to store its data. I have a 'Search' panel. Performing a search (scan of the database) in the background. And

[sqlite] Re: Multithreading Question

Thanks for the response Igor. I've added a few more introspection routines to my code to see what is going on while these two threads are working and it seems the following is happening: Again, with two threads (A and B), each thread does the following: BEGIN IMMEDIATE TRANSACTION; (60,000

RE: [sqlite] Very Slow delete times on larger databases, please help!

Thanks to both Christian Smith and John Stanton for your posts. > On Wed, 19 Oct 2005, Christian Smith wrote: > From the VDBE output you originally posted, you are doing a > fair amount of > work for each deleted row: > - Index search to find the next row from EXAMINATIONS to delete > -

Re: [sqlite] On VACUUM I get "constraint failed"

Preston, Thanks for the advice. I dumped the sql and attempted to recreate the db and got this error: >sqlite3 -init db.sql test.db Loading resources from db.sql INSERT INTO "category_meta_information" VALUES(NULL, NULL, NULL, NULL, NULL); SQL error: category_meta_information.taxonomy_id may not

Re: [sqlite] who is responsible for memory

Hi, >Sorry, I forgot to add: sqlite3_column_name(16). Currently I >let MS .NET free memory from that as well. You shouldn't do that. with sqlite 2 you had to free some memory when calling sqlite_compile using sqlite_freemem. With sqlite3 that is no longer needed, also not when calling

Re: [sqlite] who is responsible for memory

Sorry, I forgot to add: sqlite3_column_name(16). Currently I let MS .NET free memory from that as well. Thanks, Rob - Original Message - From: "Rob Lohman" <[EMAIL PROTECTED]> To: Sent: Friday, October 21, 2005 7:05 PM Subject: [sqlite] who is responsible

[sqlite] who is responsible for memory

Hi everyone, A couple of months ago I started writing a Microsoft .NET (1.1 at the moment, but it will be 2.0) wrapper around SQLite. I know a couple of those already exist, but for various reasons these do not meet my requirements. Everything is looking fine except for managing memory. I've

[sqlite] Re: Multithreading Question

Michael J. Sviridov wrote: I've got two thread's (with unique db handles), each thread does the following: BEGIN EXCLUSIVE TRANSACTION; (60,000 INSERT OR REPLACE statements into the same table) COMMIT TRANSACTION; This works fine, as expected, one thread acquires the lock and the other thread

[sqlite] Multithreading Question

Hi All Using sqlite 3.2.7 in a multi-threaded C++ application: I've got two thread's (with unique db handles), each thread does the following: BEGIN EXCLUSIVE TRANSACTION; (60,000 INSERT OR REPLACE statements into the same table) COMMIT TRANSACTION; This works fine, as

Re: [sqlite] Zip file with prebuilt DLL incomplete

Cory Nelson wrote: > > Indeed it should probably include sqlite3.h, but you are supposed to > generate an import .lib for your compiler using the .def file. VC++ comes > with lib.exe, I'm not sure how you do it with others. > > I know that the GNU compilers have a similar utility - I just have