News Feed
Sections




News Archive
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
September 12, 2006 @ 16: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.

0 comments voice your opinion now!
sqlite windows client version support directory permissions sqlite windows client version support directory permissions


blog comments powered by Disqus

Similar Posts

Maarten Balliauw: Working with Windows Azure from within PhpStorm

Gopal Vijayaraghavan's Blog: APC 3.1.2 Released!

Greg Beaver\'s Blog: Why it is very important to upgrade to PEAR 1.4.6 from PEAR 1.3.x

Nexen.net: PHP statistics for December 2006

Christopher Jones' Blog: LinuxWorld; Oracle PHP Books; NCLOBS


Community Events





Don't see your event here?
Let us know!


security symfony voicesoftheelephpant opinion interview version community package introduction podcast release laravel update tool framework series library composer language mvc

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework