[B! postgresql] ockeghemã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ockeghem id:ockeghem

postgresqlã«é–¢ã™ã‚‹ockeghemã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (28)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

PostgreSQLã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆãŒç·Šæ€¥ãƒªãƒªãƒ¼ã‚¹
OSSã®RDBMSã§ã‚ã‚‹PostgreSQLã§ã€äºˆå‘Šã•ã‚Œã¦ã„ãŸã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯é€Ÿã‚„ã‹ãªã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã‚’ã€‚ 2013å¹´4æœˆ4æ—¥ã€PostgreSQLã§ã€Œæ·±åˆ»ãªè„†å¼±æ€§ã€ã«å¯¾å¿œã™ã‚‹ãŸã‚ã®ãƒžã‚¤ãƒŠãƒ¼ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã€‚ ä»Šå›žç™ºè¦‹ã•ã‚ŒãŸè„†å¼±æ€§ã¯ã€DBã®æ£è¦ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’æŒãŸãªã„ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒpsqlãªã©ã§DBæŽ¥ç¶šã—ã‚ˆã†ã¨ã™ã‚‹ã ã‘ã§DBã‚’ç ´å£Šã§ãã‚‹ã¨ã„ã†ã‚‚ã®ã€‚ã€Œ-ã€ã§å§‹ã¾ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼åã§æŽ¥ç¶šã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã®ãƒ‡ãƒ¼ã‚¿ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ãªã©ã«å½±éŸ¿ã‚’ä¸Žãˆã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã€‚ä¸€èˆ¬ãƒ¦ãƒ¼ã‚¶ãƒ¼æ¨©é™ã§å®Ÿè¡Œã§ãã‚‹ã“ã¨ã‹ã‚‰ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ã¯é€Ÿã‚„ã‹ãªã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã‚’å‘¼ã³æŽ›ã‘ã¦ã„ã‚‹ã€‚ ã‚‚ã—å³æ™‚ã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆãŒå›°é›£ãªå ´åˆã¯ã€ä¸€æ™‚çš„ã«ã‚ªãƒ¼ãƒ—ãƒ³ãªãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‹ã‚‰PostgreSQLã¸ã®æŽ¥ç¶šã‚’åˆ¶é™ã™ã‚‹ã¨ã„ã£ãŸå›žé¿ç–ã‚‚æ¤œè¨Žã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã ã‚ã†ã€‚ ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã®å¯¾è±¡ã¯ä»¥ä¸‹ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã€‚7.4ç³»ã€8.0ï½ž3
ockeghem 2013/04/06
ã€Žã€Œ-ã€ã§å§‹ã¾ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼åã§æŽ¥ç¶šã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã®ãƒ‡ãƒ¼ã‚¿ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ãªã©ã«å½±éŸ¿ã‚’ä¸Žãˆã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã€

postgresql

security
ãƒªãƒ³ã‚¯
PostgreSQL Conference 2012ã§è¬›æ¼”ã—ã¾ã™ - ockeghem's blog
PostgreSQL Conference 2012ã§è¬›æ¼”ã™ã‚‹æ©Ÿä¼šã‚’é ‚ãã¾ã—ãŸã®ã§å ±å‘Šã—ã¾ã™ã€‚ æ—¥æ™‚ï¼š2012å¹´2æœˆ24æ—¥ï¼ˆé‡‘æ›œæ—¥ï¼‰ 14æ™‚30åˆ†ã€œ17æ™‚20åˆ†ï¼ˆå¾³ä¸¸ã®å‡ºç•ªã¯16:30ã€œ17:00ï¼‰ å ´æ‰€ï¼šAP å“å· ï¼ˆæ±äº¬éƒ½æ¸¯åŒºï¼‰ è²»ç”¨ï¼š3,500å††ï¼ˆç”³ã—è¾¼ã¿ã¯ã“ã¡ã‚‰ï¼‰ è¬›æ¼”ã‚¿ã‚¤ãƒˆãƒ«ï¼šå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ ä»Šå›žã¯ã€IPAã®å®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã‚’é¡Œæã¨ã—ã¦ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®ç™ºç”ŸåŽŸç†ã‹ã‚‰ã€å®‰å…¨ãªSQLã®åˆ©ç”¨æ–¹æ³•ã‚’åŸºç¤Žã‹ã‚‰å®Ÿéš›ã¾ã§ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ ã‚ã¾ã‚Šãƒˆãƒªãƒƒã‚ãƒ¼ãªæ”»æ’ƒã®æ–¹æ³•ã¯ã—ãªã„ã¤ã‚‚ã‚Šã§ã€åŸºç¤Žçš„ãªè©±ãŒä¸å¿ƒã¨ãªã‚Šã¾ã™ã€‚å®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã®ä½œæˆçµŒç·¯ã«ã¤ã„ã¦ã¯ã€ã€Œä»Šå¤œã“ãã‚ã‹ã‚‹å®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ ã€œ é«˜æœ¨æµ©å…‰æ°ã«èžã„ã¦ã¿ãŸã€ã‚’å‚ç…§ä¸‹ã•ã„ã€‚ ã•ã¦ã€ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã¯ä»¥ä¸‹ã®äº”åã«ã‚ˆã‚‹åŸ·ç†ã¨ãªã£ã¦ã„ã¾ã™ã€‚ åŸ·ç†è€… å¾³ä¸¸ æµ©ã€€ã€€ æ°¸å®‰ ä½‘å¸Œå…ã€€ã€€ ç›¸é¦¬ åŸºé‚¦ã€€ã€€ å‹
ockeghem 2012/01/20
PostgreSQL Conference 2012ã§ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã«ã¤ã„ã¦è¬›æ¼”ã—ã¾ã™

event

sql

postgresql

ã‚»ãƒ«ã‚¯ãƒž
ãƒªãƒ³ã‚¯
PHPã‹ã‚‰è¦‹ãŸPostgreSQLã®æ•°å€¤ãƒ‡ãƒ¼ã‚¿åž‹ï¼ˆæ•°å€¤ãƒªãƒ†ãƒ©ãƒ«ï¼‰ | Let's POSTGRES
smallintã¯int2ã€integerã¯int4 ãŠã‚ˆã³intã€bigintã¯int8ã¨åŒæ„ã§ã™ã€‚ã¾ãŸsequenceã‚’ä½¿ã†ã¨ã„ã†æ©Ÿèƒ½ã‚’é™¤ã‘ã°ã€serialã¯integerã¨ã€bigserialã¯bigintã¨åŒæ§˜ã®å‹•ãã‚’ã—ã¾ã™ã€‚ã“ã‚Œã‚‰ã¯å°æ•°ç‚¹ä»¥ä¸‹ã®ãªã„ã€Œæ•´æ•°å€¤ã€ã§ã™ã€‚ serialã€bigserialã®å€¤ã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆãƒ»ç¯„å›²ã®ãƒã‚§ãƒƒã‚¯ãªã©ã¯integerã€bigintã¨åŒã˜ã§ã™ã®ã§ã€ä»¥ä¸‹ã¯ãã‚Œãžã‚Œã«èªã¿æ›¿ãˆã¦ãã ã•ã„ã€‚ 64bitã‚·ã‚¹ãƒ†ãƒ ã§ã®æ•´æ•°å€¤ã®ãƒã‚§ãƒƒã‚¯ smallintã¨integer ã¾ãšã€å€¤ãŒè² ã§ãªã„ï¼ˆã™ãªã‚ã¡ãƒžã‚¤ãƒŠã‚¹è¨˜å·ãŒã¤ã‹ãªã„ï¼‰ã“ã¨ã‚’å¿…é ˆã«ã—ã¦ã—ã¾ã£ã¦ã‚ˆã‘ã‚Œã°ã€smallintã‚„integerã®ãƒã‚§ãƒƒã‚¯ã¯ç°¡å˜ã§ã™ã€‚ if(!ctype_digit($_REQUEST['num']) || $_REQUEST['num'] > 32767) { // NGå‡¦ç† } ã“ã‚Œ
ockeghem 2011/12/13
ã€Žæ•°å€¤ã¯ã‚·ãƒ³ã‚°ãƒ«ã‚¯ã‚©ãƒ¼ãƒˆã§å›²ã‚“ã æ–‡å—åˆ—ã¨ã—ã¦ã§ã¯ãªãã€æ•°å€¤ãã®ã‚‚ã®â€¦ã¨ã—ã¦SQLã«åŸ‹ã‚è¾¼ã‚€æ–¹æ³•ãŒä¸»æµã«ãªã‚Šã¤ã¤ã‚ã‚Šã¾ã™ã€<ç›¸å¤‰ã‚ã‚‰ãšç´ æ™´ã‚‰ã—ã„å†…å®¹

postgresql
ãƒªãƒ³ã‚¯
PostgreSQL 9.0ã‹ã‚‰ä½¿ãˆã‚‹è˜åˆ¥åã¨ãƒªãƒ†ãƒ©ãƒ«ã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—
(Last Updated On: 2018å¹´8æœˆ13æ—¥)PostgreSQL Advent Calenderç”¨ã®ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚ ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—å‡¦ç†ãŒå¿…è¦ãªã®ã«ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ç”¨ã®APIãŒç„¡ã„çŠ¶æ…‹ã¯è‰¯ãã‚ã‚Šã¾ã›ã‚“ã€‚ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ãªã„ãŸã‚ã«å‹•ã‹ãªã„ã®ã¯ã¾ã è‰¯ã„æ–¹ã§ã™ã€‚ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ãŒå¿…è¦ãªã®ã«ã‚¨ ã‚¹ã‚±ãƒ¼ãƒ—ã‚’ã—ãªãã¦ã‚‚å‹•ã„ã¦ã—ã¾ã„ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ä¸Šã®å•é¡Œã¨ãªã‚‹å ´åˆã‚‚ã‚ã‚Šã¾ã™ã€‚å…¨ã¦ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ»ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¯ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ãŒå¿…è¦ãªãƒ‡ãƒ¼ã‚¿ã«å¯¾ã™ã‚‹APIã‚’æŒã£ã¦ãŠãã¹ã ã§ã™ã€‚ä»Šå›žã¯PostgreSQL 9.0ã‹ã‚‰è¿½åŠ ã•ã‚ŒãŸã‚¨ã‚¹ã‚±ãƒ¼ãƒ—é–¢æ•°ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ PostgreSQLä½¿ã„å§‹ã‚ã¦æœ€åˆã®é ƒã«æ°—ã¥ãã®ã¯userãªã©ã®äºˆç´„èªžãŒãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã«ä½¿ãˆãªã„äº‹ã‹ã‚‚çŸ¥ã‚Œã¾ã›ã‚“ã€‚ä¾‹ãˆã°ã€ yohgaki@[local] test=# CREATE TABLE user (name text); ERROR:Â syntax erro
ockeghem 2011/12/12
å‰ææ¡ä»¶ãŒæ›¸ã„ã¦ãªã„ã®ã§ã‚ã‹ã‚Šã«ãã„ã‘ã©ã€userã‚’SQLæ–‡ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã«ä½¿ã†ãŸã‚ã«ã¯"user"ã¨ãƒ€ãƒ–ãƒ«ã‚¯ã‚©ãƒ¼ãƒˆã§å›²ã‚ã°ã‚ˆã„ã€‚ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—é–¢æ•°ãŒå¿…è¦ãªã®ã¯SQLæ–‡ã‚’å‹•çš„ç”Ÿæˆã™ã‚‹å ´åˆ

sql

postgresql
ãƒªãƒ³ã‚¯
PostgreSQLã¯æ¨™æº–ã§ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ãªã„ä»•æ§˜ã«ãªã£ãŸ
PostgreSQL9.1ã®ä»•æ§˜å¤‰æ›´ã«ã¦ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆæ™‚ã®è¨å®šã¨ã—ã¦ã€standard_conforming_stringsãŒonã¨ã¿ãªã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã“ã®ä»•æ§˜å¤‰æ›´ã«ã‚ˆã‚Šã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®šã§ã®PostgreSQLã¯ã€ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚‹å¿…è¦ãŒãªããªã‚Šã€ISOè¦æ ¼ã®SQLã¨åŒæ§˜ã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ãƒ«ãƒ¼ãƒ«ï¼ˆã‚·ãƒ³ã‚°ãƒ«ã‚¯ã‚©ãƒ¼ãƒˆã‚’é‡ãã‚‹ã®ã¿ï¼‰ã¨ãªã‚Šã¾ã™ã€‚ PostgreSQLã®æ–‡å—åˆ—ãƒªãƒ†ãƒ©ãƒ«ã¯ã€å…ƒã€…MySQLåŒæ§˜ã«ã€ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚‹ä»•æ§˜ã§ã—ãŸã€‚ãã®å¾Œã€ãƒªãƒªãƒ¼ã‚¹8.1ã«ã¦ã€è¨å®šãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ standard_conforming_strings ãŒè¿½åŠ ã•ã‚Œã€ã“ã®å€¤ãŒ on ã®å ´åˆã€ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ãªã„ï¼ˆISOè¦æ ¼ã¨åŒæ§˜ã®ï¼‰ä»•æ§˜ã¨ãªã‚Šã¾ã—ãŸã€‚å¾“æ¥ã®ãƒªãƒªãƒ¼ã‚¹ã§ã¯ã€standard_conforming_stringsã‚’æŒ‡å®šã—ãªã„å ´åˆoffã¨ã¿ãªã•ã‚Œã¦ã„ã¾ã—ãŸã€‚ã“ã‚Œã¯ã€å¾Œ
ockeghem 2011/09/26
æ—¥è¨˜æ›¸ã„ãŸ

sql

postgresql

security

ã‚»ãƒ«ã‚¯ãƒž
ãƒªãƒ³ã‚¯
PostgreSQL 9.1 ã®æ–°æ©Ÿèƒ½â€”Let's Postgres
PostgreSQL 9.1.0 ãŒ 2011å¹´9æœˆ12æ—¥ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ æœ€æ–°ç‰ˆã®ãƒã‚¤ãƒŠãƒªã‚„ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯ "ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ç”¨ãƒšãƒ¼ã‚¸" ã§é…å¸ƒã•ã‚Œã¦ã„ã¾ã™ã€‚ 9.1 ã§ã¯ã€9.0 ã§æ–°è¦ã«æŽ¡ç”¨ã•ã‚ŒãŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã®ä½¿ã„å‹æ‰‹ã®å¼·åŒ–ã®ä»–ã€å¤–éƒ¨ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚„ DB ã«ç›´æŽ¥ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ SQL/MED ã‚„ã€æ‹¡å¼µãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®ç®¡ç†æ©Ÿèƒ½ãªã©ã€ã•ã‚‰ãªã‚‹å¼·åŒ–ãŒè¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚ äº’æ›æ€§ã«é–¢ã™ã‚‹æ³¨æ„ æœ€åˆãŒæ³¨æ„ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ãŒã€ä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨ã®äº’æ›æ€§ã®ç„¡ã„è¨å®šãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã«å¤‰æ›´ã•ã‚Œã¦ã„ã¾ã™ã€‚æ¯”è¼ƒçš„å¤šãã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§å•é¡Œã«ãªã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ãŸã‚ã€ã‚ãˆã¦å¼·èª¿ã—ã¦æ³¨æ„ã•ã›ã¦ã‚‚ã‚‰ã„ã¾ã™ã€‚ standard_conforming_strings ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãŒ on ã«å¤‰æ›´ standard_conforming_strings = on ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã«ãªã‚Šã¾ã—ãŸã€‚E'...' å½¢å¼ã§ãªã„æ–‡å—åˆ—å†…
ockeghem 2011/09/13
ã“ã¡ã‚‰ã®æ–¹ãŒèªã¿ã‚„ã™ã„ã€‚ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ã«ã¤ã„ã¦ã®é‡è¦ãªæ³¨æ„ã€‚MySQLç‹¬è‡ªè¨˜æ³•ã‹ã‚‰ISOæ¨™æº–ã«åˆã‚ã›ãŸã¨è¨€ã†ã“ã¨ã§ã™ã

sql

postgresql
ãƒªãƒ³ã‚¯
Release 9.1
E.76.1. Overview This release shows PostgreSQL moving beyond the traditional relational-database feature set with new, ground-breaking functionality that is unique to PostgreSQL. The streaming replication feature introduced in release 9.0 is significantly enhanced by adding a synchronous-replication option, streaming backups, and monitoring improvements. Major enhancements include: Allow synchrono
ockeghem 2011/09/13
ã€ŽBy default, backslashes are now ordinary characters in string literalsã€<ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ãªããªã‚‹ã¨ã„ã†é‡è¦ãªå¤‰æ›´

sql

postgresql
ãƒªãƒ³ã‚¯
PostgreSQL ã®å°Žå…¥ - Linux ã§è‡ªå®…ã‚µãƒ¼ãƒ [ Home Server Technical. ]
PostgreSQL ã¨ã¯ã€æœ¬æ ¼çš„ãª RDBMS ï¼ˆã¤ã¾ã‚Šã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼‰ã®äº‹ã§ã™ã€‚ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§ç„¡å„Ÿã§åˆ©ç”¨ã™ã‚‹äº‹ãŒå¯èƒ½ã§ã™ã€‚ ç§ã®æ‰€æ„Ÿã¨ã—ã¾ã—ã¦ã¯ã€ã€Œåˆå¿ƒè€…ã§ã‚‚æ‰±ã„ã‚„ã™ã„ã€ã¨ã„ã†å°è±¡ã‚’å—ã‘ã¾ã—ãŸã€‚ ã¡ãªã¿ã«ã€ã€Œ PostgreSQL ã€ã¯ã€ã€Œãƒã‚¹ãƒˆã‚°ãƒ¬ã‚¹ã€ã€Œãƒã‚¹ãƒˆã‚°ãƒ¬ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ãƒ«ã€ã€Œãƒã‚¹ãƒˆã‚°ãƒ¬ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ãƒ«ã€ãªã©ã¨ç™ºéŸ³ã™ã‚‹ï¼ˆå‘¼ã°ã‚Œã¦ã„ã‚‹ï¼‰ã‚‰ã—ã„ã§ã™ã€‚ ç§ã¯ã€Œãƒã‚¹ãƒˆã‚°ãƒ¬ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ãƒ«ã€ãŒãŠæ°—ã«å…¥ã‚Šã§ã™ã€‚ Vine Linux ã«ã¯å…ƒã€… PostgreSQL ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã¾ã™ã€‚ ç§ã¯ã€è§¦ã£ã¦ã„ã‚‹å†…ã«ä½•ãŒãªã‚“ã ã‹ãƒ¯ã‚±åˆ†ã‹ã‚‰ãªããªã‚Šã€å…ƒã€…ã® PostgreSQL ã‚’å‰Šé™¤ã—ã¾ã—ãŸã€‚ ã§ã™ã®ã§ã€æ–°è¦ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹äº‹ã«ãªã‚Šã¾ã—ãŸã€‚ ã€Œç‰¹ã« PostgreSQL ã«ã¤ã„ã¦è§¦ã£ã¦ãªã„ã‚ˆã€ã¨è¨€ã†æ–¹ã¯ã€äº‹é …ã® PHP ã«é–¢ã™ã‚‹è¨˜è¿°ã‹ã‚‰ãŠèªã¿ä¸‹ã•ã„ã€‚ ã“ã® PostgreSQL ã®å°Žå…¥ã«é–¢ã—ã¦ã¯ã€
ockeghem 2010/08/31
postgresql
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
ockeghem 2010/06/24
postgresql
ãƒªãƒ³ã‚¯
PostgreSQL ä½¿ç”¨æ™‚ã®æ–‡å—åˆ—ã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—å›žé¿å•é¡Œ - t_komuraã®æ—¥è¨˜
2006.03.06 è¿½è¨˜ ã“ã®å•é¡Œã«ã¤ã„ã¦ã¯ã€iakioæ—¥èªŒ(2006-02-15)ã«ãŠã„ã¦ã€PHP ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§å›žé¿ã™ã‚‹æ–¹æ³•ã®ä¾‹ã¨ã€PostgreSQL ã« Patch ã‚’å½“ã¦ã¦å›žé¿ã™ã‚‹æ–¹æ³•ã‚’ç¤ºã—ã¦ãŠã‚‰ã‚Œã¾ã™ã€‚å•é¡Œã®å½±éŸ¿ã‚’å—ã‘ã‚‹å ´åˆã¯å‚è€ƒã«ã™ã‚‹ã¨è‰¯ã„ã¨æ€ã„ã¾ã™ã€‚ 1æœˆ22æ—¥ã«æ›¸ã„ãŸã€addslashes() ã«ã‚ˆã‚‹ SQL æ–‡å—åˆ—ã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—å›žé¿å•é¡Œã®ç¶šãã§ã™ã€‚PostgreSQL ã§ã•ã‚‰ã«æ¤œè¨¼ã—ã¦ã¿ã¾ã—ãŸã€‚ çµè«–ã¨ã—ã¦ã¯ã€å‰å›žã¨åŒæ§˜ã§ã™ãŒã€PostgreSQL ã«é–¢ã—ã¦ã¯ã€SJIS ã¯ä½¿ç”¨ã—ãªã„æ–¹ãŒå®‰å…¨ã¨ã„ã†äº‹ã«ãªã‚Šã¾ã™ã€‚ ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã¨ã—ã¦ã€SJIS ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹å ´åˆã€addslashes() ã«ã‚ˆã‚‹ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã¯æ—¢ã«æŒ‡æ‘˜ã•ã‚Œã¦ã„ã‚‹é€šã‚Šã§ã™ãŒã€PostgreSQL ç”¨ã®æ–‡å—åˆ—ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—é–¢æ•°ã§ã‚ã‚‹ã€pg_escape_string() ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹å ´åˆã§ã‚‚å•é¡ŒãŒã‚ã‚Šã¾ã™
ockeghem 2010/03/19
todo

sqli

postgresql

security

php
ãƒªãƒ³ã‚¯
pg_sleepã‚’ä½¿ã£ãŸæ¤œæŸ» - teraccâ€™s blog
å¾³ä¸¸ã•ã‚“ã®æ—¥è¨˜ï¼ˆpg_sleepã‚’SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ¤œæŸ»ã«å¿œç”¨ã™ã‚‹ - ockeghem's blogï¼‰ã‚’èªã¿ã¾ã—ãŸã€‚ ã“ã†ã„ã†æ¤œæŸ»ã®ãƒžãƒ‹ã‚¢ãƒƒã‚¯ãªè©±ã¯å¤§å¥½ãã§ã™ã€‚ ã“ã®ã‚ãŸã‚Šã®ã‚·ã‚°ãƒãƒãƒ£ã¯ã€ç§ã‚‚è‡ªä½œãƒ„ãƒ¼ãƒ«ï¼ˆå‚è€ƒï¼‰ã®æ¤œè¨Žã‚’ã—ã¦ã„ãŸéš›ã«ç›¸å½“ã„ã‚ã„ã‚æ‚©ã‚“ã§èª¿ã¹ã¾ã—ãŸã®ã§ã€ä»Šå›žã¯UPDATEæ–‡ã®SETå¥ãªã©ã«ã‚‚é©ç”¨ã§ãã‚‹ã‚ˆã†ãªæ”¹å–„ã®ææ¡ˆã‚’ã—ãŸã„ã¨æ€ã„ã¾ã™ï¼ˆãŠã‚ã‚‰ãæ—¢ã«å¾³ä¸¸ã•ã‚“ã®é ã«ã‚ã‚‹ã‚‚ã®ã ã¨ã¯æ€ã„ã¾ã™ãŒï¼‰ã€‚ å¾³ä¸¸ã•ã‚“ã®æ—¥è¨˜ã®æ¤œæŸ»ãƒ‘ã‚¿ãƒ¼ãƒ³ã¯ã€ä»¥ä¸‹ã®å€¤ã‚’æŒ¿å…¥ã™ã‚‹ã‚‚ã®ã§ã—ãŸã€‚ ' and cast( (select pg_sleep(3)) as varchar) = 'ã“ã‚Œã‚’å°‘ã—å¤‰ãˆã¦ã€ä»¥ä¸‹ã®ã‚ˆã†ã«ã—ã¾ã™ã€‚ ï¼œæ–‡å—åˆ—åž‹ï¼ž ã€å…ƒã®å€¤ã€‘'||(select pg_sleep(3))||'æ•°å€¤åž‹ã§ã‚ã‚Œã°ã€ä»¥ä¸‹ã®ã‚ˆã†ã«ã—ã¾ã™ã€‚ ï¼œæ•°å€¤åž‹ï¼ž ã€å…ƒã®å€¤ã€‘-cast(chr(48)||(select pg_s
ockeghem 2009/11/05
è¨€åŠã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚select pg_sleep(3)ã¯æ¯”è¼ƒã ã¨ã‚ãƒ£ã‚¹ãƒˆãŒå¿…è¦ãªã®ã«ã€æ–‡å—åˆ—é€£çµã ã¨ã‚ãƒ£ã‚¹ãƒˆãŒè¦ã‚‰ãªã„ã®ã§ã™ãã€‚

security

sqli

postgresql

teracc
ãƒªãƒ³ã‚¯
pg_sleepã‚’SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ¤œæŸ»ã«å¿œç”¨ã™ã‚‹ - ockeghem's blog
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®é€²åŒ–å½¢ã¨ã—ã¦ã€ãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã„ã†æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ã€‚é€šå¸¸ã®SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¯ã€æ¤œç´¢çµæžœè¡¨ç¤ºã‚„ã‚¨ãƒ©ãƒ¼è¡¨ç¤ºã®ã¨ã“ã‚ã«ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æƒ³å®šã¨ã¯åˆ¥ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ»åˆ—ã®å€¤ã‚’è¡¨ç¤ºã™ã‚‹ã‚‚ã®ã§ã™ãŒã€ãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¯ã€SQLã®çµæžœãŒã‚¨ãƒ©ãƒ¼ã«ãªã‚‹ãƒ»ãªã‚‰ãªã„ã‚’1ãƒ“ãƒƒãƒˆã®æƒ…å ±ã¨ã—ã¦æ‚ªç”¨ã—ã€ã“ã‚Œã‚’ç©ã¿é‡ãã‚‹ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã®ä»»æ„æƒ…å ±ã‚’å¾—ã‚‹ã“ã¨ãŒã§ãã‚‹ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚ 1ãƒ“ãƒƒãƒˆã®æƒ…å ±ãŒå¾—ã‚‹æ‰‹æ®µã¨ã—ã¦ã¯ã€SQLã®ã‚¨ãƒ©ãƒ¼è¡¨ç¤ºã«é™ã‚‰ãªã„ã‚ã‘ã§ã€ç¾å®Ÿå•é¡Œã¨ã—ã¦ã€SQLã®ã‚¨ãƒ©ãƒ¼ãŒå¤–éƒ¨ã‹ã‚‰ã¯åˆ¤åˆ¥ã—ã«ãã„å ´åˆã‚‚ã‚ã‚Šã¾ã™ã€‚ãã®ã‚ˆã†ãªå ´åˆã®ç©¶æ¥µå½¢ã¨ã—ã¦ã€æ™‚é–“å·®ã‚’åˆ©ç”¨ã™ã‚‹ã¨ã„ã†æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ MS SQL Serverã«ã¯ã€waitfor delayã¨ã„ã†å‘½ä»¤ãŒã‚ã£ã¦ã€æ™‚ãƒ»åˆ†ãƒ»ç§’æŒ‡å®šã§ã‚¹ãƒªãƒ¼ãƒ—ã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚é‡‘åºŠæœ¬ã«ã¯ã€MySQLã‚„PostgreSQLã®å ´åˆã®
ockeghem 2009/11/05
sqli

postgresql

security

ã‚»ãƒ«ã‚¯ãƒž
ãƒªãƒ³ã‚¯
ç¬¬11å›žã€€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ ï¼»PDOç·¨ï¼½ | gihyo.jp
PHPã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹æ–¹æ³•ã®ã†ã¡ã€ä»Šå›žã¯PDOï¼ˆPHP Data Objectsï¼‰ã«ã‚ˆã£ã¦è¡Œã†æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚PDOã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã‚’ç”¨ã„ã‚‹ã¨ã€æŽ¥ç¶šã®æ™‚ã«ãã®ç¨®é¡žã‚’æŒ‡å®šã™ã‚‹ä»¥å¤–ã¯ã€PDOã«ã‚ˆã£ã¦çµ±ä¸€åŒ–ã•ã‚ŒãŸæ–¹æ³•ã§ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚é–¢æ•°ã®å ´åˆã¯æŽ¥ç¶šã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç¨®é¡žã”ã¨ã«é–¢æ•°åãŒå¤‰ã‚ã‚Šã¾ã™ãŒã€PDOã§ã¯å¤šãã®æ©Ÿèƒ½ãŒPDOã‚¯ãƒ©ã‚¹ã«é›†ç´„ã•ã‚Œã€å„DBã”ã¨ã«ç‰¹åŒ–ã—ãŸãƒ¡ã‚½ãƒƒãƒ‰ã‚„å®šæ•°ã«ã¤ã„ã¦ã®ã¿ã€DBã®ç¨®é¡žã«å¿œã˜ãŸåç§°ãŒã¤ã‘ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ PDOã‚’åˆ©ç”¨ã™ã‚‹ãŸã‚ã®è¨å®š PDOã‚’åˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã«ã¯ã€äº‹å‰ã«ç¢ºèªã—ã¦ãŠã‹ãªãã¦ã¯ãªã‚‰ãªã„ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ æŽ¥ç¶šã™ã‚‹DBã«å¯¾å¿œã—ãŸPDOç”¨ã®ãƒ‰ãƒ©ã‚¤ãƒãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã‹ ãƒ‰ãƒ©ã‚¤ãƒã¨ã¯ã€PDOã«ã‚ˆã‚‹æŽ¥ç¶šã‚’è¡Œã†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ã€ãã‚Œãžã‚Œã®DBMSã”ã¨ã«å¿…è¦ã§ã™ã€‚Oracle, PostgreSQLãªã©ä¸»ãªDBã§ã¯ã€ã‚ã‚‰ã‹ã˜
ockeghem 2009/10/15
pdo

php

sql

postgresql
ãƒªãƒ³ã‚¯
PostgreSQL 9.0.1æ–‡æ›¸
è£½ä½œè‘—ä½œ Â© 1996â€“2023 The PostgreSQL Global Development Group, ï¼ˆç¿»è¨³ï¼‰æ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼š
ockeghem 2009/09/09
postgresql

manual
ãƒªãƒ³ã‚¯
DBD::Pg - A Postgres database driver for the Perl DBI
DBD::Pg is a Perl DBI driver for the PostgreSQL database. While both Perl and Postgres are excellent products, getting them to work together is somewhat challenging, since the driver needs to be linked with the Postgres libraries (which are not always going to be installed on the machine you're trying to access the database from). This is further compounded by the fact that the Win32 distribution
ockeghem 2009/06/24
dbd

postgresql

perl
ãƒªãƒ³ã‚¯
http://www.mono-space.net/doc/jdbc/
ockeghem 2008/12/19
java

postgresql

jdbc
ãƒªãƒ³ã‚¯
ï¼»PostgreSQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬16å›ž PostgreSQLã®ãƒãƒƒãƒ•ã‚¡ãƒ»ãƒžãƒãƒ¼ã‚¸ãƒ£ã®æ”¹è‰¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚·ã‚¹ãƒ†ãƒ ã«ã¨ã£ã¦ï¼Œãƒãƒƒãƒ•ã‚¡ã®ç®¡ç†ã‚’ä¸€æ‰‹ã«å¼•ãå—ã‘ã‚‹ãƒãƒƒãƒ•ã‚¡ãƒ»ãƒžãƒãƒ¼ã‚¸ãƒ£ã¯ï¼Œãƒ‡ã‚£ã‚¹ã‚¯I/OåŠ¹çŽ‡ï¼Œã²ã„ã¦ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚·ã‚¹ãƒ†ãƒ ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å·¦å³ã™ã‚‹é‡è¦ãªæ§‹æˆè¦ç´ ã ã€‚PostgreSQL 8.0ã®ãƒãƒƒãƒ•ã‚¡ãƒ»ãƒžãƒãƒ¼ã‚¸ãƒ£ã¯ï¼ŒARC(Adaptive Replacement Cache)ã¨ã„ã†ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã‚’æŽ¡ç”¨ã—ï¼Œä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«æ¯”ã¹ã‚‹ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒå‘ä¸Šã—ã¦ã„ã‚‹ã€‚ ã—ã‹ã—ï¼ŒARCã¯ç±³IBMãŒç‰¹è¨±ã‚’å‡ºé¡˜ä¸ã§ã‚ã‚‹ãŸã‚ï¼Œç‰¹è¨±ãŒæˆç«‹ã™ã‚‹ã¨ARCã‚’ä½¿ãˆãªããªã£ã¦ã—ã¾ã†å¯èƒ½æ€§ãŒã‚ã‚‹ã€‚ã‚‚ã¡ã‚ã‚“ç‰¹è¨±ãŒæˆç«‹ã™ã‚‹ã¾ã§ã¯ARCã‚’ä½¿ã†ã“ã¨ã«ä½•ã‚‰å•é¡Œã¯ãªã„ãŒï¼Œãã‚Œã§ã‚‚æ—©ã„ã†ã¡ã«æ‰‹ã‚’æ‰“ã¤ã«è¶Šã—ãŸã“ã¨ã¯ãªã„ï¼Œã¨ã„ã†ã“ã¨ã§PostgeSQLã®é–‹ç™ºè€…ã¯ARCã«ä»£ã‚‹ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã‚’æŽ¡ç”¨ã™ã¹ãé–‹ç™ºä¸ã§ã‚ã‚‹ã€‚æ–°ã—ã„ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã¯ï¼Œã¾ã‚‚ãªããƒªãƒªãƒ¼ã‚¹ã•ã‚Œã‚‹ã¨æ€ã‚ã‚Œã‚‹PostgreSQL 8.0.2ã«æè¼‰ã•ã‚Œã‚‹äºˆå®šã ã€‚
ockeghem 2008/12/02
postgresql
ãƒªãƒ³ã‚¯
ï¼»PostgreSQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬39å›ž PostgreSQL 8.4ã®æ–°æ©Ÿèƒ½ã€Œå†å¸°SQLã€ã¨æœ€æ–°æƒ…å ±
æ¥å¹´ã¯ã˜ã‚ã®ãƒªãƒªãƒ¼ã‚¹ã‚’ç›®æŒ‡ã—ã¦é–‹ç™ºä¸ã®PostgreSQL 8.4ã®å§¿ãŒè¦‹ãˆå§‹ã‚ã¦ããŸã€‚ä»Šå›žã¯8.4ã®æ–°æ©Ÿèƒ½ã®ç›®çŽ‰ã®ä¸€ã¤ã§ã‚ã‚‹ã€Œå†å¸°SQLã®ã‚µãƒãƒ¼ãƒˆã€ã‚’ä¸å¿ƒã«ãŠè©±ã—ã™ã‚‹ã€‚ é–‹ç™ºã«ã‚ãŸã£ã¦ã¯ï¼ŒPostgreSQLã®å¤§è¦æ¨¡åˆ©ç”¨ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§ã‚ã‚‹ä½å‹é›»å·¥æƒ…å ±æ ªå¼ä¼šç¤¾ãŒãƒªã‚½ãƒ¼ã‚¹ã‚’æä¾›ã—ï¼Œç†è€…ã®å‹¤å‹™ã™ã‚‹SRA OSSæ—¥æœ¬æ”¯ç¤¾ãŒPostgreSQLã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã¨ã®èª¿æ•´ãŠã‚ˆã³å®Ÿè£…ã‚’æ‹…å½“ã—ãŸã€‚æœ€çµ‚çš„ã«ã¯PostgreSQLã‚³ã‚¢ãƒ¡ãƒ³ãƒã‚‰ã®å”åŠ›ã§å®Ÿè£…ãŒãƒ–ãƒ©ãƒƒã‚·ãƒ¥ã‚¢ãƒƒãƒ—ã•ã‚Œï¼Œ8.4ã¸ã®å–ã‚Šè¾¼ã¿ãŒç¢ºå®šã—ãŸã€‚ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã«ãŠã‘ã‚‹å†å¸°å‡¦ç† å†å¸°å‡¦ç†ã¯Cã‚„Javaãªã©ã®é€šå¸¸ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã§ã¯æ™®é€šã«ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ãŠã‚Šï¼Œã†ã¾ãä½¿ã†ã¨åŠ¹çŽ‡ã®ã‚ˆã„ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ãã‚Œã„ã«æ›¸ãã“ã¨ãŒã§ãã‚‹ã€‚å†å¸°å‡¦ç†ã¯å†å¸°çš„ãªæ§‹é€ ã‚’æŒã¤ãƒ‡ãƒ¼ã‚¿ï¼Œä¾‹ãˆã°æœ¨æ§‹é€ ã‚„ãƒªã‚¹ãƒˆæ§‹é€ ã‚’å‡¦ç†ã™ã‚‹éš›ã«è‰¯ãä½¿ã‚ã‚Œã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã‘ã‚‹å†å¸°å‡¦ç† å†å¸°SQLã¨ã¯ï¼Œæ–‡å—
ockeghem 2008/11/07
postgresql
ãƒªãƒ³ã‚¯
æ—¥æœ¬PHPãƒ¦ãƒ¼ã‚¶ä¼š æŽ²ç¤ºæ¿: PHP 5 Â» php5.2.6ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ç‰ˆã€zipç‰ˆï¼ˆwinï¼‰ã«ã¤ã„ã¦
ã“ã‚“ã«ã¡ã‚ã€‚ã¯ã˜ã‚ã¾ã—ã¦ã€‚ ã©ã“ã«æ›¸ãè¾¼ã‚ã°ã‚ˆã„ã®ã‹åˆ†ã‹ã‚‰ãªã‹ã£ãŸã®ã§ã€ã¨ã‚Šã‚ãˆãšã“ã¡ã‚‰ã«ã€‚ å…ˆæ—¥ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸphp5.2.6ã«ã¤ã„ã¦ã€ã‚·ã‚¹ãƒ†ãƒ ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã‚’ãƒ†ã‚¹ãƒˆã™ã‚‹ãŸã‚ windowsãƒã‚¤ãƒŠãƒªç‰ˆã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ï¼ˆã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆï¼‰ã—ãŸã¨ã“ã‚ã€å†…éƒ¨ã‚µãƒ¼ãƒãƒ¼ã‚¨ãƒ©ãƒ¼ï¼•ï¼ï¼ ãŒç™ºç”Ÿã—ã¾ã—ãŸã€‚ ã„ã‚ã„ã‚èª¿ã¹ã¦ã¿ã¾ã™ã¨ã€postgreSQLã¨ã®é€£å‹•ãŒå–ã‚Œã¦ã„ãªã„ã“ã¨ã«èµ·å› ã—ã¦ã„ã‚‹ã‚ˆã†ã§ã€ pg_sql.dllãŒé©åˆ‡ãªå ´æ‰€ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã«ã‚‚é–¢ã‚ã‚‰ãšã€pg_sql.dllãŒå˜åœ¨ã—ã¦ã„ãªã„ ã‚ˆã†ãªæŒ¯ã‚‹èˆžã„ã‚’ã—ã¦ã„ã‚‹ãŸã‚ã«ã€ã‚¨ãƒ©ãƒ¼ã¨ãªã£ã¦ã„ã‚‹ã‚ˆã†ã§ã—ãŸã€‚ ä½•åº¦ã‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å‰Šé™¤â†’å†ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚’ç¹°ã‚Šè¿”ã—ãŸã®ã§ã™ãŒå‹•ä½œã—ãªã‹ã£ãŸã®ã§ã€ pg_sql.dllã®ã¿ã‚’php5.2.5ç‰ˆã«å«ã¾ã‚Œã¦ã„ãŸã‚‚ã®ã¸å·®ã—æ›¿ãˆã‚‹ã¨æ£å¸¸å‹•ä½œã—ã¾ã—ãŸã€‚ ï¼ˆã¡ãªã¿ã«ã€php5.2.6zipç‰ˆã«å«ã¾ã‚Œã¦ã„ã‚‹pg_sql.d
ockeghem 2008/10/23
åƒ•ã‚‚ã¯ã¾ã£ãŸã€‚5.2.6ã¯ç¾æ™‚ç‚¹ã§å®‰å®šç‰ˆã®æœ€æ–°ã˜ã‚ƒãªã„ã‹ã€‚æ—©ãä¿®æ£ã—ã¦ãã‚Œã‚ˆï½ž/ã¨ã‚Šã‚ãˆãšã¯5.2.5ã‹ã‚‰php_pgsql.dllã‚’å–ã‚Šå‡ºã—ã¦ã‚³ãƒ”ãƒ¼ã—ãŸã‚‰ç›´ã£ãŸ

php

postgresql
ãƒªãƒ³ã‚¯
è‡ªå‹•åŒ–ã•ã‚ŒãŸSQL Injectionã®æ”»æ’ƒå¯¾è±¡ - teraccâ€™s blog
WASCã®Web Security MLã®å°‘ã—å‰ã®æŠ•ç¨¿ã‚ˆã‚Šã€‚ Tactical Web Application Security: Mass SQL Injection Attacks Now Targeting PHP Sites è‡ªå‹•åŒ–ã•ã‚ŒãŸSQL Injectionæ”»æ’ƒãŒã€ç¾åœ¨ã¯PHPã‚µã‚¤ãƒˆã‚’ã‚¿ãƒ¼ã‚²ãƒƒãƒˆã«ã—ã¦ã„ã‚‹ã¨ã®å†…å®¹ã®è¨˜äº‹ã§ã™ã€‚ ç¢ºã‹ã«ã€SQL Injectionã«ã‚ˆã£ã¦åŸ‹ã‚è¾¼ã¾ã‚Œã‚‹JSãƒ•ã‚¡ã‚¤ãƒ«ã®URLã‚’ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã«ã—ã¦Googleæ¤œç´¢ã™ã‚‹ã¨ã€æ‹¡å¼µåãŒphpã®ãƒšãƒ¼ã‚¸ã‚‚ãƒ’ãƒƒãƒˆã—ã¾ã™ã€‚ "1000mg.cn/csrss/w.js" - Google Search å€‹äººçš„ã«ä¸€ç•ªæ°—ãŒã‹ã‚Šãªã®ã¯ã€ã“ã‚Œã¾ã§ç‹™ã‚ã‚Œã¦ã„ãŸSQL Serverä»¥å¤–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒæ–°ãŸã«æ”»æ’ƒå¯¾è±¡ã«ãªã£ã¦ã„ã‚‹ã®ã‹ï¼ˆã‚ã‚‹ã„ã¯ãã†ã§ã¯ãªã„ã®ã‹ï¼‰ã¨ã„ã†ã“ã¨ã§ã™ã€‚ ãã“ã«ã‚‚é–¢ã‚ã‚Šãã†ãªè©±ãªã®ã§ã€å¯èƒ½ãªç¯„å›²ã§èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚
ockeghem 2008/09/15
æ”¹ã–ã‚“ã®æ‰‹æ³•ã¨ã—ã¦ã¯ã‚¢ãƒ—ãƒªã®SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ä»¥å¤–ã«phpBBã®ãœã„å¼±æ€§ã‚’åˆ©ç”¨ã—ãŸã‚‚ã®ã‚‚å¤šã„ã‚ˆã†ã§ã™ã€‚ã¾ãŸã€æ‹¡å¼µåcfmã¯ColdFusionã§ã™ãŒã€ãšã„ã¶ã‚“å¤šã„ã®ãŒæ°—ã«ãªã‚Šã¾ã™ã€‚

security

asp

php

mssql

postgresql

teracc
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸