Cells

Idea: build a spreadsheet application closely on top of a database.

  • Every tab is just a table.
  • You get filtering, aggregation and such for free.
  • Columns have data types. Bonus points if data types can be dynamically defined using WebAssembly, which also containers methods to render them as HTML.
  • Columns can also be defined as formulas (written in a declarative/functional way).
  • You can further write scripts (typically in any language, for example Python). These need to be somewhat deterministic, and track what queries they perform to determine which input data they depend on.
  • You can define things like graphs as queries of the data. They update in real-time as the data changes.