[sqlite] Queue INSERTs to locked DB

I'm writing an application that uses an SQLite DB to maintain a list of hashes that mutliple threads access at random times. Is there a way to queue sqlite3_exec() statements to locked databases or a way to check if a database is locked so I can retry every few seconds? Thanks, Kurt ___

Re: [sqlite] Using sqlite3: Excess memory consumed ?

Did you try to VACUUM the database? When items are removed from the database, the size doesn't shrink, it just marks the pages as free. Correct me if I'm wrong. Kurt -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kavita Raghu

Re: [sqlite] Compiling SQLite as .lib increases projectsizeandbuildtime?

From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kurt D. Knudsen Sent: Thursday, December 17, 2009 10:31 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Compiling SQLite as .lib increases projectsizeandbuildtime? Yeah, seems to be giving m

Re: [sqlite] Compiling SQLite as .lib increases projectsizeandbuild time?

e- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kurt D. Knudsen Sent: Thursday, December 17, 2009 10:19 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Compiling SQLite as .lib increases projectsizeandbuild time? Hi Pavel, I thin

Re: [sqlite] Compiling SQLite as .lib increases project sizeandbuild time?

generate .lib file and it can cause the error you see. Pavel On Thu, Dec 17, 2009 at 9:49 AM, Kurt D. Knudsen wrote: > Pavel, > > I have not defined it in the Linker properties. I have a solution called > 'SQLite Test' and inside it consists of 4 projects: > > HouseKee

Re: [sqlite] Compiling SQLite as .lib increases project size andbuild time?

Pavel, I have not defined it in the Linker properties. I have a solution called 'SQLite Test' and inside it consists of 4 projects: HouseKeeper - compiles as .dll Common - compiles as .dll SQLiteTest - compiles as .exe Sqlite - forced to compile as .lib (Why?!) Under Project Dependencies: * Hous

[sqlite] Compiling SQLite as .lib increases project size and build time?

Hi all, Since we're moving our project over from flat-files to an SQL DB, I've noticed that projects that utilize SQLite3 have increased to over 500k in size. Their original sizes were between 50-100k. Also, the build times have increased dramatically. I have SQLite added as a separate project

Re: [sqlite] Escaping strings to be used in queries in C/C++

] Escaping strings to be used in queries in C/C++ Kurt D. Knudsen wrote: > Thanks for the prompt reply. It seems sqlite3_mprintf() is exactly > what > I was looking for. I do have to ask, though, what is the benefit of > using the blob binding? I have my tables defined either usi

Re: [sqlite] Escaping strings to be used in queries in C/C++

+ Hi, The function "sqlite3_mprintf" is what you look for. see http://www.sqlite.org/capi3ref.html#sqlite3_mprintf Also, you might want to use bind variables instead of putting literals into your SQL text. see http://www.sqlite.org/capi3ref.html#sqlite3_bind_blob Martin Kurt D. Knudsen w

[sqlite] Escaping strings to be used in queries in C/C++

Hi guys, I've been searching high and low for a solution to this, but haven't found anything that I fully understand. Right now, I'm inserting text into a database that contains single quotes and backslashes. Is there a function that will properly escape these characters so they will be inserted p