October 25, 2026
Keep CQRS Use Cases Clear Without Splitting the Application
Separate commands from queries while keeping one deployable application and one transactional database.
1 min read
Read article →NOTES & IDEAS
Journal
Notes worth keeping and coming back to.
October 25, 2026
Protect Cookie-Based Internal APIs from CSRF
Authentication identifies a signed-in administrator; authorization and anti-forgery checks protect each mutation.
2 min read
Read article →October 25, 2026
Choose ASP.NET Core Dependency Lifetimes by Ownership
Understand scoped request services, singleton lifetime, and the captive dependency problem.
1 min read
Read article →October 25, 2026
Choose Offset or Keyset Pagination with Evidence
Offset paging is convenient; keyset paging can keep deep sequential pages efficient and stable.
2 min read
Read article →October 25, 2026
Make PostgreSQL Upserts Safe and Idempotent
Use a unique key, ON CONFLICT, and a transaction boundary that matches the business operation.
2 min read
Read article →October 25, 2026
Use SQL Window Functions for Rankings and Trends
Rank rows within groups and calculate running metrics without collapsing detail rows.
2 min read
Read article →October 25, 2026
Value Semantics, References, and Records in C#
Understand copying, mutation, equality, and when an immutable record makes a clearer data contract.
2 min read
Read article →October 25, 2026
Async Request Flows Need Cancellation
Propagate request cancellation through database and network calls, and keep async APIs honest about failures.
2 min read
Read article →October 25, 2026
Shape EF Core Queries Around the Response
Use projection, bounded results, and deliberate loading to avoid oversized queries and N+1 behavior.
2 min read
Read article →