dynamo local - Whats the best way to query dynamodb based on date range? -

-

as part of migrating sql dynamodb trying create dynamodb table. ui allows users search based on 4 attributes start date, end date, name of event , source of event. table has 6 attributes , above 4 subset of other attributes being priority , location. query described above makes mandatory search based on above 4 values. whats best way store information in dynamodb me in querying based on start date , end date easy. thought of creating gsi hashkey startdate, rangekey end date , gsi on rest 2 attrributes ?

inshort: table in dynamodb have 6 attributes eventname, location, startdate, end date, priority , source.

query have 4 mandatory attributes startdate, enddate, source , event name.

thanks help.

you can use greater than/less comparison operators part of query http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/queryandscan.html

so try build table schema: (eventname (hashkey), "startdate-enddate" (sortkey), other attributes)

in case sort-key combination of start , end date allowing use >= (on first part) , <= (on second part)... dynamodb uses ascii based alphabetical ordering... lets assume sortkey looks following: "73644-75223" use >= "73000-" , <= "73000-76000" given event.

additionally, create gsi on table each of remaining attributes need read via query. project data index want fetch query. in contrast lsi, queries gsi not fetch attributes not projected. aware of additional costs (read/write) involved using gsi (and lsi)... , additional memory required data projections...

hope helps.


Comments

Post a Comment

Popular posts from this blog

ruby - Trying to change last to "x"s to 23 -

-
i have been playing around irb , have string looks this: irb(main):072:0> puts ["[\"4354 5432 5432 xxxxx\", \"6547 6547 8543 xxxxx\", \"2344 6543 6674 xxxxx\", \"2346 6236 7543 xxxxx\", \"1273 5585 5587 xxxxx\"]"] => nil irb(main):073:0> what want gsub last 2 "x" s of each 17 digit combination, 23 . what i've tried far (i've been using rubular): a.gsub(/\d[x]/,"23") <= grabs "x" s i'm close a.gsub(/\w[x{2}]/,"23") <= grabs "x" s grabs two digits each combination. is there easier way i'm not understanding? a.gsub(/\d{4} \d{4} \d{4} xxx\kxx/, '23') \d{4} = 4 digits what \k drop matched far. can use don't replace entire number, still able validate have in desired format.
Read more

jquery - Clone last and append item to closest class -

-
this bare-bones code on page: <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <di
Read more

c - Unrecognised emulation mode: elf_i386 on MinGW32 -

-
i'm trying make kernel, , cannot link c output assembly. ld . i'm getting error: unrecognized emulation mode: elf_i386 i'm using windows 10 professional mingw32 , msys. code using: link.ld /* * link.ld */ output_format(elf32-i386) entry(start) sections { . = 0x100000; .text : { *(.text) } .data : { *(.data) } .bss : { *(.bss) } } kernel.c /* * kernel.c */ void kmain(void) { const char *str = "my first kernel"; char *vidptr = (char*)0xb8000; //video mem begins here. unsigned int = 0; unsigned int j = 0; /* loops clears screen * there 25 lines each of 80 columns; each element takes 2 bytes */ while(j < 80 * 25 * 2) { /* blank character */ vidptr[j] = ' '; /* attribute-byte - light grey on black screen */ vidptr[j+1] = 0x07; j = j + 2; } j = 0; /* loop writes string video memory */ while(str[j] != '\0') { /
Read more