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 Coding Agent作りで学ぶ文脈設計〜
kworkdev
PRO
3
1.5k
Codexとも仲良く。CodeRabbit CLIの紹介
moongift
PRO
1
240
難しいセキュリティ用語をわかりやすくしてみた
yuta3110
0
200
Geospatialの世界最前線を探る [2025年版]
dayjournal
1
230
[Codex Meetup Japan #1] Codex-Powered Mobile Apps Development
korodroid
2
910
Sansan Engineering Unit 紹介資料
sansan33
PRO
1
3k
Introdução a Service Mesh usando o Istio
aeciopires
0
170
衛星画像超解像化によって実現する2D, 3D空間情報の即時生成と“AI as a Service”/ Real-time generation spatial data enabled_by satellite image super-resolution
lehupa
0
170
Data Hubグループ 紹介資料
sansan33
PRO
0
2.2k
サイバーエージェント流クラウドコスト削減施策「みんなで金塊堀太郎」
kurochan
4
2k
【Kaigi on Rails 事後勉強会LT】MeはどうしてGirlsに? 私とRubyを繋いだRail(s)
joyfrommasara
0
270
プロダクトのコードから見るGoによるデザインパターンの実践 #go_night_talk
bengo4com
1
2.6k
Featured
See All Featured
Rails Girls Zürich Keynote
gr2m
95
14k
Done Done
chrislema
185
16k
Java REST API Framework Comparison - PWX 2021
mraible
34
8.9k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
194
16k
BBQ
matthewcrist
89
9.8k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
333
22k
Stop Working from a Prison Cell
hatefulcrawdad
271
21k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
248
1.3M
Building Adaptive Systems
keathley
44
2.8k
Writing Fast Ruby
sferik
629
62k
Keith and Marios Guide to Fast Websites
keithpitt
411
23k
Git: the NoSQL Database
bkeepers
PRO
431
66k
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
͚ͩͷͷͰͳ͍