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

hiro_y id:hiro_y

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

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

Instagram ã®ã‚¹ã‚±ãƒ¼ãƒ«æ£æ”»æ³• -- Kosei Kitahara's Blog
Instagram ãŒã©ã“ã«è²·åŽã•ã‚ŒãŸã¨ã‹ã¯ä»–ã®ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚µã‚¤ãƒˆã«ãŠä»»ã›ã—ã¦ã€Django ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ£æ”»æ³•ã§ã‚¹ã‚±ãƒ¼ãƒ«ã—ã¦ "æˆåŠŸ" ã—ã¦ã‚‹ã®ãŒã¨ã¦ã‚‚èˆˆå‘³æ·±ã„ã§ã™ã€‚ç¾æ™‚ç‚¹ã§ Instagram Engineering ã§ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ã“ã¨ã¨ TechCrunch ã«ã‚‚æŽ²è¼‰ã•ã‚ŒãŸã‚¹ãƒ©ã‚¤ãƒ‰ã‹ã‚‰å€‹äººçš„ãªãƒ¡ãƒ¢ã¨ã—ã¦ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ Instagram ã®å“²å¦ã¯ ã‚·ãƒ³ãƒ—ãƒ«ã§ã‚ã‚‹ã“ã¨ ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³è² è·ã‚’æœ€å°åŒ–ã™ã‚‹ã“ã¨ ã™ã¹ã¦è£…å‚™ ã¨ã®ã“ã¨ã€‚ Instagram ã¯ä»¥ä¸‹ã® OSS, ã‚µãƒ¼ãƒ“ã‚¹ã§æ§‹ç¯‰ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ >>> OS / ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚° Ubuntu Linux 11.04 ã‚’ Amazon EC2 ã«ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã€‚ä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯é«˜ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã«ãªã‚‹ã¨å›ºã¾ã‚‹å•é¡ŒãŒã‚ã£ãŸã‚ˆã†ã§ã™ã€‚é‹ç”¨ã¯ 3 äººã€‚EC2 ã«ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã—ã¦ã„ã‚‹ç†ç”±ã¯ã€èª¿æŸ»çµæžœã«ã‚ˆã‚‹ã‚‚ã®ã§ã¯ãªãã€"ã¾ã é€²åŒ–é€”ä¸ã ã‹
hiro_y 2012/04/17
gearmanä½¿ã£ã¦ã‚‹ã®ã‹

postgresql

redis
ãƒªãƒ³ã‚¯
Scaling Instagram
on TechCrunch http://techcrunch.com/2012/04/12/how-to-scale-a-1-billion-startup-a-guide-from-instagram-co-founder-mike-krieger
hiro_y 2012/04/13
postgresql

couchdb

aws
ãƒªãƒ³ã‚¯
Post by @instagram-engineering
What Powers Instagram: Hundreds of Instances, Dozens of Techno logies One of the questions we always get asked at meet-ups and conversations with other engineers is, â€œwhatâ€™s your stack?â€ We thought it would be fun to give a sense of all the systems that power Instagram, at a high-level; you can look forward to more in-depth descriptions of some of these systems in the future. This is how our system
hiro_y 2012/04/12
Instagramã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰

aws

nginx

postgresql

redis

solr
ãƒªãƒ³ã‚¯
pgmemcacheã‹ã‚‰memcachedã®ãƒ‡ãƒ¼ã‚¿ã‚’æ“ä½œã™ã‚‹
æœ¬ç¨¿ã®å‰æç’°å¢ƒ memcached 1.2.5 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼šPostgreSQL 8.3.1 OSï¼šCentOS 5ï¼ˆLinux kernel 2.6 ï¼‰ ã‚·ã‚§ãƒ«ï¼šbash CPUï¼šIntel Core2Quad 9660 2.4GHz RAMï¼šPC2-6400 8GBytes ä»¥é™ã§ã¯ã€å‰ç·¨ã®å†…å®¹ã‚’å‰æã¨ã—ã¦ã€å®Ÿéš›ã«memcachedã«ã‚¢ã‚¯ã‚»ã‚¹ã—ãªãŒã‚‰pgmemcacheã®ä½¿ã„æ–¹ã‚’èª¬æ˜Žã—ã¾ã™ã®ã§ã€memcachedãŒèµ·å‹•ã•ã‚Œã¦ã„ã‚‹ã‹ã©ã†ã‹ç¢ºèªã—ã¦ãã ã•ã„ã€‚ æœ€åˆã«ã€ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã‚½ãƒ•ãƒˆpsqlã‚’ä½¿ã£ã¦ç›´æŽ¥pgmemcacheã®ä¸»è¦ãªé–¢æ•°ã‚’å®Ÿè¡Œã—ã¦ã¿ã¾ã™ã€‚ æ¬¡ãƒšãƒ¼ã‚¸ã‹ã‚‰ã¯ç°¡å˜ãªä¾‹ã‚’ä½¿ã£ã¦ã€PostgreSQLã¨memcachedã‚’é€£æºã•ã›ã‚‹æ–¹æ³•ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹é–¢æ•° pgmemcacheã¯libmemcacheã®ã»ã¨ã‚“ã©ã®æ©Ÿèƒ½ã‚’åˆ©ç”¨ã§ãã¾ã™ãŒã€ã“ã“ã§ã¯åŸºæœ¬çš„ãªé–¢æ•°ã®èª¬æ˜Žã«ã¨ã©
hiro_y 2009/11/09
PostgreSQLã‹ã‚‰memcachedã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹pgmemcacheè§£èª¬ã€‚

postgresql

memcache
ãƒªãƒ³ã‚¯
Home
Itâ€™s dangerous to go alone, take this! â€“The Legend of Zelda Welcome to Pro Gaming Foundry, your source for information on all things gaming. We cover everything to do with maximizing your performance online, from chairs and VR rigs, all the way through monitors and gaming laptops. Whether you need to customize your seating, improve your monitors, get a faster desktop, or stream your latest adventu
hiro_y 2009/11/09
PostgreSQLã‹ã‚‰memcachedã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹é–¢æ•°ã‚’æä¾›ã€‚

postgresql

memcache
ãƒªãƒ³ã‚¯
http://www.interdb.jp/techinfo/web%20db48/pgpool.html
hiro_y 2009/10/22
pgpool-IIã«ã‚ˆã‚‹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€‚ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒªã‚«ãƒãƒªã®ä»•çµ„ã¿ã€‚

postgresql
ãƒªãƒ³ã‚¯
ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã®åˆ†æž | Let's POSTGRES
NTT ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚»ãƒ³ã‚¿ æ¿åž£ è²´è£• ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒª (æ™‚é–“ã®ã‹ã‹ã‚‹SQL) ã‚’ç™ºè¦‹ã™ã‚‹ã¾ã§ã®æ‰‹é †ã‚’è§£èª¬ã—ã¾ã™ã€‚ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªåˆ†æžã¨æ”¹å–„ã¯ä»¥ä¸‹ã®æµã‚Œã§è¡Œã†ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ã“ã®è¨˜äº‹ã§ã¯ä¸»ã« 1. ã®ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã®ç‰¹å®šæ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚2.ã«ã¤ã„ã¦ã¯ã€Žã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã®æ”¹å–„ã€ã‚’å‚è€ƒã«ã—ã¦ãã ã•ã„ã€‚ ã©ã®SQLãŒé…ã„ã®ã‹ã‚’è¦‹ã¤ã‘ã‚‹ã€‚ ãã®SQLãŒãªãœæ™‚é–“ãŒã‹ã‹ã‚‹ã®ã‹ã‚’åˆ¤æ–ã™ã‚‹ã€‚ è¨å®šãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã€SQLã€ã‚¹ã‚ãƒ¼ãƒžãªã©ã‚’æ”¹å–„ã™ã‚‹ã€‚ ç€ç›®ã—ãŸSQLã®æ€§èƒ½ã‚’å†æ¸¬å®šã—ã€2. ã‹ã‚‰ç¹°ã‚Šè¿”ã™ã€‚ ç€ç›®ã—ãŸSQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãŒå®Œäº†ã—ãŸã‚‰ã€ä»–ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’æŽ¢ã™ãŸã‚ 1. ã‹ã‚‰ç¹°ã‚Šè¿”ã™ã€‚ ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã®è¦‹ã¤ã‘æ–¹ ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã‚’è¦‹ã¤ã‘ã‚‹ã«ã¯ã€å¤§ããåˆ†ã‘ã¦çµ±è¨ˆæƒ…å ±ãƒ“ãƒ¥ãƒ¼ã‚’ä½¿ã†æ–¹æ³•ã¨ã€ã‚µãƒ¼ãƒãƒã‚°ã‚’ä½¿ã†æ–¹æ³•ã®2ã¤ãŒã‚ã‚Šã¾ã™ã€‚çµ±è¨ˆæƒ…å ±ãƒ“ãƒ¥ãƒ¼ã‚’ä½¿ã†æ–¹æ³•ã¯ PostgreSQL 8.4 ä»¥é™ã§ã—ã‹åˆ©ç”¨ã§ãã¾ã›ã‚“ãŒ
hiro_y 2009/09/16
PostgreSQLã§é…ã„ã‚¯ã‚¨ãƒªã‚’è¦‹ã¤ã‘ã‚‹æ–¹æ³•ã€‚

postgresql
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: PostgreSQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•
å…ˆæ—¥æ›¸ã„ãŸã€ŒMySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•ã€ã«ã¤ã„ã¦ã€PostgreSQL ã§ã‚‚ pg_stat_activity ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ã£ã¦å®Ÿè¡Œä¸ã®ã‚¯ã‚¨ãƒªä¸€è¦§ã‚’å–å¾—ã§ãã‚‹ã¨ higepon ã•ã‚“ã«æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸã®ã§ã€ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚ % ppdump > ppdump.txt ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªã‚’ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚° (ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§100ç§’é–“ç¨‹åº¦) ã—ã¦ã€ % ppfilter < ppdump.txt | ppreport ã®ã‚ˆã†ã«ã™ã‚‹ã¨ã€å¹³å‡è² è·ã®é«˜ã„ã‚¯ã‚¨ãƒªã‹ã‚‰é †ã«ã‚½ãƒ¼ãƒˆã•ã‚Œã¦è¡¨ç¤ºã•ã‚Œã¾ã™ã€‚è©³ã—ã„ä½¿ã„æ–¹ã‚„è€ƒãˆæ–¹ã«ã¤ã„ã¦ã¯ã€mprofile ã®ã‚¨ãƒ³ãƒˆãƒªã‚’ã”å‚ç…§ãã ã•ã„ã€‚ pprofile ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯ã€/platform/postgresql/pprofile â€“ CodeRepos::Share â€“ Tracã«ç½®ã„ã¦ã‚ã‚Šã¾ã™ã€‚è² è·ãŒé«˜ã„ PostgreSQL ç’°å¢ƒãŒæ‰‹å…ƒã«ãªã„ã®
hiro_y 2009/07/27
PostgreSQLã®ã‚¯ã‚¨ãƒªã®å‡¦ç†çŠ¶æ³ã‚’å®šæœŸçš„ã«æŽ¡å–â†’è§£æžã€‚

postgresql

db
ãƒªãƒ³ã‚¯
pgFouine - a PostgreSQL log analyzer
About pgFouine pgFouine is a PostgreSQL log analyzer used to generate detailed reports from a PostgreSQL log file. pgFouine can help you to determine which queries you should optimize to speed up your PostgreSQL based application. pgFouine is written in PHP, is object oriented and easily extensible if you need specific reports. pgFouine is free software and is distributed under the GNU General
hiro_y 2009/07/19
PostgrSQLã®ãƒã‚°ã‚’è§£æžã—ã¦ãã‚Œã‚‹ã€‚PHPè£½ã€‚http://www.plusmb.jp/2009/07/17/4163.html

postgresql

php
ãƒªãƒ³ã‚¯
SQLã®likeæ¼”ç®—åã§ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ãŒå¿…è¦ãªæ–‡å— - teraccâ€™s blog
ã¾ã¨ã‚ã‚‹ã¨ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ Oracle % _ ï¼…(å…¨è§’ï¼‰ï¼¿(å…¨è§’) DB2 % _ ï¼…(å…¨è§’ï¼‰ï¼¿(å…¨è§’) MS SQL Server % _ [ MySQL % _ PostgreSQL % _ æ³¨æ„ç‚¹ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã€‚ DB2ã€Oracleã¯ã€ã€Œï¼…ã€ã€Œï¼¿ã€ï¼ˆå…¨è§’ï¼‰ã‚‚ãƒ¯ã‚¤ãƒ«ãƒ‰ã‚«ãƒ¼ãƒ‰ã¨ã—ã¦è§£é‡ˆã™ã‚‹ SQL Serverã¯ã€[a-z]ã®ã‚ˆã†ãªæ£è¦è¡¨ç¾çš„ãªè¨˜è¿°ã‚’è§£é‡ˆã™ã‚‹ å½“ç„¶ã€ãƒ¯ã‚¤ãƒ«ãƒ‰ã‚«ãƒ¼ãƒ‰çš„ãªæ©Ÿèƒ½ã‚’æŒãŸã›ãŸã„ã€Œ%ã€ã‚„ã€Œ_ã€ç‰ã¯ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ãªã„ å…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…±é€šã®è©±ã¨ã—ã¦ã€ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—æ–‡å—è‡ªä½“ã‚‚ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ï¼ˆMySQLã€Postgresã§ã¯ã€Œ\ã€ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—æ–‡å—ï¼‰ likeã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã‚’ã—ãŸå¾Œã«ã€Prepared Statementã§å€¤ã‚’SQLã«ãƒã‚¤ãƒ³ãƒ‰ã™ã‚‹ ï¼ˆé–¢é€£ï¼‰2008-07-10 - T.Teradaã®æ—¥è¨˜
hiro_y 2009/07/04
likeã§ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ãŒå¿…è¦ãªæ–‡å—ã¾ã¨ã‚ã€‚

sql

db

mysql

postgresql

oracle

sqlserver

db2
ãƒªãƒ³ã‚¯
é–‹ç™ºç’°å¢ƒã§è‡ªå‹•ã§SQLã«Explainã‚’ã‹ã‘ã‚‹ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—(1.1) PostgreSQLå¯¾å¿œ - cakephperã®æ—¥è¨˜(CakePHP, Laravel, PHP)
English page is here. ä½•åº¦ã‚‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ã¦ã™ã¿ã¾ã›ã‚“ã€‚MASA-Pã•ã‚“ã®ã‚³ãƒ¡ãƒ³ãƒˆã‚„ã€ã‚ã¤ã•ã‚“ã®ãƒˆãƒ©ãƒƒã‚¯ãƒãƒƒã‚¯ã‹ã‚‰PostgreSQLã§ã¯ä¸€éƒ¨ã®Explainçµæžœã—ã‹å‡ºåŠ›ã•ã‚Œãªã„å•é¡ŒãŒã‚ã‹ã‚Šã¾ã—ãŸã€‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ PostgreSQLã§æ¤œè¨¼ã—ã¦ã¾ã›ã‚“ã§ã—ãŸã€æ‰‹ã‚’æŠœã„ã¦ã™ã¿ã¾ã›ã‚“ã€‚ã€‚ã€‚ ã¨ã„ã†ã‚ã‘ã§ã€PostgreSQLå¯¾å¿œã—ã¾ã—ãŸã€‚ã‚ã¤ã•ã‚“ã®ã‚³ãƒ¼ãƒ‰ã‚’å‚è€ƒã«ã—ã¾ã—ãŸã€‚ ä¸‹è¨˜ã®ã‚ˆã†ãªç”»é¢ã«ãªã‚Šã¾ã™ã€‚ æœ€æ–°ç‰ˆã¯ã“ã“ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ãã ã•ã„ã€‚ PostgreSQLå¯¾å¿œã®å·®åˆ†ã ã‘è§£èª¬ã—ã¾ã™ CakePHP ã®ãŠã„ã—ã„é£Ÿã¹æ–¹ã§è‹±èªžã§ç´¹ä»‹ã—ã¦ã‚‚ã‚‰ãˆã¦ã€http://planetcakephp.org/ã«ã‚‚åæ˜ ã•ã‚ŒãŸã®ã§ã€ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯å…¨éƒ¨è¼‰ã›ã¦ãŠãã¾ã™ <?php /** * ExplainSqlComponent - Auto execute SQL Explai
hiro_y 2009/03/11
MySQL/PostgreSQLã«å¯¾å¿œã—ãŸSQLã®explainçµæžœã‚’ãƒ‡ãƒãƒƒã‚°è¡¨ç¤ºã§ãã‚‹CakePHPã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã€‚

php

cakephp

sql

mysql

postgresql
ãƒªãƒ³ã‚¯
ã¡ã‚‡ã£ã¨ã ã‘ã¾ã˜ã‚ã«æ›¸ã„ã¦ã¿ã‚‹ - elf's blog
ã¡ã‚ƒã‚“ã¨æ›¸ãã¹ãã“ã¨ãŒæ›¸ã‹ã‚Œã¦ã„ã‚‹ã®ã§æ›¸ãã“ã¨ãªã„ãªãƒ¼ã¨æ€ã£ãŸã‚“ã§ã™ãŒï¼Œæ™‚é–“ã‚’ã‚ã‘ã¦æ°—ã¥ã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ï¼Œãã“ã‚‚å«ã‚ã¦ã¤ã‚‰ã¤ã‚‰ï¼Ž ã§ã€ãã“ã¾ã§ã‚ã‹ã£ã¦ã„ã‚‹äººé–“ãŒèª°ã‹ã«ä¼ãˆã‚‹ã¹ãã“ã¨ã¯ã€pg_pconnectä½¿ã†ã¨éšœå®³å¯¾å¿œã§äººé–“ã‚„ã‚ã‚‹ã“ã¨ã«ãªã‚‹ã‚ˆãªã©ã¨ã„ã†æ„å‘³ä¸æ˜Žãªæ¥µè«–ã§ã¯ãªãã¦ã€ä¾‹ãˆã°ã€ŒPHPã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’å‹•ã‹ã™httpdã¨ç”»åƒã‚„CSSã‚’é€ã‚Šå‡ºã™httpdã¯åˆ¥ã«ã—ã‚ˆã†ã€ã¨ã„ã†ã“ã¨ã ã€‚ çŸ¥ã‚‰ãšã«æ€è€ƒåœæ¢ã—ã¦ã„ã‚‹ã ã‘ã§ã‚ã‚Œã°ã¾ã‚ã‚¢ãƒ¬ã ãŒï¼ˆç¬‘ï¼‰ã€çŸ¥ã£ã¦ã¦ãªãŠã‚·ãƒ£ãƒ¬ã‚„å†—è«‡ã®ã¤ã‚‚ã‚Šã§è©±ã—ã¦ã„ã‚‹ãªã‚‰ã°èª¤è§£ã‚’æ‹›ãã™ãŽã§ã‚ã‚‹ã€‚ å†·é™ã«è¦‹ã‚‹ã¨ã“ã®ã‚ˆã†ã«ã—ã‹å–ã‚Œãªã„ãªã‚‰æ®‹å¿µï¼Žã“ã¡ã‚‰ã®åŸ·ç†èƒ½åŠ›ã«æ®‹å¿µã£ã¦æ„Ÿã˜ã‹ï¼Ž ãã‚Šã‚ƒçµè«–ã¨ä½™è«‡ã¨ã„ã†é¢¨ã«åˆ†ã‘ã¾ã—ãŸã‘ã©ã(ç¬‘ ã¡ã‚ƒã‚“ã¨æ›¸ããªã‚‰ã“ã¡ã‚‰ãŒæœ¬å¿ƒã«è¿‘ã„ã§ã™ï¼Ž ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¯ãˆã¦ã—ã¦æœ€åˆã¯å¾¹åº•çš„ã«ã‚„ã‚Šã¥ã‚‰ã„ï¼Žã—ã‹ã—æ°—ã‚’ã¤ã‘ã‚‹ã¹ãã¯ã€ŒéŽè² è·ã«ãªã£ã¦ã‹ã‚‰ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã§å¯¾å‡¦ã€ã¯
hiro_y 2009/03/04
ã‚·ã‚¹ãƒ†ãƒ ã®ä¸ã®PostgreSQLã€‚

postgresql

system
ãƒªãƒ³ã‚¯
ã€ã‚³ãƒ©ãƒ ã€‘Yet Another ä»•äº‹ã®ãƒ„ãƒ¼ãƒ« (24) SQLrelayã¨pgpoolã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¸ã®é©ç”¨ç¯„å›² | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
å‰å›žã€PostgreSQLã¸ã®æŽ¥ç¶šã‚’ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã™ã‚‹ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã‚µãƒ¼ãƒã€ŒSQLrelayã€ã‚’å°Žå…¥ã—ãŸãŒã€ä»Šå›žã¯SQLrelayã‚’ä½¿ã†ãƒ¡ãƒªãƒƒãƒˆã‚’ã‚ˆã‚Šå…·ä½“çš„ã«æ„Ÿã˜ã¦ã‚‚ã‚‰ã†æ„å‘³ã§ã€ã¡ã‚‡ã£ã¨ã—ãŸãƒ—ãƒã‚°ãƒ©ãƒ ã‚’çµ„ã‚“ã§ã¿ã‚ˆã†ã€‚è¨€èªžã¯ä¾‹ã«ã‚ˆã£ã¦PHPã‚’ä½¿ç”¨ã™ã‚‹ãŒã€Webä¸Šã§å‹•ã‹ã™ã®ã¯ã¡ã‚‡ã£ã¨é¢å€’ãªã®ã§ã€ä»Šå›žã¯ã€ŒCLI (Command Line Interface)ã€ã®æ©Ÿèƒ½ã‚’ä½¿ã„ã€ã‚·ã‚§ãƒ«ã‹ã‚‰å®Ÿè¡Œã§ãã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ãã“ã¨ã«ã—ã‚ˆã†ã€‚ ã¾ãšã€figure1ã¯ç´”ç²‹ã«PHPã®PostgreSQLé–¢æ•°ç¾¤ã‚’åˆ©ç”¨ã—ã¦æ›¸ã„ãŸã‚¹ã‚¯ãƒªãƒ—ãƒˆã ã€‚ figure1 : test1.php #!/usr/local/bin/php <?php $connÂ =Â pg_connect("dbname=testdbÂ user=user1"); $sqlÂ =Â "selectÂ *Â fromÂ tab1;"; $rsltÂ =Â pg_q
hiro_y 2009/02/26
SQL Relayã¨pgpoolä½¿ã„æ¯”ã¹ã€‚

sqlrelay

postgresql

php
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
hiro_y 2009/02/26
PostgreSQLã€é«˜é€ŸåŒ–ã€‚

postgresql
ãƒªãƒ³ã‚¯
http://neta.ywcafe.net/000960.html
hiro_y 2009/02/24
PostgreSQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¾ã¨ã‚ã€‚

postgresql
ãƒªãƒ³ã‚¯
DBMSã§ãƒ†ãƒ¼ãƒ–ãƒ«åã¨ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã‚’ã‚¯ã‚©ãƒ¼ãƒˆã—ãŸéš›ã®æŒ™å‹•ã‚’çŸ¥ã‚‹ - Sooey
database Originally uploaded by Tim Morgan PEAR::MDB2ã®ãƒªãƒ¼ãƒ‰ãƒ¡ãƒ³ãƒ†ãƒŠã§ã‚ã‚‹Lorenzo Albertonæ°ã«ã‚ˆã‚‹ã€DBMS identifiers and case sensitivityãŒèˆˆå‘³æ·±ã„ã€‚DBMSã§ã€Œãƒ†ãƒ¼ãƒ–ãƒ«åã‚„ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã‚’ãƒ€ãƒ–ãƒ«ã‚¯ã‚©ãƒ¼ãƒˆã§å›²ã‚“ã ã€å ´åˆã«å¤§æ–‡å—å°æ–‡å—ãŒã©ã®ã‚ˆã†ã«æ‰±ã‚ã‚Œã‚‹ã®ã‹ã¨ã„ã†ã“ã¨ã‚’ã¡ã‚ƒã‚“ã¨æ„è˜ã—ãªã„ã¨ãƒ€ãƒ¡ã§ã™ã‚ˆã€ã¨ã„ã†å†…å®¹ã€‚ SQL:2008ã¨SQL-99ã§ã¯ã€Œã‚¯ã‚©ãƒ¼ãƒˆã—ãªã„é™ã‚Šã‚±ãƒ¼ã‚¹ã‚»ãƒ³ã‚·ãƒ†ã‚£ãƒ–ã«ã¯ãªã‚‰ãªã„ã€ï¼ˆå¤§æ–‡å—å°æ–‡å—ã‚’åŒºåˆ¥ã—ãªã„ï¼‰ã¨ã—ã¦ãŠã‚Šã€DB2ã€Oracleã€Interbaseï¼ˆFirebirdï¼‰ã¯ã“ã‚Œã«åˆè‡´ã—ã¦ã„ã‚‹ã€‚PostgreSQLã®æŒ™å‹•ã‚‚åŒæ§˜ã ãŒã€å‰è€…ãŒã€Œéžã‚¯ã‚©ãƒ¼ãƒˆæ™‚ã«å¤§æ–‡å—ã€ã¨ãªã‚‹ã®ã«å¯¾ã—ã¦ã€ã“ã¡ã‚‰ã¯ã€Œéžã‚¯ã‚©ãƒ¼ãƒˆæ™‚ã«å°æ–‡å—ã€ã«ãªã‚‹ç‚¹ãŒç•°ãªã‚‹ã€‚ MySQLã¯ãƒ†ãƒ¼ãƒ–ãƒ«ãŒãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†
hiro_y 2008/12/24
ãƒ†ãƒ¼ãƒ–ãƒ«å/ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã‚’ã‚¯ã‚©ãƒ¼ãƒˆã—ãŸå ´åˆã®å¤§æ–‡å—å°æ–‡å—ã®åŒºåˆ¥ã®é•ã„ã€‚

db

postgresql

mysql

db2

oracle
ãƒªãƒ³ã‚¯
ã“ã“ã‚®ã‚³ï¼: GoogleMapsã¨é€£å‹•ã—ãŸã„ãªã‚‰å¹¾ä½•ãƒ‡ãƒ¼ã‚¿åž‹ã‚ˆã‚ŠPostGIS
ãªã‚“ã‹å‘ã“ã†ã®ã‚³ãƒ¡ãƒ³ãƒˆã«æ›¸ãè¾¼ã‚“ã ã®ã ãŒã€ã‚ˆãåˆ¤ã‚‰ã‚“ãŒå‰Šé™¤ã•ã‚Œã¦ã—ã¾ã£ãŸã®ã§ã“ã£ã¡ã®ã‚¨ãƒ³ãƒˆãƒªã§å–ã‚Šä¸Šã’ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã®ä½ç½®æƒ…å ±ã‚’åŠ¹çŽ‡çš„ã«æ¤œç´¢ã™ã‚‹æ–¹æ³•(PostgreSQLç·¨) -Webå±‹ã®ãƒã‚¿å¸³- ãŸã¨ãˆã°ãŠã„ã—ã„ã‚±ãƒ¼ã‚å±‹ã•ã‚“ã®ä½ç½®æƒ…å ±ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã«ã‚ã‚‹ã¨ã—ã‚ˆã†ã€‚...Google Mapsãªã©ã§ã‚ã‚‹ç¯„å›²ã®åœ°å›³ã‚’è¡¨ç¤ºã—ãŸã¨ã—ã¦ã€ãŠåº—ã®ä½ç½®ã‚’åœ°å›³ä¸Šã«ãƒžãƒ¼ã‚ãƒ³ã‚°ã•ã›ãŸã„å ´åˆã«ã¯ã€ãã®åœ°å›³ã®ç¯„å›²ã®æƒ…å ±ã‚’ã‚ãƒ¼ã«ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã®ç·¯åº¦çµŒåº¦ã‚’æ¤œç´¢ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ......... ã ãŒã€ã²ã¨ãŸã³ ã‚ã‚‹1ç‚¹ã‹ã‚‰åŠå¾„rã®å††å†…ã«è©²å½“ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’æ¤œç´¢ã—ãŸã„ ã•ã‚‰ã«ãã®æ¤œç´¢çµæžœã‚’ã€ä¸å¿ƒç‚¹ã‹ã‚‰ã®è·é›¢ã§ã‚½ãƒ¼ãƒˆã—ãŸã„ ã¨ã„ã£ãŸã“ã¨ã«ãªã‚‹ã¨ã€ã¨ãŸã‚“ã«é›£ã—ããªã‚‹ã€‚ã—ã‹ã—ã€PostgreSQLã«ã‚‚ã†5å¹´ä»¥ä¸Šå‰ã‹ã‚‰å®Ÿè£…ã•ã‚Œã¦ã„ã‚‹å¹¾ä½•ãƒ‡ãƒ¼ã‚¿åž‹ã€å¹¾ä½•é–¢æ•°ã€å¹¾ä½•æ¼”ç®—åã‚’ä½¿ãˆã°ã€SELECTä¸€ç™ºã§ã§ãã‚‹ã“ã¨ã ã€‚ å¹¾ä½•
hiro_y 2008/11/10
PostGISã‚’ä½¿ã†ã€‚

postgresql

map
ãƒªãƒ³ã‚¯
http://neta.ywcafe.net/000597.html
hiro_y 2008/11/10
PostgreSQLã®å¹¾ä½•ãƒ‡ãƒ¼ã‚¿åž‹ã‚’ä½¿ã†ã€‚

postgresql

map
ãƒªãƒ³ã‚¯
SkypeGarage/DbProjects/PgBouncer - Skype Developer Zone
PgBouncer Lightweight connection pooler for PostgreSQL. Downloads, bugtracker, CVS: http://pgfoundry.org/projects/pgbouncer Features Several levels of brutality when rotating connections: Session poolingMost polite method. When client connects, a server connection will be assigned to it for the whole duration it stays connected. When client disconnects, the server connection will be put back into
hiro_y 2008/09/16
PostgreSQLã§ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã€‚

postgresql
ãƒªãƒ³ã‚¯
pgpoolã‚’ä½¿ã£ãŸPostgreSQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
ã“ã‚“ã°ã‚“ã¯ã€ç‰§é‡Žã§ã™ã€‚ å‰å›žã€ãã®å‰ã®å‰ã¨PostgreSQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ã§ã—ãŸãŒä»Šæ—¥ã‚‚PostgreSQLé–¢é€£ã§ã€PostgreSQLã§ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã§ã™ã€‚ MySQLã®å ´åˆã€åˆ¥ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’ä½¿ã‚ãªãã¦ã‚‚MySQLã ã‘ã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Ÿç¾ã§ãã¾ã™ãŒã€PostgreSQLã®å ´åˆã¯åˆ¥é€”å°‚ç”¨ã®ã‚½ãƒ•ãƒˆãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ ä»Šå›žã¯ãã‚“ãªã‚½ãƒ•ãƒˆã®1ã¤ã€pgpool-II(ä»¥ä¸‹pgpoolã¨æ›¸ã„ã¦ã„ã¾ã™ï¼‰ã‚’ä½¿ã£ãŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ pgpoolã‚’ä½¿ã†ã¨ã€PostgreSQLã§æ‰‹è»½ã«ãƒžãƒ«ãƒãƒžã‚¹ã‚¿æ–¹å¼ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Ÿç¾ã§ãã¾ã™ã€‚ ä»–ã«ã‚‚ã€ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã€ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚¹ã‚¿ãƒ³ãƒã‚¤ã€slony-Iç‰ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚½ãƒ•ãƒˆã¨çµ„ã¿åˆã‚ã›ãŸãƒžã‚¹ã‚¿ãƒ»ã‚¹ãƒ¬ãƒ¼ãƒ–æ–¹å¼ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€æ™‚é–“ãŒã‹ã‹ã‚‹æ¤œç´¢å‡¦ç†ã‚’è¤‡æ•°ã‚µãƒ¼ãƒã§ä¸¦åˆ—å‡¦ç†ã•ã›ã‚‹ï¼ˆãƒ‘ãƒ©ãƒ¬ãƒ«ãƒ¢ãƒ¼ãƒ‰ï¼‰ã¨ã„ã†ã‚ˆã†ãªã“ã¨ãŒã§ã
hiro_y 2008/08/25
pgpoolã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€‚

postgresql
ãƒªãƒ³ã‚¯
1 2 3 4 5 æ¬¡ã®ãƒšãƒ¼ã‚¸