While Model Trains

Read data blog posts.
Carefully handpicked.
Presented 3 at a time.

Optimizing Slow SQL Queries

Miguel Grinberg

How to fix the most common database performance problems, which are caused by improper indexing, along with examples for Postgres, MySQL, and SQLite.

Read it!

Confession of a so-called AI expert

Chip Huyen

"Even though I’m one of the beneficiary of this AI craze, I can’t help but thinking this will burst. I don’t know how and when, but I have this belief that the system is currently being rigged in favor of people whose resumes dotted with fancy keywords like mine, and a rigged system can’t be sustainable."

Read it!

Variance after scaling and summing: One of the most useful facts from statistics

Chris Said

"What do R2, laboratory error analysis, ensemble learning, meta-analysis, and financial portfolio risk all have in common? The answer is that they all depend on a fundamental principle of statistics that is not as widely known as it should be. Once this principle is understood, a lot of stuff starts to make more sense."

Read it!