{"repo":"travisvn/supabase-pause-prevention","free":true,"listed":false,"github":"https://github.com/travisvn/supabase-pause-prevention","clone":"git clone https://github.com/travisvn/supabase-pause-prevention.git","description":"Prevent Supabase projects from getting paused due to inactivity","language":"TypeScript","stars":178,"topics":["nextjs","supabase","vercel","free","javascript","next","react","reactjs","typescript","startup"],"license":"MIT","category":"databases-storage","readme_excerpt":"Supabase Pause Prevention ⏸️ 🛑 Stop Supabase projects from pausing due to inactivity! :raised hands: On the free-tier plan, projects that are inactive for more than 7 days are paused. Please star ⭐️ if you find this useful [!TIP] NEW & IMPROVED VERSION written in Python available at supabase-inactive-fix repo Solution / How it works - Creating a cron job (scheduled task) that makes a simple database call - (This keeps your Supabase project active) - Fetching keep-alive.ts API endpoints for the other projects, as Vercel limits free-tier users to one cron job. Getting Started Super simple to add to your existing Supabase project! Configure your main project Only 3 files matter - /app/api/keep-alive/route.ts - API endpoint the cron job will execute - /app/api/keep-alive/helper.ts - Helper functions called from route.ts - /config/keep-alive-config.ts - Configuration for your setup - /vercel.json - Directs Vercel to periodically run the keep-alive endpoint utils/supabase folder contains files provided in the Supabase docs for the Next.js Web App demo — Supabase Everything else is boilerplate from Next.js create-next-app Configuring your other Supabase projects After selecting your primary project (the one that implements the code provided in this repository) , you'll want to add an API endpoint to your other Supabase projects The only requirement is that this endpoint is reachable and makes a call to your Supabase database [!NOTE] API endpoint must make database call Ensure the s","default_branch":null,"files":null,"tree":[],"storefront":"/r/travisvn","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/travisvn/supabase-pause-prevention/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}