Postgres transactions are a distributed systems superpower

kept by eddie jul 04

Co-locating workflow state and application data in Postgres enables atomic transactions that provide exactly-once execution without application-level idempotency logic.

Building durable workflows on Postgres
Commenters debate using Postgres for durable workflows, praising its flexibility but warning it often leads to building a poor copy of dedicated workflow engines like Temporal.
also on DBOS, PostgreSQL, #software-architecture, #developer-tools
Build Durable AI Agent Systems
This course teaches how to build production-ready AI agent systems with durable execution, secure sandboxes, memory management, and multi-agent orchestration using TypeScript and Node.js.
also on DBOS, #software-engineering, #developer-tools
Video Conferencing with Postgres — PlanetScale
A developer demonstrates live video calls over PostgreSQL using logical replication, achieving 15fps with a $5 database.
also on PostgreSQL, #infrastructure, #software-engineering, #developer-tools
Postgres for time-series workloads at any scale.
Tiger Cloud provides a fully managed PostgreSQL platform that independently scales compute and storage for time-series workloads, ensuring high availability, compliance, and deep observability.
also on PostgreSQL, #software-engineering, #developer-tools
The Limit in the Loop
As AI agents scale, stateless interactions fail, making memory a systems problem requiring active maintenance—write control, deduplication, and purposeful forgetting—rather than simple storage.
also on #software-architecture, #infrastructure