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
No top articles yet