The Daily Index — Tuesday, April 30, 2024 · TLDR Index

ARTICLES & TUTORIALS

TLDR Web Dev

TLDR Web Dev

COMMON DB SCHEMA CHANGE MISTAKES

Database schema changes are complex and mistakes can cause errors or downtime. This article goes over 18 different schema change mistakes, including common ones like leaving accidental changes in the schema or failing to acquire locks. It also goes over more complex, specific mistakes and how to not make them by following best practices.

links.tldrnewsletter.com · 26 min

TLDR Web Dev

WHY SQLITE USES BYTECODE

SQLite uses bytecode to represent prepared SQL statements. This is because bytecode is easy to print and review. It also makes debugging easier because it separates the SQL parsing stage from the SQL execution stage. As SQLite is designed to run within the same process as the application, bytecode allows SQL statements to be executed step-by-step.

links.tldrnewsletter.com · 6 min

TLDR Web Dev

ASK HN: WHAT WAS THE JOB MARKET LIKE DURING THE DOT-COM CRASH? (HACKER NEWS THREAD)

This is an old Hacker News thread where people share their experiences of the dot-com crash. At the time, developers had to try much harder to get a job and learn the “boring technologies”. Others left the tech industry completely and never came back. Most that were affected were either entry-level or near-retirement.

links.tldrnewsletter.com

TLDR Web Dev

GROUND RULES OF FAIRNESS AT WORK

Employees are motivated by fairness and transparency at work. This means managers should explain how decisions are made, how compensation works, and why recognition is awarded. They should also be as objective as possible when making decisions that affect employees.

links.tldrnewsletter.com · 5 min

TLDR Web Dev

WHAT CAN LLMS NEVER DO?

LLMs have an important limitation: they cannot truly generalize or extrapolate beyond their training set. For example, they can't solve word puzzles like Wordle because these tasks require iterative steps with memory that LLMs can't effectively manage. LLMs also fail to “think ahead” and their “thought” drifts over multiple steps of prompting.

links.tldrnewsletter.com · 30 min

TLDR Web Dev

HOW DOES LINUX START A PROCESS?

Linux starts a process first by calling the execve() system call, which provides the kernel with a path to the executable file. The kernel then prepares the new process and maps its relevant sections into memory. Then, control is passed to the program, and execution is started.

links.tldrnewsletter.com · 8 min

TLDR Web Dev

FAKING DEMOS FOR DEVS CAN COME BACK AND HURT YOU

Summary unavailable

links.tldrnewsletter.com · 2 min

TLDR Web Dev

BLOCKIN' BOTS

This author blocked AI bots from scraping their website's content by directly editing their .htaccess file to enforce the block, rather than relying solely on robots.txt.

links.tldrnewsletter.com · 3 min

TLDR Web Dev

NEW C# 12 FEATURE PROVES CONTROVERSIAL: PRIMARY CONSTRUCTORS ‘WORST FEATURE I'VE EVER SEEN IMPLEMENTED'

The new C# 12 primary constructors feature (for easier class/struct creation) is poorly implemented and less readable, according to C# devs.

links.tldrnewsletter.com · 4 min