Hacker News Reader

Is Wikipedia available as an SQL database dump?

That would be really useful.

Yes and no. You can get SQL dumps (although XML is more common), but it doesn't contain any useful structure. The article content is just wikitext, and only metadata such as revisions are structured.

You can get a lot of data from Wikidata. They have a SPARQL interface at https://query.wikidata.org/#%23Humans%20born%20in%20New%20Yo... and you can also get all the data in a variety of rdf formats.

You can get all the edges (links between pages) and nodes (pages and text therein), so not sure what you mean about structure. I loaded all of Wikipedia into Neo4J like 6 months ago... Wasn't very hard.

Yeah of course, downloadable als SQL or XML: https://en.wikipedia.org/wiki/Wikipedia:Database_download#En...

Reply on news.ycombinator.com