And Then Some

Reddit only caches 1000 saved posts+comments. This is a problem if you keep saving posts and want to view your oldest ones.

The name for this project is named "And Then Some", because it has the ability to retrieve all your Reddit posts, and then some, because it can retrieve any updates as well.

Pushes or merges to master branch will initiate github actions.

Docker

Docker build command:

docker build $(pwd) --tag n30w/andthensome:latest --label n30w/andthensome:latest

Docker run command:

docker run --env-file=env_vars --publish 4000:4000 andthensome

Notes

• Use make bin to create a binary, or make run to run it.

Migration from MySQL

As of March 29, 2024, I have migrated from Planetscale's MySQL database to NeonDB's Postgresql database. Planetscale had discontinued their free tier on April 8, 2024. I used this guide to migrate to Neon: Migrate from MySQL to Neon. The guide uses pgloader.

There's also this online tool that converts MySQL statements to Postgresql ones. Pretty sure one could use ChatGPT as well.

TODO

• Store reddit credentials in .env file
• SQL Comparison function
• Setup webserver
• Use a docker container for API calls
• Deletion function for SQL db
• Implement Go Routines and channels for faster performance (blazingly fast you could say)
• Switch to Taskfile.dev
• Benchmark Tests for receiving data

Links

• Multiarchitecture Build With GitHub Actions Docker
• Docker Building Multi-platform Images
• How to get more JSON Results
• SQL Go Create Table Insert Row
• Go Docker Tutorial
• SQL Getting Unique Names when IDS are different
• Learn Git Basics