22 posts tagged with "database"

Custom Postgres Roles and RLS in Supabase​

Yes, you can define your own custom PostgreSQL roles and use them with RLS in Supabase. This is a powerful feature for implementing sophisticated Role-Based Access Control (RBAC) [1, 2].

The key is to understand that Supabase's built-in auth.uid() function and authenticated role are tied to the user's session. To use custom roles, you need to store this role information and make it accessible to your RLS policies.

There is minimal vendor lock-in with Supabase. The platform is designed to be as open as possible, leveraging established, open-source technologies. This makes it relatively easy to migrate away from their managed service if needed.

Supabase is built on a standard PostgreSQL database, giving you the flexibility to interact with it using various tools and methods. This guide explores how to integrate with Supabase, extend its functionality, and choose the right method for different tasks.

How to Monitor Slow Queries in Supabase​

Supabase provides powerful, built-in tools to help you identify and diagnose slow queries. The key is to leverage the pg_stat_statements extension, which is enabled by default on all Supabase projects [1, 4].

Building robust applications requires more than just a functional database; it requires a disciplined approach to managing changes, testing, and deployment. This guide will focus on the DevOps side of Supabase, explaining how to handle database migrations, integrate with CI/CD pipelines, and manage test data.

Here are detailed answers and a guide on how Supabase's Real-time, Auth, and RLS policies work together to secure your application.

The Advanced Supabase Guide: Database Features, Multi-Tenancy, and Scalability​

This guide delves into the advanced functionality of Supabase, exploring database features, security, and best practices for building robust, scalable applications.

An In-Depth Guide to Supabase: Architecture, Scalability, and Production Readiness​

As a developer, choosing a backend platform is a critical decision that impacts everything from data modeling to scalability and security. Supabase, the open-source Firebase alternative, has gained significant traction. This guide will provide an in-depth analysis of Supabase, answering key questions about its architecture, scalability, and suitability for production applications.

Answering the frontend-focused Supabase database questions.

Supabase is a Backend-as-a-Service (BaaS) platform that is almost entirely open source, which provides flexibility for developers. While their hosted service is what most people use, you have the freedom to self-host the entire stack. This open-source nature is a key differentiator when comparing it to other solutions like a custom stack with Hasura.