Building a Reusable Chat Infrastructure with DynamoDB Single Table Design
The Context Most applications need chat at some point. Customer support, collaboration...
Tag archive
The Context Most applications need chat at some point. Customer support, collaboration...

DynamoDB vs Amazon Aurora compared — NoSQL key-value store versus managed MySQL/PostgreSQL-compatible relational database, from joins to scaling and pricing.

How we built a local SQL engine for DynamoDB — a database with no JOIN, no GROUP BY, and no COUNT. Streaming pages into embedded SQLite, the parser that silently lied to us, and why we rebuilt the aggregation engine when we realized the competitor is a throwaway script.

Why DynoTable never writes to DynamoDB when you click Save — every edit becomes a reviewable diff in a staging area and ships as a transaction guarded by optimistic locks. The engineering story - the cross-tab bug that reshaped the design, the refactor that deleted a subsystem, and why AI agents made staging the load-bearing wall.

How we made small, cheap LLMs reliably query DynamoDB — prescriptive tool validators that treat rejection messages as teaching signals, aggressive result caps, and an eval harness that runs real agent loops against DynamoDB Local. The engineering story behind DynoTable's AI assistant.

What it took to build a safe DynamoDB MCP server inside a desktop app — an OAuth 2.1 authorization server in Electron, per-connection AWS credential isolation, consent-time region freezing, live license clamping, and MFA completed over MCP elicitation. The engineering story behind DynoTable's MCP server.

The DynamoDB adjacency list pattern — model a social follow graph as edge items in one table, then traverse both directions of the relationship with a single GSI.

How to delete multiple items in DynamoDB — BatchWriteItem delete loops, TransactWriteItems, PartiQL batches, TTL, and staged multi-row deletes in DynoTable — plus why there is no DELETE WHERE.

DynamoDB adaptive capacity and burst capacity explained — how DynamoDB absorbs spikes and boosts hot partitions automatically, and where it still can't save you.
I'm writing this as part of my submission for the H0 Hackathon: Hack the Zero Stack with Vercel and...
Solace is an AI patient intake and triage app for emergency departments. Here is the full stack and...
I built Solace, an AI-native patient intake and triage app for emergency departments, on Amazon...