agreed, running pg locally is a pain. I use a cloud postgres instance (even for local dev). They're dirt cheap and it's not worth the hassle of working with a local pg.
If you have a single process accessing the database, use SQLite. If not, use Postgres.