SOL · 4,127 · CASSINI ARCHIVECLASSIFIED · POSTGRES INSIDE

Something is erupting
from a moon of Saturn.

Plumes of ice and water. Salt. Organic compounds. A liquid ocean beneath the crust. The Cassini probe sent back twelve years of strange, beautiful data - and nobody can quite explain what it means.

You've just been hired as the interim DBA. The previous one walked off the job. Nobody's saying why.

Take the assignment - $30
PostgreSQL · taught the fun way
EPUB + PDF · real Cassini mission data
A Curious Moon by Rob Conery
ENC-04°W · 80°S
JUST
$30
EPUB+PDF
◉ Cassini · 2004 → 2017 · 13 yrs in orbit·635 GB telemetry · 453,048 images · indexed in Postgres·14 cryovolcanic vents · Enceladus south pole·4.9 / 5 · 800+ reviews·Used in classrooms · Stanford · MIT · Carnegie Mellon·◉ Cassini · 2004 → 2017 · 13 yrs in orbit·635 GB telemetry · 453,048 images · indexed in Postgres·14 cryovolcanic vents · Enceladus south pole·4.9 / 5 · 800+ reviews·Used in classrooms · Stanford · MIT · Carnegie Mellon·
01The Mystery

They named it Enceladus.
And then it broke physics.

For decades, we thought the outer moons of the solar system were dead. Frozen rocks. Done. Then in 2005, the Cassini probe flew past a tiny ice ball orbiting Saturn - only 314 miles wide - and saw jets. Hundreds of them. Erupting from cracks in the southern hemisphere.

Water. Salt. Organic molecules. The kind of chemistry that, on a planet like ours, eventually decides to start building things.

So what's going on down there?

◉ FIG. 01 · OBSERVATION LOG
South polar plumes · 2005-11-27
VENT_ID   ALEXANDRIA-04
LAT/LON   -80.42, -04.13
VELOCITY   2,189 km/h
COMPOSITION   H₂O · NaCl · NH₃ · CH₄
ANOMALY   UNRESOLVED
PLUME ACTIVITY · 13Y
02Your Mission
◉ DOSSIER · INTERIM-DBA-04EYES ONLY
◉ REC
YOU
Self-taught · Postgres-curious
STATUSINTERIM
CLEARANCEPROVISIONAL
DURATION13 chapters
OUTCOMEFLUENT IN PG

You take the role of an interim DBA.

The last one walked off the job. The team is small, the deadline is yesterday, and somebody handed you a 635-gigabyte archive of raw NASA telemetry - magnetometer readings, plume velocities, image plate metadata - and asked you to figure out what's actually going on.

You'll do this with PostgreSQL. Not because anyone wants to teach you SQL. Because the data is there, and the database is the only tool that can answer what you need to ask of it.

◉ The trick

By the time you've solved the case, you'll have shipped a working data pipeline in production-grade Postgres. You won't have noticed. That's the point.

03The Story You'll Live

A noir told in SELECT statements.

Most database books read like a tax return. A Curious Moon reads like the journal of someone in over their head, who is also having the time of their life. You'll meet Dee Yan - your fictional taskmaster, brilliant and a little terrifying - and her team. They'll hand you problems. You'll pour another coffee.

DAY 01
First contact
Meet Dee. Sign the NDA.
WEEK 01
Import the archive
psql, COPY, sanity checks
WEEK 03
Suspicious patterns
Joins, GROUP BY, window fns
WEEK 06
The big inference
Geospatial, time series
FINALE
You file the report
Deploy. Tune. Ship.
The Chapters

Nine chapters.
One database. One question.

Plain-English explanations. Real queries. Run them yourself against the data. By the end you won't just know Postgres - you'll have used it to crack a case.

01
Ch · 01
Setup & psql Survival

From zero to comfortable on the command line.

psql · roles · CREATE DATABASE
02
Ch · 02
Importing the Archive

635 GB of NASA telemetry, one COPY at a time.

COPY · CSV · staging tables
03
Ch · 03
Sanity & Schemas

Constraints, foreign keys, the real shape of the data.

DDL · constraints · indexes
04
Ch · 04
First Queries

Where are the plumes? When did they fire?

SELECT · WHERE · ORDER BY
05
Ch · 05
Joins & GROUP BY

Cross-referencing 14 instruments worth of pings.

JOIN · aggregates · HAVING
06
Ch · 06
Window Functions

Sliding views over 13 years of orbit.

OVER · LAG · ROW_NUMBER
07
Ch · 07
Geospatial

Plotting eruptions on a sphere with PostGIS.

PostGIS · ST_DWithin
08
Ch · 08
Time Series

What's actually changing about Enceladus?

date_trunc · interval · CTEs
09
Ch · 09
The Inference

Putting the pieces together. The big reveal.

materialized views · EXPLAIN
Field reports

From the readers who came back.

★★★★★4.9 / 5 · 800+ reviews
★★★★★
"Equal parts mystery novel and Postgres tutorial. I read it on a flight and bought two more copies for my team when I landed."
MC
Maria C.
Staff Engineer · Stripe
★★★★★
"I've shipped Postgres in production for a decade and still learned things - and laughed. Twice."
DH
Derek H.
Principal · 18F
★★★★★
"The way I always wished databases had been taught. Storytelling is a delivery mechanism for muscle memory."
PR
Priya R.
Database Engineer
★★★★★
"Three days in I started looking for excuses to write SELECT statements. That has never happened to me before."
TV
Tom V.
Junior dev
★★★★★
"Like sitting next to a senior engineer who actually likes their job. With a really good cover."
AS
Anya S.
Tech Lead · GitHub
★★★★★
"If you've been intimidated by SQL, this book quietly fixes that and you don't even notice."
JK
Jordan K.
Self-taught dev
What you'll learn

What You'll Discover in A Curious Moon.

I won't waste your time with sleep-inducing demos and examples - we're going to hit the ground running by importing millions of records into PostgreSQL right from the command line and then we're going to interrogate it for correctness. From there we put our detective hats on and get to work.

Learning Through a Fun Story

You'll learn PostgreSQL through storytelling, not dry tutorials, so you can maintain interest and actually remember what you learn, which means you'll finally break through your database learning plateau.

Master ETL Processes

You'll master ETL processes with real NASA data so you can confidently handle complex datasets in your own work, which means you'll be prepared for real-world data challenges.

Work with Raw Data

You'll work with raw, imperfect data and learn how to audit and clean it, which means you'll develop real-world skills that textbooks never teach.

Optimize Database Performance

You'll optimize slow queries using EXPLAIN and ANALYZE to figure out where to put your indexes, which means you'll know how to make your databases lightning fast.

Perform Scientific Analysis

You'll perform mathematical analysis to verify flyby altitudes and speeds using data from the Ion and Neutral Mass Spectrometer during the 22 close encounters with Enceladus, which means you'll understand how to extract meaningful insights from complex datasets.

Search for Extraterrestrial Life

You'll run the ultimate analysis: Is there life under the ice of Enceladus? You'll have all the data needed to support this claim, which means you'll experience firsthand how database skills can contribute to groundbreaking scientific discovery.

04Author
◉ ON THE RECORD
A Bio Reactor
possible life · cosmic mystery
30-DAY
REFUND
NO QUESTIONS
Your guarantee

Don't love the book? Email me. Full refund. No friction, no hard feelings.

Why I wrote this
strange little book.

I'm Rob Conery. I've been building software for 25 years, mostly without a clue what I was doing - and definitely without a CS degree. I've worked at Microsoft, with Visa, Google, Starbucks, PayPal. I co-founded Tekpub. None of that taught me Postgres.

I learned Postgres because I had real questions and a real database in front of me. That's what works. So I sat down to write the book I wished had existed: one that gives you a problem worth solving, then hands you the database to solve it with.

Cassini was that problem for me. The data is real. The mission is real. The story I built around it isn't - but the SQL is, and that's the part you'll keep.

Built and shipped for
MicrosoftVisaGoogleStarbucksPayPalPluralsight
Final transmission · A Curious Moon

Find out what's down there.
Learn Postgres on the way.

$30 for the EPUB and PDF. The mission archive is included. 30 days to refund, no questions asked.

Begin the assignment - $30
Stripe checkout · EPUB + PDF · refund anytime in 30 days