Joonas' blog

Posts tagged supabase

Security Testing Supabase PostgREST

Some common enumeration, recon and exfiltration methods for Supabase

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

Migrating to PKCE-compatible generateLink in Supabase

auth-helpers-nextjs 0.7.0 made PKCE the default and broke generateLink. What changed, and the route handler that fixes it.

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

Implement user impersonation in Supabase

Let admins log in as any user in a Next.js and Supabase app, with the code to start and stop impersonation.

Generating Supabase JWT/access token manually

How to manually generate JWT tokens to use Supabase services as any user

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.

All posts