top | item 31311405

(no title)

_jhqp | 3 years ago

> data is effectively modelled in a nosql style.

What do you mean by this? Any references I could read?

discuss

potamic|3 years ago

You can probably search around for references on distributed data management. But basically, when your data is split across different instances, you can no longer do joins or transactions or rely on the database for acid guarantees. All these things must instead be handled in code which is exactly how you would work with data using a nosql database as well.

ceras|3 years ago

This might help: https://microservices.io/patterns/data/database-per-service....

Varies by actual DB but: with this architecture, if the DBs are NoSQL then you didn't lose as much by splitting up the databases, but if they were SQL then among other things you lose transactions across those DBs (or now need costly distributed transactions), effectively making the collective SQL system behave more like a NoSQL DB.

DeathArrow|3 years ago

I think he means the data is not relational anymore and it is not normalized.

tremon|3 years ago

Probably means that the data isn't modelled at all, just a dump of the application architecture.