Welcome to this week’s edition of the DevOps Bulletin!

This week, learn how to keep your MySQL databases running smoothly and explore how Linux containers can make your systems safer. Find out how to protect your serverless apps from common security threats.

Wondering how to keep an eye on your AWS spending? We’ll show you how to set up automated reports that make it easy to track your costs. We’re also comparing different tools for managing secrets in Lambda to help you choose the best one for your needs.

Ever thought about turning images into speech or documenting your software’s architecture? We’ve got step-by-step guides that are easy to follow. We're also talking about simplifying your server management using YAML in SAM templates and setting up a PyPI mirror with Terraform so you can get Python packages anytime, even without the internet.

This week’s cool projects include FM-Leaderboarder, a tool to help you find the best AI prompts; aws-rotate-key, a simple CLI for updating your AWS keys; and Pristup, for creating quick AWS login links without needing a username and password. Check out DrawDB, an easy-to-use online tool for designing your database relationships, and Runtipi, a one-command server setup that makes it simple to start hosting your own apps.

Hot off the press, learn from OpenTofu’s mistakes in open-source development, see how Infrastructure as Code is changing, and get insights into how distributed databases work. Plus, find out about the real challenges and triumphs of moving to AWS, and catch up on the big discussions from KubeCon EU 2024 in Paris 🤝

Tutorials of the week

• MySQL—Manage Memory Usage Efficiently: Gain insights on optimizing memory for better performance in your MySQL databases.

• Building a Linux Container Using Namespaces: A practical guide to understanding and utilizing namespaces for resource isolation.

• How to Hack Serverless Applications: Explore six common attack vectors on Serverless applications and how to defend against them.

• Automate AWS Cost & Usage Reporting: Learn how to set up automated email reports for AWS cost and usage insights to better manage your cloud expenses.

• A Guide for Docker Layer Caching in GitHub Actions: Optimize your CI/CD workflows with effective Docker caching strategies.

• Ultimate Guide to Secrets in Lambda: Compare Systems Manager, Secrets Manager, Key Management Service, and environment variables for secure secret handling.

• Image-to-Speech Pipeline: Step-by-step guide to building a backend for visual assistant applications using AWS services.

• Event-Driven Architecture Documentation: Utilize EventCatalog to document your events, services, and domains.

• Using Step Functions to Handle Feature Flags: Implement feature flags in your deployments to enhance product release control.

• Using YAML Anchors and Aliases in SAM: Simplify your SAM templates using YAML features to avoid redundancy.

• Replacing Complicated Hashmaps with SQLite: Streamline data handling by replacing complex hashmaps with a SQLite database.

• Setting Up a PyPI Mirror in AWS with Terraform: Ensure your Python packages are always accessible, even without internet access.

• Architecting Scalable Data Analytics: Build a basic web service using AWS tools for efficient data analytics.

Projects of the week

Highlighting cool DevOps projects to keep an eye on:

• FM-Leaderboarder allows you to create a leaderboard to find the best LLM/prompt for your business use case based on your data, task, and prompts.

• aws-rotate-key is an open-source CLI that simplifies the rotation of access keys defined in your credentials file.

• Pristup generates temporary AWS Console sign-in URLs for users without permanent credentials.

• DrawDB is a robust and user-friendly database entity relationship (DBER) editor right in your browser.

• Runtipi is a home server for everyone! One command setup, one-click installs for your favorite self-hosted apps.

• Piku, inspired by dokku, allows you do git push deployments to your servers, no matter how small they are.

Newsworthy Stories

Stay informed with the latest news impacting the DevOps and SRE world:

• OpenTofu may be showing us the wrong way to fork

• Infrastructure as Code is dead

• How do distributed databases handle secondary indexes?

• Poor architecture decisions when migrating to the cloud

• Journey to the center of our AWS migration battle

• KubeCon EU 2024 Paris: key takeaways

• How we’ve saved 98% in cloud costs by writing our database?

SQLite in Production?

This Hacker News post "Ask HN: SQLite in Production?" is about using SQLite for apps. The person who started the discussion says SQLite made their app much faster than using Postgresql but wonders about using it for bigger apps.