Convert a ZST file to a queryable SQLite database.
- Download the Reddit ZST compressed archive of the subreddit you're interested in at https://the-eye.eu/redarcs.
- Decompress the archive (e.g. zstd). The decompressed file is JSON.
- Rename the file to
nosleep_submissions.json. - Double check the number of submissions:
jq -s length nosleep_submissions.json - Run the conversion script:
/json-to-sqlite.js -i nosleep_submissions.json -o nosleep.sqlite - Open up the SQLite in your favorite editor.
SELECT author,title from data where title like '%train%17%'