Skip to main content
Share Your Experience: Take the 2024 Developer Survey
10 votes

DynamoDB - Multiple range keys

Put a copy of B and C in the range field (as an extra column) and make that your range key like "B_C" and you can still also have separate columns for B and C if you need.
Jeff M's user avatar
  • 254
7 votes
Accepted

When to use multiple tables in DynamoDB?

Yes, it is legit to do what you are saying. Both are actually. There are some variables that you do not have in here and can help guide how the data model should be done. What kind of scale are you ...
Kirk's user avatar
  • 317
4 votes
Accepted

Can PostGIS or Oracle Spatial and Graph scale to hundreds of terabytes of data, or should I use a NoSQL option like DynamoDB?

You might want to consider doing some Requirements Engineering for your project. When you have all the requirements listed, then you will want to write it up in a document and have companies like ...
John K. N.'s user avatar
  • 17.9k
4 votes

Why are some write requests throttled whereas the average consumed write capacity is below the provisioned write capacity?

It doesn't have to be a hot key or partitioning issue where the total provisioned write capacity is spread across the partitions. You have a 5 minute average chart there. Technically you could have a ...
Daniel's user avatar
  • 41
3 votes
Accepted

How to update DynamoDB item by searching on GSI primary key?

What I found out is I need to get the item by GSI and then using primaryKey and sortKey update the item and cannot update item using GSI only.
Lukas Liesis's user avatar
3 votes

Storing ~700 Tb in SQL Db

Is it possible to store such Tb's in a single machine Definitely. Though that machine becomes a large single-point-of-failure. Building a petabyte scale storage system that is efficient and fault ...
David Spillett's user avatar
3 votes

How can I reuse a table name after deletion (in DynamoDB)?

Answering my own question: I waited about ten minutes and then the error went away. It appears that the name is in a cache which is periodically refreshed.
Lucas Gonze's user avatar
2 votes

Why are some write requests throttled whereas the average consumed write capacity is below the provisioned write capacity?

Perhaps your partition key badly distributes the workload between the items. Or you may be doing multiple writes into the same items. As mentioned here: For example, if a table has a very small ...
Eugen's user avatar
  • 121
2 votes
Accepted

NoSQL : Getting latest item from DynamoDB table

I think you're on the right track with AtomicLong, but you'd have to run a scan operation each time your app starts to determine which value to start at. You'd want to test this to ensure it doesn't ...
Calrion's user avatar
  • 136
2 votes
Accepted

parse json into a relational database or use a NoSQL?

Most goals are accomplishable in either type of database system, but you'll likely find more flexibility in how you can query the data (inclusive of modifying data) with a relational database, at the ...
J.D.'s user avatar
  • 37.9k
1 vote
Accepted

Suitable NoSQL DB design for a fleet of IoT devices

Why NoSQL? Any RDBMS on modern hardware can easily support your requirements. Basic Setup This is meant to be RDBMS agnostic. You'll want to tweak it to the RDBMS you choose. create table ...
Michael Kutz's user avatar
  • 4,829
1 vote
Accepted

How do I search by attribute in DynamoDB?

I contacted AWS support, and they said two things: The read/write capacity of the table needed to be changed from "provisioned" to "on-demand". Scan is definitely the command to ...
kloddant's user avatar
  • 111
1 vote
Accepted

Help needed with several engines use case

So any of those options EXCEPT ElasticSearch will probably work ok for you (equal hardware under the hood considered). ElasticSearch is quite possibly the opposite use case from what you described. It'...
J.D.'s user avatar
  • 37.9k
1 vote

SQL vs NoSQL: Fetching All records in DynamoDB vs SQL Database

Scan operations aren't usually optimal but 500,000 records isn't something too crazy for the standard RDBMS. For example, I've seen Microsoft SQL Server serve up 1 million records on a decently wide ...
J.D.'s user avatar
  • 37.9k
1 vote

DynamoDB: How to model data that's shared and queried by all users?

I'm intrigued as well. :) I have a use in mind that would likewise have userID as the PK. Sounds like you could put an 'announcements.json' file in an S3 bucket, then have your application read ...
Bob Balsman's user avatar
1 vote

Storing ~700 Tb in SQL Db

While the question has a tag of dynamodb, yes you can store as much as you need. It has the limit of 400K/item and 80K WCU and RCU on N.Virginia region which can be lifted up by the support. There is ...
Lukas Liesis's user avatar
1 vote

Porting a MySQL back-end to AWS DynamoDB

I will approach your question from this point of view "MySQL does the work; 3rd party software tends to 'get in the way'"... 1) -- MySQL's FULLTEXT index would make that query very fast and efficient....
Rick James's user avatar
  • 78.4k
1 vote

How should I use DynamoDB table

depending on how you want to fetch the data. If you want to get all by item, then item as a primary key is a great choice. If you want to filter by item and url then i would add primary key Item and ...
Lukas Liesis's user avatar
1 vote
Accepted

Best way to store a list of numbers where individual numbers can be deleted

look up put with conditional expression attribute_not_exists so you will only put the item if it does not exist. delete single item only by parturition key and range key, not all of them. also the ...
Jeff M's user avatar
  • 254
1 vote
Accepted

History of the provisioned write capacity in DynamoDB beyond the last two weeks

To the best of my knowledge, there is no other place to look that could give a longer history of the provisioned write capacity for a DynamoDB table beyond the last two weeks. Therefore, one has to ...
Franck Dernoncourt's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible