Posted on February 26, 2006 - 2 Comments

Notice for PDO SQLite user

Did your PDO SQLite unable to read and write database that you just created using your SQLite console? And PDO said something like "unsupported file format", didn’t you?

Hey what’s up man?
You’re not a lucky guy my friend, me either

Did you know that the SQLite file format has changed again? At January 10th, 2006 exactly the file format changed to version 3.3, here is the log for it:

Version 3.3.0 uses a new encoding for binary values that uses less disk space. Version 3.3.0 can read and write database files created by prior versions of SQLite. But prior versions of SQLite will not be able to read or write databases created by Version 3.3.0

for complete file format logs, you can read here. Additional log can found on the complete SQLite changes log.

We’re soo late my friend, it’s more than one month ago

Current PDO uses SQLite library version 3.2.8undefined, not weird if it unable to works with your SQLite databases those created by SQLite 3.3.x console.

This time and only this time, just use your SQLite 3.2.x console in order to makes your PDO SQLite working properly and your databases safe while waiting for new PDO released. Don’t made any mistakes with open your SQLite created by PDO using SQLite 3.3.x console, if you won’t frustated and don’t get PDO wrong if it happened to you.

You has been noticed man!

 

Tags: , , ,

 

2 Comments

  • That’s pretty rude.

    I noticed that problem with the latest PHP release. I seems pretty bad to ship a release with incompatable regular SQLite and PDO SQLite extensions.

  • This could be a big trouble, if you opened your SQLite database created by PDO with your SQLite 3.3.x console. You cannot read your database anymore after did it. :?

 
 

Comments are currently closed.