I spent the last few days building a Flex/Google Gears integration demo that Kevin Lynch demonstrated during the Gears announcement today at the Google developer day in San Jose.
The demo is a Flex-based Sales Force Automation application that uses Gears to save data to a local SQLite database while offline, and automatically synchronizes back with the server when you reconnect to the network. There is a browser-based version of the application using Gears for the local database access, and an Apollo version using Apollo’s built-in SQLite support. I will post the code and more information about the application after cleaning it up a little bit.
In the meantime, here is a SQLAdmin app that I built to help me manipulate my Gears database as I was building the demo. It allows you to look at the content of your Gears SQLite database and execute any type of SQL statement (Click New Query in the menu).
You can run the application here. Per Gears’ security model, the database you create will be saved on your computer in a coenraets.org sandbox (databases cannot be shared across different domains). View source is enabled: right click and select View Source.
To use the app with your own databases, download the application here, and run it from the same domain as the database you wish to inspect.
If you are a Flex developer, this application also higlights the key steps to start using Gears in your own Flex application:
- Import Google’s gears_init.js in your HTML wrapper
- Add a couple of JavaScript functions. In this application I only defined one generic executeSQL() function that is called by the Flex app as appropriate.
- Your Flex app integrates with gears through ExternalInterface. In this app I abstracted the calls to Gears in a simple Database.as class
The source code is available here
NOTE: Make sure you install Google Gears before running the app.
Pingback: Coding with Scott » Google Gears For All! (A Flash-Gears Bridge)()
Pingback: Google Gear and Flex / Apollo « Ocean Apple()
Pingback: Google Gears and Adobe Apollo on SQLite at Flex Daddy()
Pingback: thebadtiming.com » Google Gears を Flex から使う()
Pingback: La Zona Muerta » Blog Archive » links for 2007-06-01()
Pingback: Ajaxian » Flex-based SQLAdmin for Google Gears()
Pingback: Flex-based SQLAdmin for Google Gears « outaTiME()
Pingback: Flex-based SQLAdmin for Google Gears()
Pingback: Dev::Info()
Pingback: Actionscript Hero()
Pingback: oriolrius lifestream » Christophe Coenraets » Flex-based SQLAdmin for Google Gears()
Pingback: Google Gears: Ganz große Kekse()
Pingback: paradox1x()
Pingback: Vinny Carpenter’s blog » Daily del.icio.us for Jun 01, 2007 through Jun 02, 2007()
Pingback: JEDI » Blog Archive » links for 2007-06-04()
Pingback: Utilidades para Google Gears | aNieto2K()
Pingback: Web Site Design, Internet Marketing, Ecommerce - ryanj - links for 2007-06-05()
Pingback: SQL Admin - A client side database front-end (woot!)()
Pingback: Weblogger.ch » Blog Archive » links for 2007-06-07()
Pingback: Christophe Coenraets » Flex and Google Gears: sales force automation application with offline capabilities()
Pingback: Vinny Carpenter’s blog » Daily del.icio.us for Jun 02, 2007 through Jun 06, 2007()
Pingback: Imrahil Weblog - Nokia N800 Internet Tablet » Archiwum » Pogłoski o mojej śmierci są stanowczo przesadzone…()
Pingback: BorundaLLC » Flex-based SQLAdmin for Google Gears()
Pingback: Christophe Coenraets » SQLite Admin Application for AIR()
Pingback: Web2.0Blog » Blog Archive » Flex e Google Gears()
Pingback: links for 2007-06-14 | The Marketing Technology Blog()
Pingback: SANIsoft - PHP for E Biz» Blog Archive » Into the fast (Google) gear()
Pingback: LGNewMedia » Cheers, Gears()
Pingback: Googling with Gears « Two Ducks()
Pingback: SQLAdmin for Google Gears | Adobe AIR Tutorials()
Pingback: Google Gears | Adobe AIR Tutorials()
Pingback: nice()
Pingback: 8865- sat « The Scotto Grotto()
Pingback: Flex Coding « Panduramesh’s Weblog()
Pingback: Flex with Java « anil4it()
Pingback: Pogłoski o mojej śmierci są stanowczo przesadzone… - Imrahil Weblog - Nokia N800/N810 Internet Tablet()