Supabase — BlogDrop

SupabaseAug 1, 20266 readmid

Are Supabase docs agent-friendly? We didn't know, so we checked

Supabase implemented a framework to evaluate their documentation's effectiveness for AI coding agents by running automated agent-based tests against technical guides. By comparing agent outcomes against an independent checklist of security requirements rather than the documentation itself, the team identified structural improvements that benefit both AI agents and human developers. The findings suggest that clear, explicit technical writing remains the most effective strategy for ensuring both human comprehension and reliable agent execution.

AI summary

02

SupabaseMar 26, 20269 readmid

Navigating Regional Network Blocks

This article explores the technical and operational challenges multi-tenant infrastructure providers face when dealing with regional network and domain blocking. It details how ISPs and government entities enforce blocks and provides actionable strategies, such as Public Suffix List implementation and improved abuse reporting pipelines, to mitigate impact and maintain platform accessibility.

AI summary

03

SupabaseMay 8, 20254 readsenior

PostgreSQL Event Triggers without superuser access

This article explains how the supautils extension enables non-superuser roles to create event triggers in managed Postgres environments. By leveraging Postgres Utility and Function Manager hooks, the extension safely elevates privileges during creation and prevents privilege escalation by intercepting trigger execution for superuser or reserved roles.

AI summary

04

SupabaseJul 11, 20246 readmid

Simplifying Time-Based Queries with Range Columns

This article demonstrates how to use PostgreSQL range types to store temporal data, offering an alternative to traditional two-column approaches. It explains how to simplify overlapping event queries and enforce data integrity by using range-specific operators and exclusion constraints.

AI summary

05

SupabaseJun 26, 20247 readmid

Generate Vector Tiles with PostGIS

This article demonstrates how to ingest open geospatial data from the Overture Maps Foundation into a Supabase Postgres database. It covers the workflow of transforming GeoJSON into SQL via GDAL, utilizing PostGIS to generate vector tiles, and rendering that data on a map interface using MapLibre GL.

AI summary

06

SupabaseApr 11, 202423 readmid

Postgres Roles and Privileges

This article explores the PostgreSQL permission system, detailing the relationship between database objects, roles, and privileges. It provides a practical guide on managing access control, covering ownership, privilege inheritance, and the nuances of the public role and superuser permissions.

AI summary

07

SupabaseFeb 21, 20249 readmid

Automating performance tests

This article outlines a methodology for implementing automated performance testing for WebSocket-based services, specifically focusing on the migration of the Supabase Realtime service. It details the challenges of testing persistent connections, provides a comparison between HTTP and WebSocket testing requirements, and presents an infrastructure setup using k6, Terraform, and Prometheus.

AI summary

08

SupabaseOct 8, 20238 readmid

Offline-first React Native Apps with Expo, WatermelonDB, and Supabase

This article explores the implementation of an offline-first architecture in React Native using WatermelonDB for local storage and Supabase as the backend. It details the process of syncing local SQLite data with remote PostgreSQL storage using a 'last-write-wins' strategy and triggers, balancing improved UX with the trade-off of increased schema management complexity.

AI summary

09

SupabaseFeb 17, 20237 readmid

Type Constraints in 65 lines of SQL

This article demonstrates how to extend PostgreSQL's type system by creating a custom semantic versioning (SemVer) data type. It explains how to move beyond basic composite types by implementing domain-based validation constraints, custom comparison operators, and user-defined aggregate functions to improve data integrity.

AI summary

10

SupabaseJul 9, 20204 readmid

What are PostgreSQL Templates?

PostgreSQL databases are created by cloning a template database, typically template1. This article explains how to define custom template databases to propagate schemas and configurations to new databases without modifying default system templates.

AI summary