Databases · 5 min read
Keyset Pagination for a Changing CRM Activity Feed
Page through CRM activity using a stable boundary, while making ordering, permissions, and changes between requests explicit.
Editorial date
Writing
Engineering notes, with examples.
React interfaces, Node.js and Python APIs, CRM data models, and AI-assisted development. Each note includes an illustrative example and a related project.
Subscribe via RSSCards follow an assigned editorial timeline. Publication dates appear in each article.
Databases · 5 min read
Modeling Vendor Price Revisions in PostgreSQL
Keep vendor prices traceable to their source without silently changing the prices already selected for a project.
Editorial date
Databases · 1 min read
PostgreSQL by Default, and When I Don't Use It
Postgres is my starting point for relational data. Workload and operational constraints decide when to use something else.
Editorial date
Databases · 1 min read
TimescaleDB and Citus: Scaling Time-Series and Multi-Tenant Data
Two Postgres extensions that let you scale without abandoning the database you already trust.
Editorial date