ts-db-perf

What problem does it solve?

It fixes slow TypeScript backend database access by removing inefficient query patterns and preventing correctness issues like race conditions and flaky retries.

Core Features & Use Cases

• Eliminate N+1 queries by rewriting loops into joins/includes or batched IN/JOIN strategies, so list endpoints don’t explode into hundreds of round-trips.
• Improve performance-critical queries by selecting only needed fields, adding pagination, and tightening async execution with parallel reads where safe.
• Harden writes and concurrency using transactions, chunked batch updates, optimistic locking/atomic updates, and idempotency to prevent double-processing.

Quick Start

Optimize the attached TypeScript database code to remove N+1 queries, add safe pagination and caching where appropriate, and prevent race conditions or non-atomic updates.