Gearing up MySQL: Implementing MySQL Synchronization for Browser-based Apps Using an Embedded Database (Powered by Google Gears)
Location: Ballroom D
The features offered by Google Gears (but also the upcoming HTML 5 standard, and the Webkit browser framework) allow Ajax developers to create rich, fully fledged database applications that have to ability to be partially or even completely off-line.
Access to an off-line database as provided by google gears offers great opportunities to increase the availability as well as the scalability of regular web-applications:
- Users can continue with data entry and retrieval even when the connection is lost or the central database server is down.
- Chatty conversations with the database can be taken offline, offloading the central database server by only storing the result of a transaction in the central database, shortening the number and duration of database server sessions.
- Complex queries can be executed offline, utilizing the clients processing power rather than the server’s
One of the recurring themes in creating Gears applications that utilize the embedded database is how to implement synchronization to a central relational database server. This talk describes in detail a number of different approaches to creating Google Gears database applications and synchronizing the local google gears database to an online MySQL database.
Rough outline:
Google Gears- features
- API
- synchronization
- conflict resolution
- creating and using the local database
- setting up a workerpool
- processing local SQL requests with the workerpool
- using the workerpool for background synchronization
- database schema requirements for various synchronization techniques
- security
People planning to attend this session also want to see:
Roland Bouman
XCDSQL Solutions / Strukton Rail
I studied Molecular Biology, but I’m professionally occupied as Web Application Developer, Information and Business Process Analyst, and Business Intelligence Guy. I have worked for Inter Access, MySQL AB, Sun Microsystems, and I currently work for Strukton Rail.
Comments on this page are now closed.
Co-presented By:
Sponsorship Opportunities
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com
Download the MySQL Sponsor/Exhibitor Prospectus
Media Partner Opportunities
Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com
Press and Media
For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com
MySQL Conference Newsletter
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
Contact Us
View a complete list of MySQL contacts.
O'Reilly Home | Privacy Policy | Contact Us | Sitemap | conf-webmaster@oreilly.com
Event Software Powered by Expectnation
© 2009, O'Reilly Media, Inc. | (707) 827-7000 / (800) 998-9938
Comments
Even though it wasn’t complete, I thought it showed pretty good promise. I quite enjoyed it. I wonder if even the incomplete slides might be made available and then updated if and when he chooses to complete it. Some questions I have are. 1. If you start out with a disconnected environment to the server, would it be possible to have a a client side view of the web interface to still show up? Would you essentially create or replicate the server generated web interfaces wthin your client side google gears environment so that if you start out disconnected, you can still operate “Disconnected”.
2.
Presentation wasn’t done, and the MySQL-relevant bit (syncing gears db with a MySQL db) was completely missing. The speaker was completely up front about this, but especially given the title, it was pretty disappointing.