Meta Stack Exchange is a question and answer site for meta-discussion of the Stack Exchange family of Q&A websites. It only takes a minute to sign up.
Sign up to join this community
I know we can download the entire Stack Overflow database from the Web Archive
Is there any way to query the Stack Overflow database archive? The entire database is around 30 GB, and I don't want all of it, only the Q&A with a specific tag (or even a combination of two or more tags). For example, say I only want Q&A related to Android programming and I don't want any other categories. Is there a way to download only certain part of database?
No, you can't do that.
You have to download all the XML before you can do any filtering. If the size of the dump is an issue you might consider The Stack Exchange Data Explorer as it is updated weekly and has a bit more tables. There are some tricks to download lots of data at once for the Data Explorer.
An other option if you don't want to download the whole dump is using the StackAPI but it is limited to 10,000 api calls per day so for huge tags it might take a while before you have all posts in a tag. Start here for the questions, implement paging and fetch the answers-by-id for the questions you found.
Last but not least you could setup some ordinary web-scraping. Watch out for the throttling though.
iosfromstackOverflow.comPostsfile, parse out theTagscolumn foriosand retrieve those posts. Or use the data explorer, as rene answered.