17 posts tagged with "database"

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.

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.

As a Django app grows, managing database queries effectively is crucial for maintainability, performance, and testability. Storing them haphazardly is a recipe for disaster. The best place to store your queries is on custom Model Managers and QuerySets. This approach keeps your logic organized, reusable, and closely tied to the data it operates on. Here are the main variants for storing your queries, from the least recommended to the best practice.