In a new post over at ‘Turn up the Crank’, the author talks about how all his customers have a review site that has a list of contacts. The file was contacts.html and it was a static HTML file, he says. The managers had to edit the HTML directly to add, update, or delete any contacts. Since editing HTML directly is difficult, they all wanted Dreamweaver on their systems, which would get expensive, he writes.

Since there are already 100s of sites using the static HTML, the author wanted to avoid any kind of complex migration or external database. He decided to give SQLite a try since the db files are portable. Each site would have it’s own database with a single contacts table.

Problems he encountered include:

• SQLite 3 does not work with PHP
• PHP is not very friendly with SQLite 2
• SQLite is stupid about directory permissions