#121: Versioning in Postgres using Git

Hey folks 👋🏻
After a short break, I'm thrilled to bring you an especially packed edition of the DevOps Bulletin:

Secure Multi-Account CI/CD
Deploy a Lambda with a static IP at no extra cost
Running LLM in AWS Lambda
Revamping AWS account access using Terraform, Granted, and GitOps
Kubernetes network troubleshooting
Postgres Versioning with Git
Execute complex queries against CSV files without needing SQL tables
Improve slow SQL queries by steering clear of the DISTINCT clause
40% reduction in compute capacity on EKS
Generating images from text using Amazon Bedrock's Stable Diffusion XL model through AWS CLI
Open Source Spotlight: This week, I'm spotlighting a security tool for Linux device activity monitoring using eBPF, a visual tool for Redis applications, and a solution for centralizing orphan resources in Azure environments.
and more!

Enjoy this week's digest!

📖 TUTORIALS OF THE WEEK

"Adopt Open ID Connect (OIDC) in Terraform for secure multi-account CI/CD to AWS" - Increase security posture with OIDC as authentication mechanism in CI/CD - Read more »

"Deploy a Lambda with a static IP for FREE" - Assign a static IP to a Lambda for free using the AWS CDK - Read more »

"Running an LLM inside an AWS Lambda Function" - Cool tutorial on running LLM inside a Lambda function - Read more »

"Overhauling AWS account access with Terraform, Granted, and GitOps" - Accessing thousands of client AWS accounts in a secure way - Read more »

"A hands-on Kubernetes network troubleshooting journey" - How to troubleshoot an unreached Kubernetes POD IP from a worker node - Read more »

"Versioning data in Postgres? Testing a git like approach" - An alternative way to achieve data versioning in Postgres using git pattern - Read more »

"Don’t use DISTINCT as a “join-fixer”" - How to improve SQL slow queries by avoiding DISTINCT - Read more »

"Everything you need to know about multi-account authentication and configuration" - The title says it all! - Read more »

"Joining CSV data without SQL" - Run complex queries against a CSV without SQL tables - Read more »

"Generate image from text using Amazon Bedrock's Stable Diffusion XL model via AWS CLI" - Generate an image from a text prompt - Read more »

"Reducing compute capacity by 40% on EKS" - Insightful podcast episode about lessons learned in adopting, rolling out and scaling EKS clusters over 7 years - Read more »

"Some miscellaneous git facts" - Short and insightful tips - Read more »

"Quickly reproducing production bug with event sourcing" - what Event Sourcing is, how to build an application with Event Sourcing, and a strategy to reproduce a production bug quickly - Read more »

"Using Vault secrets operator in Kubernetes" - How to configure VSO and includes a demonstration how it works - Read more »

🛠 PROJECTS OF THE WEEK

1️⃣ Pulsar is a security tool for monitoring the activity of Linux devices at runtime, powered by eBPF - Learn more »

2️⃣ Secretive is an app for storing and managing SSH keys in the Secure Enclave - Learn more »

3️⃣ Centralized environments, secrets, and configuration management for cloud applications and infrastructure - Learn more »

4️⃣ `yorbox` is a command-line interface (CLI) tool that helps manage tags consistently across infrastructure as code (IaC) frameworks - Learn more »

5️⃣ RedisInsight is a visual tool that provides capabilities to design, develop and optimize your Redis application - Learn more »

6️⃣ Centralize orphan resources in Azure environments - Learn more »

📰 NEWSWORTHY STORIES

"How we built a streaming SQL engine" - Read more »

"The Do’s and Don’ts for effective observability" - Read more »

"HashiCorp CEO predicts OSS-free Silicon Valley unless the open source model evolves" - Read more »

"Demystifying what’s causing AWS Config costs" - Read more »

"The FTX trial, day four: The fraud was in the code" - Read more »

"2023 State of DevOps Report: Culture is everything" - Read more »

💡 THREAD OF THE WEEK

😂 MEMES OF THE WEEK

I hope you enjoy this week’s newsletter! Share it with a friend or colleague if you find it helpful, drop me an email or send me a DM on Twitter about topics you’d like to hear about in future editions.

Remember to share if you enjoyed this issue!

Share

Forward

Digest #121: Versioning in Postgres using Git 😃

#121: Versioning in Postgres using Git

Older messages

Digest #120: Lambda Monolith 🤨

Digest #119: SRE Interview Prep Plan ✅

Digest #118: Database Migrations 🤩

Digest #117: Pre-Commit Hooks for Terraform 🤖

Digest #116: Scalability Testing on Amazon EKS 🧪

You Might Also Like

Help Shape the Future of Laravel News - Quick Survey

Data Science Weekly - Issue 579

💎 Issue 449 - JRuby with JBang

💻 Issue 449 - JavaScript Benchmarking Is a Mess

📱 Issue 443 - EU asks for views on plan to force Apple to open up iOS

💻 Issue 442 - SOLID: The Liskov Substitution Principle (LSP) in C#

Daily Coding Problem: Problem #1649 [Easy]

JSK Daily for Dec 26, 2024

📱 Issue 446 - Fatbobman's Swift Weekly #063

💻 Issue 444 - Four limitations of Rust’s borrow checker