News for hackers. Stuff that matters.
Re:How Figma's databases team lived to tell the scale by zarzavat on Thursday March 14, 2024 @06:48PM (#39709879)
Figma is more or less a desktop application that happens to run in a web browser.

If I use Photoshop to edit a .psd file I don’t think “man that psd file should really be stored in a single planet-sized database of all psd files in existence”. It’s just a file on my computer.

Figma requires a little bit more intermingling of data than Photoshop, it has multiuser support for one, so a pure local storage based approach wouldn’t work. But, at its heart it’s still based on the document model. When you open a Figma document it’s its own isolated little universe, the connections with resources outside the document are limited, and that matches user expectations.

Re:How Figma's databases team lived to tell the scale by joegibbs on Friday March 15, 2024 @05:42AM (#39713734)
Agreed - it's not like you'd ever have to do SELECT * FROM Shapes WHERE 'type' = 'circle'. Could they have stored each document as a file, stored references to the files in the database, opened the file in the backend when someone opened it in the frontend, and written it back when they've stopped editing it?