Personally, I had a really easy time getting Supabase to work locally. However, we use `dbmate` to manage our migrations instead of built-in Supabase migrations.

Also curious to hear from others on this:

> After a bit of sleuthing, it ended up that Supabase was taking a database backup that took the database fully offline every night, at midnight.

This seems like a terrible design decision if true. Why not just backup via physical or logical replication?

And totally hear the issues here with database resizing and vacuuming and other operations. That stuff is a big pain when it breaks.