Hello,
I have a question regarding the locking in Sqlite3: Does Sqlite3 lock the
entire database when there is a lock on only one table?
In my code I want to read from one table and write the results to another
table. But if I don't fetch all the results and close the reading
connection, I cannot write to another table in the same database. Is this the
intended behavior? And how could I work around that?
I believe that this worked in In SQlite2. Here is a reduced example in PHP:
<?
$db="/tmp/testdb";
//unlink($db); // always use a fresh database
// open database s1
$s1 = new SQLite3($db);
// create a table
$s1->query("CREATE TABLE t1(one varchar(10), two smallint);");
// write one entry
$s1->query("INSERT INTO t1 VALUES('dog',1);");
$s1->query("INSERT INTO t1 VALUES('cat',2);");
// read the only entry and output it
$r = $s1->query("SELECT * FROM t1");
$a = $r->fetchArray(SQLITE3_ASSOC);
var_dump($a);
// close connection to s1, makes the code work
//$s1->close();
// write to table s2 -> does not work because database is locked
$s2 = new SQLite3($db);
$s2->query("CREATE TABLE t2(one varchar(10), two smallint);");
$s2->query("INSERT INTO t2 VALUES('fish',3);");
?>
This code produces a warning "database is locked" and does not insert the value
"fish".
Any help is appreciated.
Thank you,
Andreas
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
