The SQL Query Roadtrip

The SQL Query Roadtrip

3 articles in this series •

Articles

  1. 1

    Overview

    • 11 min read

    Ever wonder what happens when you type SELECT * FROM users WHERE id = 42; and hit Enter? That simple query triggers a fascinating journey through PostgreSQL’s internals—a complex series of …

  2. 2

    Connections and Communication

    • 9 min read

    In the previous article, we explored the complete journey a SQL query takes through PostgreSQL—from parsing to execution. But before any of that can happen, your application needs to establish a …

  3. 3

    Parsing and Analysis

    • 12 min read

    In the previous article, we explored how PostgreSQL establishes connections and communicates using its wire protocol. Once your connection is established and the backend process is ready, you can …