⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠
Text Elements
Spreadsheet Design Ideas (Fullstack)
12
A
I
C
D
B
E
F
G
H
5
2
3
4
1
=$B1
Option 3:
- use nosql db to store each cell’s raw value.
- on blur, update the backend with the cell’s raw value.
- compute the evaluated value on the frontend.
- for the most part, these calculations should be easily handled by the browser, and will be much less load on the server, which can be freed up to handle concurrency.
Option 1:
- store raw value, computed value, and dependencies on the backend in a database.
- on blur of a field, pass the new value to the backend and compute new values.
- api returns new values and frontend updates. — will require lots of database updates, which is costly. +- very secure and consistent data.
Option 2:
- manage computed values on the frontend using a state management library that supports computed values/dependency relationships.
- store a serialized version of the sheet to the database on an interval or on save.
- option to store computed values or just raw values.