menu
techminis

A naukri.com initiative

google-web-stories
Home

>

Devops News

>

How to Pre...
source image

Dev

1M

read

299

img
dot

Image Credit: Dev

How to Prevent Your Supabase Project Database from Being Paused Using GitHub Actions

  • Supabase pauses databases after inactivity but you can prevent it with automated pings via GitHub Actions.
  • GitHub Actions workflow can keep your Supabase database active and prevent pausing.
  • Supabase pauses databases to save resources, common in free-tier plans.
  • Automate database pings with GitHub Actions to keep your database active.
  • GitHub Actions workflow provided to ping Supabase database at intervals.
  • Workflow triggers ping every Monday and Thursday at 9:00 AM UTC.
  • Set up environment variables like SUPABASE_URL and SUPABASE_KEY for the workflow.
  • Pinging Supabase involves querying a table to maintain database activity.
  • Customize the workflow schedule and table name to suit your needs.
  • Benefits include keeping the database active, automated workflow, and cost-effectiveness.

Read Full Article

like

18 Likes

For uninterrupted reading, download the app