Settings

Theme

Show HN: Supabase-Test – Fast Isolated Postgres DBs for Testing Supabase RLS

npmjs.com

30 points by pyramation a month ago · 10 comments · 1 min read

Reader

Hi HN — we've built a testing framework for Supabase that spins up fast, isolated Postgres databases for each test case. It’s designed to make RLS policies easy to validate with real database state, without global test fixtures or mock auth.

Features: - Instant isolated Postgres DBs per test - Automatic rollback after each test - RLS-native testing with `.setContext()` for auth simulation - Flexible seeding (SQL, CSV, JSON, JS) - Works with Jest, Mocha, and any async test runner - CI-friendly (runs cleanly in GitHub Actions)

We also published example projects and a free set of tutorials: https://launchql.com/learn/supabase

Package: https://www.npmjs.com/package/supabase-test

Source + full test suite: https://github.com/launchql/supabase-test-suite

Happy to answer questions and get feedback, cheers :)

John23832 a month ago

This reminds me of a supabase testcontainers idea I explored.

dang a month ago

[under-the-rug stub]

[see https://news.ycombinator.com/item?id=45988611 for explanation]

Keyboard Shortcuts

j
Next item
k
Previous item
o / Enter
Open selected item
?
Show this help
Esc
Close modal / clear selection