In fact, that work has already been done:
http://stackapps.com/questions/3610/stackdump-an-offline-bro...
An example of similar hotspotting would be the ftp app on f-droid.
What would be good would be if there was an easy way to filter the local database for specific tags before putting it on the phone.
Edit: I'm guessing SO probably won't have an issue with it.