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

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

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
Avatar for nikawa2161 nikawa2161
December 28, 2025
Technology
0
24

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

Avatar for nikawa2161

nikawa2161

December 28, 2025
Tweet

More Decks by nikawa2161

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

Other Decks in Technology

See All in Technology
Phase05_ClaudeCode入門
Avatar for overflow ,Inc overflowinc
0
2.1k
VSCode中心だった自分がターミナル沼に入門した話
Avatar for Genki Sano sanogemaru
0
640
AIエージェント時代に必要な オペレーションマネージャーのロールとは
Avatar for KentaroFujii kentarofujii
0
100
開発チームとQAエンジニアの新しい協業モデル -年末調整開発チームで実践する【QAリード施策】-
Avatar for kaomi kaomi_wombat
0
240
Copilot 宇宙へ　〜生成AIで「専門データの壁」を壊す方法〜
Avatar for なかしょ nakasho
0
190
Agent Skill 是什麼？對軟體產業帶來的變化
Avatar for Bo-Yi Wu appleboy
0
230
【AWS】CloudTrail LakeとCloudWatch Logs Insightsの使い分け方針
Avatar for Yuma Tsurugasaki tsurunosd
0
120
スピンアウト講座01_GitHub管理
Avatar for overflow ,Inc overflowinc
0
1.4k
Kubernetesの「隠れメモリ消費」によるNode共倒れと、Request適正化という処方箋
Avatar for g0xu g0xu
0
120
スケールアップ企業でQA組織が機能し続けるための組織設計と仕組み〜ボトムアップとトップダウンを両輪としたアプローチ〜

Avatar for tarappo tarappo
4
370
How to install a gem
Avatar for André Arko indirect
0
1.5k
Phase09_自動化_仕組み化
Avatar for overflow ,Inc overflowinc
0
1.7k

Featured

See All Featured
New Earth Scene 8
Avatar for Sydney Stone popppiees
1
1.8k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
Avatar for Morgane Peng morganepeng
133
19k
Save Time (by Creating Custom Rails Generators)
Avatar for Garrett Dimon garrettdimon
PRO
32
2.5k
brightonSEO & MeasureFest 2025 - Christian Goodrich - Winning strategies for Black Friday CRO & PPC
Avatar for Christian Goodrich cargoodrich
3
130
Are puppies a ranking factor?
Avatar for Jono Alderson jonoalderson
1
3.2k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
Avatar for Stéphanie Walter stephaniewalter
287
14k
How to Align SEO within the Product Triangle To Get 
Buy-In & Support - #RIMC
Avatar for Aleyda Solis aleyda
1
1.5k
Statistics for Hackers
Avatar for Jake VanderPlas jakevdp
799
230k
Speed Design
Avatar for Sergey Chernyshev sergeychernyshev
33
1.6k
KATA
Avatar for Megan Lloyd mclloyd
PRO
35
15k
First, design no harm
Avatar for Per Axbom axbom
PRO
2
1.1k
世界の人気アプリ100個を分析して見えたペイウォール設計の心得
Avatar for Akihiro Kokubo akihiro_kokubo
PRO
68
38k

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