Writing
Engineering Notes & System Case Studies
Practical write-ups on building reliable sync pipelines, avoiding governor limits, and making decoupled systems agree on the truth.
Consolidating Multiple Apex Triggers into a Single Handler Framework
How to eliminate order-of-execution race conditions, recursion bugs, and governor limit errors by moving multiple Apex triggers into a unified handler pattern.
Building a Salesforce Sync Engine, Part 3: Cross-System Foreign Keys and Distributed Locks
How to resolve circular relational dependencies, manage cross-system foreign keys at scale, and guarantee fail-safe synchronization using PostgreSQL advisory locks.
Building a Salesforce Sync Engine, Part 2: In-Database Transforms and Handling Schema Drift
How to handle Salesforce custom field drift and execute high-speed picklist mapping using PostgreSQL information_schema intersections and JSONB operators.
Building a Salesforce Sync Engine, Part 1: Streaming Bulk API 2.0 into Postgres COPY
How to stream large Salesforce query results directly into PostgreSQL staging tables with a flat memory profile using HTTP chunk streaming and asyncpg COPY.
Eliminating Checkout Timeouts: Decoupling Frontends from Salesforce Triggers
How slow Apex triggers cause checkout lockups, and how to use the transactional outbox pattern to keep customer requests fast and reliable.
Idempotent Webhook Ingestion in Odoo 17 & 19
How to handle out-of-order deliveries and network retries gracefully using HMAC-SHA256, database deduplication, and a dead-letter queue.