News for hackers. Stuff that matters.

A comment on Why Has Figma Reinvented the Wheel with PostgreSQL?. Parent comment

Re:Why Has Figma Reinvented the Wheel with PostgreSQL? by gedy on Saturday March 30, 2024 @11:56AM (#39876047)
> why not a dedicated database for every customer

Well there's trade-offs with this too, whether needing aggregate data across shards for features, reporting, etc. Shared data between customers, users, etc. API access, etc.

[ Parent | on HN ]
Re:Why Has Figma Reinvented the Wheel with PostgreSQL? by giva on Saturday March 30, 2024 @04:07PM (#39878153)
Sure there are trade offs. If a significant part of the value of the app rely on data sharing or transactions between customers this is clearly unfeasible. But if the app mostly deals with a significant amount of private data of the customers that occasionally needs to be shared, I think using separate databases (not servers) is the safest option.
[ Parent | on HN ]