[B! PostgreSQL] s_z_kiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

s_z_ki id:s_z_ki

PostgreSQLã«é–¢ã™ã‚‹s_z_kiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

${{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ã§ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’ä½œæˆã™ã‚‹ | Let's POSTGRES
ç¬ åŽŸ è¾°ä» æœ¬è¨˜äº‹ã¯2013å¹´ã®PostgreSQL Advent Calendar ã® 12/25 ã®è¨˜äº‹ã§ã™(åœ°å‘³ãªãƒˆãƒ”ãƒƒã‚¯ã«ãªã£ã¦ã—ã¾ã„ã™ã„ã¾ã›ã‚“)ã€‚PostgreSQLã§ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ä½œæˆã«å½¹ç«‹ã¤æ©Ÿèƒ½ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã¯ã˜ã‚ã« PostgreSQLã‚’å¯¾è±¡ã¨ã—ãŸã®æ€§èƒ½æ¤œè¨¼ã‚„æ©Ÿèƒ½æ¤œè¨¼ã‚’è¡Œã†éš›ã«ã€é–‹ç™ºç’°å¢ƒã‚„è©¦é¨“ç’°å¢ƒã§ã‚¹ã‚ãƒ¼ãƒž(ãƒ†ãƒ¼ãƒ–ãƒ«ã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹)ã‚’ä½œæˆã—ã€ãƒ€ãƒŸãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ã‚’æŠ•å…¥ã—ã¦SQLã®ãƒã‚§ãƒƒã‚¯ã‚’è¡Œã†ã“ã¨ãŒå¤šã€…ã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚å˜ç´”ãªæ©Ÿèƒ½ã®æ£å¸¸è©¦é¨“ã§ã‚ã‚Œã°å°‘é‡ã®ãƒ‡ãƒ¼ã‚¿æŠ•å…¥ã§äº‹è¶³ã‚Šã‚‹ã¨æ€ã„ã¾ã™ãŒã€å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã™ã‚‹æ¤œç´¢å‡¦ç†ã‚„ãƒãƒƒãƒå‡¦ç†ã‚’è©¦ã™éš›ã¯ã€ãã‚Œãªã‚Šã®é‡ã®è©¦é¨“ãƒ‡ãƒ¼ã‚¿ã‚’ç”Ÿæˆã—ã€DBã«æŠ•å…¥ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ é€šå¸¸ã€è©¦é¨“ãƒ‡ãƒ¼ã‚¿ã¯ã€ä¾‹ãˆã°å°‚ç”¨ã®ã‚¸ã‚§ãƒãƒ¬ãƒ¼ã‚¿ã‚’ä½œã‚‹ã€å®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒžã‚¹ã‚ãƒ³ã‚°ã—ãŸã‚‚ã®ã‚’ä½¿ã†ã€ã‚µãƒ³ãƒ—ãƒ«ã¨ã—ã¦å˜åœ¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿(éƒµä¾¿ç•ªå·ã®ãƒ‡ãƒ¼ã‚¿ãªã©)ã‚’åˆ©ç”¨ã™ã‚‹ã€ã¨ã„ã£ãŸã“ã¨ãŒå¤šã„ã¨æ€
s_z_ki 2013/12/25
PostgreSQL
ãƒªãƒ³ã‚¯
Designing with Class: Sinatra + PostgreSQL + Heroku
Know a little Ruby? Ready to start web development? Before jumping to Rails, get your hands dirty with Sinatra. Itâ€™s the perfect learning tool. My recommendation: Start with a basic dynamic website, backed with SQLite. Create and manage your database tables with raw SQL. Practice deploying on Heroku. Practice. Once you feel good, add another step. Perhaps switch to DataMapper or ActiveRecord for m
s_z_ki 2013/12/06
Sinatra

PostgreSQL

Heroku
ãƒªãƒ³ã‚¯
Apache JMeterã§PostgreSQLã®è² è·è©¦é¨“ã‚’ã™ã‚‹
ã“ã®ã‚¨ãƒ³ãƒˆãƒªã¯ã€PostgreSQL Advent Calendar 2013ã®Day3ã®è¨˜äº‹ã§ã™ã€‚ ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è² è·è©¦é¨“ã€ã‚’è€ƒãˆã‚‹æ™‚ã€çš†ã•ã‚“ã¯ã©ã®ã‚ˆã†ãªæ–¹æ³•ã§å®Ÿæ–½ã™ã‚‹ã“ã¨ã‚’æ¤œè¨Žã™ã‚‹ã§ã—ã‚‡ã†ã‹ã€‚è‡ªå‰ã®ãƒ†ã‚¹ãƒˆã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ã—ã‚‡ã†ã‹ã€‚ã‚ã‚‹ã„ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å˜ä½“ã®è² è·è©¦é¨“ã¯è¡Œã‚ãšã€Webã‚·ã‚¹ãƒ†ãƒ å…¨ä½“ã®è² è·è©¦é¨“ã¨ã—ã¦å®Ÿæ–½ã™ã‚‹ã§ã—ã‚‡ã†ã‹ã€‚ PostgreSQLã«ã¯ã€pgbenchã¨ã„ã†ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ„ãƒ¼ãƒ«ãŒä»˜å±žã—ã¦ãŠã‚Šã€ã“ã®ãƒ„ãƒ¼ãƒ«ã®ã‚·ãƒŠãƒªã‚ªã‚’ä½œæˆã™ã‚‹ã“ã¨ã§å¤šå°‘ã¯ç‹¬è‡ªã®ã‚·ãƒŠãƒªã‚ªã§ã®è©¦é¨“ã‚’è¡Œã†ã“ã¨ã‚‚å¯èƒ½ã§ã™ãŒã€çŠ¶æ³ã«ã‚ˆã£ã¦ã¯ãã‚Œã ã‘ã§ã¯è‡ªç”±åº¦ãŒä¸è¶³ã™ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ä»Šå›žã¯ã€Webã‚·ã‚¹ãƒ†ãƒ ã®è² è·ãƒ†ã‚¹ãƒˆã§ã‚ˆãä½¿ã‚ã‚Œã‚‹JMeterã‚’ä½¿ã£ã¦ã€è‡ªç”±ãªã‚·ãƒŠãƒªã‚ªã§PostgreSQLå˜ä½“ã®è² è·è©¦é¨“ã‚’è¡Œã†æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ï¼ˆãªãŠã€JMeterã¯éžå¸¸ã«å¤šæ©Ÿèƒ½ãªè² è·ç”Ÿæˆãƒ„ãƒ¼ãƒ«ã§ã™ã®ã§ã€ä»Šå›žã¯JMeterã®ç¶²ç¾…çš„ãªèª¬æ˜Ž
s_z_ki 2013/12/04
PostgreSQL

jMeter
ãƒªãƒ³ã‚¯
RDS for PostgreSQLã®ä¸ã‚’è¦—ã„ã¦ã¿ãŸï¼ˆè¿½è¨˜ã‚ã‚Šï¼‰
çš†ã•ã‚“ãŠå¾…ã¡ã‹ãã®ã€RDS for PostgreSQLãŒæ˜¨æ—¥ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ Amazon Web Services ãƒ–ãƒã‚°: ã€AWSç™ºè¡¨ã€‘Amazon RDS for PostgreSQLãŒã”åˆ©ç”¨å¯èƒ½ã«ãªã‚Šã¾ã—ãŸï¼ http://aws.typepad.com/aws_japan/2013/11/amazon-rds-for-postgresql-now-available.html æ—¢ã«ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ç«‹ã¡ä¸Šã’ã¦ã¿ãŸæ–¹ã‚‚ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ Amazon RDS for PostgreSQLãŒã‚„ã£ã¦ããŸï¼ï¼ ï½œ Developers.IO http://dev.classmethod.jp/cloud/amazon-rds-for-postgresql-now-on-sale/ cloudpackãƒ–ãƒã‚°: Amazon RDS ã§ PostgreSQL ãŒåˆ©ç”¨å¯èƒ½ã« http://bl
s_z_ki 2013/11/21
PostgreSQL
ãƒªãƒ³ã‚¯
Blogger
Google ã®ã‚¦ã‚§ãƒ–ãƒã‚°å…¬é–‹ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ã€ãƒ†ã‚ã‚¹ãƒˆã€å†™çœŸã€å‹•ç”»ã‚’å…±æœ‰ã§ãã¾ã™ã€‚
s_z_ki 2012/12/16
PostgreSQL
ãƒªãƒ³ã‚¯
PostgreSQLã®ãƒ¡ãƒ¢ãƒªç®¡ç† | Everyday Deadlock
ã“ã®è¨˜äº‹ã¯ PostgreSQL Advent Calendar 2012 ã®13æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ æ˜”ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³é–¢ä¿‚ã®ç ”ç©¶ã‚’ã—ã¦ã„ã‚‹ã†ã¡ã®ç ”ç©¶å®¤ ã§ã¯ã€ã€ŒPostgreSQLã‚’ä½¿ã†ã€ã¨ã„ã†ã¨PostgreSQLã®ã‚³ãƒ¼ãƒ‰ã‚’ã„ã˜ã£ã¦TPCãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’èµ°ã‚‰ã›ã‚‹ã“ã¨ã‚’æŒ‡ã™ã®ã§ã€æœªã ã«SQLã¨ã‹æ›¸ã‘ãªãã¦å›°ã‚‹ã“ã¨ãŒå¤šã„ã®ã§ã™ãŒã€å¹¸ã‹ä¸å¹¸ã‹PostgreSQLã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯ãã“ãã“èªã‚ã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ãã‚“ãªã‚ã‘ã§ã€PostgreSQLã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã®ä¸ã§ã‚‚ã€ä»Šå›žã®Advent Calendarã®ãƒã‚¿ã¨ã—ã¦ãƒ¡ãƒ¢ãƒªç®¡ç†ã®éƒ¨åˆ†ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ã“ã‚Œã‹ã‚‰PostgreSQLã®ã‚³ãƒ¼ãƒ‰ã‚’èªã‚“ã§ã¿ãŸã„ã¨ã„ã†äººã«ã¨ã£ã¦ã¯ã€ã‚³ãƒ¼ãƒ‰ã®ã©ã®éƒ¨åˆ†ã‚’èªã‚“ã§ã‚‚å¿…è¦ã¨ãªã‚‹çŸ¥è˜ãªã®ã§ã€å‰²ã¨å½¹ã«ç«‹ã¤ã¨ãŠã‚‚ã„ã¾ã™ã€‚ ã€å®£ä¼ã€‘å¤§æ™¦æ—¥ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åŒäººèªŒã‚’ã‚³ãƒŸã‚±ã§å£²ã‚Šã¾ã™ æœ¬é¡Œã«å…¥ã‚‹å‰ã«ã„ããªã‚Šå®£ä¼ã§æç¸®ã§ã™ãŒ
s_z_ki 2012/12/14
PostgreSQL
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
s_z_ki 2012/09/25
PostgreSQL
ãƒªãƒ³ã‚¯
PostgreSQLã«èˆˆå‘³ãŒã‚ã‚‹äººå‘ã‘ã«ã¾ã¨ã‚ã¦ã¿ãŸã€‚ï½œPostgreSQLï½œãŠä»•äº‹ãƒ¡ãƒ¢ï½œPictnotes
PostgreSQL9.2ãŒã§ãŸã®ã¨ã€ä¸€éƒ¨ã§ï¼Ÿã¾ãŸPostgreSQLã‚’ä½¿ã„ãŸã„ã¨æ€ã£ã¦ã‚‹äººãŒå¤šããªã£ãŸã¨ã‹ã‚ã‚‹ã¿ãŸã„ãªã®ã§ 4ã€œ5å¹´è§¦ã£ã¦ãªã‹ã£ãŸã‹ã€å…¨ç„¶çŸ¥ã‚‰ãªã„äººå‘ã‘ã¨ãŠã•ã‚‰ã„ã¨ã—ã¦ã¾ã¨ã‚ã¦ã¿ãŸã€‚ ã–ã£ãã‚Šæ›¸ã„ã¦ã‚‹ã®ã§ã€è©³ã—ã„äººã‹ã‚‰ã¿ã‚‹ã¨ãŠã‹ã—ã„ç‚¹ã‚‚ã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ãŒã€æ°—ã«ãªã£ãŸç‚¹ã¯ã‚ˆã‚Šè©³ã—ã„è¨˜äº‹ãŒ ã‚ã‚‹ã¨æ€ã†ã®ã§ã€èª¿ã¹ã¦ã¿ã¦ãã ã•ã„ã€‚ æ˜Žã‚‰ã‹ãªé–“é•ãˆç‰ã€…ã¯ã€ä¿®æ£åŠ ç†ã—ãŸã„ã®ã§ã€ã‚³ãƒ¡ãƒ³ãƒˆã‹ twitterã® @itm_kiyoã¾ã§ã€å¾¡é¡˜ã„ã—ã¾ã™ã€‚ Q. ãªã‚“ã¦èªã‚€ã®ï¼Ÿæ›¸ãã®ï¼Ÿ A. PostgreSQL(ã½ã™ã¨ãã‚Œã™ãã‚…ãƒ¼ãˆã‚‹)ã€Pã¨SQLã¯å¤§æ–‡å—ã€‚ã¡ãªã¿ã«MySQL(yä»¥å¤–ã¯å¤§æ–‡å—)ãªã‚“ã§ã€å°æ–‡å—ã¨å¤§æ–‡å—ã®åŒºåˆ¥ã‚’ãã¡ã‚“ã¨ã™ã‚‹ã¨ãã®ç•Œéšˆã®äººãŒã‚ˆã‚ã“ã³ã¾ã™ã€‚ ã§ã‚‚ã€ã€Œpostgresã€ ã¨ã‹ ã€ã€ŒPostgresã€ã‚„ã€Œãƒã‚¹ã‚°ãƒ¬ã€ã¨ã‹æ›¸ã‹ã‚Œã¦ã‚‹ã“ã¨ã‚‚å¤šã„ã§ã™ã€‚ Q. ã©ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ä½¿ã†ã®
s_z_ki 2012/09/14
PostgreSQL
ãƒªãƒ³ã‚¯
1