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!

Automated text extraction at Bolt

Francesco Pochetti

A comprehensive explanation of the system implemented at Bolt to extract text from ID documents.

Read it!

Data Analysis at the Command Line

@lucytalksdata

Using csvkit, grep, gnuplot, and other command-line tools to perform data analysis directly from the command line.

Read it!