Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
DynamoDBでQuery
Search
jacoyutorius
February 22, 2020
Technology
0
230
DynamoDBでQuery
Hamamatsu.js #8のLT資料です
jacoyutorius
February 22, 2020
Tweet
Share
More Decks by jacoyutorius
See All by jacoyutorius
Amplify Gen 2 Authentication では Cognito IdentityPool のみでのゲストユーザーへの認可ができない件
jacoyutorius
0
100
kamalでRailsアプリを Amazon Lightsailにデプロイするぞ!
jacoyutorius
0
200
オープンデータとAWSで作っている 浜松市イベントカレンダー
jacoyutorius
0
260
浜松市オープンデータを使ってイベントカレンダーアプリを作りました
jacoyutorius
0
91
Amplifyアプリを 任意のタイミングでデプロイするぞ!
jacoyutorius
1
440
AWS Amplify で翻訳アプリを作った話とAmplifyからカジュアルにCloudWatchLogsにログを送る方法について
jacoyutorius
1
1.4k
AWS App Runner + copilot cli
jacoyutorius
1
1.1k
AWS App Runner + Copilot CLI
jacoyutorius
0
72
covid19対策サイトを通してコミュニティとシビックテックのあり方について思うこと
jacoyutorius
0
400
Other Decks in Technology
See All in Technology
PHP開発者のためのSOLID原則再入門 #phpcon / PHP Conference Japan 2025
shogogg
4
640
How Community Opened Global Doors
hiroramos4
PRO
1
110
250627 関西Ruby会議08 前夜祭 RejectKaigi「DJ on Ruby Ver.0.1」
msykd
PRO
2
220
【TiDB GAME DAY 2025】Shadowverse: Worlds Beyond にみる TiDB 活用術
cygames
0
1k
MySQL5.6から8.4へ 戦いの記録
kyoshidaxx
1
170
“社内”だけで完結していた私が、AWS Community Builder になるまで
nagisa53
1
340
Observability в PHP без боли. Олег Мифле, тимлид Altenar
lamodatech
0
330
5min GuardDuty Extended Threat Detection EKS
takakuni
0
110
Uniadex__公開版_20250617-AIxIoTビジネス共創ラボ_ツナガルチカラ_.pdf
iotcomjpadmin
0
160
Абьюзим random_bytes(). Фёдор Кулаков, разработчик Lamoda Tech
lamodatech
0
330
20250625 Snowflake Summit 2025活用事例 レポート / Nowcast Snowflake Summit 2025 Case Study Report
kkuv
1
290
本当に使える?AutoUpgrade の新機能を実践検証してみた
oracle4engineer
PRO
1
140
Featured
See All Featured
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
tammyeverts
53
2.8k
Side Projects
sachag
455
42k
Fireside Chat
paigeccino
37
3.5k
VelocityConf: Rendering Performance Case Studies
addyosmani
330
24k
Visualization
eitanlees
146
16k
The MySQL Ecosystem @ GitHub 2015
samlambert
251
13k
Building a Scalable Design System with Sketch
lauravandoore
462
33k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
667
120k
Producing Creativity
orderedlist
PRO
346
40k
Reflections from 52 weeks, 52 projects
jeffersonlam
351
20k
[RailsConf 2023] Rails as a piece of cake
palkan
55
5.6k
What’s in a name? Adding method to the madness
productmarketing
PRO
23
3.5k
Transcript
"NB[PO%ZOBNP%#Ͱݕࡧ͢Δ !KBDPZVUPSJVT )BNBNBUTVKT
খ༔ే !KBDPZVUPSJVT ‣ ΤΞʔζגࣜձࣾ ‣ +"846()BNBNBUTVSC ‣ 3VCZ3VCZPO3BJMT+BWBTDSJQU"84 ࠷ۙࣗ࡞ΩʔϘʔυͱΧϨʔ࡞ΓʹϋϚ͍ͬͯΔ
None
None
+4ύΠϓ໓ଟʹΘͳ͍͔ΒେৎͩΖଟ
"NB[PO%ZOBNP%# ‣ ϑϧϚωʔδυͳ/P42-σʔλϕʔε ‣ ߴՄ༻ੑ ͭͷ";ͷϨϓϦέʔγϣϯ ‣ ΩʔόϦϡʔετΞ ‣
εΩʔϚϨε ‣ ΩϟύγςΟϢχοτ ‣ ಡΈॻ͖ੑೳΛܾఆ͢Δύϥϝʔλ ‣ lΦϯσϚϯυzͱ͍͏Φϓγϣϯ͋Δɻ"NQMJGZΛ௨ͯ͠%ZOBNP%#ͷςʔϒϧ Λ࡞ͬͨ߹ɺσϑΥϧτͰͪ͜ΒͷΦϓγϣϯ͕༗ޮʹͳΔ
%ZOBNP%#ͷݕࡧ ‣ RVFSZ ‣ TDBO ςʔϒϧશମΛεΩϟϯͯ݅͠ʹ߹க͢ΔͷΛฦ͢ ύʔςΟγϣϯΩʔιʔτΩʔΛࢦఆͯ݅͠ʹ߹க͢Δͷ Λநग़͢Δ ॊೈͳݕࡧ͕ՄೳͳҰํɺ%#ͷෛՙ͕ߴ͘ύϑΥʔϚϯεྑ͘ͳ͍
Γ͔ͨͬͨ͜ͱ ‣ %ZOBNP%#Ͱݕࡧ ‣ ύʔςΟγϣϯΩʔ ιʔτΩʔΛ͏
͍ͬͯͳ͍͜ͱ ‣ ΩϟύγςΟϢχοτͷࢼࢉ ‣ ྉۚ
EPDLFSDPNQPTFZNM
‣ %ZOBNP%#"ENJO ‣ IUUQMPDBMIPTU ‣ EBUBCBTFFOEQPJOU ‣ IUUQMPDBMIPTU %ZOBNP%#ΛϩʔΧϧͰىಈ
None
ॅॴ$% ಓݝ$% ࢢ۠ொଜ$% ொҬ$% ༣ศ൪߸ ࣄۀॴϑϥά ഇࢭϑϥά ಓݝ ಓݝΧφ ࢢ۠ொଜ
ࢢ۠ொଜΧφ ੩Ԭݝ γζΦΧέϯ দࢢத۠ ϋϚϚπγφ ΧΫ ੩Ԭݝ γζΦΧέϯ দࢢத۠ ϋϚϚπγφ ΧΫ ொҬ ொҬΧφ ொҬิ ژ௨Γ໊ ࣈஸ ࣈஸΧφ ิ ࣄۀॴ໊ ࣄۀॴ໊Χ φ ࣄۀॴॅॴ ৽ॅॴ$% ொ ΧδϚν יߐ ΧϞΤ দࢢอ݈ॴ ϋϚϚπγϗ έϯδϤ יߐ̎ஸ̍ ̍̎ ॅॴKQ IUUQKVTZPKQ
1,Ͱݕࡧ͢Δ ॅॴ$% ॅॴ ॅॴΧφ ੩Ԭݝদࢢத۠יߐொ γζΦΧέϯϋϚϚπγφΧΫΧϞΤνϣ ੩Ԭݝদࢢத۠יߐொத෦ిྗɹʢגʣɹদӦۀॴיߐொ̎ ̎̍
γζΦΧέϯϋϚϚπγφΧΫΧϞΤνϣνϢϒσϯϦϤΫɹʢΧϒʣɹ ϋϚϚπΤΠΪϤγϤ
ύʔςΟγϣϯΩʔࢦఆʹΑΔݕࡧ݁Ռ
ύʔςΟγϣϯΩʔࢦఆʹΑΔݕࡧ݁Ռ
1,4,Ͱݕࡧ͢Δ
https:/ /docs.aws.amazon.com/ja_jp/amazondynamodb/latest/developerguide/ LegacyConditionalParameters.KeyConditions.html “ςʔϒϧʹର͢ΔΫΤϦͷ߹ɺςʔϒϧͷϓϥΠϚϦΩʔଐੑͷΈ ͷ݅Λ࣋ͭ͜ͱ͕Ͱ͖·͢ɻEQ ݅ͱͯ͠ύʔςΟγϣϯΩʔͷ໊ લͱΛఏڙ͢Δඞཁ͕͋Γ·͢ɻ ΦϓγϣϯͰɺιʔτΩʔΛࢀর͢Δ 2 ൪ͷ݅ΛࢦఆͰ͖·͢ɻ”
RVFSZͷ੍ݶ
https:/ /docs.aws.amazon.com/ja_jp/amazondynamodb/latest/developerguide/ LegacyConditionalParameters.KeyConditions.html KeyConditions ͷ߹ɺ࣍ͷൺֱԋࢉࢠͷΈ͕αϙʔτ͞Ε͍ͯ·͢ɻ EQ | LE | LT
| GE | GT | BEGINS_WITH | BETWEEN RVFSZͷ੍ݶ
IUUQTEPDTBXTBNB[PODPNKB@KQBNB[POEZOBNPECMBUFTUEFWFMPQFSHVJEF)PX*U8PSLT1BSUJUJPOTIUNM
ࢁསݝ ੩Ԭݝ Ѫݝ ʜ ੩ԬࢢѮ۠ ੩Ԭࢢਗ਼ਫ۠ ʜ দࢢத۠ দࢢ۠ ʜ
ொ ࠠொ ʜ יߐ ݩொ ʜ FY TFMFDUCPYͰυϦϧμϯ͢ΔΑ͏ͳ6*
(4* ‣ ςʔϒϧ࡞࣌ʹࢦఆ͢Δ1,4,ͱผʹఆٛͰ͖ΔΠϯσοΫε ‣ Ұͭͷςʔϒϧʹ͖ͭɺ࠷େͭͷ(4*͕ొՄೳ ‣ (4*͝ͱʹΩϟύγςΟϢχοτͷઃఆ͕ඞཁ ‣ (4*ςʔϒϧͷࣹӨɻϨίʔυͷొޙʹ(4*ݕࡧΛ͔͚͙ͯ͢ʹ ө͞Ε͍ͯͳ͍߹͕͋Δ
άϩʔόϧηΧϯμϦΠϯσοΫε
ॅॴ$% ಓݝ $% ࢢ۠ொଜ $% ொҬ$% ༣ศ൪߸ ࣄۀॴϑϥ ά ഇࢭϑϥά
ಓݝ ಓݝΧ φ ࢢ۠ொଜ ࢢ۠ொଜΧ φ ொҬ ொҬΧφ ੩Ԭݝ γζΦΧέ ϯ দࢢத۠ ϋϚϚπγ φΧΫ יߐ ΧϞΤ DBUFHPSZ WBMVF DJUZ দࢢத۠ DBUFHPSZ WBMVF QSFGFDUVSF ੩Ԭݝ DBUFHPSZ WBMVF UPXO יߐ
ॅॴ$% DBUFHPSZ DBUFHPSZ@WBMVF ಓݝ ࢢ۠ொଜ ொҬ QSFGFDUVSF ੩Ԭݝ ੩Ԭݝ
DJUZ ੩Ԭݝদࢢத۠ দࢢத۠ UPXO ੩Ԭݝদࢢத۠יߐ יߐ 1, 4, ॅॴ$% ಓݝ $% ࢢ۠ொଜ $% ொҬ$% ༣ศ൪߸ ࣄۀॴϑϥ ά ഇࢭϑϥά ಓݝ ಓݝΧ φ ࢢ۠ொଜ ࢢ۠ொଜΧ φ ொҬ ொҬΧφ ੩Ԭݝ γζΦΧέ ϯ দࢢத۠ ϋϚϚπγ φΧΫ יߐ ΧϞΤ
ॅॴ$% DBUFHPSZ DBUFHPSZ@WBMVF ಓݝ ࢢ۠ொଜ ொҬ QSFGFDUVSF ੩Ԭݝ ੩Ԭݝ
DJUZ ੩Ԭݝদࢢத۠ দࢢத۠ UPXO ੩Ԭݝদࢢத۠יߐ יߐ 1, 4, 1, 4, ॅॴ$% DBUFHPSZ DBUFHPSZ@WBMVF ಓݝ ࢢ۠ொଜ ொҬ QSFGFDUVSF ੩Ԭݝ ੩Ԭݝ DJUZ ੩Ԭݝদࢢத۠ দࢢத۠ UPXO ੩Ԭݝদࢢத۠יߐ יߐ (4*
(4*ύʔςΟγϣϯΩʔࢦఆʹΑΔݕࡧ݁Ռ
(4*ύʔςΟγϣϯΩʔιʔτΩʔࢦఆʹΑΔ લํҰகݕࡧ݁Ռ
(4*ύʔςΟγϣϯΩʔιʔτΩʔࢦఆʹΑΔݕࡧ݁Ռ
ࢁསݝ ੩Ԭݝ Ѫݝ ʜ ੩ԬࢢѮ۠ ੩Ԭࢢਗ਼ਫ۠ ʜ দࢢத۠ দࢢ۠ ʜ
ொ ࠠொ ʜ יߐ ݩொ ʜ FY TFMFDUCPYͰυϦϧμϯ͢ΔΑ͏ͳ6*
%ZOBNP%#σʔλϞσϦϯάދͷר IUUQNBSDZIBUFOBCMPHDPNFOUSZ ͷ΅Γʔ͞ΜͷΫϥυΠϯϑϥ1PEDBTUʰ5SBDLরҪ͞Μͷ 4FSWFSMFTTΞʔΩςΫτࢦೆͱɺ1BUSFPOొͷ͓ΒͤʱͷϝϞ IUUQTDMPVEJOGSBBVEJPUSBDLEGFD %ZOBNP%#Λ༻ͨ͠ઃܭͱΞʔΩςΫνϟͷઃܭʹؔ͢ΔϕετϓϥΫςΟε IUUQTEPDTBXTBNB[PODPNKB@KQBNB[POEZOBNPECMBUFTUEFWFMPQFSHVJEFCFTU QSBDUJDFTIUNM
None
None
None
"84&YQFSU0OMJOF+"846(দ"84ษڧձ IUUQTKBXTVHIBNBNBUTVEPPSLFFQFSKQFWFOUT +"846(দ"84ษڧձ IUUQTKBXTVHIBNBNBUTVEPPSLFFQFSKQFWFOUT +"84%":4 IUUQTKBXTEBZTKBXTVHKQ