[sqlite] Transaction Flow

Hi there,   I would just like to confirm that this is the processing flow for a transaction made of two SQL statements (INSERT + UPDATE):   sqlite3_open_v2() - open database sqlite3_prepare_v2() - prepare statement sqlite3_step() - BEGIN TRANSACTION using above prepared statement sqlite3_reset()

[sqlite] Transaction Flow

Hi there,   I would like to confirm the transaction flow for three SQL statements (2 INSERT's + 1 UPDATE):   sqlite3_open_v2() - open database sqlite3_prepare_v2() - prepare a statement sqlite3_step() - BEGIN TRANSACTION    if an error occured sqlite3_finalize() sqlite3_reset() - reset

[sqlite] SOLVED: Allocating Memory For A Pool Of Database Connections

It works when passing the db_cache_list[i]-db to sqlite3_open_v2 without trying to allocate it. Thanks a lot Richard and Ken. - Never miss a thing. Make Yahoo your homepage.

[sqlite] Allocating Memory For A Pool Of Database Connections

Hi there, I am having a minor issue when trying to malloc() memory for a list of database connections. I need to keep open a large number of database files and run queries against them. The application is running on Linux and is a synchronuous, single threaded application. In order to keep

[sqlite] SQLite3 Issue - Solved

Hi there, Thanks a lot Richard for your quick reply. I found the source of the error. gdb was displaying it in sqlite3_step but it was actually two lines before. Regards, David - Get easy, one-click access to your favorites. Make Yahoo! your

[sqlite] SQLite3 Issue

Hi there, I have started using recently SQLite which is pretty great for what I need, (i.e. a scientific application). After going through PostgreSQL, CDB, Tiny CDB and Berkeley DB it feels like coming home when I am looking at the size, speed, number of features and license. :)