Joonas' blog

Posts tagged postgres

Next.js + Supabase app in production: what would I do differently

My learnings for building a Next.js and Supabase app and keeping it running in production

PostgREST/Supabase: joins and join conditions

A look at how postgREST does joins and the gotchas involved

PostgREST datetime operators

Quick reference to PostgREST operator behavior with datetime columns

Creating a Postgres function for a Supabase RLS policy

Postgres function templates that move repeated access checks out of your Supabase RLS policies, starting with a join table membership check.

PostGIS marker culling

Implementing low-priority marker culling for PostGIS queries

All posts