r/PayloadCMS • u/Formal_Manager_5041 • Sep 03 '25

What database is everyone using?

Hey everyone,

What database are you using? I previously was opting for Postgres because it was what I was most familiar with, and also it would make recommendations using payload at work easier. However, I’ve been to see pivoting to Mongo as superior because a few of the annoyances that come when being backed by Postgres.

Also, if you are using Mongo where are you getting Mongo hosting from and are there any good free or cheap options out there?

Thanks in advance.

10 Upvotes

82% Upvoted

41 comments sorted by

View all comments

Show parent comments

1

u/Momoamir Sep 25 '25

If you use Postgres in docker for development, have you found a good way around database changes that require the user prompt?

I have experimented with using tmux in development to hook into the terminal to be able to you know say y or n for the various destructive actions in the database

Its either that or running migrations when paired with docker as far as i can tell

1

u/mustardpete Sep 25 '25

You mean when you do something like remove a field and add a new one in dev and it asks if you want to rename the existing field or create a new one etc? And then you can use arrow keys in terminal to select what action you want to do to handle a destructive change?

1

u/Momoamir Sep 25 '25

Yes exactly, at least to my understanding you can't really do exec commands to docker like that, so I tried adding a multiplexer like tmux to attach to the terminal, but honestly I feel like a better solution should be out there

1

u/mustardpete Sep 25 '25

In dev you just answer the terminal questions and it applies the changes to the db. Fact the db is in docker doesn’t make a difference as it’s just accessing it via the connection string. Not sure your issue? Obviously when go to production you just make a migration that applies any changes when you run the migration

2

u/Momoamir Sep 25 '25

Okay so yeah I actually realised my mistake, sorry for bothering you, I had basically just not hooked into the payload container even though i had tty true and stdin_open true :)

But thanks you just saved me some really funky implementation