Ask HN: How Airtable / Notion's Database is implemented?

1 pointsh_mirin2y ago2 comments

Both Airtable and Notion, along with numerous no-code tools, create their own interpretations of "tables". In these tables, you can define inter-table relationships, make columns unique, and so forth, much like real tables.

These tools likely don't permit users to directly manipulate an actual database table. Therefore, I believe they adopt alternative approaches.

My hypothesis is that they might utilize NoSQL databases and treat each row as a discrete item.

However, ensuring reference consistency without using real table features might be very challenging. Some tools offer a "calculated column" feature, which stores the results of complex functions that take the results of referenced tables as input. Caching and data change notifications might do the job, but is it really feasible?

Furthermore, I suspect that performance might be severely degraded in such an architecture if the number of rows grows significantly.

Any thoughts?

2 comments

collinc7772y ago

There are some open source competitors to Airtable and Notion that can provide good insight. Check out https://github.com/kelseyhightower/nocode

h_mirinOP2y ago

The link you provided seems to be a joke repo! However, your idea to look into the open source alternative implementations is indeed insightful. I'll take a look at them. Thanks.

j / k navigate · click thread line to collapse