Articles

Amazon Web Services (AWS) is the biggest cloud platform in the world, with over 200 features. In this article, we break down 10 AWS services that support at least some SQL syntax, talk about their use cases, and give examples of how to write queries.

Service Description SQL Support Use Case
RDS Postgres, MySQL, etc. Full Small-medium web apps
Aurora Serverless databases Full Serverless apps
Redshift Data warehouse Full OLAP, Petabytes of data, analytics
DynamoDB NoSQL database Some – PartiSQL Ecommerce, building fast
Keyspaces Managed Cassandra (key value) Some – CQL Messaging
Neptune Graph database Some – openCypher Social networks
Timestream Time series database Partial IOT, Logging
Quantum Ledger Cryptographically verified transactions Some – PartiSQL Finance
Athena Ad-hoc queries on S3 Some – CTAS Historical data
Babelfish MSFT SQL Server on Aurora Full .NET

The table above shows how SQL support varies between the services. A graph database cannot be queried in the same way as a classic relational database, and various subsets of SQL, like PartiQL, have emerged to fit these models. In fact, even within standard SQL, there are many SQL dialects for different companies like Oracle and Microsoft.

Source de l’article sur DZONE