![]() To make this guide more interesting, imagine you are helping a small business owner grow their business. Wait.a growing small business needs your help? In a couple minutes you'll get the hang of Postgres Arrays and never look at Airtable the same way. ![]() These might not be as familiar to you, but arrays are first-class in Postgres. With Sequin, these field types will all end up in Postgres as arrays. Many field types in Airtable can contain multiple values: attachments, multiple select, lookups, and collaborators. ![]() (The new image is simply another value in the array.) So when a new image pops into the Products table, your Postgres table can support it immediately, without migrations or changes to existing queries. To reflect this flexibility, when Airtable data is pulled into Postgres via Sequin, that data is often represented as Postgres Arrays. But what happens later when I decide to keep more than one image per product? I just drag another image into the row! No need to migrate the column or my previous images. It's great.įor example, let's say I have a Products table with a column that contains the product's image. Thanks to Airtable's friendly UI, I can add new tables, new columns, or change the format of a column at will. Airtable and Postgres ArraysĪirtable's power lies in its flexibility. Then, you'll unlock your Airtable data with some killer PostgreSQL array methods. In this guide, you'll first replicate Airtable to Postgres using Sequin. While Airtable looks and feels like a database, you can't query it like a database.
0 Comments
Leave a Reply. |