WampServer
Apache, PHP, MySQL
on Windows
SQLite version trap - here's a solution
Posted by:
logisch
(---.dip.t-dialin.net)
Date: November 03, 2006 06:21PM
When using SQLiteManager, the default for creating a new database is a version 2.x format.
. <input type="radio" name="dbVersion" value="2" checked>
. <input type="radio" name="dbVersion" value="3">
As the last build for the sqlite.exe commandline tool is 2.8.17
dating from december 2005 whilst sqlite3.exe is availabel in
version 3.3.4 already and is maintained, its not understandable
that the defaults are selected the way they are.
(It took me an afternoon of google search just to find out
its that simple. I even gave perl "DBI
QLite2" a compile
run just to see afterwards that its only a legacy module and
the non-numbered default version of perl is really SQLite 3.x.x.)
A database conversion method is supplied by the SQLite folks.
Its done that way:
./sqlite your-de-2.1.db .dump | ./sqlite3 your-db-3.db
(I will give the new wampserver release a test run in a few minutes.)
. <input type="radio" name="dbVersion" value="2" checked>
. <input type="radio" name="dbVersion" value="3">
As the last build for the sqlite.exe commandline tool is 2.8.17
dating from december 2005 whilst sqlite3.exe is availabel in
version 3.3.4 already and is maintained, its not understandable
that the defaults are selected the way they are.
(It took me an afternoon of google search just to find out
its that simple. I even gave perl "DBI
QLite2" a compilerun just to see afterwards that its only a legacy module and
the non-numbered default version of perl is really SQLite 3.x.x.)
A database conversion method is supplied by the SQLite folks.
Its done that way:
./sqlite your-de-2.1.db .dump | ./sqlite3 your-db-3.db
(I will give the new wampserver release a test run in a few minutes.)
Sorry, only registered users may post in this forum.
