View this email in your browser

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 is sponsoring open source developers by offering $500/month for a year
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.

38TB of data accidentally exposed by Microsoft AI researchers
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

PostgreSQL Performance Tuning, Part I: How to Size Your Database
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.

When Zig Outshines Rust - Memory Efficient Enum Arrays
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.

Use your database to power state machines
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.

What actually happens when you COPY in Postgres?
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.

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

All the ways to capture changes in Postgres
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.

Inside New Query Engine of MongoDB
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 Key Management: Simplify Your Development Workflow
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.

How to Interview Software Developers as a Software Developer

Tracing: structured logging, but better in every way

JPEG and EXIF Data Manipulation in Javascript

Watch and Listen

Introducing a Memory-Safe Successor Language in Large C++ Code Bases
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.

Kubernetes? Database Schema? Schema Management with Atlas Operator
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.

SE Radio 582: Leo Porter and Daniel Zingaro on Learning to Program with LLMs
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.

Nicolas Frankel on Navigating API Complexity
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

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

HyperDX
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
Catala is a domain-specific language for deriving faithful-by-construction algorithms from legislative texts.

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

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

tldraw
A collaborative digital whiteboard.

awesome-bun
A curated list of awesome things related to Bun.

uDSV
A faster CSV parser in 5KB (min).

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 © 2023 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 - Issue 172

Sunday, September 17, 2023

View this email in your browser Programmer Weekly Welcome to issue 172 of Programmer Weekly. Let's get straight to the links this week. Quote of the Week "Don't do speculative programming.

Programmer Weekly - Issue 171

Thursday, September 7, 2023

View this email in your browser Programmer Weekly Welcome to issue 171 of Programmer Weekly. Let's get straight to the links this week. Quote of the Week "There is nothing so useless as doing

Programmer Weekly - Issue 170

Thursday, August 31, 2023

View this email in your browser Programmer Weekly Welcome to issue 170 of Programmer Weekly. Let's get straight to the links this week. Quote of the Week "To be a programmer is to develop a

Programmer Weekly - Issue 169

Thursday, August 24, 2023

View this email in your browser Programmer Weekly Welcome to issue 169 of Programmer Weekly. Let's get straight to the links this week. Quote of the Week "That which optimizes one part of the

Programmer Weekly - Issue 168

Thursday, August 17, 2023

View this email in your browser Programmer Weekly Welcome to issue 168 of Programmer Weekly. Let's get straight to the links this week. Quote of the Week "Code never lies, comments sometimes

📧 Building Async APIs in ASP.NET Core - The Right Way

Saturday, November 23, 2024

Building Async APIs in ASP .NET Core - The Right Way Read on: my website / Read time: 5 minutes The .NET Weekly is brought to you by: Even the smartest AI in the world won't save you from a

WebAIM November 2024 Newsletter

Friday, November 22, 2024

WebAIM November 2024 Newsletter Read this newsletter online at https://webaim.org/newsletter/2024/november Features Using Severity Ratings to Prioritize Web Accessibility Remediation When it comes to

➡️ Why Your Phone Doesn't Want You to Sideload Apps — Setting the Default Gateway in Linux

Friday, November 22, 2024

Also: Hey Apple, It's Time to Upgrade the Macs Storage, and More! How-To Geek Logo November 22, 2024 Did You Know Fantasy author JRR Tolkien is credited with inventing the main concept of orcs and

JSK Daily for Nov 22, 2024

Friday, November 22, 2024

JSK Daily for Nov 22, 2024 View this email in your browser A community curated daily e-mail of JavaScript news React E-Commerce App for Digital Products: Part 4 (Creating the Home Page) This component

Spyglass Dispatch: The Fate of Chrome • Amazon Tops Up Anthropic • Pros Quit Xitter • Brave Powers AI Search • Apple's Lazy AI River • RIP Enrique Allen

Friday, November 22, 2024

The Fate of Chrome • Amazon Tops Up Anthropic • Pros Quit Xitter • Brave Powers AI Search • Apple's Lazy AI River • RIP Enrique Allen The Spyglass Dispatch is a free newsletter sent out daily on

Programmer Weekly - Programmer Weekly - Issue 173

Programmer Weekly

Older messages

Programmer Weekly - Issue 172

Programmer Weekly - Issue 171

Programmer Weekly - Issue 170

Programmer Weekly - Issue 169

Programmer Weekly - Issue 168

You Might Also Like

📧 Building Async APIs in ASP.NET Core - The Right Way

WebAIM November 2024 Newsletter

➡️ Why Your Phone Doesn't Want You to Sideload Apps — Setting the Default Gateway in Linux

JSK Daily for Nov 22, 2024

Spyglass Dispatch: The Fate of Chrome • Amazon Tops Up Anthropic • Pros Quit Xitter • Brave Powers AI Search • Apple's Lazy AI River • RIP Enrique Allen

Charted | How the Global Distribution of Wealth Has Changed (2000-2023) 💰

Daily Coding Problem: Problem #1616 [Easy]

The problem to solve

Issue #568: Random mazes, train clock, and ReKill

Whats Next for AI: Interpreting Anthropic CEOs Vision