Category

PostgreSQL in Production

Explore our curated collection of articles, insights, and stories about PostgreSQL in Production.

4 Articles
How to get COUNT(*) in Supabase
PostgreSQL in Production
5 min read·2026-06-06

How to get COUNT(*) in Supabase

If you are fetching whole result sets just to count them, you are paying for bandwidth and latency you do not need. Supabase already returns counts in query metadata.

Read more
Return inserted row ID in Supabase JS
PostgreSQL in Production
5 min read·2026-06-06

Return inserted row ID in Supabase JS

If `data` is null after an insert, Supabase is doing exactly what the current docs say. You need to ask for the row back explicitly.

Read more
Create an enum column in Supabase – 2026 guide
PostgreSQL in Production
7 min read·2026-06-02

Create an enum column in Supabase – 2026 guide

Step‑by‑step guide to adding a PostgreSQL enum type and column in Supabase, including verification and common pitfalls.

Read more
Fix "permission denied for schema public" in Supabase
PostgreSQL in Production
7 min read·2026-06-02

Fix "permission denied for schema public" in Supabase

Learn the exact steps to grant the right permissions in Supabase and stop the 'permission denied for schema public' error from breaking your app.

Read more