that solves only the part of synchronizing local and remote databases, but not the offline work
for offline you need a desktop solution (adobe air , other solution), or if you need to work in browser, I don't see other solution than google gears Google Gears is in fact a javascript interface to sqlite databases