Build a SQLite satabase from your Reddit data

Hacker News

With Reddit's upcoming API changes[0], I got nervous that I'd no longer be able to access the many posts and comments I've left there over the years. Inspired by the Dogsheep projects[1], this CLI lets you immediately pull your most recent 1k comments & 1k posts (the max allowed by the paged API) into a nicely-structured SQLite database. It's perfect for loading into Datasette for nice viewing & full-text search of your content. Taking it a step further, the project's killer feature is the ability to import data from GDPR archives. This allows you to store your full Reddit history (including deleted comments and posts on removed subreddits). I hope you find this tool useful! I'll be around to answer questions and field comments (or feel free to open a GH issue). [0]: https://old.reddit.com/r/reddit/comments/12qwagm/an_update_r... [1]: https://dogsheep.github.io/

Visit product View on Hacker NewsMay 24, 2023

Share card

Actual performance

3points

Did not reach leaderboard

Launch Intel predictions

Analyze your own launch →

Hacker NewsStrong engagement from HN community · Strong signals: io, including · Missing: https docs, excited, just released

84%84% predicted probability of success on Hacker News, based on ML models trained on real launch data.

nativeThis product was originally launched on this platform.

Product HuntOn track for Day 1 leaderboard · Strong signals: open · Missing: mac, agents, macos

77%77% predicted probability of success on Product Hunt, based on ML models trained on real launch data.

Indie HackersFits the IH revenue-focused audience · Strong signals: including · Missing: supports, reddit linkedin, podcasting

74%74% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.

TrustMRRLess likely to generate early MRR · Missing: mobile apps, ios, personal

41%41% predicted probability of success on TrustMRR, based on ML models trained on real launch data.

AppSumoMay struggle as an AppSumo deal · Missing: plus, platform, intuitive

31%31% predicted probability of success on AppSumo, based on ML models trained on real launch data.

Acquire.comPre-revenue stage for this audience · Missing: arr, mrr, revenue

18%18% predicted probability of success on Acquire.com, based on ML models trained on real launch data.

BetaListMay not resonate with beta-testers · Missing: web3, chat, crypto

0%0% predicted probability of success on BetaList, based on ML models trained on real launch data.

Incorrect prediction on native model

Similar products

Policing the Police with Scraped Data – Started on Reddit/HN72%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Policing the Police with Scraped Data – Started on Reddit/HN

Hacker News11

My attempt at a decentralised Reddit60%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

My attempt at a decentralised Reddit

Hacker News2

Reddit Imgur Uploader69%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Reddit Imgur Uploader

Hacker News2

Reddit 1.056%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Reddit 1.0

Hacker News4

Afroic – The African Reddit63%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Afroic – The African Reddit

Hacker News3

Dumppit – A Reddit Firehose63%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Dumppit – A Reddit Firehose

Hacker News1

Reddit Firehose74%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Reddit Firehose

Hacker News23

Bleuit – A Recursive Reddit61%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Bleuit – A Recursive Reddit

Hacker News9

I scraped 5k Reddit, G2, Capterra and Upwork complaints36%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

I scraped 5k Reddit, G2, Capterra and Upwork complaints

Hacker News3

Rockets – Reddit and websockets61%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Rockets – Reddit and websockets

Hacker News98

Browse all products Analyze your launch