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

TAKESAKO id:TAKESAKO

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

${{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}}

Cybozu Inside Out: ã‚°ãƒ«ãƒ¼ãƒ—ã‚¦ã‚§ã‚¢ã®ãƒã‚°ãƒ‡ãƒ¼ã‚¿ã‚’åˆ†æžå¯¾è±¡ã¨ã—ãŸã€ PL/Rã‚’ç”¨ã„ãŸãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°Webã‚¢ãƒ—ãƒªã®å®Ÿç¾(1)
ã‚°ãƒ«ãƒ¼ãƒ—ã‚¦ã‚§ã‚¢ã®ãƒã‚°ãƒ‡ãƒ¼ã‚¿ã‚’åˆ†æžå¯¾è±¡ã¨ã—ãŸã€ PL/Rã‚’ç”¨ã„ãŸãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°Webã‚¢ãƒ—ãƒªã®å®Ÿç¾(1) ã‚¢ãƒ–ã‚¹ãƒˆãƒ©ã‚¯ãƒˆï¼š æ–°å…¥ç¤¾å“¡ãŒå—ã‘ã‚‹ä¸€ãƒ¶æœˆã®é–‹ç™ºç ”ä¿®ã§ã€PostgreSQLã¨Rè¨€èªžã‚’çµ±åˆã—ã€PL/Rã‚’ç”¨ã„ã¦ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°ã®Webã‚¢ãƒ—ãƒªã‚’å®Ÿè£…ã—ã¾ã—ãŸã€‚ã¾ãŸã€ã‚µã‚¤ãƒœã‚¦ã‚ºç¤¾å†…ã§ä½¿ç”¨ã—ã¦ã„ã‚‹ã€Œã‚µã‚¤ãƒœã‚¦ã‚ºã‚¬ãƒ«ãƒ¼ãƒ³2ã€ã®Webã‚µãƒ¼ãƒãƒ¼ã®ãƒã‚°ãƒ‡ãƒ¼ã‚¿ã‚’åˆ†æžã—ã¦ã¿ã¾ã—ãŸã€‚ã“ã“ã§ã€ã“ã‚Œã‚‰ã®æŠ€è¡“ã«ã¤ã„ã¦ã€ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ï¼š ã‚°ãƒ«ãƒ¼ãƒ—ã‚¦ã‚§ã‚¢ã€ãƒã‚°ãƒ‡ãƒ¼ã‚¿ã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°ã€å¯è¦–åŒ– åˆã‚ã¾ã—ã¦ã€å‘¨ã¨ç”³ã—ã¾ã™ã€‚2009å¹´2æœˆã«ã€Œãƒã‚¹ãƒ‰ã‚¯æŽ¡ç”¨æž ã€ï¼ˆãƒã‚¹ãƒ‰ã‚¯æž ï¼‰ã§å…¥ç¤¾ã—ã€ç¾åœ¨ã¯é–‹ç™ºéƒ¨ã«æ‰€å±žã—ã¦ã„ã¾ã™ã€‚ä»Šå›žã€é–‹ç™ºéƒ¨æ¥å‹™ç ”ä¿®ã§å®Ÿè£…ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°Webã‚¢ãƒ—ãƒªã‚„ãƒã‚°ãƒ‡ãƒ¼ã‚¿åˆ†æžã«ã¤ã„ã¦ã®æŠ€è¡“ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚µã‚¤ãƒœã‚¦ã‚ºã§ã¯ã€ãƒã‚¹ãƒ‰ã‚¯æž ã§æŽ¡ç”¨ã•ã‚Œã‚‹æ–°å…¥ç¤¾å“¡ã¯ã€ç´„1ãƒ¶æœˆã®äºº
TAKESAKO 2009/06/15
R

postgresql
ãƒªãƒ³ã‚¯
Queue::Q4Pg::Lite ã‚’æ›¸ã„ãŸ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
PostgreSQL ã§ç°¡æ˜“ã« MQ - Mi manca qualche giovedi`? ã‚’èªã‚“ã§ã€ã“ã‚Šã‚ƒç´ æ™´ã‚‰ã—ã„ã¨æ€ã£ãŸã®ã§ Perl ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«åŒ–ã—ã¾ã—ãŸã€‚ simple message queue using PostgreSQL. http://github.com/fujiwara/perl-queue-q4pg-lite/tree/master å‰²ã¨ç°¡æ˜“ãª Message Queue ã¨ã„ã†ã“ã¨ã§ã€Lite ã£ã¦åå‰ã«ã€‚pg_advisory_lock() ã‚’ä½¿ç”¨ã—ã¦ã‚‹ã®ã§ã€PostgreSQL-8.2 ä»¥é™ã§ãªã„ã¨å‹•ãã¾ã›ã‚“ã€‚ ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã¯ Queue::Q4M ã¨ã»ã¨ã‚“ã©åŒã˜â€¦â€¦ã¨ã„ã†ã‹ã€ã‚³ãƒ¼ãƒ‰è‡ªä½“ã‚’åŠåˆ†ãã‚‰ã„ Queue::Q4M ã‹ã‚‰é ‚ã„ã¦ã„ã¾ã™ã€‚ use Queue::Q4Pg::Lite; my $q = Queue::Q4Pg::Lite->conn
TAKESAKO 2009/04/27
ãŠãŠãŠ

MQ

perl

postgresql

Q4M

Q4Pg
ãƒªãƒ³ã‚¯
PostgreSQL ã¸ã®ãƒ‘ãƒƒãƒã®é€ã‚Šæ–¹ - higepon blog
ãªãœãƒ‘ãƒƒãƒã‚’æ›¸ãã‹ï¼Ÿ ãƒã‚°ã‚’è¦‹ã¤ã‘ãŸå ´åˆã¯ãã‚Œã‚’ä¿®æ£ã™ã‚‹ãŸã‚ãªã©ã€‚ å˜ç´”ã«ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«è²¢çŒ®ã—ãŸã„ã®ã§ã‚ã‚Œã°ã€Todo - PostgreSQL Wikiã€€ã‚’è¦‹ã¦è‡ªåˆ†ãŒã§ããã†ãªã‚‚ã®ã‚’é¸ã¶ã€‚ è¦æ±‚ä»•æ§˜ãŒåˆ†ã‹ã‚‰ãªã„å ´åˆã¯éŽåŽ»ãƒã‚°ã‚’æ¤œç´¢ã™ã‚‹ã€ãã‚Œã§ã‚‚åˆ†ã‹ã‚‰ãªã„ã¨ãã¯ Hackers ML ã§è³ªå•ã™ã‚‹ã€‚ ãƒ‘ãƒƒãƒã‚’æ›¸ã PostgreSQL ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°è¦ç´„ã«å¾“ã£ã¦ã€ãƒ‘ãƒƒãƒã‚’æ›¸ãã€‚åŸºæœ¬çš„ã«ã¯è‡ªåˆ†ãŒæ‰‹ã‚’å…¥ã‚Œã¦ã„ã‚‹å‘¨è¾ºã®ã‚³ãƒ¼ãƒ‰ã¨åŒã˜ã‚ˆã†ãªä½“è£ã«æ•´ãˆã‚Œã°è‰¯ã„ã¨æ€ã†ã€‚ 4 ã‚«ãƒ©ãƒ Tabï¼ˆspace ã«å±•é–‹ã•ã‚Œãªã„ï¼‰ ãƒ¬ã‚¤ã‚¢ã‚¦ãƒˆã¯ BSD è¦ç´„ C++ ã® // ã‚³ãƒ¡ãƒ³ãƒˆã¯ä½¿ã‚ãªã„ æ£ã—ã„ã‚¹ãƒšãƒ« ãªã©ã€‚ä»–ã«ã‚‚ãŸãã•ã‚“ã€‚ ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ PostgreSQL ã¯ BSD ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ãªã®ã§ãƒ‘ãƒƒãƒã‚‚ãã‚Œã«æº–ãšã‚‹ã€‚ ãƒ†ã‚¹ãƒˆã™ã‚‹ src/test ã«ãƒ†ã‚¹ãƒˆãŒã‚ã‚‹ã€‚è‡ªåˆ†ãŒæ›¸ã„ãŸã‚³ãƒ¼ãƒ‰ãŒæ—¢å˜ã®æ©Ÿèƒ½ã‚’å£Šã—ã¦ã„ãªã„ã‹ã ã‘ã§ã‚‚ãƒ†
TAKESAKO 2009/03/26
oss

postgresql
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
TAKESAKO 2009/02/26
postgresql
ãƒªãƒ³ã‚¯
ï¼»PostgreSQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬16å›ž PostgreSQLã®ãƒãƒƒãƒ•ã‚¡ãƒ»ãƒžãƒãƒ¼ã‚¸ãƒ£ã®æ”¹è‰¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚·ã‚¹ãƒ†ãƒ ã«ã¨ã£ã¦ï¼Œãƒãƒƒãƒ•ã‚¡ã®ç®¡ç†ã‚’ä¸€æ‰‹ã«å¼•ãå—ã‘ã‚‹ãƒãƒƒãƒ•ã‚¡ãƒ»ãƒžãƒãƒ¼ã‚¸ãƒ£ã¯ï¼Œãƒ‡ã‚£ã‚¹ã‚¯I/OåŠ¹çŽ‡ï¼Œã²ã„ã¦ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚·ã‚¹ãƒ†ãƒ ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å·¦å³ã™ã‚‹é‡è¦ãªæ§‹æˆè¦ç´ ã ã€‚PostgreSQL 8.0ã®ãƒãƒƒãƒ•ã‚¡ãƒ»ãƒžãƒãƒ¼ã‚¸ãƒ£ã¯ï¼ŒARC(Adaptive Replacement Cache)ã¨ã„ã†ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã‚’æŽ¡ç”¨ã—ï¼Œä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«æ¯”ã¹ã‚‹ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒå‘ä¸Šã—ã¦ã„ã‚‹ã€‚ ã—ã‹ã—ï¼ŒARCã¯ç±³IBMãŒç‰¹è¨±ã‚’å‡ºé¡˜ä¸ã§ã‚ã‚‹ãŸã‚ï¼Œç‰¹è¨±ãŒæˆç«‹ã™ã‚‹ã¨ARCã‚’ä½¿ãˆãªããªã£ã¦ã—ã¾ã†å¯èƒ½æ€§ãŒã‚ã‚‹ã€‚ã‚‚ã¡ã‚ã‚“ç‰¹è¨±ãŒæˆç«‹ã™ã‚‹ã¾ã§ã¯ARCã‚’ä½¿ã†ã“ã¨ã«ä½•ã‚‰å•é¡Œã¯ãªã„ãŒï¼Œãã‚Œã§ã‚‚æ—©ã„ã†ã¡ã«æ‰‹ã‚’æ‰“ã¤ã«è¶Šã—ãŸã“ã¨ã¯ãªã„ï¼Œã¨ã„ã†ã“ã¨ã§PostgeSQLã®é–‹ç™ºè€…ã¯ARCã«ä»£ã‚‹ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã‚’æŽ¡ç”¨ã™ã¹ãé–‹ç™ºä¸ã§ã‚ã‚‹ã€‚æ–°ã—ã„ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã¯ï¼Œã¾ã‚‚ãªããƒªãƒªãƒ¼ã‚¹ã•ã‚Œã‚‹ã¨æ€ã‚ã‚Œã‚‹PostgreSQL 8.0.2ã«æè¼‰ã•ã‚Œã‚‹äºˆå®šã ã€‚
TAKESAKO 2008/12/02
postgresql

lock

algorithm
ãƒªãƒ³ã‚¯
2008-06-30
ä»Šé€±æœ«(7/5 åœŸæ›œæ—¥ 14:00ã€œ)ã—ã¾ã™ã€‚ä»Šåº¦ã¯ãŸã¶ã‚“æº–å‚™ä¸‡ç«¯ã§ã™ã€‚ ä»Šå›žã¯ã€è‡ªåˆ†ä»¥å¤–ã«id:agtã•ã‚“ã¨id:brazilã•ã‚“ã«ã‚ˆã‚‹ã€å¯„ã£ã¦ãŸã‹ã£ã¦æ¥½ã—ã„ã‚¤ãƒ™ãƒ³ãƒˆã®äºˆå®šã§ã™ã€‚ã„ã¤ã‚‚æ›¸ã„ã¦ã„ã¾ã™ãŒã€å¯¾è±¡ã¯ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’å§‹ã‚ã¦1ã€œ3å¹´ãã‚‰ã„ã®Webç³»ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã®æ–¹ã€…ã‚’ä»®å®šã—ã¦ã„ã¾ã™ã®ã§ã€ä¸€ç·’ã«æ¥½ã—ãWebã®æŠ€è¡“ã‚’å‹‰å¼·ã—ã¦ã„ããŸã„ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ å…¬å¼ã‚µã‚¤ãƒˆ: http://tenjin-web.jottit.com/tenjin.web/3 ä»Šé€±ã®æœ¨æ›œ19:00ã”ã‚ã‹ã‚‰ã€Postgresqlã®SQLã§å’Œæš¦å¤‰æ›ã¨ã‹ãƒãƒ¼ãƒžå—ä»®åå¤‰æ›ã¨ã‹ã‚’è¡Œã†æŠ€è¡“ã«ã¤ã„ã¦ã®å‹‰å¼·ä¼šã‚’è¡Œã†äºˆå®šã§ã™ã€‚ICU4Cè‡ªèº«ã‚„ã€C++ã‚’Perlã§ãƒ©ãƒƒãƒ—ã—ã¦Postgresqlã«çµ„ã¿è¾¼ã‚€æŠ€è¡“ãªã©ã«ã¤ã„ã¦ç°¡å˜ã«å ±å‘Šã—ã¾ã™ã€‚ã‚‚ã—èˆˆå‘³ãŒã‚ã‚Šã¾ã—ãŸã‚‰ã€ãœã²èžãã«ãã¦ã„ãŸã ã„ã¦ã€ã„ã‚ã„ã‚æ•™ãˆã¦ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ã€‚äººæ•°æŠŠæ¡ã®éƒ½åˆãŒã‚
TAKESAKO 2008/07/01
Postgresqlã‚’Perlã¨C++ã§æ‹¡å¼µã™ã‚‹å…¬é–‹å‹‰å¼·ä¼š

postgresql

event

perl

c++
ãƒªãƒ³ã‚¯
SQLã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã«ãŠã‘ã‚‹ã€Œ\ã€ã®å–ã‚Šæ‰±ã„
è£œè¶³ ã“ã®è¨˜äº‹ã¯æ—§å¾³ä¸¸æµ©ã®æ—¥è¨˜ã‹ã‚‰ã®è»¢è¼‰ã§ã™ã€‚å…ƒURLã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯1ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯2ã€‚ å‚™å¿˜ã®ãŸã‚è»¢è¼‰ã„ãŸã—ã¾ã™ãŒã€ã“ã®è¨˜äº‹ã¯2008å¹´6æœˆ2æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã‚‚ã®ã§ã€å½“æ™‚ã®å¾³ä¸¸ã®è€ƒãˆã‚’ç¤ºã™ã‚‚ã®ã‚’ã€åŸºæœ¬çš„ã«å†…å®¹ã‚’å¤‰æ›´ã›ãšã«ãã®ã¾ã¾è»¢è¼‰ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ è£œè¶³çµ‚ã‚ã‚Š æ˜¨æ—¥ã®ã‚¨ãƒ³ãƒˆãƒª(å¾³ä¸¸æµ©ã®æ—¥è¨˜ - ãã‚ãã‚SQLã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã«é–¢ã—ã¦ä¸€è¨€ã„ã£ã¨ãã‹ - SQLã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—å†è€ƒ)ã¯æ€ã„ãŒã‘ãšå¤šãã®æ–¹ã«èªã‚“ã§ã„ãŸã ã„ãŸã€‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ãã®ä¸ã§é«˜æœ¨æµ©å…‰æ°ã‹ã‚‰ãƒ–ã‚¯ãƒžã‚³ãƒ¡ãƒ³ãƒˆã‚’é ‚æˆ´ã—ãŸã€‚ \ãŒescapeç”¨æ–‡å—ã®DBã§\ã®escapeãŒå¿…é ˆã«ãªã‚‹ç†ç”±ãŒæ˜Žç¢ºã«æ›¸ã‹ã‚Œã¦ãªã„ã€‚\'ãŒä¸Žãˆã‚‰ã‚ŒãŸã¨ã'ã ã‘escapeã™ã‚‹ã¨â€¦ã€‚è‡ªä½œescapeã¯å±ã†ã„ã€‚ã€Œå®‰å…¨ãªâ€¦ä½œã‚Šæ–¹ã€3ç‰ˆã§è¿½åŠ ã®ã€Œ3.å¤±æ•—ä¾‹ã€ã§ã¯DBã§ç”¨æ„ã•ã‚ŒãŸescapeæ©Ÿèƒ½ã—ã‹æŽ¨å¥¨ã—ã¦ã„ãªã„ ã“ã®ã†ã¡ã€ã¾ãšã€Œ\ã€ã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ãŒå¿…
TAKESAKO 2008/06/03
mysql

security

sql

postgresql
ãƒªãƒ³ã‚¯
ã€PostgreSQLã‚¦ã‚©ãƒƒãƒã€‘ç¬¬27å›ž SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ã‚’ä¿®æ£ï¼Œæ—¥æœ¬èªžãƒ¦ãƒ¼ã‚¶ãƒ¼ã«å¤§ããªå½±éŸ¿ï¼šITpro
ã€PostgreSQLã‚¦ã‚©ãƒƒãƒã€‘ç¬¬27å›ž SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ã‚’ä¿®æ£ï¼Œæ—¥æœ¬èªžãƒ¦ãƒ¼ã‚¶ãƒ¼ã«å¤§ããªå½±éŸ¿ é€£è¼‰ç›®æ¬¡ã¸ >> SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«é–¢ã™ã‚‹è„†å¼±æ€§ã®ä¿®æ£ãªã©ã‚’è¡Œã£ãŸPostgreSQL 8.1.4,8.0.8ï¼Œ7.4.13ï¼Œ7.3.15ã®å„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒï¼Œ5æœˆ23æ—¥ä¸€æ–‰ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸï¼ˆé–¢é€£è¨˜äº‹ï¼‰ã€‚ã„ãšã‚Œã‚‚åŒã˜ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç³»åˆ—ã§ã‚ã‚Œã°ï¼Œdump/restoreã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ç§»è¡Œãªã—ã§ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã§ãã‚‹(ãŸã ã—ï¼Œ8.1ï¼Œ8.1.1ã‹ã‚‰8.1.4ã¸ã®ç§»è¡Œã«ã¤ã„ã¦ã¯æ³¨æ„ãŒå¿…è¦ã€‚è©³ç´°ã¯ä»˜å±žã®ãƒªãƒªãƒ¼ã‚¹ãƒŽãƒ¼ãƒˆã‚’å‚ç…§ã•ã‚ŒãŸã„)ã€‚ ä¿®æ£ãŒæä¾›ã•ã‚Œãªã„PostgreSQL 7.2ä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ ä»Šå›žå¯¾ç–ã•ã‚ŒãŸè„†å¼±æ€§ã¯PostgreSQL 7.2ä»¥å‰ã«ã‚‚å˜åœ¨ã™ã‚‹ãŒï¼Œé–‹ç™ºè€…ã®ãƒãƒªã‚·ãƒ¼ã«ã‚ˆã‚Šï¼Œ7.2ä»¥å‰ã¯ã‚µãƒãƒ¼ãƒˆã®å¯¾è±¡ã«ãªã£ã¦ã„ãªã„ã€‚ã„ã¾ã ã«7.2 ä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ä½¿ã£ã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ï¼Œ7.
TAKESAKO 2008/05/13
security

postgresql

charset

ã‚ã¨ã§
ãƒªãƒ³ã‚¯
PostgreSQLã§åŠ¹çŽ‡çš„ãªè² è·åˆ†æ•£ã‚’å®Ÿç¾ã—ã€ãƒ¢ãƒã‚²ãƒ¼ã‚„mixiã‚’è¿½æ’ƒ â€• TechTargetã‚¸ãƒ£ãƒ‘ãƒ³
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®PostgreSQLã§ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ 10ä»£ã€20ä»£ã‚’ä¸å¿ƒã«æ€¥æ¿€ãªæ™®åŠã‚’è¦‹ã›ã‚‹â€œã‚±ãƒ¼ã‚¿ã‚¤SNSâ€ã€‚ä¼šå“¡æ•°ãŒ865ä¸‡äººã«é”ã™ã‚‹ã€Œãƒ¢ãƒã‚²ãƒ¼ã‚¿ã‚¦ãƒ³ã€ã‚„æœˆé–“118å„„ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ï¼ˆPVï¼‰ã‚’èª‡ã‚‹ã€Œmixiã€ï¼ˆç´„6å‰²ãŒãƒ¢ãƒã‚¤ãƒ«çµŒç”±ï¼‰ãªã©ã€å¤§æ‰‹SNSã‚µã‚¤ãƒˆãŒå˜åœ¨æ„Ÿã‚’å¢—ã—ã¦ã„ã‚‹ï¼ˆæ•°å€¤ã¯ã„ãšã‚Œã‚‚2007å¹´12æœˆç¾åœ¨ï¼‰ã€‚ãã†ã—ãŸä¸ã§å…ˆè¡Œçµ„ã‚’æ¿€ã—ãè¿½æ’ƒã—ã¦ã„ã‚‹ã®ãŒã€ã‚ªãƒ¼ãƒ—ãƒ³ãƒ‰ã‚¢ãŒé‹å–¶ã™ã‚‹æºå¸¯é›»è©±å‘ã‘ã®SNSã‚µã‚¤ãƒˆã€Œå¤§é›†åˆNEOã€ã ã€‚ 2007å¹´1æœˆã«ã‚¹ã‚¿ãƒ¼ãƒˆã—ãŸå¤§é›†åˆNEOã¯ã€SNSã®ã¿ãªã‚‰ãšã€ã‚¢ãƒã‚¿ãƒ¼ã‚„ã‚²ãƒ¼ãƒ ã€å°èª¬ã€å‹•ç”»ã€æ—¥è¨˜ã€ãƒãƒ£ãƒƒãƒˆãªã©ã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã™ã¹ã¦ç„¡æ–™ã§æ¥½ã—ã‚ã‚‹ã®ãŒç‰¹å¾´ã ã€‚ã‚¢ãƒã‚¿ãƒ¼ã‚„ã‚µã‚¤ãƒˆå†…é€šè²¨ã®ä½¿ã„å‹æ‰‹ã®è‰¯ã•ã§å…ˆè¡Œã‚µã‚¤ãƒˆã¨å·®åˆ¥åŒ–ã‚’å›³ã‚Šã€2007å¹´å¤ã«50ä¸‡äººã ã£ãŸä¼šå“¡æ•°ãŒ2008å¹´2æœˆæ™‚ç‚¹ã§2å€ã®100ä¸‡äººã«é”ã—ã¦ã„ã‚‹ã€‚ ãã®å¤§é›†åˆNEOã®ã‚·ã‚¹ãƒ†ãƒ åŸºç›¤ã‚’æ‹…ã£ã¦ã„ã‚‹ã®ã¯ã€MySQLã¨ã‚ª
TAKESAKO 2008/02/29
ã‚ªãƒ¼ãƒ—ãƒ³ãƒ‰ã‚¢ãŒé‹å–¶ã™ã‚‹æºå¸¯é›»è©±å‘ã‘ã®SNSã‚µã‚¤ãƒˆã€Œå¤§é›†åˆNEOã€ã£ã¦ Slony-I ä½¿ã£ã¦ãŸã®ã‹ï½—

postgresql

sns

mobile
ãƒªãƒ³ã‚¯
ã€ŒPostgreSQLã¯é…ã„ã€ã¯æœ¬å½“ã‹ï¼Ÿï¼šOSSãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¯”è¼ƒ
å°åˆ·ã™ã‚‹ ãƒ¡ãƒ¼ãƒ«ã§é€ã‚‹ ãƒ†ã‚ã‚¹ãƒˆ HTML é›»åæ›¸ç± PDF ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ ãƒ†ã‚ã‚¹ãƒˆ é›»åæ›¸ç± PDF ã‚¯ãƒªãƒƒãƒ—ã—ãŸè¨˜äº‹ã‚’Myãƒšãƒ¼ã‚¸ã‹ã‚‰èªã‚€ã“ã¨ãŒã§ãã¾ã™ 5ç•ªç›®ã¨ãªã‚‹æŽ¥ç¶šã‚³ã‚¹ãƒˆã«ã¤ã„ã¦åŒæ°ã¯ã€Œâ€œPostgreSQLã¯æŽ¥ç¶šã‚³ã‚¹ãƒˆãŒé‡ã„â€ã¨è¨€ã‚ã‚Œã¦ã„ã‚‹ã“ã¨ã¨ã€â€œMySQLã¯ãƒžãƒ«ãƒã‚¹ãƒ¬ãƒƒãƒ‰ã®ãƒ¢ãƒ‡ãƒ«ã ã‹ã‚‰é€Ÿã„â€ã¨è¨€ã‚ã‚Œã¦ã„ã‚‹ã“ã¨ã‚’æ¤œè¨¼ã—ãŸã‹ã£ãŸã€ã¨ã€ãã®ç‹™ã„ã‚’èª¬æ˜Žã—ã¦ã„ã‚‹ã€‚ãã†ã—ãŸèƒŒæ™¯ã®ä¸‹ã§è¡Œã£ãŸæŽ¥ç¶šã‚³ã‚¹ãƒˆã®çµæžœã ãŒã€å®Ÿéš›ã«ã¯ã€ŒPostgreSQLã¯æ„å¤–ã«é€Ÿã„ã€ã¨ã„ã†çµæžœã«ãªã£ã¦ã„ã‚‹ã€‚ ã“ã®ãƒ†ã‚¹ãƒˆã¯ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®æ•°ã‚’0ã‹ã‚‰1000å°ã¾ã§å¢—ã‚„ã—ã¦ã€æœ€åˆã®ã‚¯ã‚¨ãƒªã‚’æŠ•ã’ã‚‰ã‚Œã‚‹ã¾ã§ã®æ™‚é–“ã‚’è¨ˆæ¸¬ã™ã‚‹ã¨ã„ã†ã‚‚ã®ã ãŒã€PostgreSQLã¯ç·ã˜ã¦MySQLã‚ˆã‚Šé€Ÿã„å‡¦ç†æ™‚é–“ã¨ãªã£ã¦ã„ã‚‹ã€‚ã—ã‹ã—ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®æ•°ãŒ20å°ã®ä»˜è¿‘ã§ã¯ã€MySQLã‚ˆã‚Šã‚‚æ™‚é–“ãŒã‹ã‹ã£ã¦ã—ã¾ã†ã¨ã„ã†çµæžœã ã€‚ãªãœã€ã“ã®ã‚ˆã†ãªçµæžœã«ãªã‚‹ã‹ã«
TAKESAKO 2007/04/12
MySQL

PostgreSQL
ãƒªãƒ³ã‚¯
é€†å¼•ãSQLæ¯”è¼ƒ
Works > é€†å¼•ãSQLæ¯”è¼ƒ é€†å¼•ãSQLæ¯”è¼ƒ [Â å…±é€šäº‹é …Â ]Â [Â ORACLEÂ ]Â [Â MSSQLÂ ]Â [Â SSAÂ ]Â [Â PostgresÂ ]Â [Â MySQLÂ ]Â [Â JetÂ ]Â Last Updated. 14-May-2006 Since 08-May-2001 â– ã¯ã˜ã‚ã« è¤‡æ•°ã® RDBMS ã‚’ä½¿ã£ãŸçµŒé¨“ãŒã‚ã‚‹äººãªã‚‰ã€ãŠã‚ã‹ã‚Šã‹ã¨æ€ã„ã¾ã™ãŒã€SQL ã¯ RDBMS ã«ã‚ˆã£ã¦ç•°ãªã‚‹éƒ¨åˆ†ãŒçµæ§‹ã‚ã‚Šã¾ã™ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã¯å„ RDBMS ã«ãŠã‘ã‚‹ åŸºæœ¬çš„ãªæ©Ÿèƒ½ï¼ˆä¸»ã«SQLã«ã¤ã„ã¦ï¼‰ã®æ¦‚è¦ã‚’ã€é€†å¼•ãã§ã€ã‹ã¤å¹³æ˜“ãªè¨€è‘‰ã§é–²è¦§ ã™ã‚‹äº‹ã‚’ç›®çš„ã«ä½œã£ãŸãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã§ã™ã€‚ ç‰¹å®šã® RDBMS ã‚’æŒã¡ä¸Šã’ãŸã‚Šã€è²¶ã‚ãŸã‚Šã™ã‚‹ã®ãŒç›®çš„ã§ã¯ãªã„ã®ã§èª¤è§£ãªãã‚ˆã†ã€‚ ã¾ãŸã€é–“é•ã„ã«ã¤ã„ã¦ã®ã”æŒ‡æ‘˜ã‚„ã€Žã“ã†ã—ãŸæ–¹ãŒåŠ¹çŽ‡çš„ã ã€ãªã©ã®ã”æ„è¦‹ã‚‚å¤§æ“è¿Žã§ã™ã€‚ å¯¾è±¡ã¨ã—ã¦ã„ã‚‹ã®ã¯ä»¥ä¸‹ã® RDBMSã§
TAKESAKO 2007/04/02
sql

mysql

oracle

postgresql
ãƒªãƒ³ã‚¯
1