WAwackget·Jun 10, 2023
Done: https://github.com/xavdid/reddit-user-to-sqlite/issues/15
I see someone else has already filed one about saving the context.
In Archive your Reddit data before it's too latexavdid
reddit-user-to-sqlite
Python2023–2023
xavdid / reddit-user-to-sqlite
reddit-user-to-sqlite
Pull Reddit user data into a SQLite database
2Distinct people
4Mentions
0Explicit recommenders
230GitHub stars
What to know before exploring
What it is
Pull Reddit user data into a SQLite database
GitHub
Where it is used
No documented product use has been verified yet.
What people are saying
No recommendation phrase was found in the indexed comments.
No classified warning is attached to this page. Read the discussions before treating silence as approval.
Also in these discussions
No other repository is repeatedly linked in the same discussions.
This week on Hacker News
Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 3:56:07 PM UTC.
No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.
Mentions over time
HN mentions by day4 dated mentions
Observed mentions: 2023-05-24 18:35:37 UTC to 2023-06-10 23:43:13 UTC.
Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.
View mention counts and date ranges
| Period | Start (UTC) | End (exclusive, UTC) | Mentions | Submissions | Comments |
|---|---|---|---|---|---|
| May 24 | 2023-05-24 00:00:00 UTC | 2023-05-25 00:00:00 UTC | 1 | 1 | 0 |
| May 25 | 2023-05-25 00:00:00 UTC | 2023-05-26 00:00:00 UTC | 0 | 0 | 0 |
| May 26 | 2023-05-26 00:00:00 UTC | 2023-05-27 00:00:00 UTC | 0 | 0 | 0 |
| May 27 | 2023-05-27 00:00:00 UTC | 2023-05-28 00:00:00 UTC | 0 | 0 | 0 |
| May 28 | 2023-05-28 00:00:00 UTC | 2023-05-29 00:00:00 UTC | 0 | 0 | 0 |
| May 29 | 2023-05-29 00:00:00 UTC | 2023-05-30 00:00:00 UTC | 0 | 0 | 0 |
| May 30 | 2023-05-30 00:00:00 UTC | 2023-05-31 00:00:00 UTC | 0 | 0 | 0 |
| May 31 | 2023-05-31 00:00:00 UTC | 2023-06-01 00:00:00 UTC | 2 | 0 | 2 |
| Jun 1 | 2023-06-01 00:00:00 UTC | 2023-06-02 00:00:00 UTC | 0 | 0 | 0 |
| Jun 2 | 2023-06-02 00:00:00 UTC | 2023-06-03 00:00:00 UTC | 0 | 0 | 0 |
| Jun 3 | 2023-06-03 00:00:00 UTC | 2023-06-04 00:00:00 UTC | 0 | 0 | 0 |
| Jun 4 | 2023-06-04 00:00:00 UTC | 2023-06-05 00:00:00 UTC | 0 | 0 | 0 |
| Jun 5 | 2023-06-05 00:00:00 UTC | 2023-06-06 00:00:00 UTC | 0 | 0 | 0 |
| Jun 6 | 2023-06-06 00:00:00 UTC | 2023-06-07 00:00:00 UTC | 0 | 0 | 0 |
| Jun 7 | 2023-06-07 00:00:00 UTC | 2023-06-08 00:00:00 UTC | 0 | 0 | 0 |
| Jun 8 | 2023-06-08 00:00:00 UTC | 2023-06-09 00:00:00 UTC | 0 | 0 | 0 |
| Jun 9 | 2023-06-09 00:00:00 UTC | 2023-06-10 00:00:00 UTC | 0 | 0 | 0 |
| Jun 10 | 2023-06-10 00:00:00 UTC | 2023-06-11 00:00:00 UTC | 1 | 0 | 1 |
What Hacker News says
4 sourcesI got nervous that the API changes would be the end of Apollo, and thus largely the end of my Reddit use. So, I made a way to export all of my post and comment data into a searchable SQLite archive:
https://github.com/xavdid/reddit-user-to-sqlite/
It can pull your recent activity from the API, but also has support for pulling data from a GDPR archive (a feature I'm very proud of).
In Had a call with Reddit to discuss pricingIf anyone wants to export a pretty good version of all their reddit data, I wrote an exporter that dumps into SQLite: https://github.com/xavdid/reddit-user-to-sqlite/
It also supports the Reddit GDPR archive format, so you can fetch your whole history of comments/posts (which isn't possible to page via the API).
In Reddit's API ChangesShow HN: Build a SQLite satabase from your Reddit data
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]: htt