Upgrade to Pro — share decks privately, control downloads, hide ads and more …

2大OSSデータベースのMySQLとPostgreSQLの違い(後半)

 2大OSSデータベースのMySQLとPostgreSQLの違い(後半)

第32回 PostgreSQL 勉強会(2015年10月10日)の資料です。
https://www.postgresql.jp/wg/shikumi/pgstudy_32/view

88f4e84b94fe07cddbd9e6479d689192?s=128

soudai sone

April 02, 2016
Tweet

Transcript

  1. 2େOSSσʔλϕʔεͷ MySQLͱPostgreSQLͷҧ͍ (ޙ൒) ୈ32ճ PostgreSQL ษڧձ

  2. What is it? ͜ͷεϥΠυͷ గਖ਼Օॴ ΛؚΊͨϒϩά͸ͪ͜Β IUUQTPVEBJCMPHTQPUKQPTTNZTRMQPTUHSFTRMIUNM

  3. What is it? લ൒ઓΛऴ͑ͯ

  4. What is it? લ൒ઓΛऴ͑ͯ ˣ .Z42-ͱ1PTUHSF42-͕ҧ͏ͷ͸Θ͔ͬͨ

  5. What is it? લ൒ઓΛऴ͑ͯ ˣ .Z42-ͱ1PTUHSF42-͕ҧ͏ͷ͸Θ͔ͬͨ ˣ ΠϯυͱΠϯυωγΞ͘Β͍ҧ͏

  6. What is it? લ൒ઓΛऴ͑ͯ ˣ .Z42-ͱ1PTUHSF42-͕ҧ͏ͷ͸Θ͔ͬͨ ˣ +BWBͱ+BWB4DSJQU͘Β͍ҧ͏

  7. What is it? લ൒ઓΛऴ͑ͯ ˣ .Z42-ͱ1PTUHSF42-͕ҧ͏ͷ͸Θ͔ͬͨ ˣ +BWBͱ+BWB4DSJQU͘Β͍ҧ͏ ྨࣅྫҰཡ ΠϯυͱΠϯυωγΞҧ͏

    ,0'ͷژͱ,0'ͷژ͘Β͍ҧ͏ ετͷϦϡ΢ͱέϯ͘Β͍ҧ͏ ए೫Ֆͱو೫Ֆ͘Β͍ҧ͏ ϙέϞϯͱ༯ո΢Υον͘Β͍ҧ͏ લా݈ଠͱલాஐಙ͘Β͍ҧ͏ ʜͳͲ
  8. What is it? ͭ·Γ͸ಉ͡3%#Ͱ΋݁ߏҧ͏

  9. What is it? Ͱ΋ػೳͷҧ͍͚ͩͰ͸ઓྗͷҧ͍ʹͳΒͳ͍

  10. What is it? Ћͷ෦෼Λ͝঺հ͠·͢

  11. What is it? લఏ৚݅ લ൒ઓͷ࿩Λௌ͍ͯΔ͜ͱ·ͨ͸ݟͯΔ͜ͱ

  12. What is it? લఏ৚݅ ଓɾ1PTUHSF42-ŧŔŕŪƂŜſ

  13. What is it? લఏ৚݅ ଓɾ1PTUHSF42-ŧŔŕŪƂŜſ ˣ ࠷৽൛ͱ͔1PTUHSF42-ͷ᠘ͷ࿩͸ͳ͍Ͱ͢

  14. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹίϛϡχςΟͷҧ͍ ̏ɹϋϚϦͲ͜ΖͷTips ̐ɹMySQL 5.7ͱPostgreSQL 9.5 ̑ɹ·ͱΊ

  15. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹίϛϡχςΟͷҧ͍ ̏ɹϋϚϦͲ͜ΖͷTips ̐ɹMySQL 5.7ͱPostgreSQL 9.5 ̑ɹ·ͱΊ

  16. ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ̏̌ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿWebΤϯδχΞ ॴଐɿ೔ຊPostgreSQLϢʔβձ ɹɹɹதࠃࢧ෦ ࢧ෦௕ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢

  17. ࣗݾ঺հ ໊લɿીࠜɹ૖େʢͦͶɹ͚ͨͱ΋ʣ ೥ྸɿ̏̌ࡀʢࡾਓͷࢠڙ͕͍·͢ʣ ৬ۀɿWebΤϯδχΞ ॴଐɿ೔ຊPostgreSQLϢʔβձ ɹɹɹதࠃࢧ෦ ࢧ෦௕ ɹɹٕज़తʹ͸LLܥݴޠͱ͔RDB͕޷͖Ͱ͢

  18. தࠃ஍ํDBษڧձ https://dbstudychugoku.github.io/

  19. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹίϛϡχςΟͷҧ͍ ̏ɹϋϚϦͲ͜ΖͷTips ̐ɹMySQL 5.7ͱPostgreSQL 9.5 ̑ɹ·ͱΊ

  20. ίϛϡχςΟͷҧ͍ ߲໨ίϛϡχςΟ໊ .Z/" +16( ࢀՃํ๏ .-ͷొ࿥ .-ʹొ࿥ਖ਼ձһొ࿥ ૊৫छྨ ༗ࢤʹΑΔϘϥϯςΟΞ /10๏ਓ

    ӡӦࢿۚ ɹແ͠ ༗Γ ίϛϡχέʔγϣϯ πʔϧ .-ɾTMBDL .-ɾTMBDL
  21. ίϛϡχςΟͷҧ͍ ߲໨ίϛϡχςΟ໊ .Z/" +16( ࢀՃํ๏ .-ͷొ࿥ .-ʹొ࿥ਖ਼ձһొ࿥ ૊৫छྨ ༗ࢤʹΑΔϘϥϯςΟΞ /10๏ਓ

    ӡӦࢿۚ ɹແ͠ ༗Γ ίϛϡχέʔγϣϯ πʔϧ .-ɾTMBDL .-ɾTMBDL
  22. ίϛϡχςΟͷҧ͍ ߲໨ίϛϡχςΟ໊ .Z/" +16( ࢀՃํ๏ .-ͷొ࿥ .-ʹొ࿥ਖ਼ձһొ࿥ ૊৫छྨ ༗ࢤʹΑΔϘϥϯςΟΞ /10๏ਓ

    ӡӦࢿۚ ɹແ͠ ༗Γ ίϛϡχέʔγϣϯ πʔϧ .-ɾTMBDL .-ɾTMBDL
  23. ίϛϡχςΟͷҧ͍ ༧ࢉͷ༗ແ w .Z42-Ϣʔβձ͸͓ۚͷ੍໿Λ࡞Βͳ͍ͨΊ ʹ༧ࢉΛ׶͑ͯઃ͚ͯͳ͍ w ೔ຊ1PTUHSFTϢʔβձ͸ڠࢍۚΛूΊɺ/10 ๏ਓͱͯ͠؅ཧ͍ͯ͠Δ

  24. ίϛϡχςΟͷҧ͍ ༧ࢉͷ༗ແ w .Z42-Ϣʔβձ͸͓ۚͷ੍໿Λ࡞Βͳ͍ͨΊ ʹ༧ࢉΛ׶͑ͯઃ͚ͯͳ͍ w ೔ຊ1PTUHSFTϢʔβձ͸ڠࢍۚΛूΊɺ/10 ๏ਓͱͯ͠؅ཧ͍ͯ͠Δ ࠓ೔ͷަ௨අ͸+16(ʹࢧԉͯ͠΋Βͬͯ·͢

  25. ίϛϡχςΟͷҧ͍ ϢʔβձͷΞ΢τϓοτͷҧ͍ w +16(͸υΩϡϝϯτ͸ίϛϡχςΟͰ࡞੒ w .Z/"͸ݸʑͷΞ΢τϓοτʹҕͶΔ
 ެࣜυΩϡϝϯτ͸0SBDMF͕࡞੒ w ษڧձ͸ͲͪΒ΋ਵ࣌ओମͰߦ͍ͬͯΔ

  26. ίϛϡχςΟͷҧ͍ TMBDL͕ؾܰʹ࣭໰Ͱ͖ͯϨεϙϯε΋ྑ͍ .Z42-ɿIUUQNZTRMDBTVBMTMBDLJOIFSPLVBQQDPN 1PTUHSF42-ɿIUUQTQPTUHSFTRMIBDLFSTKQIFSPLVBQQDPN

  27. ίϛϡχςΟͷҧ͍ ಥવͰ͕͢ʜ

  28. ίϛϡχςΟͷҧ͍ ಥવͰ͕͢ʜ ˣ ࠓ͙͢ϑΥϩʔ͢΂͖ΤϯδχΞϦετ

  29. ίϛϡχςΟͷҧ͍ ಥવͰ͕͢ʜ ˣ ࠓ͙͢ϑΥϩʔ͢΂͖ΤϯδχΞϦετ େମࠓ೔ͷ࿩͸͜ͷਓͨͪΛݟͯΕ͹ࣗવͱ֮͑Δ

  30. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ

  31. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ !3,BKJZBNB

  32. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ !LBNJQP

  33. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ !ZZBNBTBLJ

  34. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ !OJQQPOEBOKJ

  35. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖.Z42-ΤϯδχΞ !ZPLV

  36. ίϛϡχςΟͷҧ͍ ԶΑΓڧ͍.Z42-ΤϯδχΞʹձ͍ʹߦ͘ ೔ຊ.Z42-Ϣʔβձձʢ.Z/"ձʣಛผฤ Ϣʔβձप೥ه೦ύʔςΟ ʙϢʔβձͱ.Z42-ͷ೥ΛৼΓฦΔʂʙ ։࠵೔෇ɿ೥݄೔ ۚ  ։࠵࣌ࠁɿΛ༧ఆ ձ৔ɿגࣜձࣾίϩϓϥ

    ʢ౦ژɾܙൺणΨʔσϯϓϨΠελϫʔ֊ʣ
  37. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ

  38. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ 1PTUHSF42-ͳਓɺ5XJUUFS࢖ͬͯͳ͍໰୊

  39. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !GVKJJ@NBTBP

  40. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !TOBHB

  41. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !T

  42. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !TBXBEB@NBTBIJLP

  43. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !OPCPSVT

  44. ίϛϡχςΟͷҧ͍ ࠓ͙͢ϑΥϩʔ͢΂͖1PTUHSF42-ΤϯδχΞ !OVLP@ZPLPIBNB

  45. ίϛϡχςΟͷҧ͍ 1PTUHSF42-ΧϯϑΝϨϯε ೔࣌ɿ೥݄೔ ۚ ɹʙ ৔ॴɿ"1඼઒ɹ ౦ژ౎ߓ۠ߴྠ౦ٸୈೋϏϧ  ಺༰ɿޕલجௐߨԋΛؚΉߨԋΛ༧ఆ ޕޙτϥοΫʹͯߨԋఔ౓Λ༧ఆɻ

    ΧϯϑΝϨϯεऴྃޙʹ࠙਌ձ͕͋Γ·͢ɻ ࢀՃਓ਺ݟࠐΈɿ໊ ҰൠࢀՃ໊ఔ౓  ࢀՃඅɿ ԁΛ༧ఆ IUUQXXXQPTUHSFTRMKQFWFOUTKQVHQHDPO
  46. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹίϛϡχςΟͷҧ͍ ̏ɹϋϚϦͲ͜ΖͷTips ̐ɹMySQL 5.7ͱPostgreSQL 9.5 ̑ɹ·ͱΊ

  47. ϋϚϦͲ͜ΖͷTips ͓଴ͨͤ͠·ͨ͠ ຊ೔ͷϝΠϯͰ͢

  48. ϋϚϦͲ͜ΖͷTips ຊ೔ͷ͓඼ॻ͖ .Z42-ฤ  w ᐆດͳάϧʔϓ w SPPU͸౓ࢗ͢ w ᐆດͳ஋

    w ΪϟοϓϩοΫͱτϥϯβΫγϣϯϨϕϧ
  49. ϋϚϦͲ͜ΖͷTips ຊ೔ͷ͓඼ॻ͖ .Z42-ฤ  w ᐆດͳάϧʔϓ w SPPU͸౓ࢗ͢ w ᐆດͳ஋

    w ΪϟοϓϩοΫͱτϥϯβΫγϣϯϨϕϧ
  50. ϋϚϦͲ͜ΖͷTips 4&-&$5 '30.TBNQMF JE HSPVQ OBNF BHF  ޿ౡ 4POF

      ޿ౡ TPOF   ෱ࢁ TPVEBJ   ෱ࢁ UBLFUPNP 
  51. ᐆດͳGROUP SELECT id, `group`,age FROM sample GROUP BY `group`

  52. ᐆດͳGROUP SELECT id, `group`,age FROM sample GROUP BY `group` HSPVQ͕༧໿ޠͳͷͰAͰғΉ

  53. ϋϚϦͲ͜ΖͷTips ݁Ռ JE HSPVQ BHF  ޿ౡ   ෱ࢁ

    
  54. ϋϚϦͲ͜ΖͷTips ݁Ռ JE HSPVQ BHF  ޿ౡ   ෱ࢁ

     6OJRVFͰ͸ແ͍ͷͰԿ͕ग़Δ͔͸Θ͔Βͳ͍
  55. ϋϚϦͲ͜ΖͷTips LBNJQP53"%*5*0/"-

  56. ᐆດͳGROUP SET SESSION sql_mode=‘TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY’; SELECT id, `group`,age FROM sample GROUP

    BY `group`;
  57. ᐆດͳGROUP SET SESSION sql_mode=‘TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY’; SELECT id, `group`,age FROM sample GROUP

    BY `group`;
  58. ᐆດͳGROUP SET SESSION sql_mode=‘TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY’; SELECT id, `group`,age FROM sample GROUP

    BY `group`; .Z42-ͷಠ֦ࣗுΛແޮʹ͢Δ
  59. ᐆດͳGROUP SET SESSION sql_mode=‘TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY’; SELECT id, `group`,age FROM sample GROUP

    BY `group`; ΋ͪΖΜNZDPOGʹ͔͍ͯ΋ྑ͍
  60. ϋϚϦͲ͜ΖͷTips ຊ೔ͷ͓඼ॻ͖ .Z42-ฤ  w ᐆດͳάϧʔϓ w SPPU͸౓ࢗ͢ w ᐆດͳ஋

    w ΪϟοϓϩοΫͱτϥϯβΫγϣϯϨϕϧ w ࢖͑Δͷ͸ͭ
  61. root͸2౓ࢗ͢ ——ΞΧ΢ϯτΛ֬ೝ͢Δ SELECT user , host FROM user;

  62. ϋϚϦͲ͜ΖͷTips ݁Ռ VTFS IPTU SPPU  SPPU  SPPU MPDBMIPTU

  63. ϋϚϦͲ͜ΖͷTips ݁Ռ VTFS IPTU SPPU  SPPU  SPPU MPDBMIPTU

    ͦΕͧΕผϢʔβ
  64. ϋϚϦͲ͜ΖͷTips ݁Ռ VTFS IPTU SPPU  SPPU  SPPU MPDBMIPTU

    ΞΫηεग़དྷΔIPTU
  65. ϋϚϦͲ͜ΖͷTips ݁Ռ VTFS IPTU SPPU  SPPU  SPPU MPDBMIPTU

    QH@ICB@DPOG૬౰
  66. ϋϚϦͲ͜ΖͷTips ຊ೔ͷ͓඼ॻ͖ .Z42-ฤ  w ᐆດͳάϧʔϓ w SPPU͸౓ࢗ͢ w ᐆດͳ஋

    w ΪϟοϓϩοΫͱτϥϯβΫγϣϯϨϕϧ
  67. ᐆດͳ஋ SELECT * FROM sample WHERE name = 'sone'

  68. ϋϚϦͲ͜ΖͷTips ݁Ռ JE HSPVQ OBNF BHF  ޿ౡ 4POF 

     ޿ౡ TPOF 
  69. ϋϚϦͲ͜ΖͷTips ݁Ռ JE HSPVQ OBNF BHF  ޿ౡ 4POF 

     ޿ౡ TPOF 
  70. ϋϚϦͲ͜ΖͷTips ݁Ռ JE HSPVQ OBNF BHF  ޿ౡ 4POF 

     ޿ౡ TPOF  େจࣈখจࣈΛൺֱͯ͠ͳ͍
  71. ϋϚϦͲ͜ΖͷTips ຊ೔ͷ͓඼ॻ͖ .Z42-ฤ  w ᐆດͳάϧʔϓ w SPPU͸౓ࢗ͢ w ᐆດͳ஋

    w ΪϟοϓϩοΫͱτϥϯβΫγϣϯϨϕϧ
  72. ϋϚϦͲ͜ΖͷTips τϥϯβΫγϣϯϨϕϧ ෼཭Ϩϕϧ μʔςΟ Ϧʔυ ϑΝδʔ Ϧʔυ ϑΝϯτϜ Ϧʔυ ಡΈऔΓ

    ϩοΫ 3&"% 6/$0..*55&% :FT :FT :FT /P 3&"% $0..*55&% /P :FT :FT /P 3&1&"5"#-& 3&"% /P /P :FT /P 4&3*"-*;"#-& /P /P /P /P
  73. ϋϚϦͲ͜ΖͷTips τϥϯβΫγϣϯϨϕϧ ෼཭Ϩϕϧ μʔςΟ Ϧʔυ ϑΝδʔ Ϧʔυ ϑΝϯτϜ Ϧʔυ ಡΈऔΓ

    ϩοΫ 3&"% 6/$0..*55&% :FT :FT :FT /P 3&"% $0..*55&% /P :FT :FT /P 3&1&"5"#-& 3&"% /P /P :FT /P 4&3*"-*;"#-& /P /P /P /P .Z42-ͷσϑΥϧτ
  74. ϋϚϦͲ͜ΖͷTips τϥϯβΫγϣϯϨϕϧ ෼཭Ϩϕϧ μʔςΟ Ϧʔυ ϑΝδʔ Ϧʔυ ϑΝϯτϜ Ϧʔυ ಡΈऔΓ

    ϩοΫ 3&"% 6/$0..*55&% :FT :FT :FT /P 3&"% $0..*55&% /P :FT :FT /P 3&1&"5"#-& 3&"% /P /P :FT /P 4&3*"-*;"#-& /P /P /P /P 1PTUHSF42-ͷσϑΥϧτ
  75. ίϛϡχςΟͷҧ͍ ΪϟοϓϩοΫ w .Z42-ͷσϑΥϧτ͸3&1&"5"#-&3&"% w *OOPEC͸ߋ৽ର৅ͷߦ͚ͩΛϩοΫͰ͸ͳ͍ʂ w ༧૝֎ͷϩοΫΛऔಘ͢Δ w ߋ৽ॲཧͳͲͰϩοΫ଴ͪ౳͕ൃੜ͢Δ͜ͱ͕͋Δ

  76. ίϛϡχςΟͷҧ͍ ΪϟοϓϩοΫ w .Z42-ͷσϑΥϧτ͸3&1&"5"#-&3&"% w *OOPEC͸ߋ৽ର৅ͷߦ͚ͩΛϩοΫͰ͸ͳ͍ʂ w ༧૝֎ͷϩοΫΛऔಘ͢Δ w ߋ৽ॲཧͳͲͰϩοΫ଴ͪ౳͕ൃੜ͢Δ͜ͱ͕͋Δ

  77. ΪϟοϓϩοΫ begin; SELECT * FROM lock_demo WHERE id >= 5

    AND id <= 10 FOR UPDATE; commit;
  78. ΪϟοϓϩοΫ begin; SELECT * FROM lock_demo WHERE id >= 5

    AND id <= 10 FOR UPDATE; commit; ൣғΛࢦఆͯ͠ϩοΫΛऔಘ
  79. ΪϟοϓϩοΫ INSERT INTO `demo`.`lock_demo` (`id`, `name`) VALUES ('7', 'test');

  80. ΪϟοϓϩοΫ INSERT INTO `demo`.`lock_demo` (`id`, `name`) VALUES ('7', 'test'); ؒͷۭߦ΁*/4&35

  81. ΪϟοϓϩοΫ INSERT INTO `demo`.`lock_demo` (`id`, `name`) VALUES ('7', 'test'); ؒͷۭߦ΁*/4&35

    ͜ͷ*/4&35͸଴ͨ͞ΕΔʂʂ
  82. ίϛϡχςΟͷҧ͍ ΪϟοϓϩοΫͷ஫ҙ఺ w ࣮ମҎ֎ͷϨίʔυ΋ϩοΫΛऔΔ w ൣғ಺ͷۭߦͰ΋ϩοΫ w ۭৼΓͷ4&-&$5'0361%"5&Ͱ΋ϩοΫ w ্ݶͷແ͍8)&3&ͩͱશ෦ϩοΫ

  83. ίϛϡχςΟͷҧ͍ ΪϟοϓϩοΫͷ஫ҙ఺ w ࣮ମҎ֎ͷϨίʔυ΋ϩοΫΛऔΔ w ൣғ಺ͷۭߦͰ΋ϩοΫ w ۭৼΓͷ4&-&$5'0361%"5&Ͱ΋ϩοΫ w ্ݶͷແ͍8)&3&ͩͱશ෦ϩοΫ

    ؒͷۭߦ΁*/4&35
  84. ίϛϡχςΟͷҧ͍ ΪϟοϓϩοΫͷ஫ҙ఺ w ࣮ମҎ֎ͷϨίʔυ΋ϩοΫΛऔΔ w ൣғ಺ͷۭߦͰ΋ϩοΫ w ۭৼΓͷ4&-&$5'0361%"5&Ͱ΋ϩοΫ w ্ݶͷແ͍8)&3&ͩͱશ෦ϩοΫ

    8)&3&JEͳͲ͸ةݥ
  85. ϋϚϦͲ͜ΖͷTips ߋʹωΫετΩʔϩοΫ΋͋Δ

  86. ϋϚϦͲ͜ΖͷTips ߋʹωΫετΩʔϩοΫ΋͋Δ ˣ ߋ৽ߦͷલޙͷϩοΫΛऔΔ

  87. ϋϚϦͲ͜ΖͷTips ௕͍ͷͰଓ͖͸8FCͰ !LBNJQP͞ΜͷϒϩάΛҾ༻ *OOP%#ͷϩοΫͷൣғͱωΫετΩʔϩοΫͷ࿩ IUUQCMPHLBNJQPOFUFOUSZ

  88. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹίϛϡχςΟͷҧ͍ ̏ɹϋϚϦͲ͜ΖͷTips ̐ɹMySQL 5.7ͱPostgreSQL 9.5 ̑ɹ·ͱΊ

  89. MySQL 5.7ͱPostgreSQL 9.5 ྆%#ͷ࠷৽൛

  90. MySQL 5.7ͱPostgreSQL 9.5 ྆%#ͷ࠷৽൛ ˣ ͦΖͦΖਖ਼ࣜ൛͕ग़Δ

  91. MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-ͷ࿩Λฉ͖ʹདྷͨਓʁ

  92. MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-ͷ࿩Λฉ͖ʹདྷͨਓʁ ˣ ࢒೦ɺ๯಄Ͱ΋৮Ε·͕ͨ͠આ໌͠·ͤΜ

  93. MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-

  94. MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42- ˣ ϧʔΫɺʮࣰాͷދͷרͦͷ̐ʯΛ࢖͑ ελʔɾ΢Υʔζݟͨ͜ͱແ͍͚Ͳ

  95. MySQL 5.7ͱPostgreSQL 9.5 ஶऀͷࣰా͞Μ

  96. MySQL 5.7ͱPostgreSQL 9.5 ஶऀͷࣰా͞Μ ˣ ୈճதࠃ஍ํ%#ษڧձJOग़Ӣ   Ͱ1PTUHSF42-ͷ࿩Λͯ͘͠Ε·͢

  97. MySQL 5.7ͱPostgreSQL 9.5 ͋ͱᖒా͞Μ͕1PTUHSF42-ৄ͍͠

  98. MySQL 5.7ͱPostgreSQL 9.5 ͋ͱᖒా͞Μ͕1PTUHSF42-ৄ͍͠ ˣ 1PTUHSF42-৽ػೳ঺հ IUUQXXXTMJEFTIBSFOFUIBEPPQYOUUEBUBQPTUHSFTRMOFXGFBUVSFTOUUEBUB ֆͱ͔͍ͬͺ͍͋ΔͷͰॳ৺ऀʹ΋༏͍͠ࢿྉͱͳ͓ͬͯΓ·͢

  99. MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-ΧϯϑΝϨϯε ߦͬͨΒ୭͔࿩ͯ͠ΔΑ ʢଟ෼ɺ͖ͬͱɺ.BZCFʣ

  100. MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͷৄࡉ

  101. MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͷৄࡉ ˣ தࠃ஍ํ%#ษڧձʹஔ͍ͯ͋ΔΑ IUUQTECTUVEZDIVHPLVHJUIVCJP

  102. MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͷৄࡉ ˣ தࠃ஍ํ%#ษڧձʹஔ͍ͯ͋ΔΑ IUUQTECTUVEZDIVHPLVHJUIVCJP ͔͠΋ಈը෇͖

  103. MySQL 5.7ͱPostgreSQL 9.5 தࠃ஍ํ%#ษڧձ ୈճ.Z42-ͷ࠷৽ࣄ৘ ֿࢁ͞Μ  ୈճ.Z42-࠷৽ࣄ৘ ֿࢁ͞Μ 

    ୈճ.Z42-3$ొ৔ʂ࣍ͷ.Z42-͸͕͜͜ҧ͏ͬʂ ֿࢁ͞Μ  ୈճ.Z42-։ൃ࠷৽ಈ޲ ࢁ࡚͞Μ  ͦͷதͰ͍͔ͭ͘ϐοΫΞοϓ
  104. MySQL 5.7ͱPostgreSQL 9.5 ιʔείʔυ͕HJUIVCͰެ։͞Εͨ ެࣜϦϙδτϦ IUUQTHJUIVCDPNNZTRM .Z42-ຊମҎ֎ʹ΋໘ന͍΋ͷ͕୔ࢁʂ

  105. MySQL 5.7ͱPostgreSQL 9.5 ߴ଎Խ w ಉҰεΩʔϚ಺Ͱ΋ϚϧνεϨουରԠ w ΦϓςΟϚΠβ͕ΑΓݡ͘ w *OOP%#ʹ೔ຊޠશจݕࡧ͕௥Ճ

    w WJSUVBMDPMVNO w .Z42-ΑΓഒɺΑΓഒૣ͘ʂ
  106. MySQL 5.7ͱPostgreSQL 9.5 ߴ଎Խ w ಉҰεΩʔϚ಺Ͱ΋ϚϧνεϨουରԠ w ΦϓςΟϚΠβ͕ΑΓݡ͘ w *OOP%#ʹ೔ຊޠશจݕࡧ͕௥Ճ

    w WJSUVBMDPMVNO w .Z42-ΑΓഒɺΑΓഒૣ͘ʂ
  107. MySQL 5.7ͱPostgreSQL 9.5

  108. MySQL 5.7ͱPostgreSQL 9.5

  109. MySQL 5.7ͱPostgreSQL 9.5 ߴ଎Խ w ಉҰεΩʔϚ಺Ͱ΋ϚϧνεϨουରԠ w ΦϓςΟϚΠβ͕ΑΓݡ͘ w *OOP%#ʹ೔ຊޠશจݕࡧ͕௥Ճ

    w WJSUVBMDPMVNO w .Z42-ΑΓഒɺΑΓഒૣ͘ʂ ಛʹߴෛՙ͕࣌ૣ͘ͳͬͨ
  110. MySQL 5.7ͱPostgreSQL 9.5 ߴػೳԽ w ΫΤϦɾϦϥΠτɾϓϥάΠϯ w +40/ܕΛαϙʔτ w ϨϓϦέʔγϣϯͷڧԽ

  111. MySQL 5.7ͱPostgreSQL 9.5 ߴػೳԽ w ΫΤϦɾϦϥΠτɾϓϥάΠϯ w +40/ܕΛαϙʔτ w ϨϓϦέʔγϣϯͷڧԽ

    ·ͩ1PTUHSF42-ͷํ͕Ұ೔ͷ௕͕͋Δ
  112. MySQL 5.7ͱPostgreSQL 9.5 ߴػೳԽ w ΫΤϦɾϦϥΠτɾϓϥάΠϯ w +40/ܕΛαϙʔτ w ϨϓϦέʔγϣϯͷڧԽ

    .Z42-ຊମͰࣗಈϑΣΠϧΦʔόʔΛαϙʔτ 1PTUHSF42-ίϛολ༷ɺ·ͩͰ͔͢ʁ
  113. MySQL 5.7ͱPostgreSQL 9.5 ͦͷଞ w 4:4εΩʔϚΛαϙʔτ w 0/-:@'6--@(3061@#: .Z42- ͕σϑΥϧτ

    w ೔Ͱ1BTTXPSEมߋڧ੍͕σϑΥϧτ w ͭͷςʔϒϧʹϚϧντϦΨʔΛαϙʔτ
  114. MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-

  115. MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42- ˣ ਖ਼౷೿ͳ3%#ΛΑΓ֦ு͍ͯ͘͠ײ͡

  116. MySQL 5.7ͱPostgreSQL 9.5 .Z42-

  117. MySQL 5.7ͱPostgreSQL 9.5 .Z42- ˣ ਖ਼͍͠3%#ͬΆ͘ͳͬͨ ʢͦͷӨڹͰԼҐޓ׵ੑͷແ͍มߋ΋ଟ͍ʣ ݩ͕ΏΔ;Θܥա͗ͨͷͰྑ͍ͱࢥ͏

  118. MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ.Z42-

  119. MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ.Z42- ΑΓେن໛ΞʔΩςΫνϟʹಛԽ͍͖ͯͦ͠͏

  120. MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ.Z42- ΑΓେن໛ΞʔΩςΫνϟʹಛԽ͍͖ͯͦ͠͏ ˣ ϥΠόϧ͸1PTUHSF42-Ͱ͸ͳ͘/042-

  121. MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ1PTUHSF42-

  122. MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ1PTUHSF42- ਖ਼౷೿3%#ͱͯ͠ਐԽ͍͖ͯͦ͠͏

  123. MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ1PTUHSF42- ਖ਼౷೿3%#ͱͯ͠ਐԽ͍͖ͯͦ͠͏ ˣ ϥΠόϧ͸.Z42-Ͱ͸ͳ͘ɺ঎༻%#

  124. MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͱ1PTUHSF42-

  125. MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͱ1PTUHSF42- ࠓ·Ͱ΋͜Ε͔Β΋ॅΈ෼͚͕ਐΜͰ͍͘

  126. ͋͐͡Μͩ ̍ɹࣗݾ঺հ ̎ɹίϛϡχςΟͷҧ͍ ̏ɹϋϚϦͲ͜ΖͷTips ̐ɹMySQL 5.7ͱPostgreSQL 9.5 ̑ɹ·ͱΊ

  127. ·ͱΊ ෳ਺ͷબ୒ࢶΛ஌Δ

  128. ·ͱΊ ෳ਺ͷબ୒ࢶΛ஌Δ ˣ ධՁ͕࣠૿͑ͯൃ૝͕޿͕Δ

  129. ·ͱΊ ෳ਺ͷબ୒ࢶΛ஌Δ ˣ ධՁ͕࣠૿͑ͯൃ૝͕޿͕Δ ˣ ઃܭྗ্͕͕Δ

  130. ·ͱΊ બ୒ࢶ͕૿͑Δ

  131. ·ͱΊ બ୒ࢶ͕૿͑Δ ˣ ࢓ࣄͷ෯͕૿͑Δ

  132. ·ͱΊ બ୒ࢶ͕૿͑Δ ˣ ࢓ࣄͷ෯͕૿͑Δ ˣ .Z42-΋1PTUHSF42-΋Θ͔Δਓ͸গͳ͍

  133. ·ͱΊ બ୒ࢶ͕૿͑Δ ˣ ࢓ࣄͷ෯͕૿͑Δ ˣ .Z42-΋1PTUHSF42-΋Θ͔Δਓ͸গͳ͍ ࠓޙ΋3%#૚ͷ044ར༻͸૿͑Δ͸ͣ

  134. ·ͱΊ બ୒ࢶ͕૿͑Δ ˣ ࢓ࣄͷ෯͕૿͑Δ ˣ .Z42-΋1PTUHSF42-΋Θ͔Δਓ͸গͳ͍ ࠓޙ΋3%#૚ͷ044ར༻͸૿͑Δ͸ͣ %#ΤϯδχΞͷੜ͖࢒ΓઓུͷҰͭ

  135. ·ͱΊ ࠷৽൛ͷௐࠪ

  136. ·ͱΊ ࠷৽൛ͷௐࠪ ˣ ίϛϡχςΟΛ্ख͘࢖͏

  137. ·ͱΊ ࠷৽൛ͷௐࠪ ˣ ίϛϡχςΟΛ্ख͘࢖͏ ˣ ೔ຊޠ৘ใ΋ଟ͍

  138. ·ͱΊ ࠷৽൛ͷௐࠪ ˣ ίϛϡχςΟΛ্ख͘࢖͏ ˣ ೔ຊޠ৘ใ΋ଟ͍ ߴ଎Խ΋ϝϦοτ͕ͩ ࠓࠔͬͯΔࣄΛղܾͯ͘͠ΕΔࣄ΋ଟ͍ ྫɿ1PTUHSF42-ͷ.BSHFจ .Z42-ͷτϦΨʔͳͲ

  139. ·ͱΊ ΤϯδχΞͱͯ͠ੜ͖࢒Δʹ͸

  140. ·ͱΊ ΤϯδχΞͱͯ͠ੜ͖࢒Δʹ͸ ˣ 3%#ͷٕज़ͷण໋͸௕͍

  141. ·ͱΊ ΤϯδχΞͱͯ͠ੜ͖࢒Δʹ͸ ˣ 3%#ͷٕज़ͷण໋͸௕͍ ˣ ϕϯμʔϩοΫΠϯ͞Εͳ͍஌ࣝ͸وॏ

  142. ·ͱΊ σʔλͷण໋͸ίʔυΑΓ௕͍

  143. ·ͱΊ σʔλͷण໋͸ίʔυΑΓ௕͍ ˣ ͔ͩΒͦ͜%#ͷ஌ࣝ͸େ੾Ͱ͢

  144. ·ͱΊ %#ͷʮ͜Ε஌Βͳ͔ͬͨʯ

  145. ·ͱΊ %#ͷʮ͜Ε஌Βͳ͔ͬͨʯ ˣ க໋ইʹͳΔ͜ͱ΋ଟ͍

  146. ·ͱΊ ීஈ͔Βͷ஌ࣝͷΞοϓσʔτΛେ੾ʹ

  147. ·ͱΊ ීஈ͔Βͷ஌ࣝͷΞοϓσʔτΛେ੾ʹ ˣ ൺֱ͢Δ͜ͱͰؔ࿈෇͚ͨ͠هԱʹͳΔ

  148. ·ͱΊ ٕज़͸ෳ਺ֶͼ·͠ΐ͏

  149. ͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ