少し変わった論理削除

論理削除 Casual Talks #1 (2015/08/31)

Transcript

1. গ͠มΘͬͨ࿦ཧ࡟আ ϗεςΟϯάαʔϏεʹ͓͚Δ࿦ཧ࡟আͷྫ
2. 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” }
3. Noder
8. ΑΖ͘͠ ͓ئ͍͠·͢
9. Sorry, I apologize for ͍ΘΏΔ࿦ཧ࡟আΒ͍͠࿦ཧ࡟আͷ࿩͸͋·Γग़·ͤΜ ER ਤ΍ SQL ΋ग़͖ͯ·ͤΜ ͓͜ͱΘΓ
10. ෮शɿ࿦ཧ࡟আ ࿦ཧ࡟আͱ͸ σʔλͷӬଓԽʹ͓͍ͯ ౰֘σʔλͷফڈͱ͸ผʹ σʔλ͕֎෦͔ΒࢀরෆೳͱͳΔঢ়ଶΛఆٛ͠ ͦͷঢ়ଶ΁ͱσʔλΛ্ॻ͖͢Δ͜ͱ Ͱ͋Δͱఆٛ͢Δɻ ࿦ཧ࡟আͱ͸
11. ෮शɿ࿦ཧ࡟আ del_flg ΧϥϜ෇༩ deleted_at ΧϥϜ෇༩ ঢ়ଶ؅ཧςʔϒϧ࡞੒ ཤྺςʔϒϧ࡞੒ ࿦ཧ࡟আɾ࣮૷
12. ෮शɿ࿦ཧ࡟আ ઃܭऀͷ RDBMS ʹର͢Δཧղෆ଍ ઃܭऀͷσʔλϕʔειϑτ΢ΣΞʹର͢Δཧղෆ଍ ઃܭऀͷυϝΠϯʹର͢Δཧղෆ଍ Ϗδωεཁ݅ͱͯͦ͠΋ͦ΋ఆٛ͞Εͯ͠·͍ͬͯΔ ʢےͷѱ͍ʣ࿦ཧ࡟আ͕࣮૷͞ΕΔഎܠ
13. Engineer in Wonderland
14. Engineer in Wonderland ࿦ཧ࡟আͱ͸ σʔλͷӬଓԽʹ͓͍ͯ ౰֘σʔλͷফڈͱ͸ผʹ σʔλ͕֎෦͔ΒࢀরෆೳͱͳΔঢ়ଶΛఆٛ͠ ͦͷঢ়ଶ΁ͱσʔλΛ্ॻ͖͢Δ͜ͱ Ͱ͋Δͱఆٛ͢Δɻ ࿦ཧ࡟আͱ͸
15. Engineer in Wonderland ࿦ཧ࡟আͱ͸ σʔλͷӬଓԽʹ͓͍ͯ ʢུʣ Ͱ͋Δͱఆٛ͢Δɻ ͨͩ͠ɺͦͷσʔλӬଓԽػߏ͸ RDBMS ͱ͸ݶΒͳ͍ɻ ࿦ཧ࡟আɾ࠶ఆٛ
16. Engineer in Wonderland ࿦ཧ࡟আͱ͸ σʔλͷӬଓԽʹ͓͍ͯ ʢུʣ Ͱ͋Δͱఆٛ͢Δɻ ͨͩ͠ɺͦͷσʔλӬଓԽػߏ͸ RDBMS ͱ͸ݶΒͳ͍ɻ ͞Βʹ୯ҰϨίʔυͷӬଓԽ͕ෳ਺ͷӬଓԽػߏʹ·͕ͨΔɻ ࿦ཧ࡟আɾ࠶ఆٛ
17. Hosting Service
18. Hosting Service ΢Σϒαʔό ϝʔϧαʔό σʔλϕʔεαʔό DNS ֤छCMS ԿΛαʔϏε͢Δ͔
19. Hosting Service ྫͱͯ͠΢ΣϒαʔόͰ͸ unix Ϣʔβ ϑΝΠϧγεςϜ ϑΝΠϧߦ RDBMS Ͳ͏ӬଓԽ͢Δ͔
20. Hosting Service usermod -L chmod 000 mv rmʢγϯϘϦοΫϦϯΫʣ ίϝϯτΞ΢τ REVOKE ඇ RDBMS ؀ڥʹ͓͚Δ࿦ཧ࡟আʢྫʣ
21. Hosting Service ϗεςΟϯάαʔϏεʹ͓͚Δ࿦ཧ࡟আ͸ɺ RDBMS త࿦ཧ࡟আͱ࣮ͯ͠૷Ͱ͖ͳ͍ɻ ͳ͓͔ͭɺRDBMS Ͱͷ࿦ཧ࡟আ͕ ඇ RDBMS ؀ڥͰͷ෺ཧ࡟আͱͳΔύλʔϯ͕͋Δɻ ݁Ռɺ࿦ཧ࡟আͷҙຯ͕ͿΕΔɻ
22. Hosting Service ϓϩμΫτΦʔφʔ ʮ͜ͷϢʔβɺ࡟আͰ͖ͳ͍͚ͲͳΜͰʁʯ ։ൃऀ ʮ͜Ε͸Ϣʔβͷ࿦ཧ࡟আͳͷͰ͕͢ɺ ɹϑΝΠϧγεςϜ্ͷ࡟আͱ ɹϑΝΠϧͷίϝϯτΞ΢τΛ࣮ࢪ͍ͯͯ͠ɺ ɹͦͷࡍʹ૝ఆ͞ΕΔߦ͕ͳ͔ͬͨͨΊɺ ɹϢʔβͷ࡟আϑϥά্͕͕͍ͬͯͳ͍ͷͰ͢ʯ ྫʢ͋͘·Ͱ΋͜Ε͸ྫͰ͢ʣ
23. Hosting Service ϓϩμΫτΦʔφʔ ʮϢʔβ͕࡟আ͞ΕΔલʹ৽͘͠ঢ়ଶΛ௥Ճ͍ͨ͠Μ͚ͩͲʯ ։ൃऀ ʮ͜ͷػೳͱ͜ͷػೳΛ࿦ཧ࡟আͯ͠ɺ ɹ࡟আϑϥάͱͯ͠࢖͍ͬͯΔΧϥϜʹ৽͍͠஋Λ௥Ճ͠·͠ΐ͏ʯ ྫʢ͋͘·Ͱ΋͜Ε͸ྫͰ͢ʣ
24. !! Danger !!
25. ࿦ཧ࡟আͱఔΑ͍ڑ཭ײͰੜ͖Δ ։ൃऀ͸ԟʑʹͯ͠಺෦࣮૷ΛޠΓ͗͢Δ ඇ։ൃऀ͸࡟আ͕࿦ཧ͔෺ཧ͔࡯஌͠ͳ͍ ʮ࿦ཧ࡟আʯͱ͍͏ݴ༿͕ຊ౰ʹత֬ͳදݱ͔ʁ ྫɿୀձϢʔβʁɹແޮϢʔβʁɹ࡟আ଴ͪϢʔβʁ ຊ౰ʹඞཁͳ࣌Ҏ֎ʮ࿦ཧ࡟আʯͱ͍͏୯ޠΛආ͚Δ ྫɿ։ൃऀͱ࿩͍ͯͯ֓͠೦Λ࿦ཧ࡟আͱ͔͠දݱͰ͖ͳ͍৔߹ ࿦ཧ࡟আͱݴΘͳ͍
26. ࿦ཧ࡟আͱఔΑ͍ڑ཭ײͰੜ͖Δ ෺ཧ࡟আʴϩΪϯάʹͰ͖ͳ͍͔ ࿦ཧ࡟আͰ͸ͳ͘ঢ়ଶ؅ཧͰ͸ͳ͍͔ ػೳ௥Ճɺཁ݅ͷมߋʹରͯ͠։͔Ε͍ͯΔ͔ Ϗδωεཁ݅ͱͯ͠ඞਢͷ࣌͸ؤுΔ ࿦ཧ࡟আΛආ͚Δ
27. ࿦ཧ࡟আͱఔΑ͍ڑ཭ײͰੜ͖Δ ࿦ཧ࡟আͱݴ͍ग़͢ͷ͸σʔλͷ࣋ͪํʹनΘΕ͗͢Ͱ͸ʁ ຊདྷ஫ྗ͢΂͖υϝΠϯʹ஫ྗͰ͖͍ͯͳ͍ͷͰ͸ʁ ͦ΋ͦ΋࿦
28. DDD ʰυϝΠϯۦಈઃܭʱEric Evans ʰ࣮ફυϝΠϯۦಈઃܭʱVaughn Vernon
29. ·ͱΊ ࿦ཧ࡟আ͸ RDBMS ʹݶΒͣɺ༷ʑͳܗͷ࿦ཧ࡟আ͕ଘࡏ͠͏Δ ӬଓԽػߏ͕ෳ਺ଘࡏ͢Δͱɺ࿦ཧ࡟আ͸ෳࡶ͞ͷݪҼʹͳΔ ෳࡶͳ࿦ཧ࡟আΛੜͰѻ͏ΑΓɺత֬ͳঢ়ଶදݱΛఆٛ͢Δ ӬଓԽػߏ͕ෳ਺ଘࡏ͢Δ͜ͱͰɺ݁ՌతʹυϝΠϯ΁ͷ·ͳ͟͠ ͕ᔻཆ͞ΕΔ ࿦ཧ࡟আͱ͍͏୯ޠ͸ RDBMS ͚ͩͷ΋ͷͰ͸ͳ͍