[B! db] tech-kazuhisaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

tech-kazuhisa id:tech-kazuhisa

dbã«é–¢ã™ã‚‹tech-kazuhisaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (9)

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

EBS Standard Volumeã®æ€§èƒ½ç‰¹æ€§ - SH2ã®æ—¥è¨˜
æœ€è¿‘@namikawaã•ã‚“ã¨@con_mameã•ã‚“ãŒEBSã®æ€§èƒ½æ¸¬å®šã‚’ã•ã‚Œã¦ã„ã¦ã€å°‘ã—æ°—ã«ãªã£ãŸã®ã§è¿½è©¦ã‚’ã—ã¾ã—ãŸã€‚ Amazon EBS ã®æ€§èƒ½ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ ãã®1 (Standardç·¨) - å…ƒRX-7ä¹—ã‚Šã®é©å½“ãªæ—¥ã€… Amazon EBS ã®æ€§èƒ½ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ ãã®2 (Standard-Volå¢—é‡ç·¨) - å…ƒRX-7ä¹—ã‚Šã®é©å½“ãªæ—¥ã€… Amazon EBS ã®æ€§èƒ½ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ ãã®3 (Provisioned IOPSç·¨) - å…ƒRX-7ä¹—ã‚Šã®é©å½“ãªæ—¥ã€… 4,000IOPS EBSã®ãƒ™ãƒ³ãƒã‚’ã¨ã£ã¦ã¿ãŸ - ã¾ã‚ç•‘ ä»Šä¸€åº¦Provisoed IOPS EBSã®ãƒ™ãƒ³ãƒã‚’ã¨ã£ã¦ã¿ãŸ - ã¾ã‚ç•‘ æ¸¬å®šç’°å¢ƒã§ã™ã€‚ ap-northeast-1c m1.small (Spot Instance) Amazon Linux AMI 2013.03.1 EBS Standard Volume 16GB
tech-kazuhisa 2013/05/20
aws

ebs

db
ãƒªãƒ³ã‚¯
Studio ODIN - blogé¢¨å°ãƒã‚¿é›† > PostgreSQL ã¯ TRUNCATE ã‚‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å†…ã§ã™ã€‚
ã‚¿ã‚¤ãƒˆãƒ«ã®é€šã‚Šã§ã™ãŒã€PostgreSQL ã§ã¯ã€TRUNCATE TABLE ã‚‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å†…ãªã®ã§ã€ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã™ã‚‹ã¨ ãƒ‡ãƒ¼ã‚¿ã¯å…ƒã«æˆ»ã‚Šã¾ã™ã€‚ æ¬¡ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ postgres=# select * from test1; f1 | f2 ----+---- 1 | 1 2 | 2 (2 rows) postgres=# begin; BEGIN postgres=# truncate table test1; TRUNCATE TABLE postgres=# select * from test1; f1 | f2 ----+---- (0 rows) postgres=# rollback; ROLLBACK postgres=# select * from test1; f1 | f2 ----+---- 1 | 1 2 | 2 (2 rows) é¢ç™½ã„ã®ã¯ã€CRE
tech-kazuhisa 2012/01/14
ã¾ã˜ã‹ãƒ¼ï¼ï¼Ÿã¨ã€ã„ã†ã“ã¨ã¯delete from sample;ã¨ã‚¹ãƒ”ãƒ¼ãƒ‰ã¯åŒã˜ã£ã¦ã“ã¨ï¼Ÿ

db
ãƒªãƒ³ã‚¯
GitHub - abikounso/ar_extractor: Extract database data to YAML fixtures.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
tech-kazuhisa 2011/09/14
db

yaml

rails
ãƒªãƒ³ã‚¯
Rails 3 ã§ RDBã«æ›¸ã‹ã‚Œã‚‹æ™‚é–“ã‚’æ—¥æœ¬æ™‚é–“ã«ã™ã‚‹ã«ã¯ - yuumi3ã®ãŠä»•äº‹æ—¥è¨˜
ç¾åœ¨ Ruby on Rails 3.0 ã§ã‚ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½œã£ã¦ã„ã¾ã™ãŒã€ Rails 2.X ã¨é•ã„ RDB ã«æ›¸ã‹ã‚Œã‚‹æ™‚é–“ãŒ UTC (å”å®šä¸–ç•Œæ™‚) ã§ã‹ã‹ã‚Œã¾ã™ã€‚ å›½éš›å¯¾å¿œã™ã‚‹äºˆå®šã®ã‚¢ãƒ—ãƒªãªã‚‰ã“ã‚Œã§è‰¯ã„ã®ã§ã™ãŒã€æ—¥æœ¬å‘ã‘ã®ã‚µãƒ¼ãƒ“ã‚¹ã®å ´åˆã¯ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹æ€§ã‚’è€ƒãˆã‚‹ã¨ RDB ã«ã¯æ—¥æœ¬æ™‚é–“(JST)ã§æ›¸ã‹ã‚ŒãŸæ–¹ãŒè‰¯ã„ã®ã§å¯¾å¿œã—ã‚ˆã†ã¨ã—ãŸã¨ã“ã‚ä¸€ç‹ç¸„ã§ã¯è¡Œãã¾ã›ã‚“ã§ã—ãŸã€‚ Railsã®è¨å®š config/application.rb (Rails2ã® config/environment.rb ã«å¯¾å¿œã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«)ã«ã€ã‚³ãƒ¡ãƒ³ãƒˆã‚¢ã‚¦ãƒˆã•ã‚ŒãŸ config.time_zone = 'Central Time (US & Canada)' ã¨ã„ã†è¨å®šãŒã‚ã£ãŸã®ã§ config.time_zone = 'Tokyo' ã¨ã—ã¦ã¿ã¾ã—ãŸãŒã€ãªãœã‹ã¾ã UTCã§å‹•ä½œã—ã¦ã„ã¾ã™ï¼Ÿ rails3 time_zo
tech-kazuhisa 2011/04/26
rails

db

postgrsql
ãƒªãƒ³ã‚¯
MySQL ã‚’ä½¿ã£ãŸãŠæ‰‹è»½ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼å®Ÿè£… - ãƒ‰ãƒ¯ãƒ³ã‚´ ç ”ç©¶é–‹ç™ºãƒ–ãƒã‚°
ã¯ã˜ã‚ã« ã“ã®è¨˜äº‹ã§ã¯ã€MySQL ã‚’ä½¿ã£ã¦ç°¡å˜ãªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã‚’æ‰‹è»½ã«å®Ÿè£…ã™ã‚‹æ–¹æ³•ã‚’è§£èª¬ã—ã¾ã™ã€‚ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¨ã¯ã€ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’ä¸€æ™‚çš„ã«æºœã‚ã¦ãŠãã€é †æ¬¡å‡¦ç†ã™ã‚‹ãŸã‚ã®ä»•çµ„ã¿ã§ã™ã€‚è¿…é€Ÿãªãƒ¬ã‚¹ãƒãƒ³ã‚¹ãŒå¿…è¦ãª Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã„ã¦ã€æ™‚é–“ã®ã‹ã‹ã‚‹å‡¦ç†ã‚’éžåŒæœŸã«è¡Œã†ãŸã‚ã«ã€ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ã§é †æ¬¡å‡¦ç†ã—ã¦ã„ãã‚ˆã†ãªå ´åˆã«åˆ©ç”¨ã§ãã¾ã™ã€‚ ç°¡å˜ãªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¨è¨€ã£ã¦ã‚‚ã€å¤§è¦æ¨¡ãªé‹ç”¨ã«ã‚‚è€ãˆã‚‰ã‚Œã‚‹ç¨‹åº¦ã®é€Ÿåº¦ã¨å …ç‰¢æ€§ã‚’æŒã¡ã¾ã™ã€‚ ã¾ãŸã€ã“ã“ã§è§£èª¬ã—ã¦ã„ã‚‹æ–¹æ³•ã§ä½œã‚‰ã‚ŒãŸãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¯ã€å¼Šç¤¾ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹ãƒ‹ã‚³ãƒ‹ã‚³å‹•ç”»ã«æœ€è¿‘è¿½åŠ ã•ã‚ŒãŸtwitteré€£æºæ©Ÿèƒ½ã§ã‚‚åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã‚’ä½œã‚‹ã«ã‚ãŸã£ã¦ ä»Šå›žå®Ÿè£…ã™ã‚‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¯ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®è¿½åŠ (push)ã‚’é«˜é€Ÿã«è¡Œã†äº‹ãŒã§ãã‚‹ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®å–å¾—(pop)ã¯ã‚ã‚‹ç¨‹åº¦é«˜é€Ÿã«è¡Œã†äº‹ãŒã§ãã‚‹ å¤šãã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰åŒæ™‚ã« p
tech-kazuhisa 2010/01/26
mysql

db
ãƒªãƒ³ã‚¯
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã‚‹MySQLã§ã€ãƒžã‚¹ã‚¿ã‚„ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒéšœå®³åœæ¢ã—ãŸå ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
MySQLã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ™ãƒ¼ã‚¹ã®HAãªæ§‹æˆã«ã¤ã„ã¦è€ƒãˆãŸãƒ¡ãƒ¢ã§ã™ã€‚ 3å°(ã¨ã„ã†ã‹2å°ï¼‹1å°)ãŒã„ã„ã‹ãªãã¨æ€ã£ã¦ã„ã¦ã€å‰åŠã¯ãã®ç†ç”±ã‚’ã€å¾ŒåŠã§ã¯{ãƒžã‚¹ã‚¿,ã‚¹ãƒ¬ãƒ¼ãƒ–}ãŒ{å†èµ·ä¸èƒ½ã«ãªã£ãŸ,ã¡ã‚‡ã£ã¨ãƒ€ã‚¦ãƒ³ã—ã¦ã™ãå¾©å¸°ã—ãŸ}å ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ã«ã¤ã„ã¦æ›¸ãã¾ã™ã€‚ ä»Šã®ã¨ã“ã‚ã¯ã“ã‚ŒãŒãƒ™ã‚¹ãƒˆã‹ãªã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ã€Œã“ã†ã—ãŸã»ã†ãŒã„ã„ã¨æ€ã†ï¼ã€ã€Œã“ã“ãŒãŠã‹ã—ã„ï¼ã€ãªã©ãªã©ã®ã”æ„è¦‹ã¯ã‚³ãƒ¡ãƒ³ãƒˆã€TBãªã©ã§ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ã€‚ ã‚´ãƒ¼ãƒ« ãƒžã‚¹ã‚¿ãŒè½ã¡ã¦ã‚‚ããƒ¼ã™ã‹å¯ã¦ã„ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã„ ãƒªã‚«ãƒãƒªã®ä½œæ¥ã¯ã§ãã‚‹ã ã‘å˜ç´”ã«ã€ã‹ã¤ã€çŸæ™‚é–“ã§å®Œäº†ã™ã‚‹ã‚ˆã†ã«ã—ãŸã„ ã‚ã‚“ã©ãã•ã„ã®ã¯ã„ã‚„ åŸºæœ¬æ§‹æˆã€æ–¹é‡ 2å°ï¼‹1å° ã‚µãƒ¼ãƒ“ã‚¹ã§ä½¿ã†ã®ã¯2å° (db1, db2) ã‚‚ã†1å°ã¯ç®¡ç†ç”¨ (db3) ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’å¤šæ•°ä¸¦ã¹ã‚‹æ§‹æˆã«ã¯ã—ãªã„ å°æ•°å¢—ãˆã‚‹ã¨ç®¡ç†ã‚³ã‚¹ãƒˆãŒä¸ŠãŒã‚‹ ãƒžã‚¹ã‚¿ãƒ€ã‚¦ãƒ³æ™‚ã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã¨ãã®ãƒ•ã‚§ã‚¤ãƒ«ãƒ
tech-kazuhisa 2009/10/23
mysql

db
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: RDBã§éšŽå±¤æ§‹é€ ã‚’æ‰±ã†ã«ã¯ï¼Ÿ
yukiã§ã™ã€‚ãƒ€ã‚¤ã‚¨ãƒƒãƒˆã‚’å§‹ã‚ã¦3kgæ¸›ã£ãŸã¨æ€ã£ãŸã‚‰ã€é¢¨é‚ªã‚’å¼•ã„ã¦è¦‹äº‹ã«1kgå¢—é‡ã€‚ é‹å‹•ã—ãªã„ã¨é§„ç›®ã§ã™ãã€‚ã‚ã¨æ®‹ã‚Š20kgã€é“ã®ã‚Šã¯é ã„ã§ã™ã€‚ ã•ã¦ä»Šå›žã¯ã€ã€ŒRDBã§éšŽå±¤æ§‹é€ ã‚’æ‰±ã†ã«ã¯ï¼Ÿã€ã§ã™ã€‚ ã‚ã‚‹ã‚µã‚¤ãƒˆã‚’æ§‹ç¯‰ä¸ã«éšŽå±¤æ§‹é€ ã‚’ã‚‚ã£ãŸã‚«ãƒ†ã‚´ãƒªæ§‹é€ ã«ã™ã‚‹ã“ã¨ã«ãªã‚Šã€ã©ã®ã‚ˆã†ã«DBã§æ‰±ã†ã‹æ‚©ã¿ã¾ã—ãŸã€‚ DBã¯MySQLã‚’æŽ¡ç”¨ã—ã¦ã„ãŸã®ã§ã€ã“ã®æ™‚ç‚¹ã§ã±ã£ã¨é ã«æµ®ã‹ã‚“ã é¸æŠžè‚¢ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã§ã—ãŸã€‚ XML-DBã‚’åˆ©ç”¨ã™ã‚‹ è¦ªã‚«ãƒ†ã‚´ãƒªãƒ¬ã‚³ãƒ¼ãƒ‰ã®ãƒ—ãƒ©ã‚¤ãƒžãƒªIDã‚’åã‚«ãƒ†ã‚´ãƒªãƒ¬ã‚³ãƒ¼ãƒ‰ã«æŒãŸã›ã‚‹ è¦ªã‚’å«ã‚ãŸã€Žçµ¶å¯¾ãƒ‘ã‚¹ã€ã‚’åç§°ã¨ã—ã¦æ‰±ã„ã€å–ã‚Šå‡ºã—ãŸå¾Œã«ãƒ‘ãƒ¼ã‚¹ ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã«åŒæ§˜ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ã‚’ä½œã‚Šã€æ¯Žå›žãƒ‘ãƒ¼ã‚¹ã™ã‚‹ (1)ã®XMLDBã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®eXistã‚„Xindiceã€Yggdrasillãªã©æ§˜ã€…ãªé¸æŠžè‚¢ãŒã‚ã‚Šã¾ã—ãŸãŒã€ã‚«ãƒ†ã‚´ãƒªã®ã¿ã®åˆ©ç”¨ãªå‰²ã«ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚³ã‚¹ãƒˆãŒé«˜ã™ãŽã‚‹ã®ã§è¦‹é€ã‚Šã¾
tech-kazuhisa 2009/06/25
database

db

sql

tips
ãƒªãƒ³ã‚¯
SAP Mobile Technology | SAP Community
SAP Mobile Techno logyBuilt around SAP Mobile Services running on the SAP Business Techno logy Platform, SAP Mobile Techno logies provide SDKs to help you develop your mobile applications. See how the SAP Mobile Techno logies community can help you: Connect to peers and SAP experts to exchange information about product solutions and best practices. Search for answers, ask questions, access resources,
tech-kazuhisa 2007/12/11
[ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³]

db
ãƒªãƒ³ã‚¯
SQLè¬›åº§ [Smart]
indexã¯ã€ç¬¬1å¼•æ•°STRã®å…ˆé ã‹ã‚‰ç¬¬2å¼•æ•°SUBSTRãŒæœ€åˆã«è¦‹ã¤ã‹ã£ãŸä½ç½®ã‚’è¿”ã—ã¾ã™ã€‚ ç¬¬3å¼•æ•° POSITIONã§æ¤œç´¢ã™ã‚‹ä½ç½®ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ç¬¬3å¼•æ•°POSITIONã«ã¯æœ€åˆã®æ–‡å—ã‚’ 0 ã¨ã—ã¦æŒ‡å®šã—ã¾ã™ã€‚ è¿”å´å€¤ã¯ 0ã€ã‚‚ã—ãã¯å¤‰æ•°$[ã«è¨å®šã—ãŸå€¤ã§ã™ã€‚SURSTRãŒè¦‹ã¤ã‹ã‚‰ãªã‹ã£ãŸå ´åˆã¯ -1 ã‚’è¿”ã—ã¾ã™ã€‚ indexã®ä½¿ã„æ–¹ $str = "How you always hurt the one you love."; print index($str,'you'); > 4
tech-kazuhisa 2007/11/22
db

database
ãƒªãƒ³ã‚¯
1