How to query for an entry that falls between start and end date - DynamoDB -


i new dynamodb, , had question how can find of live entries in dynamodb table. each entry in table has start , end date. confused on how can query entries current date falls between start , end date. ideas how can this?

i understand can have primary , range key. possible query other columns in entry?

each entry looks this:

id: xxxxxx startdate: 123456 // epoch time enddate: 334243 // epoch time

if not know hashkey of item(looks 'id' in case) way query dynamodb using full table scan.

you can table scan using multiple conditions, inefficient.


Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -