
PL/pgSQL for People Who Already Know SQL
A fast revision sheet: procedural PostgreSQL, from variables to triggers, and when not to use it. Postgres's procedural language is PL/pgSQL, a close cousin of Oracle's PL/SQL. Syntax differs in plac

Dates are where "it works on my machine" queries go to die: DST shifts, month-end overflow, inclusive BETWEEN on timestamps, ISO-year mismatches. This is a fast, opinionated refresher for people who a

You already know SELECT. This is the string toolbox I reach for daily when cleaning, parsing and reshaping text in Postgres, with the gotchas that actually bite in production. One schema, one dataset,

Fast reference for people who already write SQL daily. It covers aggregates, ordered and filtered aggregation, statistical functions, and multi-level grouping, all on one small schema.

JOINs to LATERAL, on one schema. Not for beginners.

How to go from a one-paragraph idea to a deployed, JWT-secured MERN app with an AI coding agent, without letting the vibes turn into spaghetti. Why vibe coding needs a process Vibe coding means descri

From an empty folder to a Dockerized API, written for developers who already know how to program but are new to the Python/FastAPI world. If you've built REST APIs in Java, C#, Node.js or Go, you alr