AppSync $util.autoId() and DynamoDB Partition and Sort Keys Design Questions
The limits for partition and sort keys of dynamoDB are such that if I want to create a table with lots of users (e.g. the entire world population), then I can't just use a unique partition key to represent the personId, I need to use both partition key and sort key to represent a personId.
$util.autoId() in AppSync returns a 128-bit String. If I want to use this as the primary key in the dynamoDB table, then I need to split it into two Strings, one being the partition key and the other being the sort key.
What is the best way to perform this split? Or if this is not the best way to approach the design, how should I design it instead?
Also, do the limits on partition and sort keys apply to secondary indexes as well?
Regarding $util.autoId(), since it's generated randomly, if I call it many times, is there a chance that it will generate two id's that are exactly the same?
amazon-web-services amazon-dynamodb aws-appsync
asked Nov 15 '18 at 0:09
Sarah GuoSarah Guo
668
add a comment |
The limits for partition and sort keys of dynamoDB are such that if I want to create a table with lots of users (e.g. the entire world population), then I can't just use a unique partition key to represent the personId, I need to use both partition key and sort key to represent a personId.
$util.autoId() in AppSync returns a 128-bit String. If I want to use this as the primary key in the dynamoDB table, then I need to split it into two Strings, one being the partition key and the other being the sort key.
What is the best way to perform this split? Or if this is not the best way to approach the design, how should I design it instead?
Also, do the limits on partition and sort keys apply to secondary indexes as well?
Regarding $util.autoId(), since it's generated randomly, if I call it many times, is there a chance that it will generate two id's that are exactly the same?
amazon-web-services amazon-dynamodb aws-appsync
asked Nov 15 '18 at 0:09
Sarah GuoSarah Guo
668
add a comment |
The limits for partition and sort keys of dynamoDB are such that if I want to create a table with lots of users (e.g. the entire world population), then I can't just use a unique partition key to represent the personId, I need to use both partition key and sort key to represent a personId.
$util.autoId() in AppSync returns a 128-bit String. If I want to use this as the primary key in the dynamoDB table, then I need to split it into two Strings, one being the partition key and the other being the sort key.
What is the best way to perform this split? Or if this is not the best way to approach the design, how should I design it instead?
Also, do the limits on partition and sort keys apply to secondary indexes as well?
Regarding $util.autoId(), since it's generated randomly, if I call it many times, is there a chance that it will generate two id's that are exactly the same?
amazon-web-services amazon-dynamodb aws-appsync
asked Nov 15 '18 at 0:09
Sarah GuoSarah Guo
668
The limits for partition and sort keys of dynamoDB are such that if I want to create a table with lots of users (e.g. the entire world population), then I can't just use a unique partition key to represent the personId, I need to use both partition key and sort key to represent a personId.
$util.autoId() in AppSync returns a 128-bit String. If I want to use this as the primary key in the dynamoDB table, then I need to split it into two Strings, one being the partition key and the other being the sort key.
What is the best way to perform this split? Or if this is not the best way to approach the design, how should I design it instead?
Also, do the limits on partition and sort keys apply to secondary indexes as well?
Regarding $util.autoId(), since it's generated randomly, if I call it many times, is there a chance that it will generate two id's that are exactly the same?
amazon-web-services amazon-dynamodb aws-appsync
amazon-web-services amazon-dynamodb aws-appsync
asked Nov 15 '18 at 0:09
Sarah GuoSarah Guo
668
asked Nov 15 '18 at 0:09
Sarah GuoSarah Guo
668
edited Nov 15 '18 at 0:26
Sarah Guo
asked Nov 15 '18 at 0:09
Sarah GuoSarah Guo
668
asked Nov 15 '18 at 0:09
Sarah GuoSarah Guo
668
asked Nov 15 '18 at 0:09
Sarah GuoSarah Guo
668
668
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I think I'm misunderstanding something from your question's premise because to my brain, using AppSync's $util.autoId() gives you back a 128 bit UUID. The point of UUIDs is that they're unique, so you can absolutely have one UUID per person in the world. And the UUID string will definitely fit within the maximum character length limits of Dynamo's partition key requirements.
You also asked:
if I call it many times, is there a chance that it will generate two
id's that are exactly the same?
It's extremely unlikely.
answered Nov 15 '18 at 1:23
Gabe HollombeGabe Hollombe
5,78333240
About the partition key and sort key limits, the [link] (docs.aws.amazon.com/amazondynamodb/latest/developerguide/…) here says that the maximum length is 2048 bytes. This sounds to be to be significantly smaller than 128 bit UUID.
– Sarah Guo
Nov 15 '18 at 1:51
Ah! A 128 bit UUID represented in hexadecimal notation is significantly shorter than 2048 bytes; it's 32 characters and four hyphens. =-)
– Gabe Hollombe
Nov 15 '18 at 4:32
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53310643%2fappsync-util-autoid-and-dynamodb-partition-and-sort-keys-design-questions%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I think I'm misunderstanding something from your question's premise because to my brain, using AppSync's $util.autoId() gives you back a 128 bit UUID. The point of UUIDs is that they're unique, so you can absolutely have one UUID per person in the world. And the UUID string will definitely fit within the maximum character length limits of Dynamo's partition key requirements.
You also asked:
if I call it many times, is there a chance that it will generate two
id's that are exactly the same?
It's extremely unlikely.
answered Nov 15 '18 at 1:23
Gabe HollombeGabe Hollombe
5,78333240
About the partition key and sort key limits, the [link] (docs.aws.amazon.com/amazondynamodb/latest/developerguide/…) here says that the maximum length is 2048 bytes. This sounds to be to be significantly smaller than 128 bit UUID.
– Sarah Guo
Nov 15 '18 at 1:51
Ah! A 128 bit UUID represented in hexadecimal notation is significantly shorter than 2048 bytes; it's 32 characters and four hyphens. =-)
– Gabe Hollombe
Nov 15 '18 at 4:32
add a comment |
I think I'm misunderstanding something from your question's premise because to my brain, using AppSync's $util.autoId() gives you back a 128 bit UUID. The point of UUIDs is that they're unique, so you can absolutely have one UUID per person in the world. And the UUID string will definitely fit within the maximum character length limits of Dynamo's partition key requirements.
You also asked:
if I call it many times, is there a chance that it will generate two
id's that are exactly the same?
It's extremely unlikely.
answered Nov 15 '18 at 1:23
Gabe HollombeGabe Hollombe
5,78333240
About the partition key and sort key limits, the [link] (docs.aws.amazon.com/amazondynamodb/latest/developerguide/…) here says that the maximum length is 2048 bytes. This sounds to be to be significantly smaller than 128 bit UUID.
– Sarah Guo
Nov 15 '18 at 1:51
Ah! A 128 bit UUID represented in hexadecimal notation is significantly shorter than 2048 bytes; it's 32 characters and four hyphens. =-)
– Gabe Hollombe
Nov 15 '18 at 4:32
add a comment |
I think I'm misunderstanding something from your question's premise because to my brain, using AppSync's $util.autoId() gives you back a 128 bit UUID. The point of UUIDs is that they're unique, so you can absolutely have one UUID per person in the world. And the UUID string will definitely fit within the maximum character length limits of Dynamo's partition key requirements.
You also asked:
if I call it many times, is there a chance that it will generate two
id's that are exactly the same?
It's extremely unlikely.
answered Nov 15 '18 at 1:23
Gabe HollombeGabe Hollombe
5,78333240
I think I'm misunderstanding something from your question's premise because to my brain, using AppSync's $util.autoId() gives you back a 128 bit UUID. The point of UUIDs is that they're unique, so you can absolutely have one UUID per person in the world. And the UUID string will definitely fit within the maximum character length limits of Dynamo's partition key requirements.
You also asked:
if I call it many times, is there a chance that it will generate two
id's that are exactly the same?
It's extremely unlikely.
answered Nov 15 '18 at 1:23
Gabe HollombeGabe Hollombe
5,78333240
answered Nov 15 '18 at 1:23
Gabe HollombeGabe Hollombe
5,78333240
answered Nov 15 '18 at 1:23
Gabe HollombeGabe Hollombe
5,78333240
answered Nov 15 '18 at 1:23
Gabe HollombeGabe Hollombe
5,78333240
5,78333240
About the partition key and sort key limits, the [link] (docs.aws.amazon.com/amazondynamodb/latest/developerguide/…) here says that the maximum length is 2048 bytes. This sounds to be to be significantly smaller than 128 bit UUID.
– Sarah Guo
Nov 15 '18 at 1:51
Ah! A 128 bit UUID represented in hexadecimal notation is significantly shorter than 2048 bytes; it's 32 characters and four hyphens. =-)
– Gabe Hollombe
Nov 15 '18 at 4:32
add a comment |
About the partition key and sort key limits, the [link] (docs.aws.amazon.com/amazondynamodb/latest/developerguide/…) here says that the maximum length is 2048 bytes. This sounds to be to be significantly smaller than 128 bit UUID.
– Sarah Guo
Nov 15 '18 at 1:51
Ah! A 128 bit UUID represented in hexadecimal notation is significantly shorter than 2048 bytes; it's 32 characters and four hyphens. =-)
– Gabe Hollombe
Nov 15 '18 at 4:32
About the partition key and sort key limits, the [link] (docs.aws.amazon.com/amazondynamodb/latest/developerguide/…) here says that the maximum length is 2048 bytes. This sounds to be to be significantly smaller than 128 bit UUID.
– Sarah Guo
Nov 15 '18 at 1:51
About the partition key and sort key limits, the [link] (docs.aws.amazon.com/amazondynamodb/latest/developerguide/…) here says that the maximum length is 2048 bytes. This sounds to be to be significantly smaller than 128 bit UUID.
– Sarah Guo
Nov 15 '18 at 1:51
Ah! A 128 bit UUID represented in hexadecimal notation is significantly shorter than 2048 bytes; it's 32 characters and four hyphens. =-)
– Gabe Hollombe
Nov 15 '18 at 4:32
Ah! A 128 bit UUID represented in hexadecimal notation is significantly shorter than 2048 bytes; it's 32 characters and four hyphens. =-)
– Gabe Hollombe
Nov 15 '18 at 4:32
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53310643%2fappsync-util-autoid-and-dynamodb-partition-and-sort-keys-design-questions%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
