Currently awake at 3:00 AM, fixing it

Chris
Wisecarver

Data engineer. Database whisperer. Owner of more lenses than sense, and a man who genuinely paid $999 for a monitor stand.

14Camera lenses
3Monitor stands
0Lenses needed
Open ETL tickets
Tech Specs

The Chris, in numbers

Independently verified by absolutely no one. Subject to change the moment a new Apple accessory drops.

Primary language
SQL, then regret
Coffee per incident
2.4 cups
Polishing cloths owned
1 (cherished)
Avg. pipeline uptime
Aspirational
Apple devices
All of them
Time to over-engineer
< 4 minutes
Production incidents (cause)
“It worked locally”
Battery health
Worse than the M-series
System Status

Pipeline status: Degraded

A real-time look at Chris's data platform. It has been like this for a while. It will be like this for a while longer.

wisecarver-data-platformDegraded
Last successful run: 6h 41m 18s ago
  • nightly_sync

    ran at 3 AM. Chris was there. Chris is always there.

    Fixing… maybe
  • customer_events_etl

    off by one timezone since 2021

    Degraded
  • warehouse_backfill

    12 hours in, 4% complete, full confidence

    Fixing… maybe
  • legacy_cron_job

    nobody owns it. it owns us.

    On fire
  • the_one_dashboard_that_works

    do not touch. do not breathe near it.

    Suspiciously fine

[03:14:07] retrying nightly_sync (attempt 47)…

[03:14:09] warning: schema drifted again, nobody knows why

[03:14:11] status: Fixing… maybe

Database Engineering

Indexing a 10-row table

A case study in scaling for the future. The table has ten rows. It has had ten rows since 2019. Chris added an index. Then a composite index. Then a partial index, just in case.

psql — production (allegedly)
db=# SELECT count(*) FROM users;
 count
-------
    10

db=# CREATE INDEX CONCURRENTLY idx_users_supercharged
  ON users (id, email, created_at, last_seen)
  INCLUDE (avatar_url);
CREATE INDEX

db=# EXPLAIN ANALYZE SELECT * FROM users;
Seq Scan on users  (index ignored)
Planning Time: 0.041 ms
Execution Time: 0.018 ms
-- worth it. definitely worth it.

Read performance

Improved by an unmeasurable amount, because the planner does a sequential scan anyway. Ten rows. It's ten rows.

Write performance

Four indexes to update on every insert. The table gets one insert per quarter. Robustly future-proofed.

Peace of mind

Immense. Chris sleeps soundly knowing the table is ready to scale to its inevitable eleventh row.

The Hoard

More lenses than sense

A curated selection from Chris's collection. The $19 cloth and the $5,000 lens get equal reverence. Add things to the cart. You won't buy them. Neither should he have.

Polishing Cloth

Wipes screens. Also wipes savings.

$19

Monitor Stand (no monitor)

Holds up a display. And your dignity.

$999

600mm f/4 Telephoto

For photographing birds he'll never edit.

$5,000

Tower Wheels

Four wheels. Costs more than a flight.

$699

Carbon Tripod, Mk IV

The Mk III was also fine. This is fine-er.

$1,299
8.0 TB

8TB of RAW Photos

Two are good. He keeps all eight thousand.

$2,199
Cart total$0

An empty bag. A rare moment of fiscal responsibility.

Skills & Obsessions

What he actually does all day

A balanced portfolio of genuine talent and expensive distractions.

Data engineering

Builds elegant pipelines, then spends the rest of his life keeping them upright. The pipelines are the job. The job is the pipelines.

Databases

Normalizes to 6th normal form, indexes everything that moves, and can recite query plans like bedtime stories. Knows your data better than you do.

Software development

Ships clean code, then refactors it three more times because the abstraction could be slightly more abstract.

Apple devotion

Owns the ecosystem. The whole ecosystem. Has opinions about the matte nano-texture display and is not afraid to share them.

Photography

Phenomenal taste in glass, questionable follow-through on editing. The hard drive of unprocessed RAWs is its own form of art.

Incident response

Calm under pressure at 3 AM, mostly because he has been there so many times it now feels like home.

Roast Generator

On the record

Affectionate, accurate, and entirely deserved. Press the button for another.

His tech stack has more moving parts than a Swiss watch and roughly the reliability of a chocolate teapot.
01 / 08
3 AM debugger$999 stand ownerEXPLAIN ANALYZE enjoyerRAW file hoarderschema drift survivorpolishing cloth curatorover-engineer of small tablesApple ecosystem liferlens > sense‘it worked locally’3 AM debugger$999 stand ownerEXPLAIN ANALYZE enjoyerRAW file hoarderschema drift survivorpolishing cloth curatorover-engineer of small tablesApple ecosystem liferlens > sense‘it worked locally’
Get in touch

Page him during an incident

He's almost certainly awake. The pipeline is almost certainly degraded. These two facts are related.

Need a pipeline diagnosed or a lens recommended? Same enthusiasm, either way.

Best reached after midnight. Worst reached before coffee.

Check status first

Built with love, mild concern, and one immaculately maintained polishing cloth.