Gary Sieling

Query Stackoverflow by tag

Stackoverflow allows you to query their data with SQL (see https://data.stackexchange.com/stackoverflow/query/new).

For example, you can get a list of all posts tagged with ‘scala’ like so:

select *
from Posts p
join PostTags pt on p.Id = pt.PostId
join Tags t on pt.TagId = t.Id and TagName = 'scala'

Exit mobile version