[B! database] at_homeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

at_home id:at_home

databaseã«é–¢ã™ã‚‹at_homeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (15)

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

Javaã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ„ãƒ¼ãƒ«ã€ŒFlywayã€ #JJUG : ryu22eBlogè·¡åœ°
2012å¹´12æœˆ07æ—¥ Javaã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ„ãƒ¼ãƒ«ã€ŒFlywayã€ #JJUG Java Advent Calendar 2012Â 7æ—¥ç›®ã§ã™ã€‚ æ˜¨æ—¥ã¯@megascusã•ã‚“ã®ã€ŒJava Bug Database å‚ç…§ã—ã¦ã„ã¾ã™ã‹ï¼Ÿã€ã§ã—ãŸã€‚ å…ˆæ—¥ã€å¼Šç¤¾ã‚µãƒ¼ãƒ“ã‚¹ã«Javaã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ„ãƒ¼ãƒ«ã€ŒFlywayã€ã‚’å°Žå…¥ã—ã¦ã¿ãŸã¨ã“ã‚ã€ãªã‹ãªã‹ä¾¿åˆ©ã ã£ãŸã®ã§ç´¹ä»‹ã—ã¾ã™ã€‚ äº‹å‰æº–å‚™ ã¾ãšã€ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã®å¯¾è±¡ã«ãªã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨æ„ã—ã¾ã™ã€‚ ã“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã¯ã€MySQL 5.5.28ã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ CREATE DATABASE flywayexample DEFAULT CHARACTER SET UTF8; Flywayã‚’ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«çµ„ã¿è¾¼ã‚€ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã‚ˆã‚‹ã¨Flywayã‚’åˆ©ç”¨ã™ã‚‹ã«ã¯ä»¥ä¸‹ã®3ã¤ã®æ‰‹æ®µãŒã‚ã‚‹ã‚ˆã†ã§ã™ã€‚ Maven Plugin Com
at_home 2014/01/24
java

DB

tool

database

flyway

migration
ãƒªãƒ³ã‚¯
Cucumber - Database cleaner is not working when default driver(selenium) is enabled
at_home 2013/08/07
Rails

cucumber

database

selenium

tips

è§£æ±º
ãƒªãƒ³ã‚¯
MySQLã®è¤‡åˆINDEX - æ†‚é¬±ãªãƒ—ãƒã‚°ãƒ©ãƒžã®å½¢è€Œä¸Šå¦
MySQL MySQLã®è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã€‚MySQLã‚’ä½¿ã„ã“ãªã—ã¦ã„ã‚‹äººã«ã¯å¸¸è˜ã®ç¯„ç–‡ã«ã¯ã„ã‚‹çŸ¥è˜ã ã¨æ€ã†ã®ã§ã™ãŒã€ã‹ã¤ã¦ã®ç§ã®ã‚ˆã†ã«ã€çŸ¥ã‚‰ãªã„ã¨ãƒ‰ãƒ„ãƒœã«ã¯ã¾ã‚‹ã®ã§ã€ã“ã“ã«ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ã‚¿ã‚¤ãƒˆãƒ«ã§ã©ã†ã„ã†å†…å®¹ã‹ã€ã‚‚ã—ã‹ã—ãŸã‚‰å¤§ä½“ã€æƒ³åƒãŒã¤ãã‹ãªã¨æ€ã†ã®ã§ã™ãŒã€MySQLã¯1ã¤ã®ã‚¯ã‚¨ãƒªãƒ¼ã§1ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã€1ã¤ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã—ã‹æ©Ÿèƒ½ã—ãªã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ã‚ˆã†ã™ã‚‹ã«ã€ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã€æ™®é€šã«å¤§é‡ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å¼µã£ã¦ã‚‚ã‚ã¾ã‚Šæ„å‘³ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ãã“ã§ã€ä»Šå›žã¯ã€æœ€é©ãªè¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã©ã®ã‚ˆã†ã«ã—ã¦ã¯ã‚‹ã“ã¨ãŒã§ãã‚‹ã‹è€ƒãˆã¦ã„ã“ã†ã˜ã‚ƒãªã„ã‹ã€ã¨ã„ã†è¶£æ—¨ã§æ›¸ã„ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ã¾ãšã¯åˆ†æžã€‚ãƒ†ã‚¹ãƒˆç’°å¢ƒã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã¦ã„ãªã„SQLã‚’é›†ã‚ã‚‹ã¾ãšã¯ã€/etc/my.cnfã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’ä»¥ä¸‹ã®ã‚ˆã†ã«è¨å®šã—ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã¦ã„ãªã„SQLã‚’ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒ¼ã«åãå‡ºã—ã¾ã™ã€‚ slow
at_home 2013/05/21
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹

SQL

tips

mysql

db

database

performance

tuning

index
ãƒªãƒ³ã‚¯
Best database field type for a URL
I need to store a url in a MySQL table. What's the best practice for defining a field that will hold a URL with an undetermined length?
at_home 2013/01/24
URLã‚’DBã«æ ¼ç´ã™ã‚‹éš›ã®é©åˆ‡ãªåž‹ã¯ï¼Ÿãªã‹ãªã‹é¢ç™½ã„è©±ã

url

database

tips
ãƒªãƒ³ã‚¯
DSASé–‹ç™ºè€…ã®éƒ¨å±‹:5åˆ†ã§ã§ãã‚‹ã€MySQLã®ãƒ¡ãƒ¢ãƒªé–¢ä¿‚ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼
MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã„ã¦éžå¸¸ã«é‡è¦ã¨ãªã‚‹ãƒ¡ãƒ¢ãƒª(ãƒãƒƒãƒ•ã‚¡)é–¢é€£ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã€ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆ DSASã®ã¨ã‚ã‚‹DBã‚µãƒ¼ãƒ(å®Ÿãƒ¡ãƒ¢ãƒª4GB)ã®å®Ÿéš›ã®è¨å®šå€¤ ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã¾ãŸã€å¿…è¦ãƒ¡ãƒ¢ãƒªã®ç·é‡ã®è¨ˆç®—ã‚„é™ç•Œå€¤ã‚’è¶Šãˆã¦ãªã„ã‹ãƒã‚§ãƒƒã‚¯ã—ã¦ãã‚Œã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚‚ç´¹ä»‹ã—ã¾ã™ã€‚ æ˜¯éžã€å‚è€ƒã«ã—ã¦ã¿ã¦ãã ã•ã„ï¼ ã¾ãšæœ€åˆã«æ³¨æ„ç‚¹ã‚’ã€‚ ãƒãƒƒãƒ•ã‚¡ã«ã¯2ã¤ã®ã‚¿ã‚¤ãƒ—ãŒã‚ã‚Šã¾ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã¯mysqldå…¨ä½“ã§ãã®ãƒãƒƒãƒ•ã‚¡ãŒ1ã¤ã ã‘ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã€ ã“ã‚Œã«å¯¾ã—ã€ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã¯ã‚¹ãƒ¬ãƒƒãƒ‰(ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³)ã”ã¨ã«ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®éš›ã«ã¯ã‚°ãƒãƒ¼ãƒãƒ«/ã‚¹ãƒ¬ãƒƒãƒ‰ã®é•ã„ã‚’æ„è˜ã™ã‚‹ã‚ˆã†ã«ã—ã¾ã—ã‚‡ã†ã€‚ ãªãœãªã‚‰ã€ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã«å¤šãã®ãƒ¡ãƒ¢ãƒªã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã€ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒå¢—ãˆãŸã¨ãŸã‚“ã«ã‚¢ãƒƒã¨ã„ã†é–“ã«ãƒ¡ãƒ¢ãƒªä¸è¶³ã«ãªã£ã¦ã—ã¾ã†ã‹ã‚‰ã§ã™ã€‚ in
at_home 2012/12/26
ã“ã‚Œã¯è‰¯ãã¾ã¨ã¾ã£ã¦ã‚‹

InnoDB

ãƒ¡ãƒ¢ãƒª

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

tips

mysql

db

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

performance

database

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
Open Tech Press | MySQLãƒ‡ãƒ¼ã‚¿ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ–¹æ³•
2007å¹´5æœˆ31æ—¥10:53 Tom-Adelsteinã€Bill-Lubanovicï¼ˆ2007å¹´5æœˆ29æ—¥ï¼ˆç«ï¼‰ï¼‰ ãƒ•ã‚¡ã‚¤ãƒ«ã‚„ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯æ¯”è¼ƒçš„ç°¡å˜ã ãŒã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãªã‚‹ã¨ã€ã„ãã¤ã‹ç‰¹åˆ¥ãªå·¥å¤«ã‚’æ–½ã™å¿…è¦ãŒã‚ã‚‹ã€‚ã“ã“ã§ã¯MySQLã‚’å–ã‚Šä¸Šã’ã¦ã„ã‚‹ãŒã€åŒã˜åŽŸç†ã¯PostgreSQLã‚„ãã®ä»–ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚‚ã‚ã¦ã¯ã¾ã‚‹ã€‚ æœ¬ç¨¿ã¯ã€æœ€è¿‘Oâ€™Reillyã‹ã‚‰å‡ºç‰ˆã•ã‚ŒãŸæ›¸ç±ã€Ž Linux System Administration ã€ã®æŠœç²‹ã€‚ MySQLã‚µãƒ¼ãƒã‚’ä¼‘ã¿ãªãç¨¼åƒã•ã›ç¶šã‘ã‚‹å¿…è¦ãŒãªã„ãªã‚‰ã€ä»¥ä¸‹ã«ç¤ºã™ã‚ˆã†ãªåœ§ç¸®ãªã—ã®ã‚ªãƒ•ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ‰‹æ³•ãŒæ‰‹ã£ã¨ã‚Šæ—©ã„ã€‚ MySQLã‚µãƒ¼ãƒã‚’åœæ¢ã•ã›ã‚‹ã€‚ # /etc/init.d/mysqld stop MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ãŠã‚ˆã³ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ã‚³ãƒ”ãƒ¼ã™ã‚‹ã€‚ä¾‹ãˆã°ã€MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒª/var
at_home 2012/07/03
mysql

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

tips

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

database

backup

ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†
ãƒªãƒ³ã‚¯
http://svn.apache.org/repos/asf/shindig/branches/1.0.x/php/external/PHPUnit/Samples/BankAccountDB/BankAccountDBTest.php
at_home 2012/05/31
PHPUnitã§ç”Ÿæˆã—ãŸPDOã¯å¼•ãå›žã™

php

phpunit

database

tips
ãƒªãƒ³ã‚¯
å‹æ‰‹ã«å›³è§£ã™ã‚‹memcached
å…ˆæ—¥ã€Brian Akerã¨ãƒŸã‚¯ã‚·ã‚£ã®å‰å‚æ°ã«ã‚ˆã‚‹memcachedã®ã‚»ãƒŸãƒŠãƒ¼ãŒã‚ã£ãŸã€‚ å®Ÿè·µã§ä½¿ç”¨ã™ã‚‹ä¸Šã§ã®è©±ã‚„é–‹ç™ºæœ€å‰ç·šã®è©±ãŒè´ã‘ãŸãŸã‚ã€ã‚»ãƒŸãƒŠãƒ¼ã¯éžå¸¸ã«ç››æ³ã§ã‚ã£ãŸã€‚ç†è€…ã«ã¨ã£ã¦ã‚‚éžå¸¸ã«å‹‰å¼·ã«ãªã‚‹å†…å®¹ã ã£ãŸã€‚ã‚»ãƒŸãƒŠãƒ¼ã®è³‡æ–™ã¯Brian Akeræ°ã®ã‚µã‚¤ãƒˆã‹ã‚‰å…¥æ‰‹ã§ãã‚‹ã®ã§ã‚»ãƒŸãƒŠãƒ¼ã«å‚åŠ å‡ºæ¥ãªã‹ã£ãŸã²ã¨ã¯ã“ã®è³‡æ–™ã‚’èªã‚“ã§è‡ªç¿’ã—ã¦é ‚ããŸã„ã€‚ ãŒã€ã„ã‹ã‚“ã›ã‚“æ°ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã¯ãƒ‘ãƒƒã¨è¦‹ãŸã ã‘ã§ã¯ãªã‚“ã¨ãªãåˆ†ã‹ã‚Šã¥ã‚‰ã„ã‚ˆã†ã«ä¿ºã¯æ€ã†ã€‚ãªãœã ã‚ã†ã‹ï¼Ÿãã‚Œã¯ãã£ã¨å›³ãŒãªã„ã‹ã‚‰ã ãƒ»ãƒ»ãƒ»ã¨å‹æ‰‹ã«æƒ³åƒã™ã‚‹ã€‚ã‚ªãƒˆã‚³ãŸã‚‹ã‚‚ã®ã€æ™‚ã«ã¯å‹æ‰‹ãªæ†¶æ¸¬ã§çªãé€²ã‚€ã®ã‚‚ã‚¢ãƒªã ã€‚ã¡ãªã¿ã«Brianã®ã‚¹ãƒ©ã‚¤ãƒ‰ã¯ã»ã¨ã‚“ã©è¦ç‚¹ã®ç®‡æ¡æ›¸ãã«ãªã£ã¦ã„ã‚‹ã€‚ã“ã‚Œã§ã¯è§£èª¬ãŒãªã„ã¨ã€ç‰¹ã«æ–°è¦ã«memcachedã‚„MySQLã‚’å¦ç¿’ã—ã¦ã„ã‚‹äººãŸã¡ã«ã¯åˆ†ã‹ã‚Šã¥ã‚‰ã„ã ã‚ã†ã€‚ ã¨ã„ã†ã‚ã‘ã§æ°ã«ä»£ã‚ã‚Šã€memcachedãŒã©ã®ã‚ˆã†ã«æ—¢å˜ã®ä»•çµ„ã¿ã‚’ç½®ãæ›ãˆã‚‹
at_home 2012/02/21
memcached

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³

mysql

è³‡æ–™

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

database

Memcached

MySQL
ãƒªãƒ³ã‚¯
çµæ§‹ä½¿ãˆã‚‹MySQLã®Triggeræ©Ÿèƒ½ï¼
çš†ã•ã‚“ã€ã”ç„¡æ²™æ±°ã—ã¦ãŠã‚Šã¾ã™ã€‚ ãƒ‘ã‚½ã‚³ãƒ³å‘¨è¾ºæ©Ÿå™¨ã«ãŠé‡‘ã‚’ã‹ã‘ã¯ã˜ã‚ã¦ã„ã‚‹ç¬¹äº€ã§ã™ã€‚ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯ãƒ‘ã‚½ã‚³ãƒ³ãŒå•†å£²é“å…·ãªã®ã§ã€ ã‚„ã¯ã‚Šä½¿ã„ã‚„ã™ã„ç‰©ã‚’ä½¿ã„ãŸããªã‚‹ã®ã¯è‡ªç„¶ãªäº‹ã§ã™ãã€‚ ã”å‚è€ƒã¾ã§ã«ã€‚ã€‚ã€‚ ãƒžã‚¦ã‚¹ã€€ã€€ï¼šLogicool MX Revolutionï¼ˆãƒ“ãƒƒã‚¯ã‚«ãƒ¡ãƒ©ã§ãƒã‚¤ãƒ³ãƒˆã§è³¼å…¥ ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ï¼šBluetooth Macç”¨ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ï¼ˆä¼šç¤¾ã®äººã‹ã‚‰å£²ã£ã¦ã‚‚ã‚‰ã„ã¾ã—ãŸw ä»Šå›žã¯Triggerã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ãŸã„ã¨ãŠã‚‚ã„ã¾ã™ã€‚ Triggerã¨ã¯ã€ãƒ‡ãƒ¼ã‚¿ã®å¤‰æ›´ãªã©ã®ã‚¤ãƒ™ãƒ³ãƒˆã«ã‚ˆã£ã¦ã‚ã‚‰ã‹ã˜ã‚æŒ‡å®šã—ãŸå‡¦ç†ã‚’è‡ªå‹•çš„ã«å®Ÿè¡Œã™ã‚‹æ©Ÿèƒ½ã§ã™ã€‚ æœ€è¿‘ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯å¿…ãšå‚™ãˆã¦ã‚ã‚‹æ©Ÿèƒ½ã§ã™ã€‚ Oracle,Postgres,MySQLã§ã‚‚å½“ãŸã‚Šå‰ã®ã‚ˆã†ã«ã‚ã‚Šã¾ã™ã€‚ å®Ÿéš›ã«ã¯ã©ã®ã‚ˆã†ãªã¨ãã«ä½¿ç”¨ã™ã‚‹ã‚‚ã®ãªã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãƒ»ç‰¹å®šã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã®å‡¦ç†ã®ãƒã‚°ã‚’ã¨ã‚‹ãŸã‚ ãƒ»ç‰¹å®šã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’
at_home 2012/02/21
mysql

tips

SQL

database

trigger
ãƒªãƒ³ã‚¯
SQLãƒ©ã‚¤ã‚¯ã«Hadoop Hiveã‚’ä½¿ã„å€’ã™!
ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’åˆ©ç”¨ã™ã‚‹ ä»Šå›žã¯å°‘ã—å‡ã£ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å®šç¾©ã‚’ã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ éƒµä¾¿ç•ªå·ãƒ‡ãƒ¼ã‚¿ã¯æ¯Žæœˆæ›´æ–°ã•ã‚Œã‚‹ã®ã§ã€ãƒ†ãƒ¼ãƒ–ãƒ«æŒ‡å®šæ™‚ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚‚æŒ‡å®šã§ãã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ã“ã®ã‚ˆã†ãªå ´åˆã€Hiveã§ã¯ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’ä½¿ã„ã¾ã™ã€‚ ä»¥ä¸‹ã«éƒµä¾¿ç•ªå·ã‚’ä¿å˜ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã€Œzipã€ã‚’å®šç¾©ã—ã¾ã™ãŒã€æ—¥ä»˜åž‹DATEã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³verã‚’è¨å®šã™ã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ hive> CREATE TABLE zip (zip STRING, pref INT, city STRING, town STRING) > PARTITIONED BY (ver DATE) > ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' > LINES TERMINATED BY '\n'; OK Time taken: 0.128 seconds
at_home 2012/02/14
hadoop hiveã¯facebookãŒé–‹ç™ºã—ãŸãã†ãªã€‚hadoopé–¢é€£ã¯å¥¥ãŒæ·±ã„ãªã

ï¼ IT

data

linux

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

database

hadoop

hive

db

Java
ãƒªãƒ³ã‚¯
Japan Air Raids.org - æ—¥æœ¬ç©ºè¥²ãƒ‡ã‚¸ã‚¿ãƒ«ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–
Welcome to JapanAirRaids.org, a digital archive dedicated to the dissemination of information and research about the air raids conducted by the United States Army Air Forces and Navy against Japan, with a particular focus on the incendiary bombing of the countryâ€™s cities. In Japan it took over twenty years following the end of World War II before a concerted effort emerged to rem ember the incendia
at_home 2010/12/08
archive

database

è³‡æ–™

æ´å²

æˆ¦äº‰

war
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
at_home 2010/07/27
SQL

ã‚¨ãƒ‡ã‚£ã‚¿

windows

ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆ

database

db
ãƒªãƒ³ã‚¯
Twitterã€ã€Œæ‹¡å¼µæ€§ã¨å¯ç”¨æ€§ã€ã‚’æ±‚ã‚ã¦MySQLã‹ã‚‰Cassandraã¸ä¹—ã‚Šæ›ãˆã‚‹ | OSDN Magazine
äººæ°—ã®ãƒžã‚¤ã‚¯ãƒãƒ–ãƒã‚°ã‚µãƒ¼ãƒ“ã‚¹ã€ŒTwitterã€ã‚’æä¾›ã™ã‚‹ç±³TwitterãŒã€ä½¿ç”¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’FacebookãŒé–‹ç™ºã—ãŸã€ŒCassandraã€ã«ç§»è¡Œã—ã¦ã„ã‚‹ã¨ã„ã†ã€‚ãƒ‡ãƒ¼ã‚¿é‡ã®å¢—åŠ ã«è‡ªå‹•çš„ã«å¯¾å¿œã§ãã‚‹æ‹¡å¼µæ€§ã‚„å¯ç”¨æ€§ãªã©ã‚’è©•ä¾¡ã—ãŸçµæžœã®ã‚ˆã†ã ã€‚ Twitterã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºè€…ã€Ryan Kingsæ°ãŒMyNoSQLã®å–æã«å¿œã˜ã¦æ˜Žã‚‰ã‹ã«ã—ãŸã€‚MyNoSQLã¯SQLã§ã¯ãªã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç·ç§°ã€ŒNoSQLã€ã«é–¢ã™ã‚‹æƒ…å ±ã‚’é›†ã‚ãŸãƒ–ãƒã‚°ã€‚ Kingsæ°ã«ã‚ˆã‚‹ã¨ã€Twitterã¯ã‚·ã‚§ã‚¢ãƒ‰MySQLã¨Memchacheã‚’çµ„ã¿åˆã‚ã›ãŸã‚·ã‚¹ãƒ†ãƒ ã‚’åˆ©ç”¨ã—ã¦ããŸãŒã€ãƒ‡ãƒ¼ã‚¿ã®å¢—åŠ ãƒšãƒ¼ã‚¹ãŒæ€¥å¢—ã—ã¦ãŠã‚Šã€å¯¾å¿œãŒæ€¥å‹™ã¨ãªã£ã¦ã„ãŸã€‚äººä»¶è²»ã‚’ã¯ã˜ã‚ã¨ã—ãŸé‹ç”¨è²»ç”¨ãŒã‹ã•ã‚“ã§ãŠã‚Šã€å…±æœ‰MySQLè¨å®šã‚’è‡ªå‹•åŒ–ã™ã‚‹ã‹ã€ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ä¹—ã‚Šæ›ãˆã‚’è€ƒæ…®ã—ãŸã¨ã„ã†ã€‚Cassandraä»¥å¤–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚‚æ¤œè¨Žã—ãŸãŒã€ãƒžã‚·ãƒ³ã®è¿½åŠ
at_home 2010/07/20
cassandra

twitter

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql

database

db
ãƒªãƒ³ã‚¯
TwitterãŒã€Cassandraã®æœ¬æŽ¡ç”¨ã‚’æ–å¿µã€‚ã€Œã„ã¾ã¯åˆ‡ã‚Šæ›¿ãˆã®æ™‚æœŸã§ã¯ãªã„ã€
ã€Œã„ã¾ã¯æ–°ã—ã„æŠ€è¡“ã¸ã®å¤§è¦æ¨¡ãªç§»è¡Œã‚’ã™ã‚‹æ™‚æœŸã§ã¯ãªã„ã¨ç¢ºä¿¡ã—ã¦ã„ã‚‹ã€ã€‚Twitterã¯ã€ã‚µãƒ¼ãƒ“ã‚¹ã®æ ¸ã¨ãªã‚‹ãƒ„ã‚¤ãƒ¼ãƒˆã‚’ä¿å˜ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã€MySQLã«ã‚ˆã‚‹å¤§è¦æ¨¡åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ã€NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹Cassandraã¸ç§»è¡Œã—ã‚ˆã†ã¨ã—ã¦ã„ã¾ã—ãŸã€‚ã—ã‹ã—Cassandraã¸ã®ç§»è¡Œä½œæ¥ã‚’ä¸æ¢ã—ã€å¼•ãç¶šãMySQLã§ã®é‹ç”¨ã‚’ç¶™ç¶šã™ã‚‹ã¨ã€Twitter Engineering Blogã¸ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒCassandra at Twitter Todayã€ã§æ˜Žã‚‰ã‹ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¯æˆ¦ç•¥ã®å¤‰æ›´ã Twitterã¯åˆ©ç”¨è€…ã‹ã‚‰ã®ãƒ„ã‚¤ãƒ¼ãƒˆã‚’ã€Scalaã«ã‚ˆã£ã¦ç‹¬è‡ªé–‹ç™ºã—ãŸãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã€ŒGizzardã€ã¨MySQLã€ãã—ã¦memcachedã‚’ç”¨ã„ãŸå¤§è¦æ¨¡åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¿å˜ã—ã¦ã„ã¾ã™ã€‚ ã—ã‹ã—ã“ã†ã—ãŸè¤‡é›‘ãªã‚·ã‚¹ãƒ†ãƒ ã«ã‚ˆã‚‹é‹ç”¨ã¯éžå¸¸ã«æ‰‹é–“ãŒã‹ã‹ã‚Šã€äººçš„ã‚³ã‚¹ãƒˆã‚’ä¸å¿ƒã¨ã—ãŸã‚³ã‚¹ãƒˆã®å¢—åŠ ãŒéžå¸¸ã«å¤§ãããª
at_home 2010/07/20
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

twitter

mysql

database

cassandra

MySQL

db

ã‚¤ãƒ³ãƒ•ãƒ©
ãƒªãƒ³ã‚¯
åˆ¶å¾¡æ§‹æ–‡ - 2éƒ¨ Perlè¨€èªžä»•æ§˜ - [SMART]
æ¡ä»¶æ–‡ æ¡ä»¶æ–‡ã¯ã„ãã¤ã‹ã®é¸æŠžè‚¢ã‚’ã‚³ãƒ¼ãƒ‰å†…ã§å®Ÿç¾ã—ãŸã„éš›ã«ä½¿ç”¨ã—ã¾ã™ã€‚ã€Œã‚‚ã—ï½žãªã‚‰ã°ã€ãƒ»ãƒ»ãƒ»ã‚’å®Ÿè¡Œã™ã‚‹ã€ã€ã€Œã‚‚ã—ï½žãªã‚‰ã°ã€ãƒ»ãƒ»ãƒ»ã‚’å®Ÿè¡Œã—ãªã„ã€ã¨ã„ã£ãŸã‚ˆã†ã«æ¡ä»¶ã«ã‚ˆã£ã¦å‡¦ç†ã‚’å®Ÿè¡Œã—ãŸã‚Šã€ã„ãã¤ã‹ã®é¸æŠžè‚¢ã®ä¸ã‹ã‚‰ã²ã¨ã¤ã®å‡¦ç†ã‚’å®Ÿè¡Œã—ãŸã‚Šã¨ã„ã£ãŸã“ã¨ã‚’å®Ÿç¾ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ifæ–‡ ã€Œã‚‚ã—ï½žãªã‚‰ã°ã€ãƒ»ãƒ»ãƒ»ã‚’å®Ÿè¡Œã™ã‚‹ã€ã¨ã„ã†æ¡ä»¶ã¤ãã®å‘½ä»¤ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã«ã€if æ–‡ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ifæ–‡ã¯ã€ã‚«ãƒƒã‚³ã®ä¸ã®æ¡ä»¶å¼ã‚’è©•ä¾¡ã—ã€TRUE ã®ã¨ãã ã‘ if ãƒ–ãƒãƒƒã‚¯ã®å‘½ä»¤æ–‡ã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ if ( æ¡ä»¶å¼ ) { å‡¦ç†.... } å¤‰æ•° $var ã®å€¤ãŒ A ã®æ™‚ã ã‘å‡ºåŠ›ã™ã‚‹ã«ã¯æ¬¡ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ if ( $var eq 'A' ) { print "Aã§ã™\n"; } æ¡ä»¶å¼ã¯è¤‡æ•°ã‚ã£ã¦ã‚‚ã‹ã¾ã„ã¾ã›ã‚“ã€‚è¤‡æ•°ã®æ¡ä»¶ã‚’ä¸¦ã¹ãŸã„ã¨ãã¯ã€è«–ç†æ¼”ç®—åã® and ã‚‚ã—ãã¯ or ã‚’ä½¿ã„ã¾ã™ã€‚ # or: $v
at_home 2009/12/01
oracle

perl

DBI

DB

database

sql

ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ãƒªãƒ³ã‚¯
1