Engineering Codex

A personal knowledge base covering Python, SQL Server, AI agents, and data engineering. Each entry is intentionally bite-sized — one concept, pattern, or snippet per file.

---

Sections

Section	Description
Python	Libraries, patterns, and best practices
SQL Server	Query writing, functions, and server-side logic
AI Agents	Concepts, prompting approaches, and patterns for working with AI
Data Engineering	Best practices and architectural patterns

---

How This Is Organised

• One file per concept. No enormous catch-all files.
• Libraries get a flat file until they accumulate enough entries to earn their own subfolder.
• AI Agents is intentionally fluid — this space is evolving fast and the content here reflects current understanding, not settled doctrine.
• Every file follows the same template so entries are scannable and consistent.

---

Entry Template

Each file in this codex follows this structure:

# Title

**System/Library:** e.g. Pandas, SQL Server, LangChain  
**Tags:** comma, separated, tags  

## What It Is
One or two sentences. What does this do, and when do you reach for it?

## Code / Explanation

​```language
# content here
​```

## Notes / Gotchas
- Things that tripped you up
- Edge cases worth remembering

## References
- Links to docs, articles, or sources

---

Last updated: April 2026