How to Download the Stack Overflow Database for Postgres
Read OriginalThis article provides a step-by-step guide to downloading the Stack Overflow data dump (as of 2024-04) and restoring it into a PostgreSQL database. It covers prerequisites like PostgreSQL 18 and 250GB of free space, using a BitTorrent client to download the 24GB archive, extracting it to a 124GB dump file, creating a database with a specific collation, and restoring via DBeaver or command line. The data includes 22.5M users, 60M posts, and 239M votes, offering a realistic dataset for learning and testing queries. The article also mentions licensing (CC BY-SA 4.0) and offers troubleshooting help.
Comments
No comments yet
Be the first to share your thoughts!
Browser Extension
Get instant access to AllDevBlogs from your browser
Top of the Week
1
Limit token usage in Microsoft Agent Framework
Jesse Liberty
•
1 votes
2
How to Roll Back AI Agents: Incident Response, Circuit Breakers, and Recovery Patterns
Paul Bryant
•
1 votes
3
Avoiding Reasoning Model Failures with Microsoft Foundry
Luke Murray
•
1 votes
4
When Your AI Agent Lies: Silent LLM Fallbacks
Luke Murray
•
1 votes
5
Adding a custom MCP server to Claude and ChatGPT
Simon Willison
•
1 votes
6
Testing AI prompts and comparing models with promptfoo
Tim Deschryver
•
1 votes
7
Superlogical
Mitchell Hashimoto
•
1 votes