Native Postgres, PGlite, or In-Memory? Choosing a Postgres Engine for Local Supabase Development

"Run Postgres locally" used to mean one thing: install Postgres, or start it in Docker. Now there are at least three very different options, and each one is good at a different job: Native Postgres: