Re: [sqlite] How to get access to SQLite Test Harness #3(TH3)

Hi *Roger Binns*, Thanks for the reply.Actually i wasnt checking mail-list for answer i thought i will be getting mail to my gmail that is the reason i posted on developers forum too. *Richard Hipp*, i dont see any reply from you in the mail-list. *Roger Binns/* *Richard Hipp,* I am planning

Re: [sqlite] Data visibility problem

On 6/25/2014 8:48 PM, João Ramos wrote: Now that you mentioned the WAL, shouldn't this actually help prevent this scenario? Quite the opposite - WAL helps enable this scenario. With traditional rollback journal, the writer would be unable to write at all while a reader is active, so issues

Re: [sqlite] Data visibility problem

>> "Externally, from the point of view of another process or thread, two >> or more database connections using a shared-cache appear as a single >> connection. The locking protocol used to arbitrate between multiple >> shared-caches or regular database users is described elsewhere." >Of course

Re: [sqlite] Support for concurrent transactions

After a little experimentation I can't find any better way of doing this than to have each transaction handled with a different connection to the database. In other words, for each BEGIN you need a sqlite3_open(). If you do this, different concurrent parts of your app can each run their own

Re: [sqlite] Data visibility problem

On Wed, Jun 25, 2014 at 8:04 PM, Sohail Somani wrote: > On 22/06/2014 6:33 PM, João Ramos wrote: > >> The issue appeared with the following scenario: - using SQLite v3.8.4.3 - >> the DB is in WAL mode and running with multi-thread mode - every thread >> has >> a read-only

Re: [sqlite] Data visibility problem

On Wed, Jun 25, 2014 at 2:19 PM, Igor Tandetnik wrote: > On 6/25/2014 5:19 AM, João Ramos wrote: > >> And I understand the limitations a shared-cache mode may have, but if this >> is to be the case, it should be documented. I can be wrong, but I didn't >> find anywhere in the

Re: [sqlite] SQLite performance with NOR FLASH

On 25 Jun 2014, at 9:14pm, Vivek Ranjan wrote: > sqlite3_backup_init() > > sqlite3_backup_step() > > sqlite3_backup_finish() >

[sqlite] SQLite performance with NOR FLASH

Dear All, I am unsing SQLite on NOR Flash with Sqlite version 3.8.5 with default setting i.e. sector and page size. Writing to NOR Flash taken around 10 seconds ( SQLite file size of 400KB, which is somehow not acceptable). Upon inserting additional debug prints, I found that since I use the

Re: [sqlite] Sequential numbers

On 2014/06/25 21:38, Dave Wellman wrote: Hi Petite, Many thanks fo rthsuggestion, it works a treat!. Hi Simon, Thanks for the thoughts but in this particular processing that is not going to happen (delete a few rows). In this processing we always empty the table completely before re-populating

Re: [sqlite] Sequential numbers

Hi Petite, Many thanks fo rthsuggestion, it works a treat!. Hi Simon, Thanks for the thoughts but in this particular processing that is not going to happen (delete a few rows). In this processing we always empty the table completely before re-populating it. I've gone with the TRIGGEr solution,

Re: [sqlite] Data visibility problem

On 22/06/2014 6:33 PM, João Ramos wrote: The issue appeared with the following scenario: - using SQLite v3.8.4.3 - the DB is in WAL mode and running with multi-thread mode - every thread has a read-only DB connection (using thread-local-storage) - a single DB connection is shared between threads

Re: [sqlite] SQLite and BLOBs

Whether to use internal or external blobs is application dependant. In my test & measurement application testing 1 widget generates 140 small (1.2kB to 14kB) blobs. Multiply that by hundreds of widgets and you can see that storing and managing these as individual files would be a big headache

Re: [sqlite] Data visibility problem

On 6/25/2014 5:19 AM, João Ramos wrote: And I understand the limitations a shared-cache mode may have, but if this is to be the case, it should be documented. I can be wrong, but I didn't find anywhere in the docs where this scenario is presented (or has some sort of warning). Well, one can't

Re: [sqlite] Sequential numbers

HI, That sounds a neat solution, I'll have a look at implementing one. Many thanks. Dave Ward Analytics Ltd - information in motion Tel: +44 (0) 118 9740191 Fax: +44 (0) 118 9740192 www: http://www.ward-analytics.com Registered office address: The Oriel, Sydenham Road, Guildford, Surrey, United

Re: [sqlite] Planner chooses incorrect index

The sample column has some sensitive data that I can't share, so I'll have to change it and then try to reproduce the problem (I removed it before because I assumed that it wouldn't be important). On Mon, Jun 23, 2014 at 3:26 PM, Dan Kennedy wrote: > On 06/23/2014 05:48

Re: [sqlite] Data visibility problem

On Mon, Jun 23, 2014 at 3:31 PM, Simon Slavin wrote: > > On 23 Jun 2014, at 11:17am, João Ramos wrote: > > > On Mon, Jun 23, 2014 at 10:58 AM, Simon Slavin > wrote: > > > >> Are you finalizing all these SQL commands (or using

Re: [sqlite] Data visibility problem

On Mon, Jun 23, 2014 at 3:03 PM, Igor Tandetnik wrote: > On 6/23/2014 5:43 AM, João Ramos wrote: > >> If multiple connections in shared cache mode are treated as a single >> "real" >> connection, should I change the thread mode to Serialized? >> > > What mode do you use now?