Programmer Weekly (Issue 215 July 25 2024)

Programmer Weekly - Issue 215

July 25, 2024

Programmer Weekly

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

Quote of the Week

 

"Profanity is the one language all programmers know best." - Anonymous

Reading List

As developers, we use databases all the time. But how do they work? In this series, we'll try to answer that question by building our own SQLite-compatible database from scratch. As an introduction, we'll implement the simplest version of the tables command, which lists the names of all the tables in a database. While this looks simple, we'll see that it requires us to make our first deep dive into the SQLite file format.

The article offers advanced terminal tips for software developers, highlighting productivity boosters like command line editing, tmux scripting, and using fzf in custom scripts. It also suggests using /dev/stdin for heredoc-like functionality and SSH multiplexing for improved remote connections.

Notion improved their browser performance by using WebAssembly (WASM) with SQLite for data caching, resulting in a 20% faster page navigation. They implemented a SharedWorker-powered architecture to manage concurrency and prevent database corruption, enhancing the user experience even for those with slower internet connections.

This post is the first of a series on Uber’s stateful platform and provides an overview of Odin’s origins, the fundamental principles, and the challenges encountered early on. 

A toolbox language is a programming language that’s good at solving problems without requiring third party packages. My default toolbox languages are Python and shell scripts, which you probably already know about. Here are some of my more obscure ones.

The architecture of our product analytics event delivery pipeline.

Explore the pros, cons, and unique characteristics of Traefik vs. NGINX for Kubernetes.

The post discusses how PostgreSQL sequences can commit out of order due to the multi-version concurrency control (MVCC) system it uses. This means that while PostgreSQL is strongly consistent, sequences might not appear so from the client's perspective, potentially causing unexpected behavior in applications relying on strictly ordered sequence numbers. The analysis includes how this out-of-order issue can be problematic, particularly when accurate time-based ordering is critical, such as in logs or events systems​

Watch and Listen

Dave explains the Crowdstrike IT outage, focusing in on its role as a kernel mode driver. 

The talk aims to cut through the hype around large language models (LLMs) by exploring their current applications, risks, and limitations. It traces the development from early AI research to today's advanced models, clarifies misconceptions about their intelligence, and demonstrates practical uses that leverage their natural language strengths.

Discussion on what reverse proxy servers are, popular options, and various use cases like combining multiple apps and servers, handling SSL, security, serving static assets, and local development.

Learn how to build a 4 node Kubernetes cluster and fit it in an Apple G4 Cube case.

Interesting Projects, Tools and Libraries

The memory layer for Personalized AI.

NativeLink is an open source high-performance build cache and remote execution server, compatible with Bazel, Buck2, Reclient, and other RBE-compatible build systems. It offers drastically faster builds, reduced test flakiness, and specialized hardware.

The tiniest PaaS you've ever seen. Piku allows you to do git push deployments to your own servers.

git-spice is a tool for stacking Git branches. It lets you manage and navigate stacks of branches, conveniently modify and rebase them, and create GitHub Pull Requests from them.

The open source, local-first Webflow alternative. Design directly in your live React site and publish your changes to code.

An extremely fast, production-grade web bundler.

Tabby is a self-hosted AI coding assistant, offering an open-source and on-premises alternative to GitHub Copilot.

AI-powered CLI assistant for troubleshooting DevOps-related issues.

Kardinal is the lightest-weight way to spin up dev and test environments in Kubernetes. Deploy the absolute minimum resources necessary and implement dev, test, and QA all in one cluster.

Our Other Newsletters

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

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