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.

A walkthrough of installing Synapse, Riot and Jitsi from scratch on Debian to run your own Matrix communication service. The description warns it is now quite outdated and links to updated material.

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 guide to using YouTube's Content ID by claiming your own videos through a distributor, so the claims share revenue with the creator and monetize re-uploads. It credits another creator who pioneered the method.

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.

The Original Ace shows how creators can use a third-party music distributor to file Content ID claims on their own videos, turning false-claim abuse into a share of ad revenue. It also names distribution companies and their revenue splits.

A step-by-step tutorial on making a Harry Potter by Balenciaga style AI video, using tools such as ChatGPT, Midjourney and Eleven Labs for script, images and voices.

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.

Imphenzia's 83-minute tutorial covers the low poly modeling techniques he learned over five years of Blender use, with timestamps from navigation and extrusion onward. It uses Blender 2.83 with default keys.

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.

Loopop reviews the Polyend Tracker hardware tracker-style sequencer and walks through a tutorial from sampling to finishing a song. It covers most of the device's features.

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.

GE Lighting's official how-to for factory resetting C by GE smart bulbs, using a long sequence of precisely timed on and off cycles.

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.