Supabase Slow Query Analysis: Find and Fix with pg_stat
The pgstatstatements extension in PostgreSQL is your go-to for uncovering performance bottlenecks, and Supabase leverages it beautifully.
Supabase Articles
49 articles
Supabase Storage Bucket Policies: Control File Access
Supabase Storage Bucket Policies are the gatekeepers for your files, and they're far more powerful than just "public" or "private.
Supabase Vector Search: Store and Query Embeddings
Supabase Vector Search lets you treat your text embeddings like any other structured data, making similarity search as straightforward as a SQL SELECT.
Supabase pgvector AI Search: Semantic Similarity Queries
Supabase's pgvector extension lets you do AI-powered semantic search directly in your PostgreSQL database, turning text into high-dimensional vectors an.
Supabase OAuth Providers: GitHub, Google, Discord Setup
The most surprising thing about Supabase OAuth providers is that they don't actually manage your users; they just authenticate them and give you a token.
Supabase Backup and Point-in-Time Restore
Supabase's backup and point-in-time restore PITR capabilities are often misunderstood as just a simple "download my database" feature.
Supabase Branching: Preview Environments Per PR
Supabase's branching feature lets you spin up a completely isolated, production-like environment for every pull request, so you can test changes without.
Supabase JS Client: Install and Configure for Web Apps
Supabase JS Client: Install and Configure for Web Apps The Supabase JS Client is your gateway to building full-stack applications with Supabase, letting.
Supabase Safe Concurrent Migrations: Avoid Lock Conflicts
Supabase migrations can deadlock each other if multiple instances try to apply changes simultaneously, leading to locknotavailable errors and halted dep.
Supabase PgBouncer Connection Pooling: Config and Tuning
Supabase PgBouncer connection pooling is a powerful tool that can dramatically improve your application's performance and scalability, but its configura.
Supabase pg_cron: Schedule Database Jobs
Supabase pg_cron: Schedule Database Jobs — practical guide covering supabase setup, configuration, and troubleshooting with real-world examples.
Supabase Custom Domain: Point Your Domain to Your Project
Supabase Custom Domain: Point Your Domain to Your Project. Adding a custom domain to your Supabase project means bypassing the default. supabase
Supabase Custom Email Templates: Brand Auth Emails
Supabase's email templating system lets you customize the emails your application sends for authentication, like password resets and email confirmations.
Supabase SQL Editor Tips: Boost Productivity in the Dashboard
The Supabase SQL Editor is more than just a place to run queries; it's a powerful, often underestimated, tool that can dramatically speed up your develo.
Supabase Database Testing with pgTAP: Unit Test SQL
Supabase Database Testing with pgTAP: Unit Test SQL. pgTAP’s plan function doesn't just declare how many tests you're running; it actually enforces it.
Supabase Database Webhooks: Trigger on Table Changes
Supabase Database Webhooks are fundamentally a pub-sub system where the "publisher" is your PostgreSQL database's logical replication stream and the "su.
Supabase Edge Functions: Deploy TypeScript on Deno
Supabase Edge Functions are Deno-based serverless functions that let you run TypeScript code close to your users, reducing latency and enabling real-tim.
Supabase Enum Type Migration: Add Values Without Downtime
Supabase's enum types are not directly mutable; adding new values requires a schema recreation, which typically means downtime.
Supabase Event Triggers: Audit Data Changes Automatically
Supabase's Realtime Engine can track and broadcast data changes, but event triggers give you a way to react to those changes before they're even committ.
Supabase with Fly.io and Cloudflare Workers: Edge Access
Supabase's Postgres database is actually a distributed system, and Fly. io's platform is designed to run that database close to your users
Supabase Foreign Data Wrapper: Query External Data Sources
Supabase's Foreign Data Wrapper FDW lets you query data from other PostgreSQL databases as if it were local, without ETL.
Supabase Free Tier Limitations: What Pauses and Throttles
Your project on Supabase's free tier can get paused or throttled, and it's not just about hitting arbitrary limits; it's how Supabase engineers the shar.
Supabase Database Functions and Triggers: Logic in Postgres
Supabase database functions and triggers let you inject imperative logic directly into your PostgreSQL database, making it a more active participant in .
Supabase Generated Columns: Computed Fields in Postgres
Supabase's generated columns are Postgres's way of making computed fields feel like first-class citizens, but they're actually just a clever application.
Supabase GraphQL with pg_graphql: Auto-Generate API
Supabase's GraphQL API, powered by pggraphql, doesn't just reflect your database schema; it actively generates your API based on it, and it's far more d.
Supabase Index Optimization: Speed Up Slow Queries
Supabase's query optimizer is surprisingly bad at automatically creating indexes for your tables, leaving you to do the heavy lifting.
Supabase Log Drain: Ship Logs to External Analytics
Supabase's log drain feature lets you send your application logs to external analytics platforms, transforming raw output into actionable insights.
Supabase MFA TOTP Setup: Two-Factor Auth for Your App
The most surprising thing about Supabase's TOTP MFA is that it doesn't actually generate the TOTP secrets itself; it relies on the client-side to do the.
Migrate from Firebase to Supabase: Auth, DB, Storage
Supabase Auth is fundamentally a PostgreSQL database with a set of pre-built roles and row-level security RLS policies that manage user authentication a.
Supabase Multi-Tenancy with Postgres Schemas
Supabase's multi-tenancy solution, leveraging Postgres schemas, is surprisingly more about isolating data than isolating users.
Supabase Postgres Performance Tuning: Key Settings
Supabase Postgres performance is less about discovering hidden knobs and more about understanding how Postgres itself is designed to share resources, an.
Supabase Postgres Config Tuning: Memory and Connections
Supabase Postgres config tuning often boils down to understanding that sharedbuffers and maxconnections aren't independent knobs, but rather a delicate .
Supabase Postgres Extensions: Enable pgcrypto, uuid-ossp
Supabase Postgres extensions are just PostgreSQL extensions, but they're managed by Supabase. This is how you enable pgcrypto and uuid-ossp in your Supa.
Supabase PostgREST API Filters: Query with URL Parameters
PostgREST doesn't just serve your data; it lets you query it with incredible flexibility using standard URL parameters, turning your database tables int.
Supabase Pro Plan: Database Size and Compute Options
Supabase Pro plan's "database size" isn't just about how much data you store; it's a proxy for the underlying compute resources allocated to your Postgr.
Supabase Project Pause and Resume: Free Tier Behavior
The free tier of Supabase projects doesn't just "pause" when inactive; it gets deleted after a period of inactivity, and you have to recreate it, not re.
Supabase API Rate Limiting: Protect Your Endpoints
Supabase doesn't actually have a built-in, user-configurable API rate limiter. Let's see what happens when you hammer a Supabase endpoint
Supabase Read Replicas: Scale Read-Heavy Workloads
Supabase read replicas don't actually make your database faster for reads; they make your application more available during read-heavy periods by offloa.
Supabase Logical Replication Slots: Stream Changes Out
Supabase logical replication slots aren't just for streaming changes out; they're the system's conscience, remembering every transaction that ever happe.
Supabase RLS Policy Examples: Auth, Roles, Ownership
Row Level Security RLS in Supabase isn't just about SELECT FROM users WHERE id = auth. uid; it's a fundamental architectural shift that lets you define .
Supabase Row Level Security: Enforce Access at the Row Level
Supabase's Row Level Security RLS is often misunderstood as just a simple WHERE clause on steroids, but its real power lies in its ability to make decis.
Supabase S3-Compatible Storage: Access via AWS SDK
Supabase Storage is actually a thin wrapper around a cloud object store, typically AWS S3, but it can also be S3-compatible storage like MinIO.
Supabase CLI Migrations: Manage Schema Changes
Supabase CLI migrations are not just a way to track schema changes; they are the single source of truth for your database's evolution, fundamentally dic.
Self-Host Supabase with Docker: Full Stack Setup
Supabase, the open-source Firebase alternative, is surprisingly easy to self-host with Docker, letting you ditch vendor lock-in and gain complete contro.
Supabase with Next.js SSR: Auth and Data Fetching
Supabase with Next.js SSR: Auth and Data Fetching — Supabase with Next.js SSR: Auth and Data Fetching The most surprising thing about Supabase with Next.
Supabase Service Role vs Anon Key: When to Use Each
The Supabase anon key is designed for client-side applications, but the service role key is the real power user for backend operations.
Supabase API Type Generation: Auto-Generate TypeScript Types
Supabase's automatic TypeScript generation for your API types is less about magic and more about disciplined schema definition.
Supabase Audit Logging with pg_audit: Track Every Query
Supabase audit logging with pgaudit is less about tracking every query and more about selectively capturing specific types of changes to your database.
Supabase Auth JWT Configuration: Custom Claims and Secrets
Supabase Auth's JWTs are signed, not encrypted, meaning anyone can read their contents, but only those with the secret can create valid ones.