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

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

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

Other Decks in Technology

See All in Technology
SONiCのLinuxベースを活かしたZabbix監視
Avatar for SONiC Users Group Japan sonic
0
160
FinOps × AIエージェントで実現する コストインシデントの自動調査
Avatar for T.REX oasis1994liveforever
0
140
ルールやカスタム機能、どう活かす?ハンズオンで体感するIBM Bobの出力コントロール
Avatar for mu (Mizuho Uehara) muehara
1
160
マルチアカウント環境での コーディングエージェントを使った障害調査が大変なので AIエージェントにReadOnly権限を付与してみた / ReadOnly AI Agents for Multi-Account AWS Incident Response
Avatar for Takashi Yamaguchi yamaguchitk333
2
100
2026 TECHFRESH 畢業分享會 - 開發日常大解密！從領域驅動到企業級上線
Avatar for LINE Developers Taiwan line_developers_tw
PRO
0
1k
中期計画、2回作ってみた　～業務委託と正社員、両方の視点から～
Avatar for 株式会社出前館 demaecan
1
750
NAB Show 2026 動画技術関連レポート / NAB Show 2026 Report
Avatar for CyberAgent cyberagentdevelopers
PRO
0
200
AAIFに入ってみた ～内から見えるコミュニティ動向～
Avatar for Satoshi Ito sato4
0
230
攻撃者視点で考えるDetection Engineering
Avatar for Ruslan Sayfiev cryptopeg
3
1.8k
2026 TECHFRESH 畢業分享會 - AI-Native 重塑軟體工程與虛擬講師
Avatar for LINE Developers Taiwan line_developers_tw
PRO
0
1k
2026TECHFRESH畢業分享會 - Lightning Talk - E起 See See : 電商推薦讀心術? 數據說了算
Avatar for LINE Developers Taiwan line_developers_tw
PRO
0
1k
Claude Code の Sandbox 機能を Anthropic Sandbox Runtime(srt) で試そう！/lets-play-anthropic-sandbox-runtime
Avatar for tomoki10 tomoki10
1
600

Featured

See All Featured
Build The Right Thing And Hit Your Dates
Avatar for Maggie C. maggiecrowley
39
3.2k
KATA
Avatar for Megan Lloyd mclloyd
PRO
35
15k
Conquering PDFs: document understanding beyond plain text
Avatar for Ines Montani inesmontani
PRO
4
2.8k
Navigating the moral maze — ethical principles for Al-driven product design
Avatar for Skipper Chong Warson skipperchong
2
390
No one is an island. Learnings from fostering a developers community.
Avatar for Antonio thoeni
21
3.7k
Optimising Largest Contentful Paint
Avatar for Harry Roberts csswizardry
37
3.7k
Site-Speed That Sticks
Avatar for Harry Roberts csswizardry
13
1.2k
Beyond borders and beyond the search box: How to win the global "messy middle" with AI-driven SEO
Avatar for David Carrasco davidcarrasco
3
160
Save Time (by Creating Custom Rails Generators)
Avatar for Garrett Dimon garrettdimon
PRO
32
3.4k
Side Projects
Avatar for Sacha Greif sachag
455
43k
Performance Is Good for Brains [We Love Speed 2024]
Avatar for Tammy Everts tammyeverts
12
1.7k
Future Trends and Review - Lecture 12 - Web Technologies (1019888BNR)
Avatar for Beat Signer signer
PRO
0
3.6k

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