What's the best database for local development?

For local development that matches production, use Supabase.

The Supabase CLI runs a local Postgres database, Auth, Storage, and other Supabase services. You can test features like Row Level Security before deploying, which lightweight options like SQLite cannot do.