ããã«ã¡ã¯ãHabrïŒ
ç§ã¯ãã€ãã補åã®ããŽãããã€ãã®äºçŽ°ãªããšã§ã¯ãªããšããŠããã»ãã®å°ãã®æéã§èãåºããšæã£ãŠããŸããã ãã ããPostgreSQLã®äŸã¯ããããå®å šã«ããã§ã¯ãªãããšã瀺ããŠããŸãã Vertabeloã³ãã¥ããã£ãããŒãžã£ãŒã®Patricia Dybkaã«ããèšäºã®ç¿»èš³ã«æ³šç®ããŠãã ããã
ããŽã¯éåžžã«éèŠã§ãã é åçã§ãã£ãããŒãªã·ã³ãã«ãããã補åã人ã ã«æãåºãããæ¹ãè¯ãã§ããããïŒ ããã念é ã«çœ®ããŠãä»æ¥ã¯ãPostgreSQLãããŽã«è±¡ãéžãã ã®ã¯ãªãã§ããããšãã質åã«çããŸãã
å補åãŸãã¯äŒæ¥ã«ã¯ç¬èªã®ããŽãããããã©ã³ãã®æ¬è³ªãèå¥ããŠå ·äœåããŠããŸãã æéãçµã€ã«ã€ããŠãå®è³ªçã«ãã©ã³ãã«ãªããŸããé»éã®ã¢ãŒãã®ãªããã¯ããã«ããæ³åã§ããŸããïŒ ã³ã«ã³ãŒã©ã®ããŽã玫è²ã®ãããã¯ããªã³ãã§çªç¶ãã€ã³ããããå Žåã¯ã©ããªããŸããïŒ
ããŽã¯ãæ¶è²»è ã«åŒ·ãã³ãã¥ãã±ãŒã·ã§ã³ãšå¿ èª å¿ãäžããææ ãåŒã³èµ·ãããŸãã ç»åãç¹å®ã®è£œåã«é¢é£ä»ããããšã§èšæ¶ãããŸãã ãã®èšäºã§ã¯ã90幎代ã«æ»ããPostgresãSlonik象ãšã©ã®ããã«é¢é£ããããã«ãªã£ããã調ã¹ãŸãã
象ãåç©åã®ããŽã«åå
æã人æ°ã®ããæè¡ããŽãããã€ãèŠãŠã¿ãŸãããã ã芧ã®ãšããããã¯ãããžãŒçšã®åç©ã®éžæã¯ç¹å¥ãªãã®ã§ã¯ãããŸããã
Linuxã«ã¯ãTuxãšããååã®ãã³ã®ã³ãããŸãã | |
MySQLã«ã¯Sakilaã€ã«ã«ãããŸãã | |
PostgreSQLã«ã¯ãSlonikãšããŠç¥ããã象ãããŸãã |
Postgresã象ãéžãã çç±ãšãé·å¹Žã«ããã£ãŠããŽãã©ã®ããã«é²åããŠããããèŠãŠã¿ãŸãããã
PostgreSQLããŽã®é²å
1996/12/30ãªãªãžãã«ã®PostgreSQLããŽ
Postgre象ã«è³ãé²åã®ããã»ã¹ã¯éåžžã«é·ããã®ã§ãã åæã®PostgresããŽã®1ã€ã¯ãPostgreSQLãéãæãã厩å£ããå£ã§ããã 以äžã®å³ã¯ãPostgresã®å ¬åŒWebãµã€ãããæç²ãããã®ã§ã1996幎ã®æ¥ä»ã§ãã
ã¢ãŒã«ã€ãïŒ postgresql.orgã®å©çšå¯èœãªæãå€ãããŒãžã§ã³ã®1996幎12 æ30æ¥ã ãœãŒã¹
1997幎4æ3æ¥è±¡ã®åºçŸ
1997幎ã®åããŸã§ã«ãPostgreSQLã«ã¯å€§ããªå€åããããŸããã 1æã¯ååã®å€æŽããå§ãŸããŸãããå ã®ååãPostgre95ãã¯ãPostgreSQLãã«çœ®ãæããããŸããã ãã®æç¹ã§ãããŽã«é¢ããå ¬åŒã®è°è«ãå§ãŸããŸããã æçµçã«è±¡ã®åºçŸã«ã€ãªãããŸãããã1997幎ã®æçš¿ã«ç€ºãããŠããããã«ãä»ã®ã¢ã€ãã¢ãææ¡ãããŸããã
æ¥ä»ïŒ1997-04-03 20:36:33
ä»ã®ã¢ã€ãã¢ïŒ
-å£ïŒãã©ãŽã³ã®ããæ¬ã®è¡šçŽãã掟ç-éå ·ãšããŠã®PostgresïŒ
-POSTGRESQLãæžãããŠããã¢ã«ãã¡ãããæåã®å ¥ã£ãã¹ãŒãããŠã«
-ãªãã«ããŒ/ãã©ãŒïŒGrosse Pt-Postgresã¢ãã°ã©ã ãšãžã§ã³ã»ãã¥ãŒã¶ãã¯ã«ããæ°ããæ ç»ã®ååã®ç¥èªïŒ
ããããåç©ããŒã¹ã®ããŽãå¿ èŠãªå Žåã象ã¯ã©ãã§ããããïŒ æåŸã«ãã¢ã¬ãµã»ã¯ãªã¹ãã£ã®ååã瀺ãããã«ã象ã¯èŠããããšãã§ããŸã...
ããããã»ã€ã³
ã¢ãŒã«ã€ãïŒ 04/03/1997象ã®ã¢ã€ãã¢
åºæ
ããã¯ãã¡ãã»ãŒãžã§èšåãããŠããããã©ãŽã³ã®æ¬ã®è¡šçŽãã§ããå¯èœæ§ããããŸãã
ãœãŒã¹ïŒ https : //en.wikipedia.org/wiki/Compilers : _Principles,_Techniques,_and_Tools
å€ãã®æåã§ã¯ã象ã¯åªããèšæ¶åãæã£ãŠããŸãã ïŒAgatha Christieã®æ¬ãElephants Can Rememberã§ã¯ãããã¯ç¹°ãè¿ãã®ããŒããšããŠäœ¿çšãããŠããŸããïŒè±¡ã®ããŽã¯ããŸããŸãªæ¹æ³ã§è§£éã§ããŸãããæãäžè¬çãªã®ã¯ãããŒã¿ããŒã¹ãšããŠã®è±¡ãåªããæ å ±ä¿æè ã§ãããšããããšã§ãã
ãã®ã¢ã€ãã¢ã¯äººæ°ãåããŸãããã誰ããããã«åæããããã§ã¯ãããŸããã 1997幎ã®pgsql-hackerséµäŸ¿ã°ã«ãŒãã§ã®è°è«ããåããã次ã®åŒçšã¯ã象ã®èãã«å¯Ÿããç°ãªãç解ã瀺ããŠããŸãã
>>ããããåç©ããŒã¹ã®ããŽãå¿ èŠãªå Žåã象ã¯ã©ãã§ããããïŒ
>>æåŸã«ãã¢ã¬ãµã»ã¯ãªã¹ãã£ã®ååã瀺ãããã«ã象ã¯èŠããããšãã§ããŸã...
象ã人ã ã«èª€è§£ãäžããããšãæããŠããŸãã 圌ãã¯èããã ãã
Postgresã¯ã倧ãããé ããæ±ãã«ããããŒã¿ããŒã¹ã§ãã
ã¬ãª
ã¢ãŒã«ã€ãïŒ 04/07/1997
åºæ
1997/12/12ããŒã¿ãŒã®ããŽã¿ã€ãïŒ
象ã¯ãã§ã«ããŽã«éžã°ããŠãããšããäºå®ã«ããããããã1997幎ã®çµããã«ããŒã¿ãŒã䜿çšããããEmpowered PostgreSQLããšããéãå»ãŸããŸããã ããŒãžã§ã³ã以äžã«ç€ºããŸãã 1996幎以éã®Postgresã®ã¬ã³ã¬å£ã®ã°ã©ãã£ãã¯ã䜿çšãããŠããŸãã
ã¢ãŒã«ã€ãïŒ 12/12/1997ããŒã¿ãŒ
åºæ
1998-1999象ãå£ãçªãç Žã
ããŒã¿ãŒãšã®ããŽã®åŸãå¥ã®ããŒãžã§ã³ãæ瀺ãããŸããïŒè±¡ãã¬ã³ã¬ã®å£ãçªç ŽããŸãã æ®å¿µãªãããç§ã¯ãã®å³é¢ãå ¥æã§ããŸããã§ãããã次ã®ã³ã¡ã³ããèŠãŸããïŒ
ã¡ãã£ãšãããããã¯ã§ãããããŽãã¬ã³ã¬ã®å£ãçªãç Žã象ã ã£ãã®ãä»ã§ãèŠããŠããŸã...ãã以åã¯ãã¬ã³ã¬ã®å£ãçªãç ŽããPostgreSQLããšããèšèã§ããã æ®å¿µãªããã1998幎ãš1999幎ã«ã¯ãWayBack Machineã§ã¢ãŒã«ã€ãããªãã£ãææããããŸãã*;* The Wayback Machine-ã¢ãŒã«ã€ãWebãµãŒãã¹ã WebããŒãžã®ã³ã³ãã³ãã¯ããããã䜿çšããŠããŸãã¯ãµã€ã蚪åè ãä¿®æ£ããããŒãžã¢ãã¬ã¹ãæåã§ç€ºãããšãã«èšé²ãããããšããããŸãã ãããã£ãŠãç¹å®ã®ããŒãžãååšããªããªã£ãå Žåã§ããåã®ããŒãžãã©ã®ããã«èŠãããã確èªã§ããŸãã
ã©ããŒã»ãªãŒãŠã§ã³
åºæ
1998幎6æãã®ä»ã®PostgresããŽã®ã¢ã€ãã¢
1998幎6æãpgsql-hackerséµäŸ¿ã°ã«ãŒãã®ãããªãè°è«ã¯ã次ã®ãããªããŸããŸãªããŽã®ææ¡ã§ãã£ã±ãã§ããã
éã©ã€ãªã³ãŸãã¯ãã°ãã女..
2ïŒéã©ã€ãªã³ãäžã«çœ®ããŸãã èäžã¯ããŒã®äžã«ãããŸãã å足ã®éãã¯ãreããå足ã¯ãSãã§ãã 圌女ã®å°Ÿã¯ãPãã®æåãå ã¿èŸŒã¿ãããã¹ããã®äžãéããŸãã 圌ã¯æåŸã«ãsããšãtãã®éã§ã¶ã€ããå§ããŸãã 圌女ã¯é ãäžããŠçšå¿æ·±ãã圌女ã®èŠç·ã®åïŒå³ïŒãšç§ãã¡ã®äžéãåããŸããã 圌女ã®é¡ã®è¡šæ ã¯ãã¯ãã«ã§ç¬åçã§ããã¯ã...
3ïŒå·Šäžãã€ãŸãã¯ã«ãŒãã®äžã«ãå°ããªæåã§ãPowered byããšããããã¹ãããããŸãã
4ïŒéã©ã€ãªã³ãåããŠããæ¹ãè¯ããšæãã ããã«ãããçœé»ããªã³ã¿ãŒã§ããè¯ãããŽå°å·ãå¯èœã«ãªããŸãã
人ã ãti眪ã奜ããªããããªãã¯åãããšãããããšãã§ããŸãã ãããã圌女ã¯äœãšãç¹ã«ãã®äœçœ®ã§èŠãŸããã èŠããŠãããŠãç§ã¯ããªããèãã倧眪ãåºå¥ããæ¹æ³ãããããŸããã
ãããããã¬ã³ãã1997幎4æ3æ¥
åºæ
誰ããç§ãã¡ã®ããŒãã ãšããŠã¯ããæãã€ãã...ãããã誰ãããã䜿çšããããã«*匷ã*ã€ã¡ãŒãžãæãä»ãããšãã§ããªãã£ã:(ç§ã¯ãŸãŠãã«ã¡ã®ãããªãã®ã§ã...圌ãã¯å°ãé ãã§ãããéåžžã«ä¿¡é Œæ§ãé«ã...ããŒã¿ãŒãã¬ãŒã«ãã€ãŒã°ã«...
ããŒã¯G.ãã«ããš06/03/1998
åºæ
ã¯ãã¯èŠæ ããè¯ãããã¡ããéåžžã«åŒ·ãã§ãã åç©ãäœããªããã°ãªããªãå Žåããªãªãžãã«ã®ããŽãšããŠãããŒã¿ãŒãã¬ãŒã«ããŸãã¯ã¯ã·ã®ä»ããããŽãªã©ãäœããçŽ æ©ãè¡ãã®ãæ£ãããšæããŸãã 圌ã¯åžžã«ãã®åœã§æåããã§ããã:)ç¬...
ã¹ãã£ãŒããã°1998幎6æ4æ¥
åºæ
1ïŒæ¬åœã«åç©ã欲ãããªããã©ãããŠDOGã¯ã©ãã§ããïŒ ç·ã®èŠªå;-)ãã©ãã...
...ãããããã®åç©ã¯PostgreSQLã«ãšã£ãŠè¯ãã€ã¡ãŒãžã§ã¯ãªããšæããŸããæ©...
ãã»ã»ãœã¢ã¬ã¹ã»ãã»ã·ã«ã1998/08/08
åºæ
PostgreSQLã¯ããŒã¿ããŒã¹ã·ã¹ãã ã ãšæããŸãã ãããã£ãŠãããŽã¯äœããã®BASEã®ãããªãã®ã§ãªããã°ãªããŸããã ããšãã°ãããªããžã¯ãããŒã¿ã§æºãããã倧ãã匷åãªããªããžã§ãã ãŸãã¯ãããŒã¿ã§ãã£ã±ãã®ãã©ãã¯ããããŠãåã³ã象...
ãªã¬ã°ã»ããã€ããã³06/08/1998
åºæ
> 1998幎7æ24æ¥éææ¥ãããŒãããããã«ãŒã¯æ¬¡ã®ããã«æžããŠããŸãã
>>çŽ æµãªå€èŠ³ãæãã€ãããšã¯ã§ããŸããã§ããã
>>ãã¿ãªã¹ãã³ã...æåŸã«èããã®ã¯ãã¯ããèŠãŠã
>>ã¹ã±ãããäœæãããŸããããæçµç»åã¯å®çŸ©ãããŠããŸãã...
>
>ããããã¯ãã¯ããŸãã«ã䌌ãŠãããããããŸãã
> Netscape Mozillaæç«ïŒãŸãã¯ãã®ä»ïŒ
> :-)ãããªãã¯æããŸãããïŒ
ãããç§ã¯è±¡ã奜ãã§ãã 倧ããã匷ããä¿¡é Œã§ãã圌ã¯æ±ºããŠäœãå¿ããŸãã...
ãã³ãã©ããŒ06/23/1998
åºæ
10/13/1999ãã€ã€ã¢ã³ãã®äžã®è±¡
1999幎10æãPostgresããŽã®ããŒã¿ãŒã®ã¢ã€ãã¢ã¯å®å šã«æŸæ£ãããŸããã ãã€ã€ã¢ã³ãã®äžã®è±¡ãå ¬åŒã®ããŽã«ãªã£ãŠããŸãã
ã¢ãŒã«ã€ãïŒ 2000幎2æ29æ¥è±¡
åºæ
ãã€ã€ã¢ã³ãã«è±¡ãä¹ãã2000幎2æ29æ¥ã®ãPostgreSQLæ€çŽ¢ã
2000幎2æã«ã象ãšãã€ã€ã¢ã³ãããSearch PostgreSQLããšããåèªãšçµã¿åããããŸããã
ã¢ãŒã«ã€ãïŒ 2000幎2æ29æ¥è±¡
åºæ
2003幎1æ28æ¥çŸåšã®ããŽ
2003幎ã«ãæ§åŒåãããéã象ãå°å ¥ãããŸããã
ã¢ãŒã«ã€ãïŒ 01/28/2003象
åºæ
2013幎9æã«è¡ãããè°è«ã«ãããšã以åã®ããŽã¯é åçã§ã¯ãªããšèããããŠããŸããïŒæ§ããã«èšã£ãŠãïŒïŒã PostgreSQL Incãç«ã¡äžããŠéããªããéã象ãéçºãããŸããã
ç§ãã¡ã®æåã®ããŽã¯ããã€ã€ã¢ã³ãã®è±¡ã§ããã€ã³ã«ãã£ãŠãã¶ã€ã³ãããŸããã ã¢ã€ãã¢ã¯è¯ãã£ãããèŠãç®ã¯ããŸãè¯ããªãã£ãã®ã§ãããŒã¯ãšã°ã¬ãã°ãPostgreSQL Inc.ãç«ã¡äžãããšãã圌ãã¯ç§ãã¡ãä»æã£ãŠããéã象ãäœã£ãæ¬åœã®ãã¶ã€ããŒãéã£ãã ãã®åŸããã®èšèšãã³ãã¥ããã£ã«è¿œå ãããŸããã
Josh BerkusãPostgreSQLã¡ã³ããŒã2013幎9æ20æ¥
åºæ
2006幎8æ23æ¥æŽå²ã®ã¿ãã
ãã«ãŒãšã¬ãã¡ã³ãããŽã®ããã¥ãŒã«ç¶ããŠããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã®å±¥æŽãªãœãŒã¹ã¯ãå ã®ãšã¬ãã¡ã³ãããŽã®æ¥ä»ãšãšãã«æ°ããããŽãšãšãã«PostgreSQLã衚瀺ãå§ããŸããã
ã¢ãŒã«ã€ãïŒ 08/23/2006象
åºæ
Postgres象ã¯ã©ã®ããã«ããŠãã®ååãååŸããŸãããïŒ
çŸåšã®ããŽãèŠãã ãã§ãã©ããªããã°ã©ããŒãããã«ãPostgresããèããã§ãããã ãããããŸãŠã®ååããã·ã¢èªã®ããŸãŠãã«ç±æ¥ããã¹ãããã¯ãšããååã§ããããšã誰ããç¥ã£ãŠããããã§ã¯ãããŸããã æ®å¿µãªããããã®ç¹å®ã®ååãéžæããæ¥ä»ãšç¶æ³ã¯äžæã§ãã ããã¯ããããPostgres Slony-Iãããžã§ã¯ãã«ãã£ãŠéå§ãããŸããã Slony-Iã¯ãéåæã®ãã¹ã¿ãŒã¹ã¬ãŒãè€è£œã·ã¹ãã ã§ãã Jan Wieckãããã«ã€ããŠæãåºããã®ã¯æ¬¡ã®ãšããã§ãã
ã¡ãªã¿ã«ããµã€ãäžã®ãã®ç»åã«ã¯ããã¡ã€ã«åãšããŠãslonikããŸãã¯ä»£æ¿ç»åããã¹ãïŒãaltãïŒããããŸããããæ£ç¢ºã«ã¯èŠããŠããŸããã ããããç§ã¯ãããäœãæå³ããã®ãçåã«æããŸããã確ãã«ãååã¯ãã·ã¢èªã®ã象ãïŒslonyïŒã«ç±æ¥ããã象ããæå³ããŸãã ãã®Postgresãããžã§ã¯ãããã次ã®çšèªãååŸããŸãã
æ£ç¢ºã«ã¯èŠããŠããŸããããããã¯ãã·ã¢ã®è±¡ã®ååã§ã¯ãããŸãããïŒ
ã¹ãã³=象
ã¹ãããŒ=象
ã¹ãããã¯=ãã³ã
ã¬ããªã±ãŒã·ã§ã³ã·ã¹ãã ã§ã¯ã1ã€ã®ããŒããslonã§ãïŒãã®ãããã¬ããªã±ãŒã·ã§ã³ãšã³ãžã³ã®å®è¡å¯èœãã¡ã€ã«ã®ååïŒã ã°ã«ãŒããŸãã¯ã¯ã©ã¹ã¿ãŒã¯SlonyãšåŒã°ããããŸããŸãªã¢ã¯ã·ã§ã³ã®ãã¯ãšãªãã«äœ¿çšãããã¹ã¯ãªããäœææ¯æŽã¯slonikãšåŒã°ããŸã:)
ã€ã³ãŠã£ãã¯ã2004幎7æ10æ¥
åºæ
Slonyã¯è€æ°ã®åèªã§ãã¯ã©ã¹ã¿ãŒãè€æ°ã®ããŒã¿ããŒã¹ã§æ§æãããŠããããšãæå³ããŸãã
ã¹ãã³ã¯ç¹ç°ãªèšèã§ãã åã¬ããªã±ãŒã·ã§ã³ããŒãã¯ããslonããšåŒã°ããããã°ã©ã ã«ãã£ãŠç®¡çãããŸãããã®ããã°ã©ã ã¯ãåè¿°ã®ããšã¬ãã¡ã³ãã¯ã©ã¹ã¿ãŒãã«çµåãããŸãã
Slonikã¯ãå°ããªè±¡ããæå³ããèšèã§ãããããã¯ã©ã¹ã¿ãŒã®æ§æã«äœ¿çšãããããã°ã©ã ã®ååã§ãã
代æ¿PostgresããŽ-ã¿ãŒãã«
åºæ
äžéšã®å°åã§ã¯ãPostgresã¯å°ãç°ãªãæ¹æ³ã§è¡šç€ºãããŸãã ããšãã°ãéåžžã«æŽ»çºãªåœéã°ã«ãŒãã§ããæ¥æ¬ã®PostgreSQLãŠãŒã¶ãŒã°ã«ãŒãïŒJPUGïŒã¯ã象ã®ä»£ããã«ç¬èªã®ããŽãäœæããŸããã
圌ãã¯ã«ã¡ãéžã³ãŸããã 1970幎代ã«ã¯ãã«ã¡ã¯INGRESã®ãã¹ã³ãããšããŠäœ¿çšãããPostgresã«æ®ãããŸããã ããŒã¯ã¬ãŒããŒã¿ããŒã¹ã°ã«ãŒãã«ãããšïŒ
ã«ã¡ã¯ã70幎代ã«INGRESã°ã«ãŒãã«ãã£ãŠãã¹ã³ãããšããŠæ¡çšãããŸããããé ãããå¿ èŠãªå Žæã«åžžã«å±ããããã§ãã ãããŠãã»ã³ãã¡ã³ã¿ã«ãªçç±ã§POSTGRESã®ãã¹ã³ãããšããŠä¿åãããŸããã
åºæ
JPUGãPostgresã®ã«ã¡ã䜿çšããçç± éããŸãŠã¯ã1995幎ã®æ±äº¬ã§ã®ãµãªã³æ»æã«é¢é£ããå°å ã®ãããªã¹ãã°ã«ãŒãã䜿çšããèšå·ãšäžé©åãªé¡äŒŒæ§ãæã£ãŠãããšç€ºåãã人ãããŸãã
ä»ã®è£œåãšåæ§ãPostgresã®ããŽã¯é·å¹Žã®è°è«ã®ããã«æ éã«éžæãããŠããŸãã ãããŠæçµçã«ã¯ãSlonikãšããååã®è±¡ãšããæçµçãªåœ¢ãåããŸããã
åæ§ã®ã¹ããŒãªãŒã¯éåžžã«äžè¬çã§ãã ä»ã®æè¡çãªããŽã®æŽå²ãç¥ã£ãŠãããªãã以äžã®ã³ã¡ã³ãã§ããããå ±æããŠãã ããã