Anthony Accomazzo

Anthony Accomazzo

BY Anthony Accomazzo
8 min read
Design patterns for extracting from REST APIs

Most integrations rely on an extraction process. But REST APIs don't make extraction easy. Follow these design patterns to avoid common pitfalls....

Read more →
BY Anthony Accomazzo
6 min read
NATS: First impressions

NATS has a ton of great features. From pub/sub to JetStream, here's our team's takeaways after spending some time with NATS....

Read more →
BY Anthony Accomazzo
12 min read
LiveView is best with Svelte

Phoenix's LiveView is powerful. But it felt like it was missing something. Adding Svelte not only filled a big gap – it introduced us to an entirely new way to develop web apps....

Read more →
BY Anthony Accomazzo
7 min read
What was that commit? Searching GitHub with OpenAI embeddings

Embeddings let you search, cluster, and categorize GitHub data in a whole new way. One thing you can build is an advanced search tool across all your org's Pull Requests, Issues, etc....

Read more →
BY Anthony Accomazzo
2 min read
Sequin Events Alpha

We’re announcing the alpha for one of our most requested features: events! You can now subscribe to events on the sources we sync using Kafka and Webhooks....

Read more →
BY Anthony Accomazzo
9 min read
Storing Salesforce embeddings with pgvector and OpenAI

Use OpenAI to generate embeddings for your Salesforce objects and store them in Postgres. Then, you can easily build powerful search and clustering tools on top of your Salesforce data....

Read more →
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
10 min read
Building a Postgres proxy to write back to APIs

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 Anthony Accomazzo
3 min read
Announcing SQL writes: Write data back to APIs using SQL in your database, synchronously

We’re Sequin. We stream data from services like Salesforce, Stripe, and AWS to messaging systems like Kafka and databases like Postgres. It’s the fastest way to build high-performance integrations you don’t need to worry about. 💡Update: SQL writes was a neat feature, and we learned a lot....

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 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 Anthony Accomazzo
10 min read
We used Elixir's Observer to hunt down bottlenecks

We’re Sequin. We stream data from services like Salesforce, Stripe, and AWS to messaging systems like Kafka and databases like Postgres. It’s the fastest way to build high-performance integrations you don’t need to worry about. We're built on Elixir - and love it. We recently...

Read more →
BY Anthony Accomazzo
8 min read
How to make it easy to detect changes in your API

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

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 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-provisioned Airtable database. We'd expect a database query to be at least an order of magnitude faster than an...

Read more →