[mritchie712]

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.

[counttheforks]

What OS are you on? Running postgres on Linux is as trivial as it gets, and for Windows they have a nice installer. Or just use docker.

[collyw]

Does the docker have users set up? I seem to remember that being a pain point in the initial setup.

[jacquesc]

I love Postgres.app on mac, makes running locally a breeze. Running Postgres fast on the cloud is what I always struggled with (without paying enormous sums)

[osigurdson]

>> agreed, running pg locally is a pain

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

[kikowi]

which cloud do you use for local dev?

[mritchie712]

aws, gcp, digital ocean and supabase all have pretty good free tiers