<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-2">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>hi,</p>
<p>first of all, i know sqlite is not designed for concurrency</p>
<p>workarounds are wal - <a class="moz-txt-link-freetext" href="https://www.sqlite.org/wal.html">https://www.sqlite.org/wal.html</a> . can be
specified when creating DB with "pragma journal_mode=wal"<br>
</p>
<p>and <br>
</p>
<p>busy_timeout <a class="moz-txt-link-freetext" href="https://www.sqlite.org/c3ref/busy_timeout.html">https://www.sqlite.org/c3ref/busy_timeout.html</a> .
MUST be specified per connection<br>
</p>
<p><br>
</p>
<p>we are using sqlite for cel and queue_log. <br>
</p>
<p><a class="moz-txt-link-freetext" href="https://github.com/asterisk/asterisk/blob/master/res/res_config_sqlite3.c">https://github.com/asterisk/asterisk/blob/master/res/res_config_sqlite3.c</a></p>
<p><a class="moz-txt-link-freetext" href="https://github.com/asterisk/asterisk/blob/master/cel/cel_sqlite3_custom.c">https://github.com/asterisk/asterisk/blob/master/cel/cel_sqlite3_custom.c</a></p>
<p>busy_timeout is hardcoded (value is in ms)
</p>
<p><span class="pl-c1">sqlite3_busy_timeout</span>(db->handle, <span
class="pl-c1">1000</span>);</p>
<br>
<p>will you accept patch where busy_timeout will be configurable?<br>
</p>
<p><br>
</p>
<p>btw our use case is</p>
<p>- central data warehouse</p>
<p>- apache kafka as receiver</p>
<p>- every asterisk has producer (node.js) which analyze sqlite
cel/queue_log. producer builds call structure and send it to
kafka. main problem is in updating sqlite cel/queue_log by
producer which rows was sent (concurrent write access)<br>
</p>
<p><br>
</p>
<p>Marek<br>
</p>
<p><br>
</p>
<p><br>
</p>
</body>
</html>