coder000

Everything on coder000

364 posts, 15 series and 15 free tools, all on one page. The three learning paths come first, every series in reading order, then Fixes and the tools. Looking for one word? Search is quicker.

New this month

Learn the stack

Set Up a Windows PC for .NET Development

  1. 01.NET SDKs, Runtimes and global.json: Which One Builds, Which One Runs
  2. 02WSL for .NET Work: A Distribution, the SDK, the File System and the Ports
  3. 03Ports and the Firewall on a Windows Dev PC: Reserved Ranges, localhost and the Security Alert
  4. 04Databases on a Dev PC: LocalDB, Express and PostgreSQL in Docker
  5. 05Git for Windows Settings That Stop the Warnings
  6. 06HTTPS on localhost: The Developer Certificate on Windows, in WSL and in a Container

Docker for .NET Developers on Windows

  1. 01What Docker Desktop Actually Runs on Windows
  2. 02Containers: Run, Look Inside, Stop, Remove
  3. 03Files In and Out: Bind Mounts and Volumes on Windows
  4. 04Ports and Networking: Who Binds What, Where
  5. 05PostgreSQL in a Container for a .NET App
  6. 06Compose: The App and Its Database from One File
  7. 07Building the .NET Image: Dockerfile or dotnet publish
  8. 08The Daily Loop and the Clean-Up: Disk, Restart Policies, Health, Events and a Pre-Push Check

Git & GitHub: Zero to Advanced

  1. 01Why Version Control Exists: A Short History of Git
  2. 02Your First Repository: init, add, commit
  3. 03Reading History and Undoing Small Mistakes
  4. 04Branches: Parallel Universes for Your Code
  5. 05Merging and Conflicts, Without Fear
  6. 06GitHub: Your Code in the Cloud
  7. 07Pull Requests and Code Review, Together
  8. 08Rewriting History (Carefully): Rebase, Cherry-Pick and Stash
  9. 09The Rescue Kit: Reflog, Reset, Revert and Bisect
  10. 10Under the Hood: How Git Thinks — and Where to Go Next

Blazor: Beginner to Intermediate

  1. 01Hello, Blazor: Set Up and Build Your First App
  2. 02Anatomy of a Blazor Project: Every File Explained
  3. 03Blazor Components: Build Once, Use Everywhere
  4. 04Data Binding and Events: Making Pages Interactive
  5. 05Rendering Lists and Conditionals in Blazor
  6. 06Component Communication: Parameters Down, Events Up
  7. 07Blazor Forms and Validation, the Friendly Way
  8. 08Routing and Navigation: Pages, URLs and Parameters
  9. 09Services and Dependency Injection in Blazor
  10. 10The Component Lifecycle: What Runs When (and Why)
  11. 11Calling Web APIs from Blazor with HttpClient
  12. 12Blazor Render Modes: SSR, Server, WebAssembly — and What's Next

SQL Server → PostgreSQL

  1. 01SQL Server to PostgreSQL: Why Switch, and What to Expect
  2. 02Instances, Databases, Schemas and Roles: Remapping Your Mental Model
  3. 03Data Types: The SQL Server → PostgreSQL Translation Table
  4. 04The T-SQL → PostgreSQL Phrasebook
  5. 05Stored Procedures, Functions and Triggers in PL/pgSQL
  6. 06Indexes, MVCC and Performance: Unlearning the Clustered Index
  7. 07Backup and Restore in PostgreSQL, for SQL Server DBAs
  8. 08PostgreSQL with .NET and EF Core — and Your Migration Plan

Conversation to System Design

  1. 01Simple Conversation to System Design — Introduction
  2. 02Chat with a Doctor to Gather Requirements
  3. 03Finding Entities from Conversation
  4. 04Deciding Attributes for Entities
  5. 05Finding Relationships Between Entities
  6. 06Creating Relationships Using Foreign Keys and Junction Tables
  7. 07Simple Conversation to System Design — Conclusion

Database Design for Developers

  1. 01From ER Diagram to CREATE TABLE: Turning Entities into Real Tables
  2. 02Primary Keys: Identity, GUID or Natural Key?
  3. 03One-to-Many Relationships: Foreign Keys and ON DELETE
  4. 04Many-to-Many Relationships: Junction Tables Done Properly
  5. 05Choosing Column Types: Strings, Money, Dates, Booleans and Status
  6. 06Constraints: Where Business Rules Belong
  7. 07Normalization With a Real Example: From Spreadsheet to 3NF
  8. 08Naming Conventions: Singular or Plural, snake_case or PascalCase
  9. 09Indexes Explained With Query Plans: Which Columns to Index
  10. 10Soft Delete, Audit Columns and History Tables
  11. 11Schema Migrations: Add, Rename and Backfill Without Downtime
  12. 12Search, Reporting Views and the Finished Clinic Schema

Student Projects: From Conversation to Database

  1. 01Library Management System Database Design: ER Diagram, Tables and SQL
  2. 02School Management System Database Design: ER Diagram, Tables and SQL
  3. 03Attendance Management System Database Design: ER Diagram, Tables and SQL
  4. 04Hostel Management System Database Design: ER Diagram, Tables and SQL
  5. 05Hospital Management System Database Design: ER Diagram, Tables and SQL
  6. 06Inventory Management System Database Design: ER Diagram, Tables and SQL
  7. 07Hotel Management System Database Design: ER Diagram, Tables and SQL
  8. 08Railway Reservation System Database Design: ER Diagram, Tables and SQL
  9. 09Online Shopping System Database Design: ER Diagram, Tables and SQL

Web & APIs

C# & .NET

Databases & Data

Developer Craft

Build with AI

From Prompt to Production

  1. 01AI-Assisted Development in 2026: Tools, Models and Honest Expectations
  2. 02Set Up Claude Code for .NET Like You Mean It
  3. 03From Conversation to Spec: Make the AI Interview You
  4. 04Spec to Schema: Designing PostgreSQL Tables with AI
  5. 05Scaffold to Skeleton: Blazor Server, EF Core and Npgsql
  6. 06CRUD with an AI Pair: The Booking Flow
  7. 07Going Real-Time: SignalR and the Live Queue Board
  8. 08Chat, Presence and the 401 That Explains Blazor Server
  9. 09Testing AI-Written Code Without Fooling Yourself
  10. 10Debugging with AI: Two Real Bugs, Start to Finish
  11. 11The Hardening Pass: AI as a Hostile Reviewer
  12. 12Ship It: A VPS, nginx, systemd — and the Headers SignalR Needs
  13. 13Power Moves: Agents, Skills, MCP — and Knowing When to Say No
  14. 14The Retro: What ClinicLive Really Cost, and What the AI Got Wrong

From Prompt to Polish

  1. 01AI UI Design Without the Slop: Four Directions and a Choice
  2. 02Foundations: Design Tokens, Dark Mode — and Killing Bootstrap
  3. 03The Screenshot Loop: Letting the AI See Its Own Work
  4. 04Phone UX: The Booking Flow and the Ticket
  5. 05Touch UX: A Kiosk for Strangers
  6. 06Signage UX: The Board Is Not a Web Page
  7. 07Pro-Tool UX: Density with Dignity
  8. 08The Accessibility Pass: Announce, Don't Just Paint
  9. 09Micro-Interactions: Motion That Explains Change
  10. 10The Polish Retro: What a Redesign Really Costs

From Prompt to Pocket

  1. 01From Prompt to Pocket: One App for Phone, Desk and Browser
  2. 02One UI, Three Hosts: The Capability-Interface Pattern
  3. 03The App Needs a Door: A Thin API Over the Clinic
  4. 04Live Queue in Your Pocket: SignalR, App Lifecycle and a Reconnect That Never Gives Up
  5. 05Buzz When You're Next: Haptics and Notifications, Permission in Context
  6. 06Push, for Real: Firebase Cloud Messaging to a Closed App
  7. 07Find the Clinic: Geolocation, a Testable Haversine and One-Tap Directions
  8. 08Scan to Check In: A QR on the Ticket, a Native Scanner Over the WebView
  9. 09Offline and Settings: Remember the Visit, Survive a Dead Signal
  10. 10Same App, on the Desk: Windows, One Breakpoint and a Waiting-Room Page
  11. 11Ship It: Signed Android, Self-Contained Windows, CI for Both
  12. 12The Pocket Retro: What a Companion App Really Costs

From Prompt to Private

  1. 01From Prompt to Private: A Clinic's Own AI, on Its Own Server
  2. 02Choosing the Model: Llama, Qwen and Gemma Sit the Clinic's Exam
  3. 03What Server Does a Clinic Need? Memory Arithmetic, Four Users and 120 Watts
  4. 04Installing the Runtime on the Server: systemd, Loopback Only, and the Port You Never Open
  5. 05Talking to It from .NET: OllamaSharp, Streaming, and a Chat Panel in the Staff Pages
  6. 06Giving It Knowledge, Part One: Chunks, Embeddings and pgvector in the Clinic's Own Database
  7. 07Giving It Knowledge, Part Two: Retrieval, Citations, and a Refusal the Model Cannot Skip
  8. 08The Staff Assistant Asks the Queue: Tool Calling, and a Guard Against Tools Nobody Asked For
  9. 09The Patient Assistant: Public Documents Only, on the Kiosk and in the App
  10. 10Does It Actually Work? Fifty Questions, Three Models, and the Number the Season Was For
  11. 11Running It for Real: Updates, Backups, Logs, and What a Month Costs
  12. 12The Private Retro: What a Clinic's Own AI Really Costs, and What It Got Wrong

Claude Code for .NET Developers

  1. 01CLAUDE.md for a .NET Solution: What to Write and What to Leave Out
  2. 02Claude Code Permissions for .NET: Allow dotnet build, Never Touch Production
  3. 03Claude Code Hooks for .NET: Format, Build and Test Without Being Asked
  4. 04Claude Code Skills for .NET: Package the EF Core Migration Chore
  5. 05Claude Code Subagents for .NET: A Second Pair of Eyes That Checks the Work
  6. 06Give Claude Code Your Database Schema: A Read-Only MCP Server in C#

AI & Modern Coding

Prepare for interviews

The .NET Developer Interview

  1. 01The .NET Developer Interview: What to Expect and How to Prepare
  2. 02C# Language Questions: Fundamentals They Always Ask
  3. 03async/await Interview Questions (the Deadlock Special)
  4. 04Collections and LINQ Questions
  5. 05ASP.NET Core and Web API Questions
  6. 06SQL and EF Core Questions
  7. 07System Design Questions for .NET Developers
  8. 08Behavioral Questions, Salary Talk, and Closing Strong
  9. 09EF Core Interview Questions: From DbContext to Production Migrations

The AI Engineer Interview

  1. 01The AI Engineer Interview: The Role, the Market, and Your Prep Roadmap
  2. 02LLM Fundamentals Questions (and Answers That Impress)
  3. 03Prompt and Context Engineering Questions
  4. 04RAG Design Questions: The New FizzBuzz
  5. 05Agents and Tool-Calling Questions
  6. 06The ML-Basics Minimum: Classic Questions You Still Get
  7. 07A Mock AI Engineer Interview, Walkthrough Style

Fixes

Have the error text? Paste it into the error lookup and jump straight to the fix. All 183, by stack, newest first in each:

MAUI, Android and Windows apps

Blazor

Ollama and local AI

EF Core, SQL Server and PostgreSQL

ASP.NET Core, C# and the .NET SDK

Docker, Git and WSL

Tools