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

Exclusive: Top SaaS Security Threats of 2025—And How to Eliminate Them

Wednesday, September 18, 2024

Learn how 39% of companies are stepping up their defenses. ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌

📳 Your Smart Home Needs Vibration Sensors — 7 Ways to Change How iOS 18 Looks

Wednesday, September 18, 2024

Also: Should You Use AI Photo Editors? How-To Geek Logo September 18, 2024 Did You Know The safety lever on a hand grenade, the lever the soldier holds down after removing the pin, but before throwing

JSK Daily for Sep 18, 2024

Wednesday, September 18, 2024

JSK Daily for Sep 18, 2024 View this email in your browser A community curated daily e-mail of JavaScript news Top 8 React Libraries for Building Beautiful and Functional UIs This article will look at

Daily Coding Problem: Problem #1560 [Medium]

Wednesday, September 18, 2024

Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Google. Given a set of closed intervals, find the smallest set of numbers that covers

Nature is Healing

Wednesday, September 18, 2024

Over-Optimized Apple, John Wick AI, Snap's New Reality Nature is Healing Over-Optimized Apple, John Wick AI, Snap's New Reality By MG Siegler • 18 Sept 2024 View in browser View in browser

We tested every iPhone 16 model - buy this one

Wednesday, September 18, 2024

What I love about Pixel 9 Pro; October Prime Day; Best fitness rings -- ZDNET ZDNET Tech Today - US September 18, 2024 placeholder We've used every iPhone 16 model and here's our best buying

Charted | Visualizing S&P 500 Returns After Interest Rate Cuts 📈

Wednesday, September 18, 2024

In the past 50 years, S&P 500 returns following interest rate cuts have varied widely, from +36.5% to -36% a year later. View Online | Subscribe | Download Our App Presented by: The economy is

Top Tech Deals 👀 Garmin Smartwatch, $20 Fire TV Stick, Power Banks, and More!

Wednesday, September 18, 2024

Get a discounted mechanical RGB keyboard, Sony FE lens, portable chargers, and other must-haves. How-To Geek Logo September 18, 2024 Top Tech Deals: Garmin Smartwatch, $20 Fire TV Stick, Power Banks,

⚙️ Intel is trying to make a comeback

Wednesday, September 18, 2024

Plus: Microsoft is launching new AI centers in the Middle East ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌

Whiskey: The Tangible Asset for Your Portfolio

Wednesday, September 18, 2024

Most people fail to diversify their investments. They invest all their money in intangible assets like stocks, bonds, and crypto. The solution - fine whiskey. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏