Settings table is very wide right now but I'll be converting it over to a few columns of jsonb in postgres.
Running 2 databases really wasn't an issue but I found myself often wanting to join data across both e.g. is setting A turned on and therefore I need some data from table B.
I decided to move everything off mongo once j got myself used to using JSON in postgres. I use the citus extension to scale horizontally as needed.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Would love to hear your thoughts 2 years later - how did it go?
Thinking of Postgres + JSON most myself in a similar situation.
// Nvm, read the comments
Ended up with everything in postgres.
Settings table is very wide right now but I'll be converting it over to a few columns of jsonb in postgres.
Running 2 databases really wasn't an issue but I found myself often wanting to join data across both e.g. is setting A turned on and therefore I need some data from table B.
I decided to move everything off mongo once j got myself used to using JSON in postgres. I use the citus extension to scale horizontally as needed.