left arrow Back to home
Blog

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....

Read more
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....

Read more
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....

Read more
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....

Read more
BY Randy Coulman
9 min read
Between the Ctrl-C's

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

Read more
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....

Read more
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....

Read more
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....

Read more
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....

Read more
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....

Read more
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....

Read more
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...

Read more
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?...

Read more
BY Lukas Schwab
8 min read
What to do without HubSpot Webhooks

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

Read more
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....

Read more
BY Eric Goldman
3 min read
How We Use Our Stripe Sync

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

Read more
BY Eric Goldman
4 min read
SQL queries for calculating Stripe MRR

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

Read more
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....

Read more
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....

Read more
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....

Read more
BY Anthony Accomazzo
8 min read
Our Airtable sync process, layer by layer

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. After the concept of Sequin crystallized, we knew we had to get something to market quickly....

Read more
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....

Read more
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....

Read more
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...

Read more
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....

Read more
BY Eric Goldman
28 min read
The Complete Developer's Guide to Airtable

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

Read more
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...

Read more
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....

Read more