Ivor O’Connor

April 5, 2009

Starting Skeleton, Template, For Sqlite Google Gear Self-Contained Client Apps

Client side applications using google gears for locally storing SQL data are obviously the future. They allow applications to be run on any operating system without coding user interfaces, learning new languages, or managing SQL database daemons/servers. You can start by running the application off a server. But it’s much better to simply download the web page and run it disconnected from the internet. To start the application in the future you simply click on the html file you downloaded.  It is so cool.

Where are all the example sites describing how to use google gears for client side applications though? I’ve looked for starting point skeletons and have found NONE! I believe it is because the subject is new. So I’m publishing my own skeleton. It can be found at http://ioconnor.atbhost.net/google.gears.skeleton.html. I’ll probably upgrade it as time goes on but my skeleton is quite good already. After you read through Google’s tutorials at http://code.google.com/apis/gears/tutorial.html download my code and use it as a starting point for your own project. Don’t reinvent the wheel!

My skeleton is self-contained. There’s no need to download a set of files or update a registry, run an installation script, etc., assuming your environment is complete.

However if your base environment is not complete no problem. The environment is tested to verify the gears addon has already been installed, that javascript is enabled, and that you have an up-to-date browser. If something is lacking you must click “ok” to acknowledge the problem and then your browser takes you to the URL where  the fix is.

I wish I had this easy to use skeleton a long time ago. It makes client side browser applications using SQL easy!

I’m probably going to make quite a few client side browser applications using this template. Having a free interface, sql database, and programming language across all OS platforms levels the playing field so much it can’t be ignored.

Update 2009.04.08: The code was refined yet again tonight. There’s nothing in it that seems to be lacking that can be done better. However please comment on it if there is something more that could be done…


March 19, 2009

California Weekly Payroll Client Side Browser Application

Filed under: Uncategorized — Tags: , — ioconnor @ 10:14 pm


I’ve been working on a client side browser application to compute taxes and print pay stubs on a weekly basis in California. This is a picture of the main display as it now stands. When the submit key is pressed a new window is opened that contains the employees’ pay stub ready to be printed.

The information at the top is filled dynamically as information is entered in the fields below. The idea is to give an idea of what the pay stub will look like when the submit key is pressed.

However I’m having trouble finding a free website to post the working application. Google sites, which was my first choice, does not allow javascript! This client side browser application is all about javascript. Does anybody know a free site I can sign up on and post to?

Until then I’ll work on getting the google gears portion of it working so I can do the year-to-date calculations which it currently lacks…

Create a free website or blog at WordPress.com.