Dec 02, 2022 12:03 PM - edited Dec 02, 2022 12:42 PM
MySQL or PostgreSQL or MongoDB or some KV Database? (include table fileds and view and record)
SQL or NoSQL?
And what is the structure of the table of database?
Dec 02, 2022 02:33 PM
Are you asking how Airtable stores its underlying data? Airtable has not published that information, and I doubt that it is any of those you listed. And even if they did, you cannot use any of those tools to work directly with Airtable data.
You cannot use SQL directly with an Airtable base. However, Airtable is a relational database. It just has its own unique way of dealing with relationships—via linked record fields. Even though you cannot use SQL, I wouldn’t call it a NoSQL platform.
The structure of a table in Airtable is what you define it to be, including its fields, views, and permission settings. And view settings covers a huge amount of features.
Dec 02, 2022 02:52 PM
Here's an article about Airtable's migration from MySQL 5.6 to 8.0: https://medium.com/airtable-eng/migrating-airtable-to-mysql-8-0-809f0398a493
Dec 02, 2022 02:59 PM
Dec 02, 2022 11:35 PM
Is it true that if I create a sheet in the project, it will create a real data table in the database accordingly?
So there will be tens of millions of data tables in database?
It is better to abstract the data and put it into few tables (Associated by some fields)?
Dec 04, 2022 12:27 PM
>>> It is better to abstract the data and put it into few tables (Associated by some fields)?
No. It is better to just use Airtable without the need to consider the underlying storage architecture. Airtable is designed for people who have no time or skills to ponder such questions. If you believe you are going to somehow alter or enhance Airtable's behaviour based on such deeper knowledge, you are probably going to be disappointed.
>>> So there will be tens of millions of data tables in database?
Even if that were the case, why would you care?
At the outset, it's very unlikely that Airtable comingles data from customer (a) with customer (b) because meeting certain security compliance certifications would rule that out. I'm almost certain your data is not stored in a common tenancy architecture. Furthermore, since there is good evidence that the various service levels exist, there's likely a container architecture running with your instance of Airtable and data storage.