PostgreSQL Deadlocks: Define the Lock Order Before Retrying
Review PostgreSQL transaction boundaries with consistent lock ordering, complete-transaction retries, bounded attempts and deterministic concurrency tests.
Timour Spiridonov
ARGONAUTE DIGITAL / ENGINEERING NOTES
Practical notes on Next.js, TypeScript, cloud architecture and AI-assisted engineering.
Review PostgreSQL transaction boundaries with consistent lock ordering, complete-transaction retries, bounded attempts and deterministic concurrency tests.
Timour Spiridonov
Build reliable asynchronous AI batch workflows with durable request manifests, per-item outcomes, selective retries and guarded publication of stale results.
Timour Spiridonov
Design Node.js exports around bounded production, slow consumers, cancellation and honest completion signals rather than a stream-shaped API alone.
Timour Spiridonov
Build a reproducible OpenTelemetry portfolio exercise: trace one request, test context propagation, isolate a delay and keep telemetry free of secrets.
Timour Spiridonov
Design request deadlines across Node.js, outbound calls and PostgreSQL so a timed-out response does not leave expensive work running without an owner.
Timour Spiridonov
Design a bounded shutdown for a Node.js HTTP service on Cloud Run: drain requests, preserve dependencies, and test interrupted writes without promising zero loss.
Timour Spiridonov
A practical tenant-isolation review for Node.js and PostgreSQL: runtime roles, trusted tenant context, transaction scope and adversarial acceptance tests.
Timour Spiridonov
A practical connection-budget review for Node.js and PostgreSQL on Cloud Run: pool ownership, concurrency, rollout headroom and overload tests.
Timour Spiridonov
A practical Node.js, PostgreSQL and GCP design for retry-safe background jobs: stable operation IDs, transactional writes and explicit recovery paths.
Timour Spiridonov
A practical expand-and-contract migration workflow for PostgreSQL-backed applications: control lock waits, separate backfills, and preserve application rollback.
Timour Spiridonov