[B! DB] tuneã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

tune id:tune

DBã«é–¢ã™ã‚‹tuneã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

Aurora - ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®DBã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ - ç™ºæ˜Žã®ãŸã‚ã®å†ç™ºæ˜Ž
ã¯ã˜ã‚ã« Amazon Auroraã¯ã€AWSã‚’è§¦ã‚‹äººãªã‚‰ã»ã¨ã‚“ã©ã®äººãŒåˆ©ç”¨ã‚’æ¤œè¨Žã—ãŸã“ã¨ãŒã‚ã‚‹ã§ã—ã‚‡ã†ã€‚ Amazonç¤¾å†…ã§ã¯Oracleã‚’æ¢ã‚ãŸã¨ã„ã†tweetã‚‚ã‚ã‚Šã¾ã—ãŸ SHUTDOWN ABORT the last Oracle database running Amazon Fulfillment! pic.twitter.com/DorqTua2Ltâ€” John Darrow (@jdarrow) 2019å¹´3æœˆ29æ—¥ ãã‚“ãªAuroraã¯ã€å¾“æ¥ã®RDBã¨ã¯é•ã„ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§å‹•ãã“ã¨ã‚’å¿µé ã«è¨è¨ˆã•ã‚Œã¦ã„ã¾ã™ã€‚ ã¾ãŸã€ãƒã‚°ãŒä¸å¿ƒçš„ãªå½¹å‰²ã‚’æŒã¤ã“ã¨ã‹ã‚‰ã€ŒThe log is the databaseã€ã¨è¡¨ç¾ã•ã‚Œã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ã€‚ ãã‚“ãªAuroraã®ä»•çµ„ã¿ã«ã¤ã„ã¦ã®è«–æ–‡ã‚’èªã‚“ã ã®ã§ç´¹ä»‹ã—ã¾ã™ã€‚ èªã‚“ã è«–æ–‡ã¯ä»¥ä¸‹ã®ï¼’ã¤ã§ã™ã€‚ Amazon Aurora: Design Conside
tune 2019/05/18
é›£ã—ã„

DB

aurora

amazon
ãƒªãƒ³ã‚¯
SQLã§ç¾ƒç‰ã«DBã‚¹ã‚ãƒ¼ãƒžç®¡ç†ãŒã§ãã‚‹ãƒ„ãƒ¼ãƒ«ã€Œsqldefã€ã‚’ä½œã£ãŸ - k0kubun's blog
sqldefã®ãƒªãƒã‚¸ãƒˆãƒª github.com ã“ã‚Œã¯ä½•ã‹ Ridgepoleã¨ã„ã†ãƒ„ãƒ¼ãƒ«ã‚’ã”å˜ã˜ã§ã—ã‚‡ã†ã‹ã€‚ ã“ã‚Œã¯Rubyã®DSLã§create_tableã‚„add_indexç‰ã‚’æ›¸ã„ã¦ã‚¹ã‚ãƒ¼ãƒžå®šç¾©ã‚’ã—ã¦ãŠãã¨ãã‚Œã¨å®Ÿéš›ã®ã‚¹ã‚ãƒ¼ãƒžã®å·®ç•°ã‚’åŸ‹ã‚ã‚‹ãŸã‚ã«å¿…è¦ãªDDLã‚’è‡ªå‹•ã§ç”Ÿæˆãƒ»é©ç”¨ã§ãã‚‹ä¾¿åˆ©ãªãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ä¸€æ–¹ã€ ã§è¨€ã‚ã‚Œã¦ã„ã‚‹ã‚ˆã†ã«ã€Ridgepoleã‚’å‹•ä½œã•ã›ã‚‹ãŸã‚ã«ã¯Rubyã‚„ActiveRecordã¨ã„ã£ãŸä¾å˜ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã€Railsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ä»¥å¤–ã§ä½¿ã†å ´åˆã«ã¯å°‘ã€…é¢å€’ãªã“ã¨ã«ãªã‚Šã¾ã™ã€‚*1 *2 ãã“ã§ã€Pure Goã§æ›¸ãã“ã¨ã§ãƒ¯ãƒ³ãƒã‚¤ãƒŠãƒªã«ã—ã€ã¾ãŸåˆ¥è¨€èªžåœã®äººã§ã‚‚ä½¿ã„ã‚„ã™ã„ã‚ˆã†ã€Rubyã®DSLã®ã‹ã‚ã‚Šã«ã€èª°ã§ã‚‚çŸ¥ã£ã¦ã‚‹SQLã§CREATE TABLEã‚„ALTER TABLEã‚’æ›¸ã„ã¦åŒã˜ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ã—ãŸã®ãŒsqldefã§ã™ã€‚ ä½¿ç”¨ä¾‹ ç¾æ™‚ç‚¹ã§ã¯My
tune 2018/08/25
ä¾¿åˆ©ãƒ„ãƒ¼ãƒ«ã

DB

postgresql

mysql
ãƒªãƒ³ã‚¯
PostgreSQLã‚¢ãƒ³ãƒãƒã‚šã‚¿ãƒ¼ãƒ³
37. ç©ã¿é‡ãªã‚‹WHEREå¥ -- æœ‰åŠ¹ãªã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ãƒ–ãƒã‚°ã‚’å–ã£ã¦ããŸã„å ´åˆ SELECT * FROM blog INNER JOIN users ON users.id = blog.user_id AND users.delete_ï¬‚ag = 0 WHERE blog.delete_ï¬‚ag = 0 38. ç©ã¿é‡ãªã‚‹WHEREå¥ -- æœ‰åŠ¹ãªã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ãƒ–ãƒã‚°ã‚’å–ã£ã¦ããŸã„å ´åˆ SELECT * FROM blog INNER JOIN users ON users.id = blog.user_id AND users.delete_ï¬‚ag = 0 WHERE blog.delete_ï¬‚ag = 0 ãƒ¦ãƒ¼ã‚¶ã®å‰Šé™¤ãƒ•ãƒ©ã‚°ã‚’è¦‹ã‚‹ 39. ç©ã¿é‡ãªã‚‹WHEREå¥ -- æœ‰åŠ¹ãªã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ãƒ–ãƒã‚°ã‚’å–ã£ã¦ããŸã„å ´åˆ SELECT * FROM blog INNER JOIN users
tune 2015/11/29
postgresql

DB

ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³
ãƒªãƒ³ã‚¯
1æ—¥ã«100ä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰å¢—ãˆã‚‹å ´åˆã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆ
MySQLï¼ˆãƒžã‚¤ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ãƒ«ï¼‰ã¯ã€TCX DataKonsultABç¤¾ãªã©ãŒé–‹ç™ºã™ã‚‹RDBMSï¼ˆãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ )ã§ã™ã€‚ä¸–ç•Œã§æœ€ã‚‚äººæ°—ã®é«˜ã„ã‚·ã‚¹ãƒ†ãƒ ã§ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã¯ã€é«˜é€Ÿæ€§ã¨ä¿¡é ¼æ€§ãŒã‚ã‚Šã€Linuxã€UNIXã€Windowsãªã©ã®è¤‡æ•°ã®ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§å‹•ä½œã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ PHPã¯ã€Webã‚µã‚¤ãƒˆæ§‹ç¯‰ã«ç‰¹åŒ–ã—ã¦é–‹ç™ºã•ã‚ŒãŸãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§ã™ã€‚å¤§ããªç‰¹å¾´ã®ã²ã¨ã¤ã¯ã€HTMLã«ç›´æŽ¥ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’åŸ‹ã‚è¾¼ã‚€ã“ã¨ãŒã§ãã‚‹ã¨ã„ã†ç‚¹ã§ã™ã€‚PHPã‚’ç”¨ã„ã‚‹ã“ã¨ã§ã€HTMLã‚’å‹•çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¨ã—ã¦å‡ºåŠ›ã§ãã¾ã™ã€‚HTMLãŒãã®ã¾ã¾ãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ã®ã«å¯¾ã—ã€PHPãƒ—ãƒã‚°ãƒ©ãƒ ã¯ã‚µãƒ¼ãƒå´ã§å®Ÿè¡Œã•ã‚ŒãŸçµæžœãŒãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ãŸã‚ã€PHPã‚¹ã‚¯ãƒªãƒ—ãƒˆã¯ã€Œã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚¹ã‚¯ãƒªãƒ—ãƒˆã€ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚
tune 2015/11/06
mysql

DB

è¨è¨ˆ
ãƒªãƒ³ã‚¯
SQL style guide by Simon Holywell
Overview General Do Avoid Naming conventions General Tables Columns Aliasing or correlations Stored procedures Uniform suffixes Query syntax Reserved words White space Indentation Preferred formalisms Create syntax Choosing data types Specifying default values Constraints and keys Designs to avoid Appendix Reserved keyword reference Column data types SQL style guide Overview You can use this set o
tune 2015/07/25
sql

styleguide

DB
ãƒªãƒ³ã‚¯
ã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã¨ã„ã†æœ¬ã‚’ç¿»è¨³ã—ã¾ã—ãŸ | b.l0g.jp
ã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã¨ã„ã†æœ¬ã‚’ç¿»è¨³ã—ã¾ã—ãŸ 2015-04-07 é¡Œã®é€šã‚Šã€ã€ŒSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€(åŽŸæ–‡ã‚¿ã‚¤ãƒˆãƒ«SQL Performance Explained)ã¨ã„ã†æœ¬ã‚’ç¿»è¨³ã—ã¾ã—ãŸã€‚PDFç‰ˆã¨å°åˆ·ç‰ˆãŒä¸Šè¨˜ã‚µã‚¤ãƒˆã‹ã‚‰è³¼å…¥ã§ãã¾ã™ã€‚ (è¿½è¨˜ 2017å¹´9æœˆã‹ã‚‰ã€æ¸‹è°·ã®BOOK LAB TOKYOã•ã‚“ã§ã‚‚å°åˆ·ç‰ˆã‚’è²©å£²ã—ã¦ã„ãŸã ã„ã¦ã„ã¾ã™ã€‚è¼¸é€ã‚³ã‚¹ãƒˆã®é–¢ä¿‚ã§ã€ã‚µã‚¤ãƒˆã‹ã‚‰è³¼å…¥ã™ã‚‹ã‚ˆã‚Šè‹¥å¹²å®‰ããªã£ã¦ã„ã¾ã™) ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã„ã¦ã€SQLã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒã©ã®ã‚ˆã†ã«é–¢é€£ã—ã€ã©ã®ã‚ˆã†ã«ã™ã‚Œã°SQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è‰¯ãã§ãã‚‹ã®ã‹ã‚’è§£èª¬ã—ãŸæœ¬ã§ã™ã€‚ç‰¹å®šã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ã«ç„¦ç‚¹ã‚’å½“ã¦ãŸæœ¬ã¯å¤šæ•°ã‚ã‚Šã¾ã™ãŒã€ã“ã®æœ¬ã§ã¯Oracle Databaseã€PostgreSQLã€MySQLã€SQL Serverã®4ã¤ã®ãƒ¡ã‚¸ãƒ£ãƒ¼ãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ã‚’åŒæ™‚ã«æ‰±ã£ã¦ã„ã¦ã€ãã‚Œãžã‚Œã®ã‚¯
tune 2015/04/08
MySQL

database

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

DB
ãƒªãƒ³ã‚¯
xRef - Database
$ sqlplus $ sqlplus myuser@myhost $ sqlplus myuser/xxxxx@myhost $ sqlplus myuser/xxxxx@myhost/xe
tune 2015/01/02
mysql

database

sql

DB

postgresql

è³‡æ–™
ãƒªãƒ³ã‚¯
O/Rãƒžãƒƒãƒ‘ãƒ¼ã«ã‚ˆã‚‹ãƒˆãƒ©ãƒ–ãƒ«ã‚’æœªç„¶ã«é˜²ã
2. copyright Â© 2014 kuwata-lab.com all rights reserved ã¾ãˆãŒã ç¾åœ¨ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã®ç¾å ´ã§ã¯ O/R Mapper (ORM) ãŒæ™®åŠã—ã¦ã„ã¾ã™ã€‚ä»Šå¾Œ ã‚‚ ORM ã‚’ä½¿ã£ãŸé–‹ç™ºã¯ã€å¢—ãˆã‚‹ã“ã¨ã¯ã‚ã£ã¦ã‚‚æ¸›ã‚‹ã“ã¨ã¯ãªã„ã§ã—ã‚‡ã†ã€‚ ã—ã‹ã— ORM ã¯ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºè€…ã«ã¨ã£ã¦ã¯ä¾¿åˆ©ã§ã‚‚ã€DB ç®¡ç†è€… (DBA) ã‹ ã‚‰ã¿ãŸã‚‰ãƒˆãƒ©ãƒ–ãƒ«ã®ç¨®ã§ã‚‚ã‚ã‚Šã¾ã™ã€‚ãã‚ŒãŒç‰¹ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é–¢ã™ã‚‹å•é¡Œã§ã‚ã‚‹ã“ ã¨ãŒå¤šã„ãŸã‚ã€é–‹ç™ºè€…ã¨ DBA ãŒå¯¾ç«‹ã™ã‚‹ã“ã¨ã‚‚çã—ãã‚ã‚Šã¾ã›ã‚“ã€‚ ã¨ã¯ã„ãˆã€ORM ã«ã‚ˆã‚‹å•é¡Œã¯ã™ã§ã«è§£æ±ºç–ãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚æœ¬å½“ã® å•é¡Œã¯ã€ã™ã§ã«å˜åœ¨ã™ã‚‹è§£æ±ºç–ãŒã‚ã¾ã‚ŠçŸ¥ã‚‰ã‚Œã¦ã„ãªã„ã“ã¨ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ãã“ã§æœ¬ç™ºè¡¨ã§ã¯ã€ORM ã«ã‚ˆã£ã¦ã©ã®ã‚ˆã†ãªå•é¡ŒãŒèµ·ã“ã‚Šã‚„ã™ã„ã‹ã€ã©ã†è§£æ±ºãƒ»äºˆé˜² ã™ã‚Œã°ã„ã„ã‹ã€ãã—ã¦ ORM
tune 2014/12/22
sql

DB

orm
ãƒªãƒ³ã‚¯
Entity-Attribute-Value: SQL ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ - ãƒšãƒ³ã‚®ãƒ³ãƒ©ãƒœ Wiki
Bill Karwin â€œSQL Antipatterns: Avoiding the Pitfalls of Database Programmingâ€ ã®èªæ›¸ãƒ¡ãƒ¢ã€‚ Jaywalking ç›®çš„ ã‚ã‚‹å±žæ€§ã«ã¤ã„ã¦ã€è¤‡æ•°ã®å€¤ã‚’æŒãŸã›ã‚‹ã€‚ ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ : ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šãƒªã‚¹ãƒˆ ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã§è¤‡æ•°ã®å€¤ã‚’ 1 ã¤ã®åˆ—ã«ç´ã‚ã‚‹ã€‚ ä¾‹ã§ã¯ã€ç‰¹å®šã®è£½å“ã«ã¤ã„ã¦ã®æ‹…å½“è€…ã‚’è¤‡æ•°è¨å®šã™ã‚‹ã®ã«ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã§ã€æ‹…å½“è€…ã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆIDã‚’è¨˜è¿°ã—ã¦ã„ã‚‹ã€‚ create table products ( product_id integer, product_name varchar(1000), acount_id varchar(100), -- comma separated list -- ... ); insert into products (product_id, product_name, accou
tune 2014/04/09
è¨è¨ˆ

ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãŸã‚ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ - ä¹…ä¿æ¸…éš†ã®ãƒ–ãƒã‚°
ä»•äº‹ã§MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ã¦ã„ã¦ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦åˆ†ã‹ã£ã¦ã„ãªã„ã“ã¨ãŒå¤šã‹ã£ãŸã®ã§èª¿ã¹ãŸã“ã¨ã‚’ãƒ¡ãƒ¢ã€‚åŸºæœ¬çš„ãªã¨ã“ã‚ã‹ã‚‰å¦ç¿’ã—ãªãŠã—ãŸã€‚ MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã€ã‚«ãƒ©ãƒ ãŒç‰¹å®šã®å€¤ã‚’ã‚‚ã¤ãƒ¬ã‚³ãƒ¼ãƒ‰ã®è¿…é€Ÿãªæ¤œç´¢ã«ä½¿ç”¨ã•ã‚Œã‚‹ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã™ã‚Œã°ã€æ•°ç™¾ã¨ã‹æ•°å„„ã‚‚ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå…¥ã£ã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ã€ä¸€çµ„ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¿…é€Ÿã«è¦‹ã¤ã‘ã¦å–ã‚Šå‡ºã™ã“ã¨ãŒå¯èƒ½ã«ãªã‚‹ã€‚ ã—ã‹ã—ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯é€Ÿåº¦ã‚’æ”¹å–„ã™ã‚‹ã“ã¨ã‚‚ã‚ã‚‹ãŒã€æŒ¿å…¥ã®é‚ªé”ã«ãªã£ã¦é…ããªã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é©åˆ‡ã«ä½¿ã†ãŸã‚ã«ã€ã¾ãšã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºæœ¬æ¦‚å¿µã‚’ãŠã•ãˆã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ¦‚å¿µ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä»•çµ„ã¿ã‚’ç†è§£ã™ã‚‹ã«ã¯ã€ã¾ãšMySQLãŒã©ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªã«å¿œç”ã™ã‚‹ã‹ã‚’çŸ¥ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ä¾‹ãˆã°ã€ SELECT * FROM phone_book WHERE last_name = 'Hoge'
tune 2014/01/12
mysql

db
ãƒªãƒ³ã‚¯
CSVãƒ‡ãƒ¼ã‚¿ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŒ–ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã€ŒCtoDã€ã®ç´¹ä»‹
å‰ã®è¨˜äº‹ã§ã¯CtoDã‚’ä½¿ã£ã¦CSVãƒ‡ãƒ¼ã‚¿ã‹ã‚‰Herokuä¸Šã«Webã‚¢ãƒ—ãƒªã‚’æ§‹ç¯‰ã™ã‚‹æ‰‹é †ã‚’èª¬æ˜Žã—ã¾ã—ãŸã€‚ Excelãƒ‡ãƒ¼ã‚¿ã‚’æœ€é€Ÿã§Webã‚¢ãƒ—ãƒª(Heroku)ã«ã™ã‚‹ï¼‘ï¼ï¼™ã®ã‚¹ãƒ†ãƒƒãƒ— ã“ã“ã§ã¯CtoDã®è©³ç´°ã‚’èª¬æ˜Žã—ã¾ã™ã€‚å¯¾è±¡ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯0.0.3ã§ã™ã€‚ ctoD | RubyGems.org | your community gem host melborne/ctoD ä½¿ã„æ–¹ gem install ctoDã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ã€ctoDã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã‚³ãƒžãƒ³ãƒ‰ãŒä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ã‚µãƒ–ã‚³ãƒžãƒ³ãƒ‰ã‚’æ¸¡ã•ãªã‘ã‚Œã°ãã®ãƒ˜ãƒ«ãƒ—ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ % ctoD Commands: ctoD create_table CSV DATABASE # Create a database table for CSV ctoD export CSV DATABASE # Export CSV data to DATA
tune 2013/11/16
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

database

ruby

db
ãƒªãƒ³ã‚¯
1