January 4, 2022

Select which tables to sync from any source

Automatic name translation with the Airtable proxy

When you are writing through our Airtable proxy, we can now translate table and column names from the Postgres snake_case to the Airtable name the API expects. This means that throughout your code, you'll be able to consistently reference Airtable fields using the name format in your database.

To use this feature, just send along the header sequin-translate: 1.

We hope this makes your code more readable, testable, and easier to write. You can learn more in our docs.

Fixes and improvements

  • Improved the user experience when selecting which tables to sync from Stripe by adding grouping.
  • Improved Airtable syncs. Some larger Airtable syncs received a 30-40 second speed-up.

December 21, 2021

Select which tables to sync from any source

Choose which tables to sync

You can now pick and choose which tables from a source sync to your database. Often, you only need a couple tables syncing to your database to start building the features your customers need. So instead of syncing all the tables from a source, you can now select just the tables you need. At any time, you can change which tables you are syncing. In the future, when you need more data from a source, you can simply edit your sync and we'll handle the rest.

Fixes and improvements

  • Added sub-account support for Twilio. You'll now find that all the data for sub-accounts is syncing to your database in real-time along with a new accounts table.
  • Added support for the /alerts endpoint to Twilio.
  • Added support for Shopify variant metadata.
  • Improved the in-app docs to dynamically show your sync's specific /wait endpoint URL.
  • Improved the look, feel, and copy of our landing page.

December 7, 2021

Fixes and improvements

  • Added support for versioning databases. This means we can make changes or upgrades to how we sync from APIs without affecting existing database schemas.
  • Add support for client-side SSL certificates. Learn more in our docs.
  • Added documentation for the /wait endpoint.
  • Added documentation for working with permissions, non-synced tables, and views.
  • Added support for Stripe restricted API keys.
  • Improved the self-hosted database provisioning flow by adding Sequin's whitelist IP addresses.
  • Improved the API credential experience. You can now select your credentials from a clean list of previously validated keys.
  • Fixed an issue that caused non-synced tables in a schema to drop.
  • Fixed an issue in the Sequin console so that only synced tables are displayed.
  • Fixed an issue that caused all statuses in the console to errantly glow red.

October 26, 2021

Fixes and improvements

  • Published a blog post on how to use PG_NOTIFY to handle events with Twilio syncs.
  • Added support for using Airtable table_id and field_id as Postgres table and columns names. Using this setting will make your database less readable directly, but will mean that code connected to your database will be resilient to table/field name changes. Send us a note for early access.
  • User experience improvements and bug fixes when connecting a self-hosted database.
  • Improved the organization of our docs by listing playbooks alongside their associated source.
  • Fixed issues with connecting to Stripe using OAuth.

October 12, 2021

Fixes and improvements

  • Published a tutorial on how to use Twilio syncs with Retool
  • Published a blog post about how we dog food our Stripe sync
  • Fixed login and sign-up jitters in the header
  • Improved the self-checkout page
  • Improved our landing page copy and images
  • Improved the /wait endpoint by dropping the kind parameter
  • Introduced graduated pricing for Airtable syncs

September 28, 2021

Twilio as a new Sequin source

Sync Twilio

Twilio is now ready for syncing! We'll sync messages, phone calls, and recordings right to your production database. Integrate faster by using SQL or your favorite ORM to work with all your conversation data. Learn more in our docs.

User management

You can build faster when everyone on your dev team has a Sequin account. Team members can set up new syncs (eg., developer databases), edit existing syncs, or pull up credentials for their database or /wait endpoint. We've supported teams since we launched, you just needed to ask us to merge your team together into the same organization. Now, you can do this all on your own! Just click on the "Users" tab and you can invite and manage the users on your team.

Fixes and improvements

  • Added support for Stripe OAuth
  • Added self-checkout
  • Added ORMs and the /wait endpoint to the connect modal
  • Added ORMs, self-hosted databases, and the /wait endpoint to our docs
  • Added platform specific sources pages to the website
  • Improved the sign-up survey
  • Improved the experience for setting up self-hosted databases

September 14, 2021

Shopify as a new Sequin source

The /wait Endpoint

With the /wait endpoint, we're completing the write story for new sources like Stripe, Close, and Shopify. (Airtable already supports writes via our special Airtable proxy.)

We advocate for a one-way data flow: data flows from the upstream platform to your Sequin database. You read from your database, but write changes back to the upstream API. Those write changes you made will flow down to your Sequin database for you to read again.

Sometimes, you want your code to read from your database right after making a change via the API. But there's a race condition: it can take a second or two for that change to propagate to your database.

So, to ensure a recent write – like a new Shopify order – has been synced to your database, you'll call our /wait endpoint. /wait returns a 200 ok only after we've confirmed that your database is up-to-date and in-sync with Shopify.

Close is generally available

Close is now generally available as a new source! Sync all your leads, contacts, and opportunities right to your production database.

Fixes and improvements

  • Added support for Airtable thumbnails.
  • Added a real-time backfill progress indicator for new syncs.
  • Added a trial duration banner to the console.
  • Added automated trial expiration notifications.
  • Added an option to halt syncs when an associated view has a conflict.
  • Improved the sources section of our website.
  • Improved navigation in our docs.
  • Switched to flat rate pricing with 14-day trial period.

August 31, 2021

Shopify as a new Sequin source

Shopify and Close integration

Our support for Shopify and Close is in closed alpha! If you'd like early access, send us a note. They'll be public soon.

With our Shopify sync, all your customers, products, and orders replicate to Postgres in real-time. Build new front-ends, internal tools, and more on your Shopify data using SQL or your favorite ORM.

Close is a popular CRM (we use it here at Sequin!) Just enter your Close API key and we'll begin syncing your contacts, leads, and opportunities right to your database. Having your CRM data in your database makes it easier to automate your pipeline, analyze sales, and build internal applications for sales and marketing.

Fixes and improvements

  • Added foreign key support for Stripe.
  • Added a sources section to our website.
  • Improved voting for next Sequin sources.
  • Renamed "Optimize sync" to "Turbo sync" for Airtable – it's more accurate.
  • Improved onboarding by adding helpful emails.
  • Improved the Stripe schema used by Prisma. We shortened/cleaned-up names for backrefs and forwardrefs.
  • Added this changelog to our website :)