I dropped postgres for sqlite and never looked back - incredibly easy to manage and spin up applications like https://github.com/authcompanion/authcompanion2

This post sold me on it https://blog.wesleyac.com/posts/consider-sqlite