2大OSSデータベースのMySQLとPostgreSQLの違い(後半)

by soudai sone

Slide 1

Slide 1 text

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

Slide 2

Slide 2 text

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

Slide 3

Slide 3 text

What is it? લ൒ઓΛऴ͑ͯ

Slide 4

Slide 4 text

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

Slide 5

Slide 5 text

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

Slide 6

Slide 6 text

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

Slide 7

Slide 7 text

What is it? લ൒ઓΛऴ͑ͯ ˣ .Z42-ͱ1PTUHSF42-͕ҧ͏ͷ͸Θ͔ͬͨ ˣ +BWBͱ+BWB4DSJQU͘Β͍ҧ͏ ྨࣅྫҰཡ ΠϯυͱΠϯυωγΞҧ͏ ,0'ͷژͱ,0'ͷژ͘Β͍ҧ͏ ετͷϦϡ΢ͱέϯ͘Β͍ҧ͏ ए೫Ֆͱو೫Ֆ͘Β͍ҧ͏ ϙέϞϯͱ༯ո΢Υον͘Β͍ҧ͏ લా݈ଠͱલాஐಙ͘Β͍ҧ͏ ʜͳͲ

Slide 8

Slide 8 text

What is it? ͭ·Γ͸ಉ͡3%#Ͱ΋݁ߏҧ͏

Slide 9

Slide 9 text

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

Slide 10

Slide 10 text

What is it? Ћͷ෦෼Λ͝঺հ͠·͢

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

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

Slide 13

Slide 13 text

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

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

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

Slide 16

Slide 16 text

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

Slide 17

Slide 17 text

Slide 18

Slide 18 text

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

Slide 19

Slide 19 text

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

Slide 20

Slide 20 text

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

Slide 21

Slide 21 text

Slide 22

Slide 22 text

Slide 23

Slide 23 text

ίϛϡχςΟͷҧ͍ ༧ࢉͷ༗ແ w .Z42-Ϣʔβձ͸͓ۚͷ੍໿Λ࡞Βͳ͍ͨΊ ʹ༧ࢉΛ׶͑ͯઃ͚ͯͳ͍ w ೔ຊ1PTUHSFTϢʔβձ͸ڠࢍۚΛूΊɺ/10 ๏ਓͱͯ͠؅ཧ͍ͯ͠Δ

Slide 24

Slide 24 text

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

Slide 25

Slide 25 text

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

Slide 26

Slide 26 text

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

Slide 27

Slide 27 text

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

Slide 28

Slide 28 text

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

Slide 29

Slide 29 text

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

Slide 30

Slide 30 text

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

Slide 31

Slide 31 text

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

Slide 32

Slide 32 text

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

Slide 33

Slide 33 text

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

Slide 34

Slide 34 text

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

Slide 35

Slide 35 text

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

Slide 36

Slide 36 text

ίϛϡχςΟͷҧ͍ ԶΑΓڧ͍.Z42-ΤϯδχΞʹձ͍ʹߦ͘ ೔ຊ.Z42-Ϣʔβձձʢ.Z/"ձʣಛผฤ Ϣʔβձप೥ه೦ύʔςΟ ʙϢʔβձͱ.Z42-ͷ೥ΛৼΓฦΔʂʙ ։࠵೔෇ɿ೥݄೔ ۚ ։࠵࣌ࠁɿΛ༧ఆ ձ৔ɿגࣜձࣾίϩϓϥ ʢ౦ژɾܙൺणΨʔσϯϓϨΠελϫʔ֊ʣ

Slide 37

Slide 37 text

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

Slide 38

Slide 38 text

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

Slide 39

Slide 39 text

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

Slide 40

Slide 40 text

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

Slide 41

Slide 41 text

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

Slide 42

Slide 42 text

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

Slide 43

Slide 43 text

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

Slide 44

Slide 44 text

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

Slide 45

Slide 45 text

ίϛϡχςΟͷҧ͍ 1PTUHSF42-ΧϯϑΝϨϯε ೔࣌ɿ೥݄೔ ۚ ɹʙ ৔ॴɿ"1඼઒ɹ ౦ژ౎ߓ۠ߴྠ౦ٸୈೋϏϧ ಺༰ɿޕલجௐߨԋΛؚΉߨԋΛ༧ఆ ޕޙτϥοΫʹͯߨԋఔ౓Λ༧ఆɻ ΧϯϑΝϨϯεऴྃޙʹ࠙਌ձ͕͋Γ·͢ɻ ࢀՃਓ਺ݟࠐΈɿ໊ ҰൠࢀՃ໊ఔ౓ ࢀՃඅɿ ԁΛ༧ఆ IUUQXXXQPTUHSFTRMKQFWFOUTKQVHQHDPO

Slide 46

Slide 46 text

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

Slide 47

Slide 47 text

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

Slide 48

Slide 48 text

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

Slide 49

Slide 49 text

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

Slide 50

Slide 50 text

ϋϚϦͲ͜ΖͷTips 4&-&$5'30.TBNQMF JE HSPVQ OBNF BHF ޿ౡ 4POF ޿ౡ TPOF ෱ࢁ TPVEBJ ෱ࢁ UBLFUPNP

Slide 51

Slide 51 text

ᐆດͳGROUP SELECT id, `group`,age FROM sample GROUP BY `group`

Slide 52

Slide 52 text

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

Slide 53

Slide 53 text

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

Slide 54

Slide 54 text

ϋϚϦͲ͜ΖͷTips ݁Ռ JE HSPVQ BHF ޿ౡ ෱ࢁ 6OJRVFͰ͸ແ͍ͷͰԿ͕ग़Δ͔͸Θ͔Βͳ͍

Slide 55

Slide 55 text

ϋϚϦͲ͜ΖͷTips LBNJQP53"%*5*0/"-

Slide 56

Slide 56 text

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

Slide 57

Slide 57 text

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

Slide 58

Slide 58 text

ᐆດͳ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-ͷಠ֦ࣗுΛແޮʹ͢Δ

Slide 59

Slide 59 text

ᐆດͳ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ʹ͔͍ͯ΋ྑ͍

Slide 60

Slide 60 text

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

Slide 61

Slide 61 text

root͸2౓ࢗ͢ ——ΞΧ΢ϯτΛ֬ೝ͢Δ SELECT user , host FROM user;

Slide 62

Slide 62 text

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

Slide 63

Slide 63 text

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

Slide 64

Slide 64 text

ϋϚϦͲ͜ΖͷTips ݁Ռ VTFS IPTU SPPU SPPU SPPU MPDBMIPTU ΞΫηεग़དྷΔIPTU

Slide 65

Slide 65 text

ϋϚϦͲ͜ΖͷTips ݁Ռ VTFS IPTU SPPU SPPU SPPU MPDBMIPTU QH@ICB@DPOG૬౰

Slide 66

Slide 66 text

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

Slide 67

Slide 67 text

ᐆດͳ஋ SELECT * FROM sample WHERE name = 'sone'

Slide 68

Slide 68 text

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

Slide 69

Slide 69 text

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

Slide 70

Slide 70 text

ϋϚϦͲ͜ΖͷTips ݁Ռ JE HSPVQ OBNF BHF ޿ౡ 4POF ޿ౡ TPOF େจࣈখจࣈΛൺֱͯ͠ͳ͍

Slide 71

Slide 71 text

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

Slide 72

Slide 72 text

ϋϚϦͲ͜Ζͷ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

Slide 73

Slide 73 text

ϋϚϦͲ͜Ζͷ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-ͷσϑΥϧτ

Slide 74

Slide 74 text

ϋϚϦͲ͜Ζͷ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-ͷσϑΥϧτ

Slide 75

Slide 75 text

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

Slide 76

Slide 76 text

Slide 77

Slide 77 text

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

Slide 78

Slide 78 text

ΪϟοϓϩοΫ begin; SELECT * FROM lock_demo WHERE id >= 5 AND id <= 10 FOR UPDATE; commit; ൣғΛࢦఆͯ͠ϩοΫΛऔಘ

Slide 79

Slide 79 text

ΪϟοϓϩοΫ INSERT INTO `demo`.`lock_demo` (`id`, `name`) VALUES ('7', 'test');

Slide 80

Slide 80 text

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

Slide 81

Slide 81 text

ΪϟοϓϩοΫ INSERT INTO `demo`.`lock_demo` (`id`, `name`) VALUES ('7', 'test'); ؒͷۭߦ΁*/4&35 ͜ͷ*/4&35͸଴ͨ͞ΕΔʂʂ

Slide 82

Slide 82 text

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

Slide 83

Slide 83 text

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

Slide 84

Slide 84 text

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

Slide 85

Slide 85 text

ϋϚϦͲ͜ΖͷTips ߋʹωΫετΩʔϩοΫ΋͋Δ

Slide 86

Slide 86 text

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

Slide 87

Slide 87 text

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

Slide 88

Slide 88 text

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

Slide 89

Slide 89 text

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

Slide 90

Slide 90 text

MySQL 5.7ͱPostgreSQL 9.5 ྆%#ͷ࠷৽൛ ˣ ͦΖͦΖਖ਼ࣜ൛͕ग़Δ

Slide 91

Slide 91 text

MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-ͷ࿩Λฉ͖ʹདྷͨਓʁ

Slide 92

Slide 92 text

MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-ͷ࿩Λฉ͖ʹདྷͨਓʁ ˣ ࢒೦ɺ๯಄Ͱ΋৮Ε·͕ͨ͠આ໌͠·ͤΜ

Slide 93

Slide 93 text

MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-

Slide 94

Slide 94 text

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

Slide 95

Slide 95 text

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

Slide 96

Slide 96 text

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

Slide 97

Slide 97 text

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

Slide 98

Slide 98 text

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

Slide 99

Slide 99 text

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

Slide 100

Slide 100 text

MySQL 5.7ͱPostgreSQL 9.5 .Z42-ͷৄࡉ

Slide 101

Slide 101 text

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

Slide 102

Slide 102 text

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

Slide 103

Slide 103 text

MySQL 5.7ͱPostgreSQL 9.5 தࠃ஍ํ%#ษڧձ ୈճ.Z42-ͷ࠷৽ࣄ৘ ֿࢁ͞Μ ୈճ.Z42-࠷৽ࣄ৘ ֿࢁ͞Μ ୈճ.Z42-3$ొ৔ʂ࣍ͷ.Z42-͸͕͜͜ҧ͏ͬʂ ֿࢁ͞Μ ୈճ.Z42-։ൃ࠷৽ಈ޲ ࢁ࡚͞Μ ͦͷதͰ͍͔ͭ͘ϐοΫΞοϓ

Slide 104

Slide 104 text

MySQL 5.7ͱPostgreSQL 9.5 ιʔείʔυ͕HJUIVCͰެ։͞Εͨ ެࣜϦϙδτϦ IUUQTHJUIVCDPNNZTRM .Z42-ຊମҎ֎ʹ΋໘ന͍΋ͷ͕୔ࢁʂ

Slide 105

Slide 105 text

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

Slide 106

Slide 106 text

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

Slide 107

Slide 107 text

MySQL 5.7ͱPostgreSQL 9.5

Slide 108

Slide 108 text

MySQL 5.7ͱPostgreSQL 9.5

Slide 109

Slide 109 text

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

Slide 110

Slide 110 text

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

Slide 111

Slide 111 text

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

Slide 112

Slide 112 text

MySQL 5.7ͱPostgreSQL 9.5 ߴػೳԽ w ΫΤϦɾϦϥΠτɾϓϥάΠϯ w +40/ܕΛαϙʔτ w ϨϓϦέʔγϣϯͷڧԽ .Z42-ຊମͰࣗಈϑΣΠϧΦʔόʔΛαϙʔτ 1PTUHSF42-ίϛολ༷ɺ·ͩͰ͔͢ʁ

Slide 113

Slide 113 text

MySQL 5.7ͱPostgreSQL 9.5 ͦͷଞ w 4:4εΩʔϚΛαϙʔτ w 0/-:@'6--@(3061@#: .Z42- ͕σϑΥϧτ w ೔Ͱ1BTTXPSEมߋڧ੍͕σϑΥϧτ w ͭͷςʔϒϧʹϚϧντϦΨʔΛαϙʔτ

Slide 114

Slide 114 text

MySQL 5.7ͱPostgreSQL 9.5 1PTUHSF42-

Slide 115

Slide 115 text

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

Slide 116

Slide 116 text

MySQL 5.7ͱPostgreSQL 9.5 .Z42-

Slide 117

Slide 117 text

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

Slide 118

Slide 118 text

MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ.Z42-

Slide 119

Slide 119 text

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

Slide 120

Slide 120 text

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

Slide 121

Slide 121 text

MySQL 5.7ͱPostgreSQL 9.5 ࠓޙͷ1PTUHSF42-

Slide 122

Slide 122 text

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

Slide 123

Slide 123 text

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

Slide 124

Slide 124 text

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

Slide 125

Slide 125 text

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

Slide 126

Slide 126 text

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

Slide 127

Slide 127 text

·ͱΊ ෳ਺ͷબ୒ࢶΛ஌Δ

Slide 128

Slide 128 text

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

Slide 129

Slide 129 text

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

Slide 130

Slide 130 text

·ͱΊ બ୒ࢶ͕૿͑Δ

Slide 131

Slide 131 text

·ͱΊ બ୒ࢶ͕૿͑Δ ˣ ࢓ࣄͷ෯͕૿͑Δ

Slide 132

Slide 132 text

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

Slide 133

Slide 133 text

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

Slide 134

Slide 134 text

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

Slide 135

Slide 135 text

·ͱΊ ࠷৽൛ͷௐࠪ

Slide 136

Slide 136 text

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

Slide 137

Slide 137 text

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

Slide 138

Slide 138 text

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

Slide 139

Slide 139 text

·ͱΊ ΤϯδχΞͱͯ͠ੜ͖࢒Δʹ͸

Slide 140

Slide 140 text

·ͱΊ ΤϯδχΞͱͯ͠ੜ͖࢒Δʹ͸ ˣ 3%#ͷٕज़ͷण໋͸௕͍

Slide 141

Slide 141 text

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

Slide 142

Slide 142 text

·ͱΊ σʔλͷण໋͸ίʔυΑΓ௕͍

Slide 143

Slide 143 text

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

Slide 144

Slide 144 text

·ͱΊ %#ͷʮ͜Ε஌Βͳ͔ͬͨʯ

Slide 145

Slide 145 text

·ͱΊ %#ͷʮ͜Ε஌Βͳ͔ͬͨʯ ˣ க໋ইʹͳΔ͜ͱ΋ଟ͍

Slide 146

Slide 146 text

·ͱΊ ීஈ͔Βͷ஌ࣝͷΞοϓσʔτΛେ੾ʹ

Slide 147

Slide 147 text

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