dynobase-icon
Dynobase

DynamoDB FAQ - Top 13 DynamoDB Questions Answered

Written by Rafal Wilinski

Published on 2021-05-26

What is DynamoDB used for?

DynamoDB has a variety of use cases ranging from simple key-value stores through traditional relational databases and even time series.

Is DynamoDB fast?

It depends. DynamoDB might seem slower than some in-memory stores like Redis but DynamoDB is persistent and has different use cases. It’s "the webscale" where DynamoDB outperforms all traditional relational databases. It has very predictable performance, no matter the size of your dataset, whether it’s only 1GB or 100TB, the speed of reads and writes remains the same, actually, it gets even better with scale. DynamoDB proved to be capable of serving over 45 million requests per second during Prime Day.

Does DynamoDB Support SQL?

It does! Recently DynamoDB introduced support for PartiQL - a SQL-like language for querying, modifying, and inserting data. You can learn more about SQL support for DynamoDB here. While PartiQL is just an abstraction over existing Query and Scan methods, it is helpful when transitioning from RDBMS world.

Is Redis faster than DynamoDB?

It’s comparing apples to oranges. While Redis is in-memory data store, perfect for caches or sessions store, DynamoDB is persistent NoSQL database. While Redis is superfast for small datasets, it gets pricier and pricier. While you probably won't use Redis as persisent datastore for e.g. e-commerce shop, DynamoDB is perfect for that. Amazon boasts about using DynamoDB for all of their Tier-1 services (e.g. Amazon.com or Kindle store).

Is DynamoDB serverless?

Yes, DynamoDB is truly “serverless” in a sense that you don’t have to manage it or patch and care about underlying servers or software that it runs on. It’s fully administered by AWS and all you need to do is just use it using CLI or SDK.

Is DynamoDB highly available?

Yes, DynamoDB is both highly available, scalable, and distributed data store. It achieves that by sharding your data over dozens of servers and does that automatically for you without dev or ops intervention.

Is DynamoDB columnar database?

No. If you’re looking for a columnar database, consider using Redshift.

When to use DynamoDB vs S3?

While S3 is object storage, DynamoDB is NoSQL database. S3 is more suitable for storing large files durably while DynamoDB is rather Key-Value store optimized for huge amount of data and concurrent operations.

Does DynamoDB support atomic updates?

Yes, DynamoDB like many other databases support transactions. With TransactGetItems and TransactWriteItems you can read/write up to 25 items per transaction.

Is DynamoDB eventually consistent?

There are two modes that user can use when working with DynamoDB: - Strong Consistency (Read-after-Write) - Eventual Consistency

Which AWS regions support DynamoDB?

DynamoDB is available in the following 19 regions:

  • US East (Ohio) us-east-2
  • US East (N. Virginia) us-east-1
  • US West (N. California) us-west-1
  • US West (Oregon) us-west-2
  • Asia Pacific (Hong Kong) ap-east-1
  • Asia Pacific (Mumbai) ap-south-1
  • Asia Pacific (Osaka-Local) ap-northeast-3
  • Asia Pacific (Seoul) ap-northeast-2
  • Asia Pacific (Singapore) ap-southeast-1
  • Asia Pacific (Sydney) ap-southeast-2
  • Asia Pacific (Tokyo) ap-northeast-1
  • Canada (Central) ca-central-1
  • Europe (Frankfurt) eu-central-1
  • Europe (Ireland) eu-west-1
  • Europe (London) eu-west-2
  • Europe (Paris) eu-west-3
  • Europe (Stockholm) eu-north-1
  • Middle East (Bahrain) me-south-1
  • South America (São Paulo) sa-east-1

Is DynamoDB a memory store?

While DynamoDB is not in-memory store, DynamoDB Accelerator (DAX) is an in-memory cache supplementing DynamoDB tables that delivers fast read performance for your tables at scale by enabling you to use a fully managed in-memory cache.

How to Add a Column in DynamoDB?

DynamoDB doesn't have a concept of columns. Each item consists of a Key and the attributes. Because it's a NoSQL database and doesn't have a strict schema, each item can have a different set of attributes, you can write whatever you like in each operation.

Dynobase is a Professional GUI Client for DynamoDB

Start your 7-day free trial today

Product Features

© 2021 Dynobase

+
Still using AWS DynamoDB Console?
Try Dynobase to accelerate your DynamoDB workflow. Start your 7-day free trial today.