èµ·ãã£ãïŒ
åœç€Ÿã¯ãPostgreSQLããã¥ã¡ã³ãã®çŸåšã®ããŒãžã§ã³ã®ãã·ã¢èªãžã®ç¿»èš³ãå ¬åŒã«å®äºããŸããããã®åºçç©ã§ã¯ããããã©ã®ããã§ãã£ããããäŒãããããšæããŸãã ãŸãããã®ç®æšãéæããããã«è¡ã£ããã¹ïŒããã³ã©ã®ãããªæ¹åæ§ãè©Šã¿ããïŒã«ã€ããŠã話ããããšæããŸãããããã¯ããããå¥ã®èšäºã®ãããã¯ã§ãã
PostgreSQLèªäœã®ãã·ã¢èªãžã®ç¿»èš³ã¯2001幎ã«å§ãŸãããã®åŸãpostgresql 7.1ã®ããŒãžã§ã³ã®ã¿ããªãªãŒã¹ãããpostgresqlèªäœã§ã¯ãéçºè ã®åªåã«ã¯ã¡ãã»ãŒãžãããŒã«ã©ã€ãºããæ©èœã®ã¿ãå«ãŸããŠããŸããïŒ ãã¡ããåç §ïŒã ã¡ãã»ãŒãžã®ãã·ã¢èªãžã®ç¿»èš³ãããã©ã³ã¹èªããã€ãèªãã¹ãŠã§ãŒãã³èªãäžåœèªããã§ã³èªãžã®ç¿»èš³ãšãšãã«ãããŒãžã§ã³7.2ã«åããŠå«ãŸããŸããã
åºã«ã¯ãšã³ã³ãŒãã£ã³ã°KOI8-RããããŸããã Windows 2000ãLinux 2.4.1ãRHEL 2.1ãDebian Woodyã pgadmin IIã UbuntuïŒ ããããèããŠããŸããã
ãµãŒããŒ7.2ã§ã¯ãçŽ30ïŒ ã®ã¡ãã»ãŒãžããã·ã¢èªã«ç¿»èš³ãããŸããïŒ3205ãã881ã¡ãã»ãŒãžïŒã ãµãŒããŒ7.2ã®ããã¥ã¡ã³ãã«ã¯çŽ1000ããŒãžããããŸããã 2005幎1æ-ããŒãžã§ã³8.0ã§ã¯ãçŽ80ïŒ ã翻蚳ãããŸããïŒ2888ã¡ãã»ãŒãžïŒã Windows 2003ãLinux 2.6.10ãRHEL 4ãDebian SargeãUbuntu-ãã§ã«ãããŒã®ããããšãèããããšããããŸãã
ããŒãžã§ã³9.0ã§ã¯ã翻蚳ã®å²åã¯64ïŒ ïŒ2765ã¡ãã»ãŒãžïŒã«æžå°ããŸããã
æåŸã«ã2012幎ã«ããŒãžã§ã³9.2ã§è¿œãã€ããŸãã-100ïŒ ïŒ6388ã¡ãã»ãŒãžïŒã ïŒããŒãžã§ã³9.5ã§ã¯ã7675ã®ã¡ãã»ãŒãžã翻蚳ãããŠããŸãã翻蚳ä»ãã®ã¡ãã»ãŒãžã®ãµã€ãºã¯çŽ1.8 MBã§ããïŒ
ãã®åŸããã£ãšæ¬²ããã£ãã pgadminãšãã®ãµã€ãã®ç¿»èš³ä»¥äžã ã¯ããã«ã ããã«å€ãã®ããã¥ã¡ã³ããèŠã€ãããŸããã å ¬åŒãµã€ãã«ã¯ããã©ã³ã¹èªãšæ¥æ¬èªã®ç¿»èš³ã®ã¿ãžã®ãªã³ã¯ããããŸããã ããã¯ææŠã§ãïŒ 9.3ã®ãªãªãŒã¹ã®æç¹ã§ãããã¥ã¡ã³ãã¯ãã§ã«çŽ2000ããŒãžãå ããŠããŸããïŒãªãªãŒã¹ããŒããé€ãïŒã®ã§ãããããŸãææŠã§ãïŒ ããã¥ã¡ã³ãã翻蚳ããè©Šã¿ã¯ãã§ã«è¡ãããŠããããšã«æ³šæããå¿ èŠããããŸãã æ å ±ãä¿åãããŠããæåã®ããŒãžã§ã³ã¯ãããŒãžã§ã³6.5.2ã®ããã¥ã¡ã³ãã®ç¿»èš³ã§ããããããã20äžçŽã«ããã®ãŒãã»ã«ã®ãšãããµãåºèº«ã®è¥ããŠç±ãç·ãã¡ã«ãã£ãŠäœæãããããã§ãã
ãã®åŸããã§ã«å¥ã®ç¿»èš³ããããŸãããããã§ã«ç§ãã¡ã®æ代ã«ã¯ãããŸããããå®å šã§ã¯ãªãããã®å質ã¯æãŸããŠããŸããã§ããã ãŸã倱æããå¥ã®è©Šè¡ã®ãã¬ãŒã¹ãèŠã€ããããšãã§ããŸãã ãããã£ãŠãæ°ãããã®ãæŽããããç°¡åã«æã«å ¥ããšå€æãããŸããã ãããŠå¥ã®å®¶æã§ã
2013幎ã®åãã«ãããã¥ã¡ã³ãã®æåã®2ã€ã®ã»ã¯ã·ã§ã³ïŒçŽ400ããŒãžïŒã®ç¿»èš³ãå®äºããå ¬éãããŸããã 2015幎ã«åœç€Ÿãèšç«ãããããã¥ã¡ã³ãã®ç¿»èš³ãå®äºããããã«åªå é äœã®1ã€ãéžæãããŸããã ãããŠãä»äºã¯æ²žéš°ãå§ããŸããã å ¥ãå£ã§ã¯ãããŒãžã§ã³9.4ã®ããã¥ã¡ã³ãã2000ããŒãžã«ãããæåã¯400ã«ç¿»èš³ãããŠããŸããã6æ25ïŒ ã翻蚳ããã12æ57ïŒ ã4æã«9.4ã®ããã¥ã¡ã³ãã®ç¿»èš³ãå®äºããŸããã 2016幎5æã«ã翻蚳ã¯ããŒãžã§ã³9.5ãšåæãããå®å šã«ãã·ã¢èªã®ããã¥ã¡ã³ãïŒ2xxxããŒãžã翻蚳ã«äŒŽãçããã¹ãã®ããªã¥ãŒã ã18 MBïŒãåãåããŸããã
ããã«ææžããããŸãïŒ
æåŸã«ãçŸåšãããŒãžã§ã³9.6ïŒbeta2ãbeta3ã...ïŒãšåçã§ããã補åã®ãªãªãŒã¹æã«å®å šãªããã¥ã¡ã³ãããã·ã¢èªã§ãªãªãŒã¹ããŸãã
幞ããªããšã«ãã¯ããŒãºããã¹ããè¡ââãããŠããRUS-Studioã®ç¹æ®ããŒãžã§ã³ãå©çšããããšãã§ããŸããã ããã«ããã翻蚳ã®æ®µéã§ããã¹ãã確èªãããšã©ãŒãç¹å®ããããšãã§ããŸããããšã©ãŒã®ããã€ãã¯ã以äžã®ç®çã®ããã«æ¥œããã§ãããæ€èšããŸãã ãã®çš®ã®ãšã©ãŒã¯ã©ãã«ã§ãèŠãããŸãããç§ãã¡ã®ééãã§ããããç§ãã¡ã«ã¯æ£ããããšããããŸãã
ç§ãã¡ã®çç
RUS-Studioãšã©ãŒïŒA000 FalsehoodïŒãããžãã¹ã¯çãæ®ããŸããïŒã=ããŠãŒã¶ãŒéã®ãã£ããã埩å ãããŸããã
RUS-Studioã®è³ªåïŒQ075 LOLã®ããŒã-äœã§ããïŒ ããŒãã«ã¯ç¬äœãçµãŸããïŒ ããŒãã«ã¯ç¬ãåŒãèµ·ããããšãã§ããŸããïŒ
ã¯ã©ã€ã¢ã³ãã¢ããªã±ãŒã·ã§ã³ããµãŒããŒã«æ¥ç¶ãããšãUnixã©ã€ã¯ãªOSã§ã®éåžžã®ãŠãŒã¶ãŒãã°ã€ã³ãšåæ§ã«ãPostgreSQLãŠãŒã¶ãŒåã瀺ãããŸããRUS-StudioèŠåïŒW203è±èªã®ãããªæãæ€åºãããŸããã
ããã«ãããããé«ãã¬ãã«ã®ä¿¡é Œæ§ãæäŸãããŸãããããã2ã€ã®ãµãŒããŒã®ã€ã³ã¹ããŒã«ããã³æ§æäžã«ã·ã¹ãã 管çè ã泚ææ·±ãäœæ¥ããå Žåã®ã¿ã§ãã質åRUS-StudioïŒQ088ããã«ãããªãã®ä»äºã¯ã©ãã»ã©äžå¯§ã§ããïŒ
ããšãã°ãã¢ããªã±ãŒã·ã§ã³ã®ã©ã€ããµã€ã¯ã«ã§ã¯ãå€æŽã®10ïŒ ãéèŠãªé¡§å®¢ããŒã¿ã§ãããä»ã®90ïŒ ã®å€æŽã¯ããžãã¹ã«ãšã£ãŠããã»ã©éèŠã§ã¯ãªãã倱ãããå ŽåïŒãŠãŒã¶ãŒéã®ãã£ãããªã©ïŒã«ç°¡åã«åŸ©å ã§ããŸããRUS-Studioãšã©ãŒïŒA000 FalsehoodïŒ "Workload"ïŒ= "Life Cycle"
ãªãªãžãã«ïŒ
ããšãã°ãã¢ããªã±ãŒã·ã§ã³ã®ã¯ãŒã¯ããŒãã¯ã次ã®ãã®ã§æ§æãããŸãïŒå€æŽã®10ïŒ ã¯éèŠãªé¡§å®¢ã®è©³çŽ°ã§ãããå€æŽã®90ïŒ ã¯éèŠæ§ã®äœãããŒã¿ã§ããããŠãŒã¶ãŒéã®ãã£ããã¡ãã»ãŒãžãªã©ãããžãã¹ã倱ãããŠãããç°¡åã«çãæ®ãããšãã§ããŸãã
RUS-Studioãšã©ãŒïŒA000 FalsehoodïŒãããžãã¹ã¯çãæ®ããŸããïŒã=ããŠãŒã¶ãŒéã®ãã£ããã埩å ãããŸããã
ãŠãŒã¶ãŒã¯ãäž»èŠãµãŒããŒã§æŽæ°è² è·ãé«ãããŒãã«ã¯ãããã¯ã¢ããã§ã®é·ãã¯ãšãªã®ãã£ã³ã»ã«ãåŒãèµ·ããå¯èœæ§ãé«ãããšãç解ããå¿ èŠããããŸããRUS-Studioãšã©ãŒïŒR005è€éãªæã
RUS-Studioã®è³ªåïŒQ075 LOLã®ããŒã-äœã§ããïŒ ããŒãã«ã¯ç¬äœãçµãŸããïŒ ããŒãã«ã¯ç¬ãåŒãèµ·ããããšãã§ããŸããïŒ
éåžžã®ïŒé埩æ§ïŒã¢ãŒãã§ãæ¥ç¶ããæš©éãæã€ããŒã«ã«å¯ŸããŠDROP USERãŸãã¯DROP ROLEã³ãã³ããå®è¡ãããŠãŒã¶ãŒãçŸåšæ¥ç¶ãããŠããå Žåããã®ãŠãŒã¶ãŒã«ã¯äœãèµ·ãããŸãã-圌ã¯æ¥ç¶ãç¶ç¶ããŸããRUS-Studioãšã©ãŒïŒB901ãã³ãã¬ãŒãã®ç Žæã
ã¯ã©ãŒã¿ã䜿ãæãããšããã£ã¹ã¯å®¹éã®äžè¶³ãšåãæªãçµæãçããŸããRUS-StudioèŠåïŒW051ããããŒã¶ã«ã®æ²çã¯ã2次å°é¢æ°ã®èš±å®¹ã¬ãã«ãè¶ ããŠããŸãã
ããªã¬ãŒé¢æ°ã¯ãé¢æ°ãããŒãžã£ãŒã€ã³ã¿ãŒãã§ã€ã¹ã®ããŒãžã§ã³1ã䜿çšããå¿ èŠããããŸããRUS-Studioãšã©ãŒïŒR00Eè±èªããã¹ããæ€åºãããŸããã
äœæããããŠãŒã¶ãŒãã»ãã·ã§ã³ãéãããšãèš±å¯ããŸãã ãããããã©ã«ãã®åäœã§ããRUS-Studioãšã©ãŒïŒL102éå¯éå§çž®ãæ€åºãããŸããã
ãªãªãžãã«ïŒ
æ°ãããŠãŒã¶ãŒã¯ãã°ã€ã³ãèš±å¯ãããŸãïŒã€ãŸãããŠãŒã¶ãŒåã¯åæã»ãã·ã§ã³ãŠãŒã¶ãŒèå¥åãšããŠäœ¿çšã§ããŸãïŒã ãããããã©ã«ãã§ãã
ã³ããŒã®äœæäžã«ããŒã¿ããŒã¹ããŒã¿ãå€æŽãããå¯èœæ§ããããããæšå®å€ã¯æŠç®å€ã§ããã100ïŒ ã®ç²ŸåºŠã¯åŸãããŸãããRUS-Studioãšã©ãŒïŒMU003æèŠã®èª€è§£ã®å åãæããã«ãªããŸããã
ãªãªãžãã«ïŒ
ããŒã¿ããŒã¹ã¯ããã¯ã¢ããäžã«å€æŽãããå¯èœæ§ããããããããã¯ãããŸã§ãæŠç®ã§ãããæ£ç¢ºã«100ïŒ ã§çµãããšã¯éããŸããã
ã©ã€ãã©ãªãªããžã§ã¯ãã®ã³ãŒããé 眮ããããã®ãã¹ãåºåããŸãããšã©ãŒRUS-StudioïŒN3ïŒïŒçµã¿åããã®åé¡ã«å¯Ÿãã誀ã£ã解決çã
ãªãªãžãã«ïŒ
ãªããžã§ã¯ãã³ãŒãã©ã€ãã©ãªã®å ŽæãåºåããŸãã
ããããµããŒããããŠãããã©ââãããã©ãŒã ã§ã¯ããµãŒããŒã¯ã¯ã©ãã·ã¥æã«ã¹ãããã·ã§ããããã£ããã£ããããšããŸãã ããã«ãããå°æ¥ã®æœåšçãªåé¡ã蚺æããã³é²æ¢ã§ããŸããRUS-StudioèŠåïŒèª€è§£ã®åé¡ã®è§£æ±ºçãšããŠã®æç« ã®ç°¡çŽ åãæããã«ãªããŸããã
ãªãªãžãã«ïŒ
ã³ã¢ãã¡ã€ã«ã«èšå®ããããœãããªãœãŒã¹å¶éã解é€ããããšã«ããããããå¯èœãªãã©ãããã©ãŒã äžã§ã³ã¢ãã¡ã€ã«ãçæããããã«ãµãŒããŒã¯ã©ãã·ã¥ãèš±å¯ããããšããŸãã ããã¯ãé害ãçºçãããµãŒããŒããã»ã¹ããã¹ã¿ãã¯ãã¬ãŒã¹ãååŸã§ããããã«ããããšã§ãåé¡ã®ãããã°ã蚺æã«åœ¹ç«ã¡ãŸãã
ãµãŒããŒãéå§ãŸãã¯åæ¢ããã®ãåŸ ã€ããšãç¡èŠããŸããRUS-Studioã®ææ¡ïŒS021è€éãªå çäžçãæã€äººã ã䜿çšããå ŽåïŒãç§ã®æåŸ ãç¡èŠããªãã§ãã ãããã
ãªãªãžãã«ïŒ
èµ·åãŸãã¯ã·ã£ããããŠã³ãå®äºããã®ãåŸ ããªãã§ãã ããã
ãããã®ãšã©ãŒã¯ãã¹ãŠå®¹èµŠãªãä¿®æ£ãããŠããŸãããè±ç«ã¬ã€ãã§ããã¥ã¡ã³ãã調ã¹ãŠããéã«ä»ã®äººã«äŒã£ãããç§ãã¡ã«é£çµ¡ããŠãã ãã ã ç§ãã¡ã®ããã¥ã¡ã³ãããªãªãžãã«ãšåãå質ã§ããããšã倧ãã«æåŸ ããŠããŸãã
ããªãã¯å°ããïŒãªãããªãã¯æ¬åœã«éåžžã«è³¢æãªææžã翻蚳ããå¿ èŠããã£ãã®ã§ããïŒ ãã¡ããããã®è³ªåããã人ã¯ãã§ã«ãªãªãžãã«ãèªãã§ããã®ã§ãè±èªã§ç解ããããšãã§ãããããããããèªã¿ç¶ãããããããšããµã€ãã£ã³ã°ãªã¡ãŒãªã³ã°ãªã¹ãã§ããããŸãã
ãã ãããã®ãã°ãããDBMSã«ãŸã æ £ããŠããªã人ã«ãšã£ãŠã¯ãè±èªã®ååãªç¥èã®æ¬ åŠã¯ãç§ãã¡ã®æ·±ã信念ã«ãããŠããã®åŠç¿ã®é害ã«ãªãã¹ãã§ã¯ãããŸããã ãããã¯åå¿è ã®ç®¡çè /éçºè ãåŠçãããã«ã¯åŠç«¥ã§ãïŒã¯ããããã¥ã¡ã³ãã«ã¯SQLã®åºæ¬ã«é¢ããè³æãå«ãŸããŠãããããªããºãã§ãç解ã§ããŸãïŒã
ããã«ãããèªäœãéåžžã«è³¢æã§ãããšããäºå®ã¯ãããã翻蚳ããåªåãæ£åœåããŸãã ããã«ãç§ãã¡ã®ç¿»èš³ãåºç€ãšããŠããªãªãžãã«ã§èŠã€ããããšãã§ããã®ãšåãã¬ãã«ã®å質ãšå®å šæ§ãåããæç§æžãšã³ãŒã¹ãéçºããŠããŸãã
æåŸã«ãPostgreSQLã«åºã¥ããŠæ§ç¯ãããPostgres Pro補åã¯ãåœå ã®ãœãããŠã§ã¢ã¬ãžã¹ããªã«å«ãŸããŠããŸããã€ãŸããäž»ã«ãã·ã¢èªã話ããŠãŒã¶ãŒã察象ãšããŠããããã·ã¢èªã®ããã¥ã¡ã³ããå¿ èŠã§ãã ããã©ããŒãžã§ã³ã®ç¿»èš³ã¯ããã·ã¢èªã話ãã³ãã¥ããã£å šäœã®postgresã®éçºã«è²¢ç®ããŠããŸãã
æ°ãæãšæ°ã¡ã¬ãã€ãã®äœæ¥ã®çµæããã®ã€ãã³ãã¯ã httpsïŒ//www.postgresql.org/docs/ããŒãžã®ç¿»èš³ãªã¹ãã«æ§ãããªãã·ã¢èªã®ãªã³ã¯ã衚瀺ãããããšã§è¡šãããŸããã
ããããïŒ