Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Turn of the Crank:
PHP 5, Sqlite, and Windows
Sep 12, 2006 @ 17:16:02

Sometimes, a technology sounds like a great, simple answer to all of your problems. That, however, was not the experience of this blogger when checking out SQLite on Windows.

My first task at my new job was a simple enough one. All our customers have a review site that has a list of contacts. The file was contacts.html and it was just a static html file.

Since there are already 100s of sites using the static html, I wanted to avoid any kind of complex migration or external database. I decided to give SQLite a try since the db files are so portable. Each site would have it’s own database with a single contacts table. Simple right? Let me go over all the problems I ran into.

He starts off with the fact that SQLite 3 doesn't work with PHP (different client drivers in PHP) and that PHP doesn't like SQLite 2 all that much either. His third and final experience? That SQLite isn't the brightest when it comes to working with directory permissions.

tagged: sqlite windows client version support directory permissions sqlite windows client version support directory permissions

Link: