View this email in your browser

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

Build your own SQLite, Part 1: Listing tables
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.

Advanced Terminal Tips and Tricks
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.

How we sped up Notion in the browser with WASM SQLite
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.

Odin: Uber’s Stateful Platform
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.

Toolbox languages
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.

How Canva collects 25 billion events per day
The architecture of our product analytics event delivery pipeline.

Traefik vs. NGINX: Comparison and Practical Guide
Explore the pros, cons, and unique characteristics of Traefik vs. NGINX for Kubernetes.

Postgres sequences can commit out-of-order
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

CrowdStrike IT Outage Explained by a Windows Developer
Dave explains the Crowdstrike IT outage, focusing in on its role as a kernel mode driver.

Beyond the Hype: A Realistic Look at Large Language Models
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.

Self Hosting: Reverse Proxy Servers
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.

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

Interesting Projects, Tools and Libraries

Mem0
The memory layer for Personalized AI.

NativeLink
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.

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

git-spice
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.

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

Mako
An extremely fast, production-grade web bundler.

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

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

Kardinal
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

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 215

Programmer Weekly

Older messages

Programmer Weekly - Issue 214

Programmer Weekly - Issue 213

Programmer Weekly - Issue 212

Programmer Weekly - Issue 211

Programmer Weekly - Issue 210

You Might Also Like

Recording: 'Data Storytelling: What Organizations Need to Know Going Into 2025'

💻 Issue 437 - Introducing local Azure Service Bus Emulator

💎 Issue 444 - Why did people rub snow on frozen feet? (2017)

💻 Issue 444 - JavaScript Dos and Donts

📱 Issue 438 - Reverse Engineering iOS 18 Inactivity Reboot

💻 Issue 362 - React Anti-Pattern: Stop Passing Setters Down the Components Tree

💻 Issue 444 - Building simple event-driven applications with Pub/Sub

📱 Issue 441 - Shift Left Is the Tip of the Iceberg

💻 Issue 439 - Async/Await Is Real And Can Hurt You

📲 Why I Ditched Linux for Samsung DeX — Buy This Instead of a Gaming Headset