Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
少し変わった論理削除
Search
Yusuke Yagyu
August 31, 2015
Technology
3
18k
少し変わった論理削除
論理削除 Casual Talks #1 (2015/08/31)
Yusuke Yagyu
August 31, 2015
Tweet
Share
More Decks by Yusuke Yagyu
See All by Yusuke Yagyu
ペパボのデザインシステムと、モバイル領域における取り組み
gyugyu
0
1.2k
Dart Sass であれを作った
gyugyu
0
80
Android CI: 2016 edition
gyugyu
3
2.4k
Other Decks in Technology
See All in Technology
生成AI活用の組織格差を解消する 〜ビジネス職のCursor導入が開発効率に与えた好循環〜 / Closing the Organizational Gap in AI Adoption
upamune
7
5.3k
Model Mondays S2E04: AI Developer Experiences
nitya
0
140
さくらのIaaS基盤のモニタリングとOpenTelemetry/OSC Hokkaido 2025
fujiwara3
3
450
品質と速度の両立:生成AI時代の品質保証アプローチ
odasho
1
360
Lufthansa ®️ USA Contact Numbers: Complete 2025 Support Guide
lufthanahelpsupport
0
200
OPENLOGI Company Profile
hr01
0
67k
SEQUENCE object comparison - db tech showcase 2025 LT2
nori_shinoda
0
150
怖くない!はじめてのClaude Code
shinya337
0
400
生まれ変わった AWS Security Hub (Preview) を紹介 #reInforce_osaka / reInforce New Security Hub
masahirokawahara
0
480
United Airlines Customer Service– Call 1-833-341-3142 Now!
airhelp
0
170
Core Audio tapを使ったリアルタイム音声処理のお話
yuta0306
0
190
AWS認定を取る中で感じたこと
siromi
1
190
Featured
See All Featured
Agile that works and the tools we love
rasmusluckow
329
21k
[RailsConf 2023] Rails as a piece of cake
palkan
55
5.7k
The Web Performance Landscape in 2024 [PerfNow 2024]
tammyeverts
8
690
Imperfection Machines: The Place of Print at Facebook
scottboms
267
13k
Writing Fast Ruby
sferik
628
62k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
331
22k
A designer walks into a library…
pauljervisheath
207
24k
The Psychology of Web Performance [Beyond Tellerrand 2023]
tammyeverts
48
2.9k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
35
2.4k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
138
34k
Balancing Empowerment & Direction
lara
1
430
Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]
tammyeverts
6
300
Transcript
গ͠มΘͬͨཧআ ϗεςΟϯάαʔϏεʹ͓͚Δཧআͷྫ
var_dump($me); object(Engineer)#1 (3) { [“name”:private]=> string(12) “Yusuke Yagyu” [“nickname”:private]=> string(6)
“gyugyu” [“position”:private]=> string(35) “Senior engineer at GMO Pepabo, Inc.” [“leisure”:private]=> string(6) “Noder” }
Noder
None
None
None
None
ΑΖ͘͠ ͓ئ͍͠·͢
Sorry, I apologize for ͍ΘΏΔཧআΒ͍͠ཧআͷ͋·Γग़·ͤΜ ER ਤ SQL ग़͖ͯ·ͤΜ ͓͜ͱΘΓ
෮शɿཧআ ཧআͱ σʔλͷӬଓԽʹ͓͍ͯ ֘σʔλͷফڈͱผʹ σʔλ͕֎෦͔ΒࢀরෆೳͱͳΔঢ়ଶΛఆٛ͠ ͦͷঢ়ଶͱσʔλΛ্ॻ͖͢Δ͜ͱ Ͱ͋Δͱఆٛ͢Δɻ ཧআͱ
෮शɿཧআ del_flg ΧϥϜ༩ deleted_at ΧϥϜ༩ ঢ়ଶཧςʔϒϧ࡞ ཤྺςʔϒϧ࡞ ཧআɾ࣮
෮शɿཧআ ઃܭऀͷ RDBMS ʹର͢Δཧղෆ ઃܭऀͷσʔλϕʔειϑτΣΞʹର͢Δཧղෆ ઃܭऀͷυϝΠϯʹର͢Δཧղෆ Ϗδωεཁ݅ͱͯͦͦ͠ఆٛ͞Εͯ͠·͍ͬͯΔ ʢےͷѱ͍ʣཧআ͕࣮͞ΕΔഎܠ
Engineer in Wonderland
Engineer in Wonderland ཧআͱ σʔλͷӬଓԽʹ͓͍ͯ ֘σʔλͷফڈͱผʹ σʔλ͕֎෦͔ΒࢀরෆೳͱͳΔঢ়ଶΛఆٛ͠ ͦͷঢ়ଶͱσʔλΛ্ॻ͖͢Δ͜ͱ Ͱ͋Δͱఆٛ͢Δɻ ཧআͱ
Engineer in Wonderland ཧআͱ σʔλͷӬଓԽʹ͓͍ͯ ʢུʣ Ͱ͋Δͱఆٛ͢Δɻ ͨͩ͠ɺͦͷσʔλӬଓԽػߏ RDBMS ͱݶΒͳ͍ɻ
ཧআɾ࠶ఆٛ
Engineer in Wonderland ཧআͱ σʔλͷӬଓԽʹ͓͍ͯ ʢུʣ Ͱ͋Δͱఆٛ͢Δɻ ͨͩ͠ɺͦͷσʔλӬଓԽػߏ RDBMS ͱݶΒͳ͍ɻ
͞Βʹ୯ҰϨίʔυͷӬଓԽ͕ෳͷӬଓԽػߏʹ·͕ͨΔɻ ཧআɾ࠶ఆٛ
Hosting Service
Hosting Service Σϒαʔό ϝʔϧαʔό σʔλϕʔεαʔό DNS ֤छCMS ԿΛαʔϏε͢Δ͔
Hosting Service ྫͱͯ͠ΣϒαʔόͰ unix Ϣʔβ ϑΝΠϧγεςϜ ϑΝΠϧߦ RDBMS Ͳ͏ӬଓԽ͢Δ͔
Hosting Service usermod -L chmod 000 mv rmʢγϯϘϦοΫϦϯΫʣ ίϝϯτΞτ REVOKE
ඇ RDBMS ڥʹ͓͚Δཧআʢྫʣ
Hosting Service ϗεςΟϯάαʔϏεʹ͓͚Δཧআɺ RDBMS తཧআͱ࣮ͯ͠Ͱ͖ͳ͍ɻ ͳ͓͔ͭɺRDBMS Ͱͷཧআ͕ ඇ RDBMS ڥͰͷཧআͱͳΔύλʔϯ͕͋Δɻ
݁Ռɺཧআͷҙຯ͕ͿΕΔɻ
Hosting Service ϓϩμΫτΦʔφʔ ʮ͜ͷϢʔβɺআͰ͖ͳ͍͚ͲͳΜͰʁʯ ։ൃऀ ʮ͜ΕϢʔβͷཧআͳͷͰ͕͢ɺ ɹϑΝΠϧγεςϜ্ͷআͱ ɹϑΝΠϧͷίϝϯτΞτΛ࣮ࢪ͍ͯͯ͠ɺ ɹͦͷࡍʹఆ͞ΕΔߦ͕ͳ͔ͬͨͨΊɺ ɹϢʔβͷআϑϥά্͕͕͍ͬͯͳ͍ͷͰ͢ʯ
ྫʢ͋͘·Ͱ͜ΕྫͰ͢ʣ
Hosting Service ϓϩμΫτΦʔφʔ ʮϢʔβ͕আ͞ΕΔલʹ৽͘͠ঢ়ଶΛՃ͍ͨ͠Μ͚ͩͲʯ ։ൃऀ ʮ͜ͷػೳͱ͜ͷػೳΛཧআͯ͠ɺ ɹআϑϥάͱ͍ͯͬͯ͠ΔΧϥϜʹ৽͍͠ΛՃ͠·͠ΐ͏ʯ ྫʢ͋͘·Ͱ͜ΕྫͰ͢ʣ
!! Danger !!
ཧআͱఔΑ͍ڑײͰੜ͖Δ ։ൃऀԟʑʹͯ͠෦࣮ΛޠΓ͗͢Δ ඇ։ൃऀআ͕ཧ͔ཧ͔͠ͳ͍ ʮཧআʯͱ͍͏ݴ༿͕ຊʹత֬ͳදݱ͔ʁ ྫɿୀձϢʔβʁɹແޮϢʔβʁɹআͪϢʔβʁ ຊʹඞཁͳ࣌Ҏ֎ʮཧআʯͱ͍͏୯ޠΛආ͚Δ ྫɿ։ൃऀͱ͍ͯͯ֓͠೦Λཧআͱ͔͠දݱͰ͖ͳ͍߹ ཧআͱݴΘͳ͍
ཧআͱఔΑ͍ڑײͰੜ͖Δ ཧআʴϩΪϯάʹͰ͖ͳ͍͔ ཧআͰͳ͘ঢ়ଶཧͰͳ͍͔ ػೳՃɺཁ݅ͷมߋʹରͯ͠։͔Ε͍ͯΔ͔ Ϗδωεཁ݅ͱͯ͠ඞਢͷ࣌ؤுΔ ཧআΛආ͚Δ
ཧআͱఔΑ͍ڑײͰੜ͖Δ ཧআͱݴ͍ग़͢ͷσʔλͷ࣋ͪํʹनΘΕ͗͢Ͱʁ ຊདྷྗ͖͢υϝΠϯʹྗͰ͖͍ͯͳ͍ͷͰʁ ͦͦ
DDD ʰυϝΠϯۦಈઃܭʱEric Evans ʰ࣮ફυϝΠϯۦಈઃܭʱVaughn Vernon
·ͱΊ ཧআ RDBMS ʹݶΒͣɺ༷ʑͳܗͷཧআ͕ଘࡏ͠͏Δ ӬଓԽػߏ͕ෳଘࡏ͢Δͱɺཧআෳࡶ͞ͷݪҼʹͳΔ ෳࡶͳཧআΛੜͰѻ͏ΑΓɺత֬ͳঢ়ଶදݱΛఆٛ͢Δ ӬଓԽػߏ͕ෳଘࡏ͢Δ͜ͱͰɺ݁ՌతʹυϝΠϯͷ·ͳ͟͠ ͕ᔻཆ͞ΕΔ ཧআͱ͍͏୯ޠ RDBMS
͚ͩͷͷͰͳ͍