RDS supported engines in AWS - Mini Project: Build & Apply

RDS supported engines

📖 Scenario: You are setting up a cloud database service using Amazon RDS. Amazon RDS supports several database engines. You want to create a list of these supported engines and then filter them based on your project needs.

🎯 Goal: Create a list of supported RDS engines, add a filter configuration, select only the engines that are open source, and finally prepare the list for deployment.

📋 What You'll Learn

Create a list variable named rds_engines with exact engine names and their open source status.

Add a configuration variable named open_source_only set to True.

Use a list comprehension to create a new list named filtered_engines containing only open source engines from rds_engines.

Add a final variable named deployment_engines that holds the filtered_engines list.

💡 Why This Matters

🌍 Real World

Cloud architects often need to select database engines supported by cloud services like Amazon RDS. Filtering engines by license type helps in compliance and cost planning.

💼 Career

Understanding how to manage and filter cloud infrastructure options is essential for cloud engineers and architects when designing scalable and compliant systems.

1

Create the initial list of RDS engines

Create a list called rds_engines with these exact dictionaries: {'name': 'MySQL', 'open_source': True}, {'name': 'PostgreSQL', 'open_source': True}, {'name': 'Oracle', 'open_source': False}, {'name': 'SQL Server', 'open_source': False}, {'name': 'MariaDB', 'open_source': True}.

AWS

# Create the list rds_engines with the specified dictionaries
# Your code here

Need a hint?

Use a list of dictionaries with keys 'name' and 'open_source'.

2

Add a configuration variable for filtering

Add a variable called open_source_only and set it to True.

AWS

rds_engines = [
    {'name': 'MySQL', 'open_source': True},
    {'name': 'PostgreSQL', 'open_source': True},
    {'name': 'Oracle', 'open_source': False},
    {'name': 'SQL Server', 'open_source': False},
    {'name': 'MariaDB', 'open_source': True}
]
# Add the open_source_only variable below
# Your code here

Need a hint?

Just assign True to the variable named open_source_only.

3

Filter the list for open source engines

Use a list comprehension to create a list called filtered_engines that includes only the engines from rds_engines where the 'open_source' key is True.

AWS

rds_engines = [
    {'name': 'MySQL', 'open_source': True},
    {'name': 'PostgreSQL', 'open_source': True},
    {'name': 'Oracle', 'open_source': False},
    {'name': 'SQL Server', 'open_source': False},
    {'name': 'MariaDB', 'open_source': True}
]
open_source_only = True
# Create filtered_engines using list comprehension below
# Your code here

Need a hint?

Use a list comprehension with a condition checking engine['open_source'].

4

Prepare the final deployment list

Create a variable called deployment_engines and assign it the value of filtered_engines.

AWS

rds_engines = [
    {'name': 'MySQL', 'open_source': True},
    {'name': 'PostgreSQL', 'open_source': True},
    {'name': 'Oracle', 'open_source': False},
    {'name': 'SQL Server', 'open_source': False},
    {'name': 'MariaDB', 'open_source': True}
]
open_source_only = True
filtered_engines = [engine for engine in rds_engines if engine['open_source'] == True]
# Assign deployment_engines to filtered_engines below
# Your code here

Need a hint?

Just assign filtered_engines to deployment_engines.