Upgrade to Pro — share decks privately, control downloads, hide ads and more …

沖縄観光とPostgreSQL排他制約の話

Avatar for nikawa2161 nikawa2161
December 28, 2025
Technology
39
0

 沖縄観光とPostgreSQL排他制約の話

Avatar for nikawa2161

nikawa2161

December 28, 2025

More Decks by nikawa2161

See All by nikawa2161
Node.js Subpath imports
Avatar for nikawa2161 nikawa2161
0
32
Sagaパターン入門（続編）
Avatar for nikawa2161 nikawa2161
0
46
Sagaパターン入門
Avatar for nikawa2161 nikawa2161
0
53
20251209_プログラミング原則の学び
Avatar for nikawa2161 nikawa2161
0
34
自分のコードを数年ぶりに読んだら
Avatar for nikawa2161 nikawa2161
0
22
ユーザーインタビュー分析に参加して得られたことと気づき
Avatar for nikawa2161 nikawa2161
0
37
oEmbedとは？
Avatar for nikawa2161 nikawa2161
0
200
はじめまして、にかわです
Avatar for nikawa2161 nikawa2161
0
28
課題を映す問題空間と、答えを描く解決空間
Avatar for nikawa2161 nikawa2161
0
23

Other Decks in Technology

See All in Technology
When Does a Local Qwen Start to Break
Avatar for Shoto morshoto
0
170
Bet AI Day 2026丨バクラク Autopilot、業務システムの再設計
Avatar for LayerX layerx
PRO
2
1.2k
AIで開発は速くなったのに、なぜ現場は楽にならないのか 〜あなたの組織のボトルネックを突き止めるワークショップ〜
Avatar for Kazuto Kusama jacopen
1
260
Guerilla InnerSource in enterprises, during the AI hype
Avatar for Oleg Nenashev onenashev
PRO
0
150
AIエージェントを雇う前に決める5つのこと
Avatar for 西岡 賢一郎 (Kenichiro Nishioka) knishioka
1
160
なぜSRE・セキュリティは評価されないのか？守りの組織を事業成長エンジンに変えた実践
Avatar for サイバーセキュリティクラウド cscengineer
PRO
3
2.2k
2026-09-04 SRE Tech Talk #15 怠惰なTerraform / Lazy Terraform
Avatar for SUZUKI Masashi masasuzu
0
190
Autonomous AI Databaseサービス・アップデート（FY27）/ adb-service-update-jp-fy27
Avatar for oracle4engineer oracle4engineer
PRO
0
110
PdMをやめて、 "プロダクトビルダー"という 働き方に変えました / PdM to Product Builder
Avatar for Takuya Shikichi shikichee
2
710
20260903 Tokyo Jazug Night #62 | Azure エンジニアよ、 その環境は本当にセキュアか？
Avatar for Olivia olivia_0707
1
610
20260906 「AWS運用入門」著者が教える、運用業務への生成AI活用入門
Avatar for Masaru Ogura masaruogura
0
230
#jawssonic2026 あの時代が悪かった ~動かなかったSageMakerと共に迎えたイベント当日~
Avatar for Kana Kitagawa ktkn1129
0
130

Featured

See All Featured
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
Avatar for Rebecca Miller-Webster rmw
35
3.8k
AI: The stuff that nobody shows you
Avatar for John Nunemaker jnunemaker
PRO
9
970
GraphQLの誤解/rethinking-graphql
Avatar for sonatard sonatard
75
12k
How to build an LLM SEO readiness audit: a practical framework
Avatar for Nick Samuel nmsamuel
1
890
Building Experiences: Design Systems, User Experience, and Full Site Editing
Avatar for Michelle Schulp Hunt marktimemedia
0
600
Agile that works and the tools we love
Avatar for Rasmus Luckow-Nielsen rasmusluckow
331
22k
Kristin Tynski - Automating Marketing Tasks With AI
Avatar for Tech SEO Connect techseoconnect
PRO
0
510
How People are Using Generative and Agentic AI to Supercharge Their Products, Projects, Services and Value Streams Today
Avatar for Helen Beal helenjbeal
1
300
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
29
4.5k
Information Architects: The Missing Link in Design Systems
Avatar for Michelle Chin soysaucechin
1
1.1k
Distributed Sagas: A Protocol for Coordinating Microservices
Avatar for Caitie McCaffrey caitiem20
333
23k
No one is an island. Learnings from fostering a developers community.
Avatar for Antonio thoeni
21
3.8k

Transcript

  1. None
  2. None
  3. None
  4. None
  5. None
  6. None
  7. None
  8. None
  9. None
  10. None
  11. None
  12. None
  13. None
  14. None
  15. None
  16. None
  17. None
  18. None
  19. None
  20. None
  21. None
  22. None

  23. btree_gist

  24. CREATE EXTENSION btree_gist; CREATE TABLE room_reservations ( room_name text, check_in

    timestamp, check_out timestamp ); ALTER TABLE room_reservations ADD CONSTRAINT no_overlapping_reservations EXCLUDE USING gist ( room_name WITH =, tsrange(check_in, check_out) WITH && );

  25. room_name check_in check_out

  26. no_overlapping_reservations

  27. &&

  28. gist ( room_name WITH =, tsrange(check_in, check_out) WITH && );

    room_name WITH = tsrange(check_in, check_out) WITH &&

  29. tsrange check_in check_out

  30. WHERE (start1 < end2) AND (start2 < end1) WHERE period1

    && period2

  31. EXTENSION btree_gist room_name

  32. None

  33. btree_gist

  34. None