CellProfiler/CellProfiler — Issue #64: JIRA [IMG-1509] ExportToDatabase: Add delay to avoid simultaneous writes to SQlite db?
Author: thouis
Created: 2011-11-23 20:49:47+00:00
State: open
Labels: current

See this forum post:http://cellprofiler.org/forum/viewtopic.php?f=16&t=1432
Is it possible to use the sqlite3_busy_handler() or sqlite3_busy_timeout() functions to delay the write until the db is unlocked?

Original reporter: mbray
Jira link: https://jira.broadinstitute.org/browse/IMG-1509
Fix version: Current
Assignee: afraser

**Comment from afraser on Mon, 29 Aug 2011 12:37:55 -0400:**
Playing Devil's Advocate: Option B would be to try to solve the problem, but show a warning in ExportToDatabase if there's a CreateBatchFiles module.
eg: Warning: Writing to SQLite in parallel is a crappy idea, so we provided a crappy solution. It might work.