ost

A three-hour PyCon 2016 tutorial by Christophe Pettus that orients Python developers to PostgreSQL. It covers installation, administration, and use, including vacuuming, MVCC, replication and backups.

Matt Risinger covers installing a Zehnder ERV fresh-air system in a tight passive house, explaining balanced ventilation, the benefits of heat recovery and the costs involved.

LifebyMikeG lists 15 common mistakes beginner sourdough bakers make, with advice on fixing sticky, wet dough and other issues.

Markus Triska tours Prolog's most distinctive features, including its use as a database and query language, rule processing, constraint solving and compile-time rewriting. It also covers concise meta-interpreters.

A two-minute Rouxbe cooking-school demo of how to heat a pan properly before cooking. It uses the Leidenfrost effect, where water beads and skates across a hot pan, to show when a stainless steel pan is ready.

Acerola explores building a shader that turns games into ASCII art, walking through techniques such as brightness mapping and edge detection to see whether it looks good.

A three-minute Emacs Rocks screencast by Magnar Sveen demonstrating paredit, which edits Lisp code structurally as a tree of s-expressions rather than characters.

Jacques Pepin demonstrates deboning a whole chicken, quickly and with complete control. It is a short, wordless-feeling technique demo that shows a skill most cooks never learn.

Inigo Quilez live-codes a painting using only mathematics in a shader, building it up step by step. The linked Shadertoy source shows the result.

The Thought Emporium shows how to receive clear images directly from GOES-15, 16 and 17 and Himawari 8 geostationary weather satellites with software-defined radio. It covers the extra effort needed to receive GOES data.

The Townsends channel shows how to make mushroom ketchup, a popular 18th-century sauce, in period style. It includes the history and a recipe and links to a blog post on whether George Washington used ketchup.

Dodoid gives an in-depth look at an SGI Onyx RealityEngine2, a $250,000 graphics supercomputer from 1993, covering its history, a physical overview, a teardown and some demos and games.

Ben Krasnow of Applied Science uses an antique 4x5 view camera to make high-resolution photolithography masks in a home shop. He photographs a poster-sized printout onto litho film to get features around 20 microns.

A step-by-step guide to building a lifter, a small triangular ionocraft made from balsa wood, aluminum foil and thin wire, powered by a high-voltage supply. It also shows high-voltage safety practices.

Andreas Kling live-codes a prototype JavaScript JIT compiler for the LibJS engine used in SerenityOS and Ladybird. He builds a standalone bytecode VM, a simple interpreter, and then a simple JIT in about 80 minutes.