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
19

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

Avatar for nikawa2161

nikawa2161

December 28, 2025
Tweet

More Decks by nikawa2161

See All by nikawa2161
Sagaパターン入門（続編）
Avatar for nikawa2161 nikawa2161
0
9
Sagaパターン入門
Avatar for nikawa2161 nikawa2161
0
13
20251209_プログラミング原則の学び
Avatar for nikawa2161 nikawa2161
0
12
自分のコードを数年ぶりに読んだら
Avatar for nikawa2161 nikawa2161
0
6
ユーザーインタビュー分析に参加して得られたことと気づき
Avatar for nikawa2161 nikawa2161
0
6
oEmbedとは？
Avatar for nikawa2161 nikawa2161
0
16
はじめまして、にかわです
Avatar for nikawa2161 nikawa2161
0
10
課題を映す問題空間と、答えを描く解決空間
Avatar for nikawa2161 nikawa2161
0
9
転生したら自己肯定感MAXになりたい
Avatar for nikawa2161 nikawa2161
0
7

Other Decks in Technology

See All in Technology
Introduction to Sansan for Engineers / エンジニア向け会社紹介
Avatar for Sansan, Inc. sansan33
PRO
6
66k
Zephyr RTOS の発表をOpen Source Summit Japan 2025で行った件
Avatar for misoji engineer iotengineer22
0
300
Contract One Engineering Unit 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
0
13k
Deno・Bunの標準機能やElysiaJSを使ったWebSocketサーバー実装 / ラーメン屋を貸し切ってLT会! IoTLT 2026新年会
Avatar for you（@youtoy） you
PRO
0
150
コスト削減から「セキュリティと利便性」を担うプラットフォームへ
Avatar for SansanTech sansantech
PRO
1
280
学生・新卒・ジュニアから目指すSRE
Avatar for Hiroya Onoe hiroyaonoe
1
250
生成AI時代にこそ求められるSRE / SRE for Gen AI era
Avatar for ymotongpoo ymotongpoo
4
680
ゼロから始めたFindy初のモバイルアプリ開発
Avatar for Takahiro Kato grandbig
2
550
SREのプラクティスを用いた3領域同時 マネジメントへの挑戦 〜SRE・情シス・セキュリティを統合した チーム運営術〜
Avatar for coconala_engineer coconala_engineer
1
200
AWS Devops Agent ~ 自動調査とSlack統合をやってみた！ ~
Avatar for Kubo kubomasataka
2
270
最速で価値を出すための プロダクトエンジニアのツッコミ術
Avatar for Kazuto Ohara kaacun
1
430
DatabricksホストモデルでAIコーディング環境を構築する
Avatar for Databricks Japan databricksjapan
0
210

Featured

See All Featured
Measuring & Analyzing Core Web Vitals
Avatar for Philip Tellis bluesmoon
9
740
Helping Users Find Their Own Way: Creating Modern Search Experiences
Avatar for Dan Newman danielanewman
31
3.1k
Introduction to Domain-Driven Design and Collaborative software design
Avatar for Kenny Baas-Schwegler baasie
1
570
A Tale of Four Properties
Avatar for Chris Coyier chriscoyier
162
24k
Designing Dashboards & Data Visualisations in Web Apps
Avatar for Des Traynor destraynor
231
54k
Practical Tips for Bootstrapping Information Extraction Pipelines
Avatar for Matthew Honnibal honnibal
25
1.7k
Understanding Cognitive Biases in Performance Measurement
Avatar for Philip Tellis bluesmoon
32
2.8k
Docker and Python
Avatar for Tania Allard trallard
47
3.7k
AI: The stuff that nobody shows you
Avatar for John Nunemaker jnunemaker
PRO
2
220
Build your cross-platform service in a week with App Engine
Avatar for Jose L jlugia
234
18k
A Modern Web Designer's Workflow
Avatar for Chris Coyier chriscoyier
698
190k
How to make the Groovebox
Avatar for あそなす asonas
2
1.9k

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