DEV Community

Discussion on: Storing user customisations and settings. How do you do it?

Collapse
 
imthedeveloper profile image
ImTheDeveloper

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.