http://www.perlmonks.org?node_id=1073535


in reply to DBD::SqLite issue while accessing DB from multiple processes

I am successfully using DBD::SQLite from 9 concurrent processes with sqlite_use_immediate_transaction set to true. However, although I'm doing inserts and updates I am NOT actually changing the schema (dropping tables). I'm not at all surprised if SQLite cannot cope with tables being dropped and recreated when a connection is already open.

  • Comment on Re: DBD::SqLite issue while accessing DB from multiple processes