I would like to have the option of using an offline (SQLite) db or an online (mySQL) db.
I am tying to use the content providers, as android suggests. This works fine for the SQLite db. However, to do so for the server, I need an override method for the 'public Cursor query(uri....)' in 'ContentProvider'. I can get my data in xml form (through a RESTful http request), but I don't see any way (at least no way that doesn't feel like a ridiculous hack) to get from there to a Cursor.
Am I missing something w/ Content Providers? I keep reading that they can be "anything", but have yet to find any example that uses anything other than a local sqlite db. Is there any any elegant way to get from the RESTful request (or any other request for that matter) to an Android Cursor? If it means creating a temporary local sqlite db from my server response I guess I can live with that...