The Daily Index — Tuesday, July 2, 2024 · TLDR Index

ARTICLES & TUTORIALS

TLDR Web Dev

TLDR Web Dev

HOW SQL QUERIES WORK: SQL QUERY EXECUTION ORDER FOR TECH INTERVIEWS

A database management system parses, optimizes, and executes a SQL query in a specific order, starting with `FROM` and `JOIN` before `SELECT`. The process includes steps like tokenization, execution plan generation, data retrieval, filtering, sorting, and aggregation. Understanding this execution flow helps in writing efficient queries and optimizing database performance.

dev.to · 7 min

TLDR Web Dev

HOW I PLAN MY WEEK AS A SENIOR ENGINEER IN BIG TECH

This senior engineer uses an Excel spreadsheet to prioritize tasks based on organizational goals, feedback, and time estimates. Over three months, this helped them achieve 90%+ of their daily goals while providing a clear record of accomplishments and reducing overplanning.

read.highgrowthengineer.com · 6 min

TLDR Web Dev

PERSPECTIVE JUMPING: HOW TO FOCUS AS A SOLO-DEVELOPER

Design problems, particularly for solo developers, can be prone to fragmentation into smaller sub-problems, leading to a loss of focus on the original issue. Timeboxing alone is insufficient to combat this, as it lacks the necessary context and reasoning to refocus the developer. To effectively manage this, a solo developer can write from the perspective of different roles, like a marketer, manager, or developer, to prioritize tasks properly.

links.tldrnewsletter.com · 3 min

TLDR Web Dev

Star Dusk on GitHub

Summary unavailable

github.com

TLDR Web Dev

MY FINETUNED MODELS BEAT OPENAI'S GPT-4

This author evaluated several fine-tuned LLMs on structured data extraction from press releases and found that they outperformed OpenAI's GPT models. The evaluation process was challenging due to the different locations and interfaces of the models. While the author was pleased with the results, they also acknowledge the tradeoffs of fine-tuning LLMs, such as the need for managing data and model versions.

mlops.systems · 26 min

TLDR Web Dev

HOW GOOGLE MIGRATED BILLIONS OF LINES OF CODE FROM PERFORCE TO PIPER

Google's source control system initially relied on a single Perforce server and faced scalability issues as the company grew. To address this, Google engineers developed Piper, a distributed source control system designed for massive scale. The migration from Perforce to Piper took over four years due to the deep integration of Perforce into Google's software ecosystem and the need to avoid disrupting production. However, the migration was successful and Piper is still used at Google today.

graphite.dev · 8 min

TLDR Web Dev

A GIT STORY: NOT SO FUN THIS TIME

In 1998, Linus Torvalds, creator of Linux, was overwhelmed by the growing number of code changes from developers. The solution they found was BitKeeper, a distributed version control system. Linux adopted BitKeeper in 2002, but its proprietary nature caused friction with free software advocates. Frustrated, Torvalds started developing Git, which gained popularity and became mainstream due to GitHub.

blog.brachiosoft.com · 32 min

TLDR Web Dev

WHAT ACTUALLY HAPPENS WHEN A USER REJECTS COOKIES? (REDDIT THREAD)

Cookie Consent Manager platforms allow websites to categorize tracking scripts and obtain user consent before loading them, similar to how Tag managers function.

reddit.com

TLDR Web Dev

FOUR LINES OF CODE … IT WAS FOUR LINES OF CODE

Summary unavailable

boston.conman.org · 3 min

TLDR Web Dev

THE OARB FRAMEWORK: WHY YOU SHOULD APPEAL TO SELF-INTEREST WHEN GIVING FEEDBACK

The OARB framework (Observation, Assertion, Repercussion, Benefit) is a technique for giving feedback that focuses on appealing to the recipient's self-interest by highlighting how their behavior negatively impacts them and how changing it would benefit them.

newsletter.weskao.com · 14 min

TLDR Web Dev

SOFTWARE ENGINEER PAY BY INDUSTRY

Software engineers in the tech and finance industries have average earnings ranging from $120,000 to $160,000 and $110,000 to $150,000 respectively.

links.tldrnewsletter.com · 3 min