Re:FerretDB, a truly open-source MongoDB alternative
by Zababa on Wednesday April 12, 2023 @06:43PM
(#35548070)
I'm curious about what makes document databases a good fit for e-commerce. I've never worked in that industry.
[ Parent
| on HN ]
Re:FerretDB, a truly open-source MongoDB alternative
by tylerchurch on Thursday April 13, 2023 @01:49AM
(#35551519)
Two things off the top of my head:
1. Denormalized data is often a boon. One of your key use cases is "give me all the information about this Product so I can show it to the user." Forget joining a ton of tables, just do 1 read of 1 product and go on your way.
2. A certain amount of more freeform data is expected. Different product categories will have different sets of information. T-shirts and drinkware both have sizes, but these sizes have nothing to do with each other. You can model all this in a traditional SQL database, but you have to stop and think really hard about it, and potentially end up with a plethora of tables. In a document database, it's much easier to just add the data and go on your way.