>> agreed, running pg locally is a pain

If you have a single process accessing the database, use SQLite. If not, use Postgres.