The Daily Index — Wednesday, February 7, 2024 · TLDR Index

ARTICLES & TUTORIALS

TLDR Web Dev

TLDR Web Dev

HOW MUCH UPTIME CAN I AFFORD?

Engineering for 99.5% uptime is much more cost-effective than 99.99% for most startups. This is because in order to achieve that level of reliability, you will need specialized architecture, redundant infrastructure, and streamlined operational and organizational procedures. The cost comes in terms of system complexity, the number of engineers required and their specializations, experience levels, and corresponding salaries, as well as significantly increased operational costs and arrangements. 99.99% guaranteed uptime must be 50 times as reliable as one with "only" 99.5%.

world.hey.com · 6 min

TLDR Web Dev

WE MIGHT WANT TO REGULARLY KEEP TRACK OF HOW IMPORTANT EACH SERVER IS

A significant air conditioning failure in a machine room led to the need to power off machines to prevent overheating. Deciding which machines to turn off was not straightforward. Maintaining documentation on the importance of each machine and its dependencies is helpful for situations like these. While this documentation takes a lot of effort, it also helps engineers understand the system's connections and dependencies, making it a valuable resource in case of future failures.

utcc.utoronto.ca · 2 min

TLDR Web Dev

WHY IS THE MOUSE CURSOR SLIGHTLY TILTED AND NOT STRAIGHT? (STACK EXCHANGE POST)

The mouse and mouse cursor was invented by Douglas Engelbart. It was initially an arrow pointing up. However, screens back in the day had a low resolution, so having a tilted cursor was more recognizable. This was first seen in the XEROX PARC machine.

ux.stackexchange.com

TLDR Web Dev

HOW SLOW IS SELECT * ?

"SELECT *" SQL queries fetch all columns from a row-store database. This is often quite slow due to issues like index-only scans, deserialization cost, external storage for large columns, network cost, client deserialization, and unpredictability. Selecting only the necessary columns avoids unnecessary overhead and leads to faster, more efficient queries.

medium.com · 4 min

TLDR Web Dev

INTRO TO WEB MONETIZATION

The Web Monetization API simplifies online payments for website users and owners by allowing visitors to pay a chosen amount directly to websites using a browser extension or native browser support. With the API, website owners no longer need to integrate multiple payment methods and currencies. Instead, they can merely signal their acceptance of payments in code, and browsers would facilitate the payment process.

webmonetization.org · 4 min

TLDR Web Dev

POSTGRES IS ENOUGH

A list of GitHub repositories that demonstrate how PostgreSQL can be used for everything, including access control, audit logs, authorization, time-series data, graph data, data visualization, and more.

gist.github.com · 1 min

TLDR Web Dev

SQL FOR DATA SCIENTISTS IN 100 QUERIES

Notes and working examples of common SQL queries.

gvwilson.github.io · 48 min

TLDR Web Dev

WHAT IS A HARD ERROR, AND WHAT MAKES IT HARDER THAN AN EASY ERROR?

In Windows, "hard errors" are error messages generated from within the I/O system, below the user interface level. Hard errors of this type disappeared in 32-bit Windows - the term "hard error" has been repurposed to describe other critical low-level error messages.

devblogs.microsoft.com · 1 min

TLDR Web Dev

YOUR REFERRAL LINK - https://tldr.tech/webdev?ref=2613930

Summary unavailable

tldr.tech