カスタムフィールドの光と闇。または、愛について。

by Toro_Unit (Hiroshi Urabe)

Slide 1

Slide 1 text

ΧελϜϑΟʔϧυͷޫͱҋɻ ·ͨ͸ɺѪʹ͍ͭͯɻ 2016.2.27@WordBench ࢁས 2016.2.27@WordBench Yamanashi vol.2 1

Slide 2

Slide 2 text

whoami ͜͡͠ΐ͏͔͍ 2016.2.27@WordBench Yamanashi vol.2 2

Slide 3

Slide 3 text

Toro_Unit ઎෦ ߛ (͏Β΂ ͻΖ͠) দຊࢢࡏॅͷϑϦʔϥϯε Frontend Engineer / Plugin Developer / Web Designer Github: @torounit Twitter: @Toro_Unit Facebook: fb.me/torounit Blog: http://www.torounit.com 2016.2.27@WordBench Yamanashi vol.2 3

Slide 4

Slide 4 text

WordPressͱͷؔΘΓ • ϓϥάΠϯ࡞ऀ (Custom Post Type Permalinks ౳) / ίΞߩݙ ऀ (4.3, 4.4) / VCCW / WP-CLI (0.20.2) • WordCamp Kansai/Tokyo 2015 εϐʔΧʔ / WordBash / WordBench ௕໺(ख఻ͬͯ) / etc.... 2016.2.27@WordBench Yamanashi vol.2 4

Slide 5

Slide 5 text

WordBench ௕໺ɾদຊൡΛ ্ཱͪ͛ͨͷͰ༡ͼʹ͖ͯ Ͷɻ ൧ాൡΑΓWordBenchࢁསͷํ͕͍ۙͬͯԿࣄ Ұ೔า͚͹༨༟Ͱͭ͘Αʁ 2016.2.27@WordBench Yamanashi vol.2 5

Slide 6

Slide 6 text

͸͍ɻ 2016.2.27@WordBench Yamanashi vol.2 6

Slide 7

Slide 7 text

ΧελϜϑΟʔϧυͬͯ օ͞Μ͝ଘ͡ʁ 2016.2.27@WordBench Yamanashi vol.2 7

Slide 8

Slide 8 text

౤ߘͱ͔ɺϖʔδͱ͔ʹɺຊจ΍ɺλΠτϧҎ֎Ͱಠࣗͷ৘ใ ΛϑϦʔμϜʹઃఆͰ͖Δػೳɻ 2016.2.27@WordBench Yamanashi vol.2 8

Slide 9

Slide 9 text

͔͜͜Β͍͡Ε·͢ɻ 2016.2.27@WordBench Yamanashi vol.2 9

Slide 10

Slide 10 text

2016.2.27@WordBench Yamanashi vol.2 10

Slide 11

Slide 11 text

ͳʹ͜Εɻ 2016.2.27@WordBench Yamanashi vol.2 11

Slide 12

Slide 12 text

Ͱ΋ϓϥάΠϯΛ࢖ͬͨΓ͢Δͱɻ 2016.2.27@WordBench Yamanashi vol.2 12

Slide 13

Slide 13 text

͜ΜͳϑΟʔϧυΛ࡞ͬͨΓ 2016.2.27@WordBench Yamanashi vol.2 13

Slide 14

Slide 14 text

౤ߘը໘Λ؆୯ʹ ΧελϚΠζग़དྷΔʂ ͪͳΈʹ௕࡚ͷΩλδϚ͞Μ࡞ͬͯΔɺSmart Custom Fields ࢖ͬͯ·͢ɻ ϫλΫγ΋ίϯτ ϦϏϡʔλʔͰ͢ɻ Smart Custom Fields — WordPress Plugins 2016.2.27@WordBench Yamanashi vol.2 14

Slide 15

Slide 15 text

ͪΌΜͱWordPressͷؔ਺΋͋ΔΑ! • get_post_meta(); • update_post_meta(); • etc.... 2016.2.27@WordBench Yamanashi vol.2 15

Slide 16

Slide 16 text

ͬ͢͝ʔ͍ɻ(๮) 2016.2.27@WordBench Yamanashi vol.2 16

Slide 17

Slide 17 text

Ͱ΋ 2016.2.27@WordBench Yamanashi vol.2 17

Slide 18

Slide 18 text

ͪΌΜͱ͠Βͳ͍Ͱ࢖͏ ͱ஍ࠈΛΈΔΑʁ 2016.2.27@WordBench Yamanashi vol.2 18

Slide 19

Slide 19 text

CMS౳ͷΧελϚΠζΛߟ͑Δͱ͖ͷ ๻Βͷ಄ͷத 2016.2.27@WordBench Yamanashi vol.2 19

Slide 20

Slide 20 text

2016.2.27@WordBench Yamanashi vol.2 20

Slide 21

Slide 21 text

ݱ࣮ 2016.2.27@WordBench Yamanashi vol.2 21

Slide 22

Slide 22 text

wp_posts ςʔϒϧ 2016.2.27@WordBench Yamanashi vol.2 22

Slide 23

Slide 23 text

σʔλ͕ͳ͍??? 2016.2.27@WordBench Yamanashi vol.2 23

Slide 24

Slide 24 text

͜͜ʹ͋ΔΑʁ 2016.2.27@WordBench Yamanashi vol.2 24

Slide 25

Slide 25 text

wp_postmeta ςʔϒϧ 2016.2.27@WordBench Yamanashi vol.2 25

Slide 26

Slide 26 text

;͊ͬ!? 2016.2.27@WordBench Yamanashi vol.2 26

Slide 27

Slide 27 text

͜Ε͕ͦ͜ΧελϜϑΟʔϧυͷਖ਼ମɻ NoSQLͰ͍͍Μ͡Όͳ͍͔ 2016.2.27@WordBench Yamanashi vol.2 27

Slide 28

Slide 28 text

͜Ε͕΋ͨΒ͢ҋ 2016.2.27@WordBench Yamanashi vol.2 28

Slide 29

Slide 29 text

ݕࡧ͕க໋తʹ஗͍ʂ • ͜ͷखͷҊ݅͸ݕࡧػೳ͕ཁٻ͞ΕͨΓ͢Δɻ • meta_value ʹ index ͕ઃఆ͞Ε͍ͯͳ͍ɻ • ਺ࣈɺจࣈྻɺγϦΞϥΠζ͞Εͨ഑ྻɺΦϒδΣΫτɺ base64Τϯίʔυͨ͠ը૾౳͕͸͍ͬͯͨΓ͢Δ͜ͱ΋ɻ • ϓϥάΠϯͳͲͷઃఆͳͲ΋ೖͬͨΓɺWordPressͷඪ४ͷ ػೳͱͯ͠ΧελϜϑΟʔϧυΛར༻͍ͯ͠Δύλʔϯ΋ 2016.2.27@WordBench Yamanashi vol.2 29

Slide 30

Slide 30 text

ͭΒ͍ʂ 2016.2.27@WordBench Yamanashi vol.2 30

Slide 31

Slide 31 text

ରࡦ • ͳΜͰ΋ΧελϜϑΟʔϧυʹग़དྷΔ͚ͲΑ͘ߟ͑Α͏ɻ • ͱΓ͋͑ͣɺΤϦΞͳͲಛఆͷ஋͔ΒબͿ΋ͷ͸ɺΧςΰϦ ʔɾλΫιϊϛʔ Λ࢖͓͏ɻͬͪ͜ʹ͸ͪΌΜͱ index ͕ு ΒΕͯΔɻ • ࣗ෼Ͱ Table ࡞Δͷͩͬͯ͋Γɻ 2016.2.27@WordBench Yamanashi vol.2 31

Slide 32

Slide 32 text

• WordPress͸PHPॻ͚Ε͹ԿͰ΋ग़དྷΔ͚ͲɺWordPress ͩ ͔Βͱ҆қʹߟ͑Δͱ஍ࠈɻԿͰ΋ग़དྷΔ͜ͱͱɺखܰʹग़ དྷΔ͜ͱɺ໨తʹԊ͍ͬͯΔ͜ͱ͸݁ߏҧ͏ɻ • ࡳଋͰԥͬͨΓɺΩϟογϡΛ૊ΜͩΓɺͦͷ෦෼͚ͩ WordPress͡Όͳ͍΋ͷʹ͢ΔͳͲɺॊೈʹߟ͑Α͏ɻ • ʮͱΓ͋͑ͣWordPress ͰͱΓ͋͑ͣϓϥάΠϯೖΕͯ…ʯ ͸஍ࠈͷ࢝·ΓɻͪΌΜͱ࢓༷Λ੔ཧͯ͠ɺઃܭ͠Α͏!!! 2016.2.27@WordBench Yamanashi vol.2 32

Slide 33

Slide 33 text

ੈͷதͷΧελϜϑΟʔϧυ͍͍ͬͯͩͨ͜͏͍͏࣮૷! ൚༻ੑͷߴ͍΋ͷʹ͸ඞͣ٘ਜ਼ʹͨ͠ͳʹ͔͕͋ΔͷΑɻ 2016.2.27@WordBench Yamanashi vol.2 33

Slide 34

Slide 34 text

݁ہ͍͍͍ͨ͜ͱɻ 2016.2.27@WordBench Yamanashi vol.2 34

Slide 35

Slide 35 text

ʮWordPress͸ͳΜͰ΋Ͱ͖Δ!ʯ • PHP Ͱॻ͔ΕͯΔ͠ PHP Ͱग़དྷΔ͜ͱͳΒԿͰ΋ग़དྷΔ Αʂ౰ͨΓલʂ • CakePHP ΍ Laravel ͱͷѱຐ߹ମͱ͔ग़དྷΔ͠ɺWordPress ͷػೳͷݺͼग़͠ΛࢭΊͨΓ͢Ε͹ WordPress ͷൽ͚ͩඃͬ ͨผͷԿ͔ʹ͔ͩͬͯ֬ʹग़དྷΔɻ 2016.2.27@WordBench Yamanashi vol.2 35

Slide 36

Slide 36 text

ͦΕ WordPress ࢖Θͳͯ͘ྑ͍ΑͶʁ 2016.2.27@WordBench Yamanashi vol.2 36

Slide 37

Slide 37 text

• ਓؒͩΕ͠΋ಘҙͳ͜ͱɺෆಘҙͳ͜ͱ͋Δʂ • ྑ͍ͱ͜΋ѱ͍ͱ͜Ζ΋ਓͦΕͧΕʂ ιϑτ΢ΣΞ΋ಉ͡ʂ 2016.2.27@WordBench Yamanashi vol.2 37

Slide 38

Slide 38 text

ྑ͍ͱ͜Ζ΋ѱ͍ͱ͜Ζ΋ղ ্ͬͨͰɺͦΕͰ΋Ұॹʹډ ͍ͨͱࢥ͏͜ͱ͕ʮѪʯͩͱ ࢥ͏ΜͰ͢Αɻ ݟͳ͔ͬͨ͜ͱʹ͢ΔΜ͡Όແ͍Μͩͧɻ ͱΖΏʹ͞Μ͸൴ঁืूதͰ͢ɻ 2016.2.27@WordBench Yamanashi vol.2 38

Slide 39

Slide 39 text

• CMS ͸ුؾͯ͠΋ྑ͍͔Β!ɺCMS ͷුؾ͸ΤϯδχΞͷߕ ൹ੑ͔ͩΒ࢓ํͳ͍ɻͰ΋ɻɻɻWordPress ͷώϞʹͳΔͱ ͔ɺͨͩ౎߹ͷྑ͍ CMSͱͯ͠ɺͳΜͱͳ͘ݺͼग़͢ͱ͔͸ ΋͏΍Ίͯ͋͛ͯ!!! • ͦͷ্ͰͪΌΜͱ WordPress Λ ʮબ୒ʯ͢Δͷ͸͖ͬͱ޾ ͤͳ WordPress ϥΠϑ!! • ࣗ෼ͷۤखͳͱ͜Ζͱɺ WordPress ͷۤखͳͱ͜ΖΛϑΥϩ ʔ͠߹͑͹ྑ͍ͱࢥ͏ͷ! ࢧ͑߹ͬͯੜ͖͍͖ͯ·͠ΐ͏Α! 2016.2.27@WordBench Yamanashi vol.2 39

Slide 40

Slide 40 text

ʮຊ౰ͷѪʯͰ WordPress ͱ޲͖߹ͬ ͯ͋͛ͯ! 2016.2.27@WordBench Yamanashi vol.2 40

Slide 41

Slide 41 text

͓ΘΓɻ 2016.2.27@WordBench Yamanashi vol.2 41