Digest #124: SQLite backed by S3
Happy New Year! 🎉 I'm excited to bring you the first newsletter of 2024, packed with great DevOps tips and tools.
This week, I'm talking about how to use Python to check database designs easily. I'll cover databases like SQL Server, Oracle, PostgreSQL, and MySQL.
Curious about which SQL features work with different databases? I've got a quick guide for that.
I'm also looking at how to use Terraform in CI/CD pipelines and how to test your Terraform setups.
For a fun way to learn about service levels and alerts, I'll introduce you to a cool visual tool.
There's more:
Moving between containers and functions on AWS.
The top 50 Terraform cloud interview questions and answers.
How to use SQS for better control over DynamoDB.
Managing Azure infrastructure using Terraform and GitLab CI/CD.
Important things DevOps teams should know for 2024.
A guide to SRE basics.
Plus, I have open-source projects to share, like a tool for checking database designs, a serverless database using S3, and a Terraform module for microservices.
Stay tuned for all these topics and more. Let's make this year a great one for learning and growing in DevOps!
Cheers,
Tutorials of the week
"Automate the schema validation process for multiple databases like SQL Server, Oracle, PostgreSQL, and MySQL databases using Python" - How to validate the database objects post-migration for multiple databases - Read more »
"SQL polyglot" - SQL Polyglot is a quick way to see if a particular SQL feature is supported in different database systems - Read more »
"CI/CD Pipeline for Terraform workflow using Amazon CodeCatalyst" - How to run Terraform workflow inside CI/CD pipeline - Read more »
"Introducing Service Level Calculator" - An interactive visual tool to learn about service levels, set meaningful SLIs and reasonable SLOs as well as alerting - Read more »
"A serverless solution for on-demand subtitle generation" - All using technologies provided by AWS - Read more »
"Take your testing to the cloud" - How to write tests, validations and checks for Terraform Cloud - Read more »
"Containers to Lambda functions" - How to transition between containers and functions on AWS - Read more »
"Step Functions re:Invented" - Testing out the new Step Function features announced at AWS re:Invent 2023 - Read more »
"Top 50 Terraform cloud interview questions and answers" - Great questions to prepare for upcoming job interview - Read more »
"Efficient Azure infrastructure management with Terraform and GitLab CI/CD" - Great hands-on tutorial! - Read more »
"Using SQS to throttle writes to DynamoDB" - The title says it all! - Read more »
"The one mistake everyone makes when using Kinesis with Lambda" - The payload captured in the OnFailure destination does not contain the event payload - Read more »
Projects of the week
1️⃣ Multi database schema validator - Learn more »
2️⃣ Analyze your AWS account's serverless resources - Learn more »
3️⃣ Terraform module to create a microservice for all purposes - Learn more »
4️⃣ AI Chatbot application to provide personalized travel recommendations using Amazon Redshift and Amazon Bedrock - Learn more »
5️⃣ Declarative permissions management for PostgreSQL - Learn more »
6️⃣ Serverless dev database: SQLite backed by S3 - Learn more »
Newsworthy stories
"Zero downtime Postgres upgrades" - Read more »
"The Guide to SRE principles" - Read more »
"What DevOps teams need to know for 2024" - Read more »
"Database Fundamentals" - Read more »