In 2 minutes, you will sync all your Airtable data to a Postgres database and can begin building on it with SQL or your favorite ORM
psql
command to connect to your database via the Proxy.
Step 2: Open your terminal, and paste the psql
command. Press Enter. This will open a connection to your database so you can write your first query:
\dt
:
_sync
tables which Sequin uses to manage your sync.
Step 4: Now, write your first query. You can start with a simple select
to get your bearings:
id
, product_name
, and price
of one of the product inventory records for the next step:
id
in the last step of this setup guide.
insert
, update
, or delete
rows in your Postgres database.
When you’re connected to your database through the Sequin Proxy, the Proxy listens for changes. When you make a mutation, the Proxy applies the mutation to Airtable’s API first. If the mutation succeeds, your database is updated as well. If it fails, your database mutation will be rolled back, and you’ll receive a Postgres error.
In this example, you’ll update the product_inventory
in the prior step by giving them a new first and last name:
psql
and check the product_inventory you just updated: