We use tracking cookies to understand how you use the product and help us improve it. For more information on how we store cookies, read our  privacy policy.

Overview

Learn Supabase’s role in Plainform and the initialization of the Supabase client for database interactions.

Supabase powers Plainform database with a PostgreSQL instance, accessible via a pre-configured Supabase client initialized in the lib folder. This client simplifies interactions with your database, supporting queries, authentication, and storage, with environment variables validated by t3-env to ensure a secure and reliable setup.

By leveraging Supabase’s client, you can quickly integrate data-driven features into your Next.js application while maintaining compatibility with Prisma for type-safe database operations.

It supports:

  • Database Queries: Perform CRUD operations on your Supabase PostgreSQL tables, such as fetching or updating user data.
  • Authentication: (Optional) Manage user sign-ups, logins, and sessions, complementing or replacing Clerk if needed.
  • File Storage: (Optional) Upload and manage files in Supabase storage buckets, ideal for assets like user avatars or documents.
  • Real-Time Subscriptions: (Optional) Enable real-time data updates for features like live notifications or collaborative apps.
  • Row-Level Security: (Optional) Apply fine-grained access control to restrict data access based on user roles.

How is this guide ?

Last updated on