In Fact, I had a testing forum which used SQLite3 DB that convert from SQLite2.
I just know a little php, so wrote an example php to test SQLite3 DB:
<?
$db = sqlite3_open("punbb.db3");
$query = sqlite3_query($db, "SELECT poster,message FROM posts");
if (!$query) die (sqlite3_error($db));
while ( ($row = sqlite3_fetch_array($query)) )
{
echo $row['poster'], $row['message'];
echo "\n";
}
sqlite3_query_close($query);
sqlite3_close ($db);
?>
and it just work fine.
But PunBB just show a empty page when i try to change some code in include\dblayer\sqlite.php like this:
from
sqlite_xxx()
to
sqlite3_xxx()
I thought it should be easy for people that familiar with php convert to SQLite3.