1

(13 replies, posted in Feature requests)

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. smile

2

(13 replies, posted in Feature requests)

SQLite 3.2.0+ support "ALTER TABLE",
and lots of Mod. can't install in current SQLite 2.x,
it will be nice if next version to support SQLite 3.2.0+ smile