What is AWS

AWS offers several alternate databases in addition to their popular managed relational database service (RDS). These alternate databases provide different functionality and are optimized for specific use cases. One such alternate database is Amazon DynamoDB, which is a fast and flexible NoSQL database service that allows users to store and retrieve any amount of data, with low latency and predictable performance.Another alternate database offered by AWS is Amazon Neptune, which is a fast, reliable, and fully-managed graph database service that makes it easy to build and run applications that work with highly connected datasets.

What is SQlite

SQLite is a widely used embedded database management system that is known for its simplicity, reliability, and ease of use. It is a serverless, self-contained, and transactional database engine that is designed to be embedded into applications rather than run as a standalone server. SQLite databases are stored as files on disk, making them easy to backup, copy, and transport between systems. They support standard SQL syntax and are fully ACID compliant, ensuring data consistency and reliability.

AWS Vs SQlite

SQLite is a lightweight, file-based relational database management system (RDBMS) that is well-suited for small-scale projects or applications. AWS offers a wide range of database options, including relational, NoSQL, and in-memory databases, each with its own set of pros and cons. Here are some of the pros and cons of alternative AWS databases in comparison to SQLite:

Amazon Relational Database Service (RDS): Amazon RDS is a fully managed relational database service that supports multiple database engines, including MySQL, PostgreSQL, and Oracle. Pros:

Scalability: RDS can easily scale to handle a large amount of traffic and data. High Availability: RDS offers automatic failover and backup options to ensure data availability. Security: RDS offers robust security features, such as encryption at rest and in transit. Managed Service: RDS is a managed service, meaning that AWS handles the administrative tasks of the database, such as backups, updates, and maintenance. Cons:

Cost: RDS can be more expensive than SQLite, especially for small-scale projects or applications. Complexity: RDS can be more complex to set up and manage than SQLite. Amazon DynamoDB: Amazon DynamoDB is a NoSQL database that can handle large amounts of data and is designed for scalability and high availability.

AWS Databases

Amazon Web Services (AWS) provides a range of database services to meet various data storage and processing needs. Some of the popular AWS databases are:

Amazon Relational Database Service (RDS): It provides fully managed relational databases, such as MySQL, PostgreSQL, Oracle, SQL Server, and Amazon Aurora.

Amazon DynamoDB: It is a fully managed NoSQL database service that provides high performance, scalability, and automatic scaling of throughput capacity.

Amazon Neptune: It is a fully managed graph database service that enables you to store and query highly connected data sets.

Amazon DocumentDB: It is a fully managed document database service that is compatible with MongoDB workloads

How to set up RDS

Sign in to your AWS account or create a new one if you don't have an account yet.
Go to the Amazon RDS service page and click on "Create database."
Choose the database engine you want to use from the list of options. Amazon RDS supports several popular database engines, including MySQL, PostgreSQL, Oracle, SQL Server, and more.
Choose the database edition and version you want to use. Each database engine has different editions and versions available, so make sure to choose the one that best suits your needs.
Choose the instance class for your database. This will determine the amount of CPU, memory, and storage allocated to your database instance.
Configure the settings for your database instance, including the database name, master username and password, and any additional settings specific to your chosen database engine.
Choose the VPC and subnet where you want to launch your database instance. You can also choose to create a new VPC if you don't have one already.
Configure the security group settings for your database instance. This will determine which IP addresses are allowed to connect to your database instance and what ports are open for incoming traffic.
Choose any additional options you want to enable, such as automatic backups, encryption, or performance insights.
Review your settings and click on "Create database" to launch your Amazon RDS instance.

Example

Video to follow: https://www.youtube.com/watch?v=Ng_zi11N4_c

Quiz

Which of the following is not an AWS database option?

A. Amazon RDS

B. Amazon Neptune

C. SQLite

D. Amazon DynamoDB

Which of the following is a file-based, lightweight RDBMS?

A. Amazon RDS

B. Amazon Neptune

C Amazon DynamoDB

D. SQLite

Which AWS service enables you to store and query highly connected datasets?

A. Amazon Relational Database Service (RDS)

B. Amazon DynamoDB

C. Amazon Neptune

D. Amazon DocumentDB