Diátaxis recently made the front page of HN. I mentioned in a comment that we applied the framework to Sequin a couple weeks ago and were very happy with it. Some folks asked me to expand on my comment, so I'm doing so here: The engineer's...
We're building Sequin, a Postgres CDC tool to streams and queues like Kafka, SQS, HTTP endpoints, and more. Efficient, correct pagination is paramount for our backfill process, so we use keyset cursors extensively. You've probably heard about the limitations of offset/limit in Postgres. There are...
Whether you're managing event logs, audit trails, or time-series data, there comes a point when you need to start pruning old records. Can Postgres do it? And what tools are at your disposal? Explore pg_cron, pg_partman, and DIY....
We're Sequin, a Postgres CDC tool to streams and queues like Kafka, SQS, HTTP endpoints, and more. Like any Postgres maxi, we tend to find ourselves down a Postgres rabbit hole a couple times per month. This is one of those times :) Who doesn't like to...
We just released Sequin v0.5. I'm really excited about this release, many of the core building blocks are in place. Sequin streams data out of your Postgres database. You can use it to replicate data from your existing tables to other apps, databases, caches, materialized views, or...
The differences between at-most-once, at-least-once, and exactly-once delivery in messaging systems....
We're Sequin, a Postgres CDC tool to streams and queues like Kafka, SQS, HTTP endpoints, and more. A lot of our users use Supabase, so we've explored all the ways they've done event-driven workflows before Sequin. Supabase makes it easy for your frontend to...
We're Sequin, a Postgres CDC tool to streams and queues like Kafka, SQS, HTTP endpoints, and more. We have a web console for managing tables and streams, and that console is built with LiveView + LiveSvelte. We wrote previously about how much we enjoyed using LiveView with LiveSvelte. Since...
We're Sequin, a Postgres CDC tool to streams and queues like Kafka, SQS, HTTP endpoints, and more. We think Sequin's cool, but you don't need to adopt the project to get started with streaming in Postgres. In fact, you can turn Postgres into a...
We're Sequin, a Postgres CDC tool to streams and queues like Kafka, SQS, HTTP endpoints, and more. Stable, sequential ordering is a very useful thing to have when building a streaming system. But Postgres' behavior here can be surprising! We go down the rabbit hole below. An...
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....
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....
How we used Elixir's Observer to chase down and fix some puzzling runtime issues....
Webhooks come with some challenges. We prefer polling an /events endpoint instead when possible....
