Supported by majority of languages including Node.js, Python, Java, Go, C#, C++
Query language
Supported query language such as SQL, MQL, PartiQL,
SQL
PartiQL (JSON like syntax)
ACID compliant
ACID is a set of properties of database transactions intended to guarantee data validity despite errors, power failures, and other mishaps
ACID compliant
ACID compliant
Self-hosting
Support for self-hosted Database instance
Doesn't have support, Only for local development
Doesn't have support, Only for local development
Backups
Backups run every hour automatically. Stores backups of your database in R2
Point-in-time recovery (PITR) provides continuous backups of your DynamoDB table data. When enabled, DynamoDB maintains incremental backups of your table for the last 35 days until you explicitly turn it off.
Security & Compliance Offerings
SOC2
Multi-factor authentication
Support of the cloud-histed database for multi-factor authentication
Encryption
Cryptographic security at rest and on transportation level
N/A
All your data in DynamoDB is encrypted in transit, HTTPS, TLS
SSO
N/A
Monitoring and analytics
Log retention
Query log retention usually keeps lofs of operations for debugging and replication purposes
N/A
AWS CloudTrail for operation logs
Statistics
Tools and APIs for analysing and monitoring of Database performance