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
17k
少し変わった論理削除
論理削除 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
1k
Dart Sass であれを作った
gyugyu
0
73
Android CI: 2016 edition
gyugyu
3
2.2k
Other Decks in Technology
See All in Technology
MySQLのロックの種類とその競合
yoku0825
6
1.6k
AI研修【MIXI 24新卒技術研修】
mixi_engineers
PRO
0
130
AOAI Dev Day LLMシステム開発 Tips集
hirosatogamo
15
3.6k
Azure OpenAI Service Dev Day / LLMでできる!使える!生成AIエージェント
masahiro_nishimi
3
740
ゆめみのアクセシビリティの現在地と今後
ryokatsuse
3
290
開発生産性をむしろ向上させる セキュリティパートナーの作り方 / Dev Productivity Con 2024
flatt_security
0
360
頼られるのが大好きな 皆さんへ - 支援相手との期待の合わせ方、突き放し方 -/For_people_who_like_to_be_relied_on
naitosatoshi
1
290
CTOから見た事業開発とプロダクト開発 / My Perspective on Business and Product Development as CTO
keisuke69
4
960
開発と事業を繋ぐ!SREのオブザーバビリティ戦略 ~ Developers Summit 2024 Summer ~
leveragestech
0
620
さらに高品質・高速化を目指すAI時代のテスト設計支援と、めざす先 / AI Test Lab vol.1
shift_evolve
0
190
Github Actions 로 Android 팀의 효율성 극대화
hadonghyun
0
160
ここがすごいよ! AWS Systems Manager!
saichan11
0
1.8k
Featured
See All Featured
XXLCSS - How to scale CSS and keep your sanity
sugarenia
245
1.2M
Rebuilding a faster, lazier Slack
samanthasiow
78
8.5k
Music & Morning Musume
bryan
43
5.9k
Testing 201, or: Great Expectations
jmmastey
33
6.9k
Learning to Love Humans: Emotional Interface Design
aarron
269
39k
Fontdeck: Realign not Redesign
paulrobertlloyd
79
5.1k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
44
4.7k
[RailsConf 2023] Rails as a piece of cake
palkan
35
4.4k
Facilitating Awesome Meetings
lara
46
5.8k
Faster Mobile Websites
deanohume
303
30k
Building a Scalable Design System with Sketch
lauravandoore
458
32k
BBQ
matthewcrist
82
9k
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
͚ͩͷͷͰͳ͍