17 posts tagged with "supabase"

Supabase Pitfalls: Avoid These Common Mistakes for a Robust Backend​

Supabase offers a powerful open-source alternative to Firebase, built around PostgreSQL. Its ease of use makes it a favorite for rapid development, but this very convenience can lead developers down paths that introduce technical debt, performance bottlenecks, and security vulnerabilities. Understanding and avoiding these common pitfalls is crucial for building a robust and scalable application.

Supabase has minimal vendor lock-in by design because it's built on a foundation of popular open-source technologies, most notably PostgreSQL. This is a core part of their philosophy and a key differentiator from closed-source alternatives like Firebase. However, while minimal, some "stickiness" exists in their value-added services.

Supabase Integration with Django​

Here's a guide to integrating Supabase with a Django application. We will use the requests library to make API calls to Supabase, as there is no official Django-specific Supabase ORM.

Supabase Integration with FastAPI​

Here's a guide to integrating Supabase with a FastAPI application. We'll cover environment setup, connecting to Supabase, and performing basic CRUD operations.

Here's a simple example of how to integrate Supabase with a Flask application. This guide will cover how to set up the environment, connect to your Supabase project, and perform basic CRUD (Create, Read, Update, Delete) operations.

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.