O’Reilly’s OnLamp has posted the second installment of their how-to guide on using Google Gears. (I wrote about Part I previously.)

In the second article, Jack Herrington walks us through how to use Google Gears’ SQLite database for offline data entry and how to sync the offline data with a PHP web application when connectivity becomes available again.

There’s been a lot of buzz about Google Gears. Google Gears is an open source browser extension that enables web applications to provide offline functionality using Ajax and SQLite. Basically, it allows applications to download data while they have a connection to a remote server, store the data locally in a database, and then retrieve and use the data even when the web application is offline. Imagine searching Google Maps while in your car or reading RSS feeds on a plane. Even better, imagine submitting data to a web application that gets uploaded once you have a connection again—a lot like having emails waiting in your outbox.

Rather than just write “Hey, Google Gears was announced!” like everyone else, I decided to hold off until someone wrote something more in depth. Well, now O’Reilly’s OnLamp has. Jack Herrington has written an article titled The Power of Google Gears (Part 1). It’s not just about Gears, he actually walks you through a sample implementation step-by-step. He uses PHP, PEAR, and Prototype, but he explains it well enough that it should be easy to do in any language or framework.

But, at least for now, you’ll need an internet connection to read the article.