Skip to content

Gary Sieling

Principal Engineer

  • Machine Learning
  • Full Text Search
  • Data Science
  • Scraping
  • Postgres
  • DevOps
  • AWS
  • Talks

Tag: sql

Posted on March 17, 2016

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'

Posts navigation

Previous page Page 1 … Page 4 Page 5 Page 6 … Page 61 Next page
  • Thought Experiments
  • Proof of Concepts
  • Book Reviews
  • Projects
  • Essays
  • Talks
  • Programming Techniques
  • Javascript
  • Python
  • Prolog
  • Scala
  • Java
  • PHP
  • C#
  • R

Recent Posts

  • Allow a CircleCI self-hosted machine runner to run jobs for more than 5 hrs
  • Import a folder of CSVs into a single Google Sheet (1 per tab)
  • R Code to summarize Dept of Ed, Civil Rights Data by school district / LEA
  • Export Census ACS5 data by GEOID/block group to CSV in R
  • Get US Census population by block group (GEOID) in R
  • Get a list of census fields available at the GEOID (block group) level in R
  • PA Senate Committees 2023 CSV Download
Proudly powered by WordPress