October 1st, 2007
After a month of use, I’m still a big fan of Code Igniter; it’s a lightweight PHP framework that hasn’t got in my way, which is a big factor regarding how long things last. I particular like its flexibility regarding handling URLs, as it doesn’t force you to use its default segment-based approach, providing direct […]
June 8th, 2007
Google continue to blur the divide between offline and online applications with the beta release of Google Gears: a browser extension that enables web developers store and retrieve data locally.
Developers
LocalServer: you can define a list of URLs, so that when the user is offline, Google Gears can transparently serve those files instead.
Database: an embedded SQLite […]
April 23rd, 2007
Unique primary keys are an important feature of relational databases, however coming from a MySQL environment, I found some small issues when looking at how SQLite automatically creates IDs for your rows. Basically this is just illustrating the autoincrement SQLite documentation.
Here’s the schema of a simple SQLite database with no ID column specified:
sqlite> CREATE TABLE […]