View this email in your browser

Programmer Weekly

Welcome to issue 199 of Programmer Weekly. Let's get straight to the links this week.

Quote of the Week

"Optimization hinders evolution. Everything should be built top-down, except the first time. Simplicity does not precede complexity, but follows it." - Alan Perlis

Reading List

Postgres Performance Boost: HOT Updates and Fill Factor
This post reviews HOT updates, what they are, how they work, and how you can put them to use for a performance improvement.

How Figma Grows: Design Beyond Designers
From $20B to the Nth. An interview with Figma's CTO on what's next.

Optimizing Javascript for fun and for profit
The article discusses common optimization techniques for JavaScript code, emphasizing the importance of benchmarking and focusing on optimizing the most significant parts of the code to achieve performance improvements.

The "current branch" in git
The post discusses the different definitions of the "current branch" in Git, highlighting that it can refer to the branch specified in the .git/HEAD file, the branch shown by the git status command, the most recently checked-out branch, or the branch displayed in the shell's git prompt. It explores how these definitions can lead to subtle differences in understanding the current branch state, especially in certain Git scenarios.

Setting up a Remote Development Environment with Google Chrome and DigitalOcean
The article discusses the benefits of setting up a remote development environment, such as increased portability and cost savings, as well as the ability to give other developers access to your machine. It outlines the author's experience in setting up a remote development environment using DigitalOcean and Google Chrome.

Finding memory leaks in Postgres C code
This post details the author's process of identifying a memory leak in Postgres's WAL Sender process using the memleak program from the bcc tools collection. It provides insights into techniques for detecting memory leaks in running programs without requiring modifications, offering valuable guidance for memory leak investigations.

Who killed the network switch?
A Hubris Bug Story.

Building an email to calendar LLM
The post discusses creating a tool to extract actionable items from emails and add them to the calendar, aiming to enhance productivity by automating task management based on email content. It addresses the challenge of managing medium-priority actionable emails efficiently by integrating them into the user's calendar for better task tracking and completion.

The problem with using a UUID primary key in MySQL
Understand the different versions of UUIDs and why using them as a primary key in MySQL can hurt database performance.

Watch and Listen

Why Most Programmers DON'T Last
This episode emphasizes the importance of long-term thinking in software development careers, cautioning against short-term approaches. It offers eight laws for achieving lasting success as a programmer, promoting a healthy and sustainable approach to software development.

Practical TypeScript – Course for Beginners
Master TypeScript from basics to advanced concepts through hands-on tutorials covering type annotations, generics, data fetching, Zod library, and more, with practical challenges for effective real-world application.

Interesting Projects, Tools and Libraries

Lapdev
Self-Hosted Remote Dev Environment.

Kvrocks
Apache Kvrocks is a distributed key value NoSQL database that uses RocksDB as storage engine and is compatible with Redis protocol.

pgJQ
jq extension for Postgres.

Hatchify
A framework that accelerates the development of CRUD web applications.

lumentis
AI powered one-click comprehensive docs from transcripts and text.

Dropflow
A CSS layout engine.

GritQL
GritQL is a declarative query language for searching and modifying source code.

pgwire
PostgreSQL wire protocol implemented as a rust library.

Retina
eBPF distributed networking observability tool for Kubernetes.

WhatTheDuck
WhatTheDuck is an open-source web application built on DuckDB. It allows users to upload CSV files, store them in tables, and perform SQL queries on the data.

Our Other Newsletters

Python Weekly - A free weekly newsletter featuring the best hand curated news, articles, tools and libraries, new releases, jobs etc related to Python.

Founder Weekly - A free weekly newsletter for entrepreneurs featuring best curated content, must read articles, how to guides, tips and tricks, resources, events and more.

Copyright © 2024 Programmer Weekly, All rights reserved.
You are receiving our weekly newsletter because you signed up at http://www.ProgrammerWeekly.com

Our mailing address is:

Programmer Weekly

Brooklyn

Brooklyn, NY 11228

Add us to your address book

Want to change how you receive these emails?
You can update your preferences or unsubscribe from this list.

Programmer Weekly - Programmer Weekly - Issue 199

Programmer Weekly

Older messages

Programmer Weekly - Issue 198

Programmer Weekly - Issue 197

Programmer Weekly - Issue 196

Programmer Weekly - Issue 195

Programmer Weekly - Issue 194

You Might Also Like

Christmas On Repeat 🎅

SRE Weekly Issue #456

The Power of an Annual Review & Grammarly acquires Coda

Daily Coding Problem: Problem #1645 [Hard]

PD#606 How concurrecy works: A visual guide

RD#486 (React) Things I Regret Not Knowing Earlier

🎶 GIFs Are Neat, but I Want Clips With Sound — Your Own Linux Desktop in the Cloud

o3—the new state-of-the-art reasoning model - Sync #498

Sunday Digest | Featuring 'The World’s 20 Largest Economies, by GDP (PPP)' 📊

Android Weekly #654 🤖