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.<p>These tools likely don't permit users to directly manipulate an actual database table. Therefore, I believe they adopt alternative approaches.<p>My hypothesis is that they might utilize NoSQL databases and treat each row as a discrete item.<p>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?<p>Furthermore, I suspect that performance might be severely degraded in such an architecture if the number of rows grows significantly.<p>Any thoughts?
There are some open source competitors to Airtable and Notion that can provide good insight. Check out <a href="https://github.com/kelseyhightower/nocode">https://github.com/kelseyhightower/nocode</a>