So RhoElements seems to solve a lot of problems and Version 2 (sometime in the first half of next year) seems to solve even more issues (device compatability / sync services) - but there is the problem today of "I wrote a data collections app. How do I get this data to a PC and able to be synchronized with other devices?"
It seems like you don't have very many options if you're working in a disconnected environment using Web SQL on the device:
1) Web Services : when you do have connectivity - you send data to a web services page and load it into a master DB.
2) FTP : You could FTP the sqlite database, but you then need to read it on the other side, reconcile it, and then have a way to push it down to the devices again.
Does RhoElements support the File IO parts of HTML5 ?
Any other ideas on how you could tackle the data sync issues today?