Environment Management & CI/CD

When building applications, it's crucial to manage different stages of development. These stages are called environments.

Typically, you'll work with three main environments:

• Development (Dev): Where developers write and test new features.
• Staging: A pre-production environment for testing by QA or stakeholders.
• Production (Prod): The live application used by your end-users.

Each environment helps isolate changes and prevent issues in the live app.

For effective environment management, it's best practice to have separate Supabase projects for each major environment.

This means you'd have:

• One Supabase project for your development database, auth, storage.
• Another Supabase project for staging.
• A final, distinct Supabase project for production.

This isolation prevents accidental data loss or breaking changes from affecting your live application.

Each environment often requires different configurations, such as database connection strings, API keys, or external service URLs.

These sensitive details should never be hardcoded directly into your application's source code.

Instead, we use environment variables. These variables are loaded at runtime and provide the necessary configuration specific to the environment your application is running in.

During local development, you'll often use a .env file to manage your environment variables. This file stores key-value pairs specific to your local setup.

Tools like the Supabase client libraries can automatically load these variables, making it easy to switch between local and deployed environments.

Remember to add .env to your .gitignore to prevent accidentally committing sensitive information!

CI/CD stands for Continuous Integration and Continuous Deployment (or Delivery). It's a set of practices that automate the building, testing, and deployment of software.

For Supabase, CI/CD helps you:

• Automatically apply database schema changes.
• Deploy Edge Functions.
• Ensure consistent deployments across environments.

This automation reduces manual errors and speeds up your development cycle.

As your application evolves, your database schema will change. Database migrations are version-controlled scripts that track and apply these changes.

The Supabase CLI provides powerful tools for managing migrations:

• supabase migration new <name>: Creates a new migration file.
• supabase db diff: Generates a migration script by comparing your local schema to your Supabase project.
• supabase db push: Applies local migrations to your Supabase project.

These commands are essential for safely evolving your database schema.

A typical CI/CD pipeline for a Supabase project might involve these steps:

• Build: Compile your application code (e.g., client-side app, Edge Functions).
• Test: Run unit and integration tests against a development or staging Supabase project.
• Deploy Schema: Apply pending database migrations to the target Supabase project.
• Deploy Functions: Deploy updated Supabase Edge Functions.
• Deploy Application: Deploy your client-side application (e.g., to Vercel, Netlify).

Each step ensures your changes are validated before reaching production.

You can use CI/CD platforms like GitHub Actions, GitLab CI, or CircleCI to automate these steps. For Supabase, a common task is to automate database migrations.

Here's a conceptual snippet of a GitHub Actions step that could apply migrations to a Supabase project. It uses the Supabase CLI and environment variables for authentication.

Which of the following are good practices when managing Supabase projects across different environments?

In this lesson, we explored how to effectively manage different environments (development, staging, production) for your Supabase projects. We also introduced the power of CI/CD.

• Separate Projects: Essential for isolating environments.
• Environment Variables: Securely manage configuration.
• Supabase CLI Migrations: Automate database schema changes.
• CI/CD: Streamline deployments and reduce errors.

By adopting these practices, you can build more robust, secure, and scalable applications with Supabase.