Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

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

Avatar for nikawa2161 nikawa2161
December 28, 2025
Technology
41
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
44
Sagaパターン入門（続編）
Avatar for nikawa2161 nikawa2161
0
52
Sagaパターン入門
Avatar for nikawa2161 nikawa2161
0
65
20251209_プログラミング原則の学び
Avatar for nikawa2161 nikawa2161
0
41
自分のコードを数年ぶりに読んだら
Avatar for nikawa2161 nikawa2161
0
26
ユーザーインタビュー分析に参加して得られたことと気づき
Avatar for nikawa2161 nikawa2161
0
44
oEmbedとは？
Avatar for nikawa2161 nikawa2161
0
250
はじめまして、にかわです
Avatar for nikawa2161 nikawa2161
0
29
課題を映す問題空間と、答えを描く解決空間
Avatar for nikawa2161 nikawa2161
0
30

Other Decks in Technology

See All in Technology
Loop Engineering これくらいでいい
Avatar for mikan mikanichinose
0
230
USB PDを使ってスマホを労わりたい
Avatar for らすぴー raspython3
0
160
[AWS 秋のクラウドオペレーション祭り 2026]AWS DevOps Agentで変わる リリースと運用対応 ~リリース管理機能と Directed actions のご紹介~
Avatar for Toshihiro Furuno furuton
4
1.2k
【Data Engineering Summit2026_登壇資料】医療ビッグデータ×AIエージェントを支えるデータ基盤とハーネスエンジニアリング
Avatar for JMDC.Inc 登壇資料 jmdc_presentation
0
140
PagerDuty Tech Hub-鳴らすけれど、人は動かない
Avatar for shinji ezaki ezaki
0
120
Persisting Massive Data with Rails ~Designing for 60 billion rows, and fighting the bottlenecks~ Railsで挑む大量データ永続化 〜600億件を永続化するための設計とボトルネックとの戦い〜
Avatar for Shoichi Ochi occhi
0
470
DevelopersIO 2026 知識の地図を描く ─ オントロジーとは何か？
Avatar for Satoru Ishikawa ishikawa_satoru
1
1.5k
AI 時代の Azure エンジニアリング ～ 私たちは何を磨き、何を任せるのか ～
Avatar for Akira Inoue chack411
1
610
Loop Engineering, beyond prompt, context, and harness engineering
Avatar for Guillaume Laforge glaforge
0
100
Getting Started with Google Antigravity
Avatar for Guillaume Laforge glaforge
0
230
Snapshot Testing in Practice: Predictable and Reliable SwiftUI Views
Avatar for Felipe Espinoza fespinoza
0
210
しろおびから始める！ログ活用の第一歩
Avatar for Shumei Ito shumei_ito
0
920

Featured

See All Featured
It's Worth the Effort
Avatar for 3n 3n
188
29k
Are puppies a ranking factor?
Avatar for Jono Alderson jonoalderson
2
4k
Redefining SEO in the New Era of Traffic Generation
Avatar for Szymon Słowik szymonslowik
1
470
Bootstrapping a Software Product
Avatar for Garrett Dimon garrettdimon
PRO
306
120k
The Mindset for Success: Future Career Progression
Avatar for Greg Gifford greggifford
PRO
0
530
Future Trends and Review - Lecture 12 - Web Technologies (1019888BNR)
Avatar for Beat Signer signer
PRO
0
3.8k
[RailsConf 2023] Rails as a piece of cake
Avatar for Vladimir Dementyev palkan
59
7.1k
Fireside Chat
Avatar for paigeccino paigeccino
43
4.1k
Joys of Absence: A Defence of Solitary Play
Avatar for Sebastian Deterding codingconduct
1
550
The innovator’s Mindset - 
Leading Through an Era of Exponential Change - McGill University 2025
Avatar for Jean-Marc De Jonghe jdejongh
PRO
1
370
Put a Button on it: Removing Barriers to Going Fast.
Avatar for kastner kastner
60
4.6k
The Cult of Friendly URLs
Avatar for Andy Hume andyhume
79
7k

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