On 10 Jul 2010, at 8:27pm, Alan Chandler wrote: > I am actually not using C, but the php routines for this. I have my > suspicions, but I can't find it explicity stated anywhere that the > PHP::SQLITE3 module behaves exactly like the C routines but that using > PHP::PDO abstraction layer handles the lock detection and retry itself
That's likely to be correct. The PDO module has to work exactly the same as the calls to other SQL engines work: you should be able to switch from, say, MySQL to SQLite3 without changing a line of your code. Consequently the PDO module has its own expected behaviour, set when the first few SQL engines were implemented in it. On the other hand the SQLITE3 module was custom-written to suit SQLite users: it can have any functions in that suit how people use SQLite. It can display whatever non-standard behaviour experienced SQLite users expect. I would expect (but haven't read the source code) that Zend's implementation of SQLITE3 consists of minimal shim functions just to make each C function of SQLite available as a PHP function. That's why the documentation for SQLITE3 is so small: anything worth looking up is already available in the documentation for SQLite3. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
