1. Home
  2. Discover
  3. Technology
  4. DevOps Bulletin

Digest #121: Versioning in Postgres using Git 😃

#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 Share
Tweet Tweet
Forward Forward
Copyright © 2023 DevOps Bulletin, All rights reserved.
Want to change how you receive these emails?
You can update your preferences or unsubscribe from this list.

Older messages

Digest #120: Lambda Monolith 🤨

Thursday, October 19, 2023

Digest #120: Lambda Monolith 🤨 #120: Lambda Monolith Hey DevOps folks! 👋🏻 This week, I've got some gems for you: - You ever been tangled with multiple Git identities? Find an easy solution in this

Digest #119: SRE Interview Prep Plan ✅

Monday, October 9, 2023

Digest #119: SRE Interview Prep Plan ✅ #119: SRE Interview Prep Plan Welcome back to your favorite weekly rendezvous—the DevOps Bulletin! Have you ever been baffled by the mysterious .git directory? Or

Digest #118: Database Migrations 🤩

Monday, October 2, 2023

Digest #118: Database Migrations 🤩 #118: Database Migrations Hey there, DevOps aficionados! 👋🏻 Welcome to another week of the DevOps Bulletin. Strap in, because we've got a thrilling line-up of

Digest #117: Pre-Commit Hooks for Terraform 🤖

Monday, September 25, 2023

Digest #117: Pre-Commit Hooks for Terraform 🤖 #117: Pre-Commit Hooks for Terraform Hey there, DevOps enthusiasts! 👋🏻 We're back, and oh boy, do we have some juicy bits for you this week in the

Digest #116: Scalability Testing on Amazon EKS 🧪

Tuesday, September 19, 2023

Digest #116: Scalability Testing on Amazon EKS 🧪 #116: Scalability Testing on Amazon EKS Welcome back to your most-awaited DevOps roundup 👋🏻 As we kick things off this week, we find ourselves exploring

You Might Also Like

Re: Hackers may have stolen everyone's SSN!

Saturday, November 23, 2024

I wanted to make sure you saw Incogni's Black Friday deal, which is exclusively available for iPhone Life readers. Use coupon code IPHONELIFE to save 58%. Here's why we recommend Incogni for

North Korean Hackers Steal $10M with AI-Driven Scams and Malware on LinkedIn

Saturday, November 23, 2024

THN Daily Updates Newsletter cover Generative AI For Dummies ($18.00 Value) FREE for a Limited Time Generate a personal assistant with generative AI Download Now Sponsored LATEST NEWS Nov 23, 2024

📧 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: m​y 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

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

Friday, November 22, 2024

This graphic illustrates the shifts in global wealth distribution between 2000 and 2023. View Online | Subscribe | Download Our App Presented by: MSCI >> Get the Free Investor Guide Now FEATURED

Daily Coding Problem: Problem #1616 [Easy]

Friday, November 22, 2024

Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Alibaba. Given an even number (greater than 2), return two prime numbers whose sum will

The problem to solve

Friday, November 22, 2024

​ Use problem framing to define the problem to solve This week, Tom Parson and Krishna Raha share tools and frameworks to identify and address challenges effectively, while Voltage Control highlights