Support for SQLite3 / SQLite2 deprecation

at 2012-01-06 in Announcements, Databases by friebe (0 comments)

With pull request #104 implemented the XP Framework now supports SQLite v3 databases via PHP's sqlite3 extension. To acquire a "connection" to an SQLite database, use "." as the hostname and supply the filename where you usually put the database in the DSN string:

  $conn= DriverManager::getConnection('sqlite://./test.db?autoconnect=1');

Note: At the same time, the sqlite scheme was changed to default to this new implementation instead of the older SQLite version 2, which will be deprecated in PHP 5.4. To stick with the old implementation, use sqlite+std as scheme to forcefully select the old driver. If you want to be forward-compatible, you may upgrade existing SQLite files as follows: sqlite old.db .dump | sqlite3 new.db.

You can subscribe to the XP framework's news by using RSS syndication.

Support for SQLite3 / SQLite2 deprecation

Subscribe

Categories

Related