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

Elastic Community Newsletter

Daily Coding Problem: Problem #1646 [Medium]

GCP Newsletter #430

⏯️ Make a Holiday Guest Profile for Your Streaming Services — What Is Linux Mint?

Ranked | The Most Satisfying vs. Most Reliable Car Brands in 2024 🚙

Bitcoin Enthusiasts Are Letting Altcoins Pass by

Last Minute Gifts from Walmart

15 ways AI saved me weeks of work in 2024

Distributed Locking: A Practical Guide

⚡ THN Weekly Recap: Top Cybersecurity Threats, Tools and Tips