Build a cost-efficient, scalable personal finance tracker using Next.js Server Actions paired with PostgreSQL, all on a single VPS, focusing on simplicity, performance, and developer productivity.
This design assumes you want reliability, observability, security, compliance, scalability, and future flexibility. 1. Executive Architecture Summary A production AI-agent platform should not be just: User → LLM → Respon...
Sagas provide a pragmatic way to manage multi‑service transactions using local transactions plus compensations. This article compares choreography and orchestration and gives examples.
Q19 — Caching Layers — IMemoryCache, IDistributedCache, HybridCache, Output Cache Level: Senior | Topic: Performance Optimization Choosing the Right Cache IMemoryCache: In-process, zero serialisation, microsecond latency...
1. Monolithic Architecture Extracted description: A single codebase and single deployable unit where all components are tightly coupled. Structure: UI / Web API → Business Logic + Data Access + Shared Components → Databa...
Q8 — JWT Authentication + Policy-Based Authorization in ASP.NET Core Level: Senior | Topic: ASP.NET Core JWT Authentication Flow The client authenticates once (POST /auth/login) and receives a signed JWT access token. On...
A practical, example-driven guide to applying CQRS in real systems: when to use it, how to handle eventual consistency, the Outbox pattern, and operational considerations.
Vertical scaling gives one machine more capacity; horizontal scaling spreads work across machines. The right choice depends on bottlenecks, state, failure tolerance, and operational cost.
A practical, detailed blueprint for building and operating a small-scale serverless web application on AWS using Lambda, API Gateway, DynamoDB, and CDK to optimize cost and simplicity.
A pragmatic performance playbook for EF Core: find bottlenecks, fix N+1s with projection/eager loading, and when to cache or use AsNoTracking.
Q21 — Rate Limiting in .NET 7+ — Fixed Window, Sliding Window, Token Bucket Level: Senior | Topic: Performance Optimization Why Rate Limiting? Rate limiting protects your API from overload — whether from abusive clients,...
Q11 — Eager, Lazy, and Explicit Loading — Differences and the N+1 Problem Level: Mid-Level | Topic: Entity Framework Core The Three Loading Strategies Eager Loading ( Include() ): Related data is loaded in the same query...
1. Understanding the Asynchronous Programming Model The diagram above shows the core problem async solves. In the synchronous model, every blocking I/O call (database query, HTTP request, file read) stalls its thread. Yo...
Q14 — EF Core Performance — Compiled Queries, Split Queries, Raw SQL Level: Senior | Topic: Entity Framework Core Performance Bottlenecks in EF Core Every LINQ query goes through an expression tree compiler that translat...
Q13 — EF Core Migrations — Production Deployment Strategy Level: Senior | Topic: Entity Framework Core The Problem with Naive Migration Deployment Running MigrateAsync() at app startup in a multi-instance deployment is d...
Q18 — Query Optimisation Workflow — Execution Plans, Statistics, Query Store Level: Senior | Topic: SQL Server The Optimisation Workflow Effective query optimisation follows a structured workflow: identify slow queries, ...
Q17 — Window Functions — ROW_NUMBER, LAG, SUM OVER, Running Totals Level: Mid-Level | Topic: SQL Server What Are Window Functions? Window functions operate across a set of rows without collapsing them into a single outpu...
Q27 — CQRS with MediatR — Commands, Queries, Pipeline Behaviours Level: Senior | Topic: Architecture CQRS in a Nutshell Command Query Responsibility Segregation separates operations that change state (Commands) from oper...
Q16 — Transaction Isolation Levels — READ COMMITTED SNAPSHOT vs SNAPSHOT Level: Senior | Topic: SQL Server Why Isolation Levels Matter Isolation levels control how transactions see data changed by concurrent transactions...
Event sourcing records every change as an immutable event. This article explains modeling choices, snapshots, upcasters, and safe external integrations.
Q5 — async/await Internals — State Machines, Pitfalls, ValueTask Level: Senior | Topic: C# Fundamentals How async/await Works Under the Hood The C# compiler transforms every async method into a state machine struct . Eac...
Monolithic — the starting point for most systems. A traditional monolith is a single process; a modular monolith enforces domain boundaries within it (great for teams not ready for microservices); vertical slice organise...
Choose consistency per operation, preserve the guarantees users rely on, and use replication lag and latency measurements to tune the rest.
Q4 — Memory Management — Stack, Heap, GC Generations, IDisposable Level: Senior | Topic: C# Fundamentals Stack vs Heap The stack stores value types and method frames — allocation and deallocation are O(1) pointer moves. ...
Q7 — DI Service Lifetimes — Singleton, Scoped, Transient and the Captive Dependency Trap Level: Mid-Level | Topic: ASP.NET Core The Three Lifetimes Singleton: One instance per application. Created once, reused forever. U...
Twelve practical interview questions on selecting, validating, operating, and evolving a technology stack without treating familiarity or fashion as evidence.