Project Revamp

[JeffThorslund]

A few things should happen to get this back up to speed.

1. The project, hosted on Supabase, was paused for some reason, possibly inactivity. I'll need to figure out why this happened and update configuration.
2. The data is outdated and stale. This probably involves going through to every website and double checking the website. There is not interface for editing on the website, so editing the prod database is what we'll have to do. Any ideas on keeping this data updated without manual intervention?
3. UI pain points or suggestions?

[travisvn]

Hey @JeffThorslund, I've actually put together an open-source solution to prevent Supabase from pausing projects

Supabase Inactive Fix

• This one's written in Python and is the most efficient

Supabase Pause Prevention

• This one's designed primarily for Next.js projects, particularly ones deployed to Vercel but can be adapted quickly to any Node.js-based project
• (it's written for the Next.js App Directory's API setup. So, since you're using the pages directory, you would either want to upgrade your Next.js verison and add the /app/api/ routes or stick with the Python version)

Both are easy solutions for having a cron job run to perform small database operation(s) to keep the Supabase project you have active.

They're the exact fix for what you're looking for with this issue.

Let me know if you have any questions—I'd be happy to help.