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 / NOTES TECHNIQUES
Des retours concrets sur Next.js, TypeScript, le cloud et l’ingénierie assistée par IA.
Les articles sont actuellement rédigés en anglais.
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