View this email in your browser

Programmer Weekly

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

Quote of the Week

"Design patterns should not be applied indiscriminately. Often they achieve flexibility and variability by introducing additional levels of indirection. A design pattern should only be applied when the flexibility it affords is actually needed." - Erich Gamma

Reading List

(Almost) Every infrastructure decision I endorse or regret after 4 years running infrastructure at a startup
The article discusses the author's experience leading infrastructure at a startup for four years, detailing major decisions made and whether they are endorsed or regretted. The author specifically endorses picking AWS over Google Cloud due to better support, stability, and minimizing backwards incompatible API changes.

What if an SQL Statement Returned a Database?
This paper challenges the conventional limitation in SQL where each statement returns a single table, suggesting that this design choice leads to issues like slow query performance and complexity for users and architects. The authors propose an extension to the SELECT clause, introducing 'RESULTDB' to support returning a result database, offering benefits such as simpler code, improved query performance, and smaller results. The paper discusses the potential advantages and provides insights on integrating this feature into existing closed and open-source database systems, supported by an initial experimental study.

Why Bloat Is Still Software’s Biggest Vulnerability
A 2024 plea for lean software.

What’s new in the Postgres 16 query planner / optimizer
In this post, assuming you’ve already got a handle on the basics of EXPLAIN, you’ll get a deep dive into the 10 improvements made in the PostgreSQL 16 query planner. For each of the improvements to the PG16 planner (the planner is often called an optimizer in other relational databases), you’ll also get comparisons between PG15 and PG16 planner output—plus examples of what changed, in the form of a self-contained test you can try for yourself.

Should you Stay Technical as an Engineering Manager?
Navigating the Balance Between Engineering Management and Technical Expertise.

The Many Ways to Deploy a Model
There are many ways to deploy models and perform inference. Here, we share our decision rubric for model deployments using LLM inference as an example.

Introducing SafeTest: A Novel Approach to Front End Testing
In this post, we’re excited to introduce SafeTest, a revolutionary library that offers a fresh perspective on End-To-End (E2E) tests for web-based User Interface (UI) applications.

Improve your SQL skills X2 in 5 minutes
SQL for managers is an underrated skill.

Watch and Listen

SmugMug's Cloud Adventure with Andrew Shieh
Andrew Shieh shares the thrilling story of SmugMug’s bold leap into AWS’s cloud technology, marking it as one of the pioneering companies to harness the cloud for digital photography storage. This episode offers a unique perspective into the type of strategy and groundbreaking tech advancements that catapulted SmugMug’s success.

Learn SvelteKit – Full Course for Beginners
Learn everything you need to know about SvelteKit & TailwindCSS by building a beginner friendly landing page (that also looks awesome!).

Interesting Projects, Tools and Libraries

LLRT
LLRT (Low Latency Runtime) is an experimental, lightweight JavaScript runtime designed to address the growing demand for fast and efficient Serverless applications.

inox
Inox is single-binary platform that will contain all you need to develop, test, and deploy web apps that are primarily rendered server-side. Applications are developped using Inoxlang, a sandboxed programming language that deeply integrates with several components.

Leo
Leo is a functional, statically-typed programming language built for writing private applications.

unlazy
Universal lazy loading library for placeholder images leveraging native browser APIs.

kubetail
Kubetail is a web-based, real-time log viewer for Kubernetes clusters.

GitButler
Git branch management tool, built from the ground up for modern workflows.

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 193

Programmer Weekly

Older messages

Programmer Weekly - Issue 192

Programmer Weekly - Issue 191

Programmer Weekly - Issue 190

Programmer Weekly - Issue 189

Programmer Weekly - Issue 188

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