Upgrade to PRO for Only $50/Year—Limited-Time Offer! 🔥

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

Avatar for nikawa2161 nikawa2161
December 28, 2025
Technology
0
0

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

Avatar for nikawa2161

nikawa2161

December 28, 2025
Tweet

More Decks by nikawa2161

See All by nikawa2161
自分のコードを数年ぶりに読んだら
Avatar for nikawa2161 nikawa2161
0
0
ユーザーインタビュー分析に参加して得られたことと気づき
Avatar for nikawa2161 nikawa2161
0
0
oEmbedとは？
Avatar for nikawa2161 nikawa2161
0
0
はじめまして、にかわです
Avatar for nikawa2161 nikawa2161
0
0
課題を映す問題空間と、答えを描く解決空間
Avatar for nikawa2161 nikawa2161
0
0
転生したら自己肯定感MAXになりたい
Avatar for nikawa2161 nikawa2161
0
0
沖縄リモート生活と、新しい発想の種
Avatar for nikawa2161 nikawa2161
0
0
バツイチマッチングアプリの進捗
Avatar for nikawa2161 nikawa2161
0
0
UNIX哲学
Avatar for nikawa2161 nikawa2161
0
2

Other Decks in Technology

See All in Technology
Connection-based OAuthから学ぶOAuth for AI Agents
Avatar for GMO Flatt Security flatt_security
0
360
日本の AI 開発と世界の潮流 / GenAI Development in Japan
Avatar for Yoshitaka Haribara hariby
1
390
NIKKEI Tech Talk #41: セキュア・バイ・デザインからクラウド管理を考える
Avatar for Ryosuke Sekido sekido
PRO
0
210
ActiveJobUpdates
Avatar for Kuniaki IGARASHI igaiga
1
310
意外と知らない状態遷移テストの世界
Avatar for nihonbuson nihonbuson
PRO
1
240
[Data & AI Summit '25 Fall] AIでデータ活用を進化させる！Google Cloudで作るデータ活用の未来
Avatar for kirimaru kirimaru
0
3.8k
re:Invent2025 3つの Frontier Agents を紹介 / introducing-3-frontier-agents
Avatar for tomoki10 tomoki10
0
400
LayerX QA Night#1
Avatar for koyaman2 koyaman2
0
260
TED_modeki_共創ラボ_20251203.pdf
Avatar for AIxIoTビジネス共創ラボ iotcomjpadmin
0
150
SREが取り組むデプロイ高速化 ─ Docker Buildを最適化した話
Avatar for capytan capytan
0
140
[Neurogica] 採用ポジション/ Recruitment Position
Avatar for Neurogica neurogica
1
120
M&Aで拡大し続けるGENDAのデータ活用を促すためのDatabricks権限管理 / AEON TECH HUB #22
Avatar for GENDA genda
0
230

Featured

See All Featured
Paper Plane (Part 1)
Avatar for Katie Cordina Lindsey katiecoart
PRO
0
1.9k
Automating Front-end Workflow
Avatar for Addy Osmani addyosmani
1371
200k
エンジニアに許された特別な時間の終わり
Avatar for watany watany
105
220k
We Analyzed 250 Million AI Search Results: Here's What I Found
Avatar for Josh Blyskal joshbly
0
260
Speed Design
Avatar for Sergey Chernyshev sergeychernyshev
33
1.4k
How To Speak Unicorn (iThemes Webinar)
Avatar for Michelle Schulp Hunt marktimemedia
1
340
Leading Effective Engineering Teams in the AI Era
Avatar for Addy Osmani addyosmani
9
1.4k
AI: The stuff that nobody shows you
Avatar for John Nunemaker jnunemaker
PRO
1
19
A better future with KSS
Avatar for Kyle Neath kneath
240
18k
The World Runs on Bad Software
Avatar for Brandon Keepers bkeepers
PRO
72
12k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
Avatar for Irina Nazarova irinanazarova
9
1.1k
The #1 spot is gone: here's how to win anyway
Avatar for Tamara Novitovic tamaranovitovic
1
860

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