Programmer Weekly (Issue 193 February 15 2024)

Programmer Weekly - Issue 193

February 15, 2024

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

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.

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.

A 2024 plea for lean software.

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.

Navigating the Balance Between Engineering Management and Technical Expertise.

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.

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.

SQL for managers is an underrated skill.

Watch and Listen

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 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 (Low Latency Runtime) is an experimental, lightweight JavaScript runtime designed to address the growing demand for fast and efficient Serverless applications.

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 is a functional, statically-typed programming language built for writing private applications. 

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

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

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

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.