Synchronizing SQLite with a remote mySQL database

[LiquidChaz]

I need some help with a little theory here and I'm interested in hearing opinions and recommendations.

I'm creating a content store with in-app purchases. The store content is being managed by a remote mySQL database. I'd like the user to be able to browse the store offline so the idea is that I'd use a SQLite database locally that would sync with the remote database. Not only would this allow the user to browse offline, but it would also result in a faster experience since the app wouldn't have to contact a remote database while browsing.

The content in the database will be updated fairly infrequently (a few times a week). My question is... what's the best way to go about synchronizing the databases?

Am I going to run into any major issues developing the system in this manner?

[LiquidChaz]

*bump*

[nobre84]

If there is no data entry involved, you could just keep an update SQLite file on your server and download it when you see any changes pending...

[zardon]

Originally Posted by nobre84

If there is no data entry involved, you could just keep an update SQLite file on your server and download it when you see any changes pending...

I would try to KISS; you could have a page pulling in a XML/RSS feed of your latest in app-store purchases and store this in either a SQLite database or some other kind of file and you can simply display this as needed on a view -- obviousily you need to make it clear that the customer needs to be online to make in-app store purchases (I don't know how you check this, but you would need to do this).