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

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

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 LBNJQP
    53"%*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
    '03
    61%"5&Ͱ΋ϩοΫ
    w ্ݶͷແ͍8)&3&ͩͱશ෦ϩοΫ
83. ίϛϡχςΟͷҧ͍ ΪϟοϓϩοΫͷ஫ҙ఺
    w ࣮ମҎ֎ͷϨίʔυ΋ϩοΫΛऔΔ
    w ൣғ಺ͷۭߦͰ΋ϩοΫ
    w ۭৼΓͷ4&-&$5
    '03
    61%"5&Ͱ΋ϩοΫ
    w ্ݶͷແ͍8)&3&ͩͱશ෦ϩοΫ ؒͷۭߦ΁*/4&35
84. ίϛϡχςΟͷҧ͍ ΪϟοϓϩοΫͷ஫ҙ఺
    w ࣮ମҎ֎ͷϨίʔυ΋ϩοΫΛऔΔ
    w ൣғ಺ͷۭߦͰ΋ϩοΫ
    w ۭৼΓͷ4&-&$5
    '03
    61%"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 WJSUVBM
     DPMVNO
     w .Z42-ΑΓഒɺΑΓഒૣ͘ʂ
106. MySQL 5.7ͱPostgreSQL 9.5 ߴ଎Խ
     w ಉҰεΩʔϚ಺Ͱ΋ϚϧνεϨουରԠ
     w ΦϓςΟϚΠβ͕ΑΓݡ͘
     w *OOP%#ʹ೔ຊޠશจݕࡧ͕௥Ճ
     w WJSUVBM
     DPMVNO
     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 WJSUVBM
     DPMVNO
     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. ͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ