TL;DR summary of stories on the internet
be commonly determined by SELECTing from other tables or modifying data in target tables. First, let’s start with a FOREIGN KEY constraint creation: begin;alter table t1 add column c123 int8;alter table t1 add constraint fk_c123 foreign key(c123) references t0(id);commit; This code demonstrates a typical failing scenario. If the table t1 has many rows, and table […]
Read more »
The author is developing an emulator for the AT&T UNIX PC, and it currently boots the 3B1 UNIX operating system. Thanks to the hard work of many individuals, the emulator can run a wide range of software, including the C compiler and MGR windowing system. Serial ports, printer port, and modem are not yet emulated, […]
The author reminisces about one of the first programs they wrote: a Java program to find valid English crossword fills given a grid pattern. Surprisingly, the jar file was still accessible on MediaFire in 2024, and the program ran successfully on a 2023 MacBook Air. The program uses beam search and Java Swing for the […]
This DIY guide will walk you through creating your own lathe at home, proving that with a little creativity and determination, anything is possible. Be prepared to be impressed by the ingenuity and resourcefulness of the human mind. Whether you’re a seasoned DIY enthusiast or a complete novice, this project will inspire you to take […]
The author explores the concept of using a flute as a controller for a mouse cursor in a first person shooter game. They developed a microcontroller-based solution called Pitch perfect pointer positioning (PiPePoPo) that allows a musician to control mouse movements based on pitch detection when playing a flute. The hardware solution involves using an […]
PySheets is a powerful tool that provides a spreadsheet UI for Python, allowing users to perform data analysis, create visualizations, import Excel sheets, and collaborate with team members. The unique feature of PySheets is that all Python code runs in the browser, eliminating the need for setting up kernels or expensive cloud costs. Users can […]
Jon Crispin was allowed to photograph artifacts from the now-closed Willard Asylum for the Insane, where patients’ personal belongings were found in storerooms. The suitcases, trunks, and crates contained ordinary objects that offered glimpses into the lives of the forgotten individuals who lived at the asylum. Photographer Jon Crispin’s detailed photographs of these objects reveal […]
In the early ’80s, music tech faced hardware and software incompatibility issues. Synth pioneers like Moog, ARP, and Sequential Circuits were racing to make synths more affordable and compact. The introduction of CV/Gate system allowed synths to play themselves, changing the music composition game. Dave Smith of Sequential Circuits proposed the Universal Synthesizer Interface, later […]
In the battle over the “flow state” of developers, the need for uninterrupted focus clashes with the necessity of external interruptions. The concept of “flow state” has evolved from its origins with Hungarian-American psychologist Mihaly Csikszentmihalyi in the 1970s to encompass various associations today. Developers often struggle with fragmented thinking that disrupts their flow state, […]
The author discusses their transition from writing visual non-interactive tutorials to creating interactive tutorials on pathfinding, particularly focusing on A*. They mention their interest in flow field pathfinding, explaining that it involves vector fields directing agents to a single destination. The author also touches on distance fields, useful in games and modeling. They discuss updating […]