Programmer Weekly (Issue 173 September 21 2023)

Programmer Weekly - Issue 173

September 21, 2023

Programmer Weekly

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

Quote of the Week

 

“Beyond basic mathematical aptitude, the difference between good programmers and great programmers is verbal ability.” - Marissa Meyer

News

Codacy Pioneers is a program for individuals involved in creating, maintaining and contributing to open source code. As part of the program, Pioneers will receive mentorship from top OSS developers, financial support, promotional resources, and free tooling. 

Wiz Research found a data exposure incident on Microsoft’s AI GitHub repository, including over 30,000 internal Microsoft Teams messages – all caused by one misconfigured SAS token.

Reading List

In this four-part series, learn how to fine-tune your PostgreSQL database for performance as your data and query volume grow—starting with properly sizing your CPU and memory.

  • Part II: Key Parameters - A deep dive into the key parameters to improve your PostgreSQL performance tuning and scale your database.

Proper support for sum types or tagged unions have become table stakes for systems programming languages. However, they can incur a lot of memory fragmentation that's not trivial to avoid without good support for metaprogramming. This post goes into Zig's powerful comptime feature, and how it allows some radical approaches to efficient data structure design.

If you build a state machine on top of a relational database you can abstract concurrency problems away from your business logic and allow developers to write safe-by-default code without dealing with concurrency concerns. This post explains how to build a library that offers those protections, and how they work under-the-hood.

This post will focus primarily on the Postgres psql implementation when performing a COPY command and will stop short of diving into the internals of Postgres’ API layer, libpq. libpq is a set of library functions that allow client programs to pass queries to the PostgreSQL backend server.

This article shows how to adopt Graph, an abstract data structure, for risk identification and anomaly discovery for ATO fraud risk.

Working with data at rest is where Postgres shines. But what about when you need data in motion? What about when you need to trigger a workflow based on changes to a table? Fortunately, Postgres comes with a lot of options to make this happen.

This article discusses MongoDB's new query engine, highlighting its improved performance and advanced optimization techniques, offering insights into the technology's benefits and features.

SSH keys provide an essential layer of security when working with remote servers, but they're often overlooked. In this guide, we'll walk through SSH key management to simplify and enhance the security of your development workflow.

Watch and Listen

This talk will explore the key design aspects of Swift that make it uniquely suitable for integration into existing code bases. It will demonstrate how we’ve made use of Swift’s nascent C++ interoperability feature to bring Swift’s safety and expressiveness to large, established C++ code bases without massive rewrites. Along the way, we’ll reflect on lessons learned from our rollout of a new, memory-safe language throughout a large software ecosystem, in the hope that it can help the C++ community chart a path forward to a memory-safe future.

This video explores the fundamentals to master database schema management using Atlas Kubernetes Operator. Learn how to efficiently manage your database schemas in a Kubernetes environment, improving scalability and reducing maintenance efforts.

Dr. Leo Porter and Dr. Daniel Zingaro, co-authors of "Learn AI-Assisted Python Programming," discuss how large language models like GitHub Copilot enhance programming education by minimizing syntax errors, easing API memorization, and promoting manual test case writing. They also address ethical concerns surrounding commercial tools and express confidence in students' responsible use of LLMs without fear of cheating.

In this episode, Developer Advocate and seasoned IT industry veteran Nicolas Frankel shares effective strategies for API evolution, delving into the complexities of API design and uncovering the pivotal role of API gateways in modern architectures.

Interesting Projects, Tools and Libraries

Open-source toolkit to build an AI copilot for SaaS products.

HyperDX helps engineers figure out why production is broken faster by centralizing and correlating logs, metrics, traces, exceptions and session replays in one place. An open source and developer-friendly alternative to Datadog and New Relic.

Catala is a domain-specific language for deriving faithful-by-construction algorithms from legislative texts.

A proto-database inspired by SQLite, written in C for educational purposes.

Local-first sync layer for web and mobile apps. Build reactive, realtime, local-first apps directly on Postgres. 

A collaborative digital whiteboard.

A curated list of awesome things related to Bun.

A faster CSV parser in 5KB (min).

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.