TLDR Web Dev 2024-04-30

An S3 bucket can lead to a massive AWS bill, even when it's empty. AWS charges for all S3 requests, including unauthorized ones (4xx errors), meaning someone trying to mistakenly write to your bucket still incurs costs for you. Misconfigured open-source tools and S3 requests without a specified region can also create unexpected costs that add up.

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.

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.

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.

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.

A simple tool written in Python for measuring Internet performance at home. It measures several performance metrics such as packet loss, latency, jitter, and DNS performance. It also aggregates these metrics into a common score, which you can use to monitor the overall health of your internet connection.

Threlte is a 3D framework for the web. It combines the simplicity of Svelte and the power of Three.js to allow devs to quickly create 3D apps online.

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.

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.

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

The ML engineer that posted the Upwork task in the demo of Devin AI has responded saying that Devin did not solve his project.

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.