DEV Community

Discussion on: PostgreSQL vs MongoDB

Collapse
 
miketalbot profile image
Mike Talbot ⭐

Relational for me, but with most data stored in JSON structures in it and projected out for indexing if necessary. Works well. Flexible data model. Fast joins. Piped to elastic for rapid cross searching. I use MySQL rather than PostgreSQL though. I like expressing queries as JSON in the front end and the node servers - but that's easily mapped to SQL and SQL is still there if it is hard to express some much more complicated principle.