The Sequin Blog

Back to home

Blog

Sync APIs to
your database
in real-time

Start free

FEATURED

Announcing SQL writes: Write data back to APIs using SQL in your database, synchronously

BY Anthony Accomazzo

3 min read

Announcing SQL writes: Write data back to APIs using SQL in your database, synchronously

TL;DR: We just released SQL writes. Now, Sequin not only lets you read data from APIs like Salesforce and HubSpot using SQL. You can write back to those APIs using SQL too. Writes happen synchronously, so your local tables are never out-of-sync and errors are easy to handle. No...

FEATURED

BY Anthony Accomazzo

3 min read

Announcing SQL writes: Write data back to APIs using SQL in your database, synchronously

Most Recent

BY Anthony Accomazzo

8 min read

All the ways to capture changes in Postgres

Working with data at rest is where Postgres shines. But what about when you need data in motion? What about when you need to trigger a workflow based on changes to a table? Fortunately, Postgres comes with a lot of options to make this happen....

BY Anthony Accomazzo

11 min read

We had no choice but to build a Postgres proxy

We knew building a database proxy would be hard. We wanted to find *any* other way to achieve our mission. But alas, after looking at all the options, only one solution remained standing. Here, I share our journey to the inescapable conclusion....

BY Randy Coulman

6 min read

GenServer.reply: Don't Call Us, We'll Call You

Let's look at how we can use `:noreply` and `GenServer.reply` to allow a GenServer to continue working even while its `call`ers wait for the result of long-running operations....

BY Anthony Accomazzo

13 min read

How we built our sync on HubSpot's API

At any scale, integrating with HubSpot becomes a syncing problem. Here's how to build a sync between HubSpot and your database....

BY Randy Coulman

9 min read

Between the Ctrl-C's

An outline of the options available in the Elixir BREAK menu....

BY Anthony Accomazzo

5 min read

Finding and fixing eventual consistency with Stripe events

Stripe events can be out of order. Here's how we use cursor logic to keep everything consistent....

BY Eric Goldman

3 min read

Sequin vs Heroku Connect

Sequin is a new alternative to Heroku Connect. How does it compare? Put simply, the main differences between Sequin and Heroku Connect are infrastructure options, price, and developer experience....

BY Eric Goldman

9 min read

How to integrate with HubSpot using your Postgres database

How to set up a sync between HubSpot and Postgres so you can integrate faster....

BY Eric Goldman

2 min read

Announcing rate limit controls

Hitting the rate limit with your integration? Sequin now gives you simple tools to manage your rate limit. Never worry about the rate limit again....

BY Dave Nguyen

5 min read

Pulling past the limits of Salesforce's /updated endpoint

Learn how we use the Salesforce APIs to reliably retrieve every change in your CRM....

BY Lukas Schwab

4 min read

Stripe metered billing, simplified

You don't just set and forget metered billing; you repeatedly report per-customer usage to Stripe. We're using our own product to make that simpler....

BY Anthony Accomazzo

10 min read

We used Elixir's Observer to hunt down bottlenecks

We're Sequin and we let developers build on their API data using their Postgres database. We sync data from third-party APIs like Salesforce and HubSpot to Postgres so you can select with SQL or your ORM. And when you mutate tables with insert, update, and delete, we write those changes...

BY Anthony Accomazzo

8 min read

What's changed in your API?

Do you make it easy for consumers to find out what's changed in your API?...

BY Lukas Schwab

8 min read

What to do without HubSpot Webhooks

HubSpot's just doesn't offer enough Webhooks. What should you do?...

BY Eric Goldman

10 min read

The Complete Developer's Guide to Airtable Part 3: Interfaces

We'll explore when to use an interface versus a script or custom Airtable App. We'll also walk through a practical use case to give you a sense of the build experience and functionality....

BY Eric Goldman

3 min read

How We Use Our Stripe Sync

How we're using our own Stripe sync to monitor subscription status....

BY Eric Goldman

4 min read

SQL queries for calculating Stripe MRR

How to calculate your MRR on Stripe using SQL....

BY Eric Goldman

7 min read

Managing Stripe as a Source of Truth

How to manage Stripe application data while keeping Stripe as the source of truth....

BY Anthony Accomazzo

6 min read

Give me /events, not webhooks

Webhooks come with some challenges. We prefer polling an /events endpoint instead when possible....

BY Anthony Accomazzo

6 min read

Syncing Stripe to Postgres

At Sequin, we replicate APIs to Postgres databases in real-time. We want to provide our customers with the experience of having direct, row-level access to their data from third-party platforms, like Stripe and Airtable....

BY Anthony Accomazzo

8 min read

Our Airtable sync process, layer by layer

BY Anthony Accomazzo

7 min read

Stripe on Sequin: Replicate Stripe to Postgres in real-time

Now you can get a replica Postgres database with all your Stripe data, synced in real-time. It’s like having row-level access to your data in stripe_prod....

BY Anthony Accomazzo

5 min read

Benchmarking Airtable API performance

I wanted to get to the bottom of what caused writes to slow down so significantly....

BY Eric Goldman

7 min read

Prototyping apps on Airtable: Best practices

The first iteration of most software is a prototype. The purpose of a prototype is to validate a hypothesis or learn more about a market. Because a prototype is likely to undergo radical changes or total abandonment in face of the information it uncovers, the faster you can generate a...

BY Eric Goldman

7 min read

The Complete Developer's Guide to Airtable Part 2: Webhooks

An update to the developer's guide to include Airtable's new Webhook triggers in automations....

BY Eric Goldman

28 min read

The Complete Developer's Guide to Airtable

A deep dive into all the ways to build on Airtable....

BY Anthony Accomazzo

8 min read

What is RDS Proxy? Exploring with benchmarks

I was surprised when a customer wrote in to explain that he noticed - for simple SQL queries - the Airtable API was about as performant as querying his Sequin [https://sequin.io/?utm_source=blog&utm_medium=post&utm_campaign=rds] -provisioned Airtable database. We'd expect a database query...

BY Eric Goldman

8 min read

How to go further with Airtable using Postgres Arrays

In this guide, you'll unlock your Airtable data with some killer PostgreSQL methods....