Re: [sqlite] sqlite3_exec() returns SQLITE_OK but Databaseshowsdifferent result

Hi Pavel, Thanks a lot. You are right. I missed out a sqlite3_finalize() and that prevented the commit. Regards, Souvik -Original Message- From: sqlite-users-boun...@sqlite.org on behalf of Pavel Ivanov Sent: Mon 12/7/2009 6:15 PM To: General Discussion of SQLite Database Subject: Re:

[sqlite] sqlite3_exec() returns SQLITE_OK but Database shows different result

Hi, I am accessing the same database from two different processes. From one of the process , I am able to create tables in runtime but when I am trying to create a table from another process in runtime on the same DB I am not able to create so. The strange part is that I find sqlite3_exec() is

Re: [sqlite] sqlite3_exec() returns SQLITE_OK but Database shows different result

Hi, I am accessing the same database from two different processes. From one of the process , I am able to create tables in runtime but when I am trying to create a table from another process in runtime on the same DB I am not able to create so. The strange part is that I find sqlite3_exec() is

[sqlite] Database in tmpfs

Hello, I am creating a db in tmpfs with following PRAGMA settings: PRAGMA encoding = "UTF-8"; PRAGMA default_cache_size = 4000; PRAGMA synchronous = OFF; PRAGMA temp_store = MEMORY; PRAGMA journal_mode = OFF; I am creating four tables on the run and inserting 8000 records in two of these

[sqlite] Making Update fast

Hello, I am having a table which contains meta data of some Mp3 files. The table may contain 6000 to 7000 records. Every time a device is inserted, I am reading the device and based on a logic, I update a column value - from 0 to 1. This needs to be done for every record that are there in the

[sqlite] Write thread missing records during insertion

Hi, I am having two threads running say Thread-A and Thread-B. Thread-A is populating a DB table with while Thread-B is trying to read from the same table. In side Thread-B , I am creating a temporary table based on filtered queries made on the table which is getting populated by Thread-A. To

Re: [sqlite] Deleting database content : SQLite3 API

Yes , I understand that. Infact I was doing that through a script during system startup. I wanted to know whether SQLite provides any API to do the same. Thanks and Regards, Souvik -Original Message- From: sqlite-users-boun...@sqlite.org on behalf of John Stanton Sent: Sat 5/30/2009

[sqlite] Deleting database content : SQLite3 API

Hello, Please let me know if we have an API in SQLite3 which allows me to retain the database but delete it's content at runtime. The problem I am facing is that : Every time I restart my system , I need to create the database. If the database exits already it's contents need to be deleted. The

Re: [sqlite] Updating Database from multiple threads

Hello Igor Tandetnik, Many thanks. It is working ! Regards, Souvik -Original Message- From: sqlite-users-boun...@sqlite.org on behalf of Igor Tandetnik Sent: Mon 5/4/2009 5:04 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Updating Database from multiple threads

[sqlite] Updating Database from multiple threads

Hi, I have an application that requires two threads to insert data into the database simultaneously ( both the threads are updating independent tables which are in the same database).I am using sqlite-amalgamation-3.6.10 on Ubuntu 8.10. My database is on ext3 partition.I found