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

JHashimoto id:JHashimoto

DBã«é–¢ã™ã‚‹JHashimotoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (107)

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

DBMSã‚’Goã§å®Ÿè£…ã—ã¦ã¿ãŸ - Sansan Tech Blog
ã“ã‚“ã«ã¡ã¯ã€‚ãƒ—ãƒãƒ€ã‚¯ãƒˆé–‹ç™ºéƒ¨ã®è’å· id:ad-sho-loko ã§ã™ã€‚çªç„¶ã§ã™ãŒã€çš†ã•ã‚“ã¯ã“ã‚“ãªç–‘å•ã‚’æŒã£ãŸã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…éƒ¨å®Ÿè£…ã¯ã©ã†ãªã£ã¦ã„ã‚‹ã®ã‹ï¼Ÿ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ã©ã®ã‚ˆã†ãªã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã§å®Ÿç¾ã•ã‚Œã¦ã„ã‚‹ã®ã‹ï¼Ÿ NoSQLãŒé…ã„ã®ã¯ãªãœã‹ï¼Ÿ å¤å…¸çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯å†…éƒ¨çš„ã«ã©ã®ã‚ˆã†ã«é•ã†ã®ï¼Ÿ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½•ã‹ã—ã‚‰ã®å½¢ã§åˆ©ç”¨ã—ã¦ã„ã‚‹ã®ã«ã‚‚é–¢ã‚ã‚‰ãšã€æ„å¤–ã¨å†…éƒ¨ã®ä»•çµ„ã¿ã‚’ç†è§£ã—ã¦ã„ãªã„å ´åˆãŒå¤šã„ã‹ã¨æ€ã„ã¾ã™ã€‚åƒ•ã‚‚ãã†ã§ã™ã€‚*1 ã—ã‹ã—ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŸã‚‹ã‚‚ã®ã€ãã®ä»•çµ„ã¿ã‚’çŸ¥ã‚‹ã“ã¨ã¯éžå¸¸ã«é‡è¦ã§ã™ã€‚åƒ•ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¤ã„ã¦å‹‰å¼·ã—ã‚ˆã†ã¨ã„ãã¤ã‹ã®æœ¬ã‚„ã‚µã‚¤ãƒˆã‚’èª¿ã¹ã¦ã„ãŸã®ã§ã™ãŒã€ãªã‹ã§ã‚‚CMUï¼ˆã‚«ãƒ¼ãƒã‚®ãƒ¼ãƒ¡ãƒãƒ³å¤§å¦ï¼‰ã®Database System GroupãŒã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¦ã„ã‚‹è¬›ç¾©ãŒæœ€ã‚‚å‹‰å¼·ã«ãªã‚Šã¾ã—ãŸã€‚ www.youtube.com ãã—ã¦æœ¬ãƒ–ãƒã‚°ã§ã¯ã€ä¸Šè¨˜ã®è¬›ç¾©
JHashimoto 2019/11/05
DB

ã¤ãã£ã¦ã¿ã‚‹
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒæ›´æ–°ãƒ»å‰Šé™¤ã§ã¯ãªãã€å·®åˆ†ã®è¨˜éŒ²ã ã£ãŸã‚‰æ“ä½œãŒè¿½è·¡ã§ãã¦è‰¯ã„ã¨æ€ã†ã®ã§ã™ãŒã€ãã†ã„ã£ãŸå·®åˆ†ç®¡ç†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿã‚ã‚‹ã¨ã—ãŸã‚‰ã€ãªãœä¸€èˆ¬çš„ã«ãªã‚‰ãªã„ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ
JHashimoto 2019/08/03
Quora

DB
ãƒªãƒ³ã‚¯
ã€é€±åˆŠ Ask An Expert #13ã€‘Amazon ElastiCache for Memcached ã«å‰²ã‚Šå½“ã¦ã‚‹ãƒ¡ãƒ¢ãƒªã‚µã‚¤ã‚ºã‚’å¢—ã‚„ã™ã«ã¯!? AWS Loft Tokyo ã§å—ã‘ãŸè³ªå•ã¾ã¨ã‚ #AWSLoft | Amazon Web Services
AWS Startup ãƒ–ãƒã‚° ã€é€±åˆŠ Ask An Expert #13ã€‘Amazon ElastiCache for Memcached ã«å‰²ã‚Šå½“ã¦ã‚‹ãƒ¡ãƒ¢ãƒªã‚µã‚¤ã‚ºã‚’å¢—ã‚„ã™ã«ã¯!? AWS Loft Tokyo ã§å—ã‘ãŸè³ªå•ã¾ã¨ã‚ #AWSLoft ã“ã‚“ã«ã¡ã¯ã€ã‚¹ã‚¿ãƒ¼ãƒˆã‚¢ãƒƒãƒ— ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆã®é‡åŽŸ (Twitter: @_hariby) ã§ã™ã€‚å¥½ããª AWS ã‚µãƒ¼ãƒ“ã‚¹ã¯ Amazon SageMaker, Amazon Rekognition, AWS DeepLens [amazon.co.jp] ã§ã™ã€‚ç›¸å¤‰ã‚ã‚‰ãšé›¨ãŒå¤šãã€7æœˆã«ã—ã¦ã¯æ¶¼ã—ã„æ—¥ãŒç¶šã„ã¦ã„ã¾ã™ãŒçš†ã•ã‚“ã„ã‹ãŒãŠéŽã”ã—ã§ã—ã‚‡ã†ã‹ã€‚ ã•ã¦ã€ä»Šå›žã®é€±åˆŠ Ask An Expert ç¬¬13å›žç›®ã‚’ãŠå±Šã‘ã—ã¾ã™ã€‚ã€Œå‚è€ƒã«ãªã£ãŸã‚ï¼ã€ã€Œãˆãˆå†…å®¹ã‚„ï¼ã€ã¨æ€ã£ã¦ã„ãŸã ã‘ãŸã‚‰ã€ãœã²ãƒãƒƒã‚·ãƒ¥ã‚¿ã‚° #AWSLoft ã‚’ä»˜ã‘ã¦ã‚·ã‚§ã‚¢ã—ã¦
JHashimoto 2019/07/20
"AWS Lambda ã¨ Amazon RDS / Amazon Aurora ã‚’åˆ©ç”¨ã™ã‚‹éš›ã®è€ƒæ…®äº‹é …ã¯ã“ã¡ã‚‰ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã«ã¾ã¨ã¾ã£ã¦ãŠã‚Šã¾ã™ã€‚"

ã‚µãƒ¼ãƒãƒ¼ãƒ¬ã‚¹ã‚¢ãƒ¼ã‚ãƒ†

DB
ãƒªãƒ³ã‚¯
ã€Javaã€‘DBã®å®šç¾©ã‚’åæ˜ ã—ãŸenumã§ã€DBã«ä¿å˜ã™ã‚‹å†…å®¹ã¨enumã®nameãŒé£Ÿã„é•ã£ãŸå ´åˆã¸ã®å¯¾å‡¦ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
JHashimoto 2019/02/08
Enum

DB

ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒˆ
ãƒªãƒ³ã‚¯
DBå¤‰æ›´ãƒªãƒªãƒ¼ã‚¹ã®åœæ¢æ™‚é–“ã‚’æœ€å°åŒ–ã™ã‚‹ã«ã¯ï¼Ÿã€ŒDevOps with Database on AWSã€ #AWSDevDay | DevelopersIO
ã€ŒDevOpsã£ã¦ã‚¢ãƒ—ãƒªã®è©±ã°ã£ã‹ã‚Šãªæ°—ãŒã™ã‚‹ã‘ã©ã€DBã‚‚ã‚¢ãƒ—ãƒªä»¥ä¸Šã«å¤‰æ›´å…¥ã‚‹ã‚ˆãªãã€ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å¤‰æ›´ã‚’ã„ã‹ã«ãƒŽãƒ¼ãƒ€ã‚¦ãƒ³ã‚¿ã‚¤ãƒ ã§æœ¬ç•ªãƒªãƒªãƒ¼ã‚¹ã™ã‚‹ã‹ï¼Ÿã‚¹ãƒ†ãƒ¼ãƒˆï¼ˆãƒ‡ãƒ¼ã‚¿ï¼‰ã‚’æŒã¤ã¨ã„ã†å®¿å‘½ä¸Šã€ãã†ç°¡å˜ã«ã„ã‹ãªã„ã“ã¨ã¯çš†ã•ã‚“æƒ³åƒã¤ãã‹ã¨æ€ã„ã¾ã™ãŒã€ãã®åˆ¶ç´„ã®ä¸ã§ã‚‚å·¥å¤«æ¬¡ç¬¬ã§ã¯åœæ¢æ™‚é–“ã‚’æ¥µå°åŒ–ã™ã‚‹æ–¹æ³•ãŒæœ‰ã‚‹ã‚“ã ãªãã¨æ°—ä»˜ã‹ã•ã‚Œã¾ã—ãŸã€‚ AWS Dev Day Tokyo 2018 | AWSã€ã€ŒDevOps with Database on AWSã€ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ¬ãƒãƒ¼ãƒˆã§ã™ã€‚ ï¼ˆç¥ï¼‰ âˆ§ âˆ§ Yã€€ ( ï¾ŸÐ”ï¾Ÿ) Î¦[_ï½¿__ï½™_lã€‰Â Â Â Â ç„¡åœæ¢DBï¾˜ï¾˜ï½°ï½½ï¾€ï¾žï¾œï½¯ï½¼ï½®ï½² |_|ï¼¿| ã—'Â´ï¼ª ã‚»ãƒƒã‚·ãƒ§ãƒ³å†…å®¹ ã‚¿ã‚¤ãƒˆãƒ«ã¯ã€ŒDevOps with Database on AWSã€ DevOps ã®ã‚¢ãƒ—ãƒãƒ¼ãƒã§ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«å–ã‚Šçµ„ã‚€ä¸Šã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã™ã‚‹å¤‰æ›´ã‚’ã©ã®ã‚ˆã†ã«æ‰±ã†ã‹ã¯é›£ã—ã„å•é¡Œã§ã™ã€‚
JHashimoto 2018/11/05
DB

AWS

DevOps
ãƒªãƒ³ã‚¯
Dbsetupã¨AssertJ-DBã§DBã®ãƒ†ã‚¹ãƒˆ - Qiita
Javaã§DBã®ãƒ†ã‚¹ãƒˆ å®Ÿéš›ã®ãƒ†ã‚¹ãƒˆã§ã‚ã‚“ã©ã„DBã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã®æº–å‚™ã¨DBã®çŠ¶æ…‹ã®ãƒ†ã‚¹ãƒˆã€‚ã“ã‚Œã¾ã§ã¯DBUnitã—ã‹ä½¿ã£ãŸã“ã¨ãªã‹ã£ãŸã‘ã©ã€Dbsetupã§ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’æº–å‚™ã—ã€AssertJ,AssertJ-DBã§DBã®ãƒ†ã‚¹ãƒˆã‚’ã‚„ã£ã¦ã¿ãŸã€‚ DBUnit http://dbunit.sourceforge.net/intro.html ãƒ‡ãƒ¼ã‚¿ã‚’å¤–éƒ¨ãƒ•ã‚¡ã‚¤ãƒ«ã§ç®¡ç†ã—ã¦ã€Assertionã‚‚æœŸå¾…å€¤ã‚’æ ¼ç´ã—ãŸãƒ•ã‚¡ã‚¤ãƒ«ã¨æ¯”è¼ƒã—ã¦æ›¸ã‘ã‚‹ã€‚ // Fetch database data after executing your code IDataSet databaseDataSet = getConnection().createDataSet(); ITable actualTable = databaseDataSet.getTable("TABLE_NAME"); // Load exp
JHashimoto 2018/08/29
Java

DB

TDD
ãƒªãƒ³ã‚¯
ã€è¶…åˆå¿ƒè€…å‘ã‘ã€‘DBUnitè¶…å…¥é–€ - Qiita
ã¯ã˜ã‚ã« ä»Šå›žã¯ã€ãƒ—ãƒã‚°ãƒ©ãƒ é–‹ç™ºã§ã¯å¤§æ´»èºï¼å˜ä½“ãƒ†ã‚¹ãƒˆã§ä½¿ç”¨ã§ãã‚‹ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã€ã€ŒDBUnitã€ã®ä½¿ã„æ–¹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ DBUnitã¨ã¯ã€Javaã§ä½¿ç”¨ã™ã‚‹ãƒ†ã‚¹ãƒ†ã‚£ãƒ³ã‚°ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®ä¸€ã¤ãªã®ã§ã™ãŒã€ç†è€…ãŒå‹‰å¼·ã—ãŸæ„Ÿã˜ã§ã¯ã€è¨˜äº‹ãŒå¤ã‹ã£ãŸã‚Šã€ãã‚Œã ã‘ã§å®Œå…¨ã«äº‹è¶³ã‚Šã‚‹webãŒå°‘ãªã„ã‚ˆã†ã«è¦‹å—ã‘ã‚‰ã‚ŒãŸã®ã§ã€ç†è€…ã®å‚™å¿˜ã¨ã€ã“ã®è¨˜äº‹ã‚’ã”è¦§ã„ãŸã ã„ãŸæ–¹ã¸ã®å…±æœ‰ã‚‚å…¼ãã¦ã€ã“ã¡ã‚‰ã«ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ å‚è€ƒã¨ã—ã¦webã«è³‡æ–™ã‚’è¨˜è¼‰ã„ãŸã ã„ã¦ã„ã‚‹å„ªã—ã„æ–¹ã‚‚ã€ãŸãã•ã‚“ã„ã‚‰ã£ã—ã‚ƒã‚‹ã‚“ã§ã™ã‘ã©ãorz #1. DBUnitã¨ã¯ å…ˆã«ã‚‚è¨˜è¼‰ã—ã¾ã—ãŸãŒã€DBUnitã¨ã¯ã€Javaãƒ—ãƒã‚°ãƒ©ãƒ ã®ãƒ†ã‚¹ãƒ†ã‚£ãƒ³ã‚°ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®ä¸€ã¤ã§ã™ã€‚ ãƒ†ã‚¹ãƒ†ã‚£ãƒ³ã‚°ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã¨èžãã¨ã€XUnitã‚’æƒ³åƒã•ã‚Œã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã®å¯¾è±¡ã¯Javaã§å®Ÿè£…ã—ãŸãƒ—ãƒã‚°ãƒ©ãƒ ã§ã™ã‹ã‚‰ã€ã‚ˆãä½¿ç”¨ã™ã‚‹ã®ã¯JUnitã§ã™ãŒã€DBUnitã‚‚JUnitã¨ä¸€ç·’
JHashimoto 2018/08/29
Java

DB

TDD
ãƒªãƒ³ã‚¯
DbUtilsã§çµæžœã‚»ãƒƒãƒˆã‚’JavaBeansã«ãƒžãƒƒãƒ”ãƒ³ã‚°ã™ã‚‹
åŸºæœ¬çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ã‚¯ã‚»ã‚¹æ–¹æ³•ã®å•é¡Œ Javaã‹ã‚‰ä¸€èˆ¬çš„ãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆä»¥ä¸‹ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨å‘¼ç§°ï¼‰ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã«ã¯ã€ä»¥ä¸‹ã«ç¤ºã™ã‚ˆã†ã«java.sqlãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®Connectionã€Statementã€ResultSetã‚’ä½¿ã†ã®ãŒåŸºæœ¬ã§ã™ã€‚ InitialContextÂ initÂ =Â newÂ InitialContext(Â ); DataSourceÂ dsÂ =Â (DataSource)init.lookup("java:comp/env/jdbc/TestDB"); ConnectionÂ conÂ =Â ds.getConnection(); StatementÂ stÂ =Â con.createStatement(); ResultSetÂ rsÂ =Â st.executeQuery("selectÂ *Â fromÂ it ems;"); â€¦â€¦// rsã‹ã‚‰çµæžœã‚’å–å¾— rs.close(
JHashimoto 2018/08/27
Java

DB
ãƒªãƒ³ã‚¯
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
JHashimoto 2018/08/27
DB

ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
Apache Sparkï¼ˆDataFrame APIï¼Spark SQLï¼‰ã§ã€MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿æ›¸ãã™ã‚‹ - CLOVERðŸ€
Apache Sparkã®DataFrame APIã€Spark SQLã§ã€é€šå¸¸ã®JDBCã‚¢ã‚¯ã‚»ã‚¹å¯èƒ½ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã—ã¦ã‚‚æ“ä½œãŒã§ããã†ãªæ„Ÿã˜ã ã£ãŸã®ã§ã€ã¡ã‚‡ã£ã¨è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ è©³è§£ Apache Spark ä½œè€…: ä¸‹ç”°å€«å¤§,å¸«å²¡ä¸€æˆ,ä»Šäº•é›„å¤ª,çŸ³å·æœ‰,ç”°ä¸è£•ä¸€,å°å®®ç¯¤å²,åŠ åµœé•·é–€å‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: æŠ€è¡“è©•è«–ç¤¾ç™ºå£²æ—¥: 2016/04/29ãƒ¡ãƒ‡ã‚£ã‚¢: å¤§åž‹æœ¬ã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚° (5ä»¶) ã‚’è¦‹ã‚‹ Thrift JDBC/ODBC serverã‚’ä½¿ã‚ãªã„ï¼Ÿãƒ‘ã‚¿ãƒ¼ãƒ³ã£ã½ã„ã§ã™ãŒâ€¦ã€‚ JDBC To Other Databases ãŠé¡Œ ã¾ãšã€å¯¾è±¡ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯MySQLã¨ã—ã¾ã™ã€‚ã¾ãŸã€ãƒ‡ãƒ¼ã‚¿ã®ãƒ†ãƒ¼ãƒžã¯æ›¸ç±ã§ã€bookãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã—ã¾ã™ã€‚ ã“ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã€Apache Sparkã§ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿æ›¸ãã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã¯ã€ã“ã¡ã‚‰ã€‚ CREATE TABLE book( is
JHashimoto 2018/08/09
Spark

DB
ãƒªãƒ³ã‚¯
RDBã¨NoSQLã«ã¿ã‚‹DBè¿‘ç¾ä»£å² ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç ´å£Šçš„ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã¯äºŒåº¦èµ·ãã‚‹ã‹ï¼Ÿ - ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢Hubï½œè‹¥æ‰‹Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ã‚ãƒ£ãƒªã‚¢ã‚’è€ƒãˆã‚‹ï¼
ã€Œãƒ¦ãƒ¼ã‚¶ãƒ¼ç›®ç·šã€ã®ã‚·ã‚¹ãƒ†ãƒ ã‚’ç›®æŒ‡ã—ã¦ RDBãŒå¾“æ¥ã®éšŽå±¤åž‹DBã«æ¯”ã¹ã¦å„ªã‚Œã¦ã„ãŸç‚¹ã¯ã„ãã¤ã‹æŒ™ã’ã‚‹ã“ã¨ãŒã§ãã¾ã™ãŒã€ã‚·ã‚§ã‚¢ã‚’ä¼¸ã°ã™ã†ãˆã§æœ€ã‚‚å¤§ããªå½±éŸ¿ã¯ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒä½¿ã„ã‚„ã™ã„ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã¨ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã«ã“ã ã‚ã£ãŸã“ã¨ã§ã™ã€‚ã™ãªã‚ã¡ã€ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã€ã¨ã€ŒSQLã€ã®ç™ºæ˜Žã§ã™ã€‚ RDBã§ã¯ã€ã™ã¹ã¦ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã€ã¨ã„ã†ãŸã ä¸€ã¤ã®ãƒ‡ãƒ¼ã‚¿å½¢å¼ã«ã‚ˆã£ã¦è¡¨ç¾ã—ã¾ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ã€è¦‹ãŸç›®ãŒã€ŒäºŒæ¬¡å…ƒè¡¨ã€ã«ä¼¼ã¦ã„ã‚‹ãŸã‚*3ã€Microsoft Excelã‚„Google ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãªã©ã®ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’ä½¿ã„æ…£ã‚ŒãŸäººãŒè¦‹ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹æ–¹æ³•ãŒç›´è¦³çš„ã«ã‚¤ãƒ¡ãƒ¼ã‚¸ã—ã‚„ã™ã„ã¨ã„ã†åˆ©ç‚¹ãŒã‚ã‚Šã¾ã™ã€‚å®Ÿéš›ã€ã“ã†ã—ãŸäºŒæ¬¡å…ƒè¡¨ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ç®¡ç†ã¯ã€Excelãªã©ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãŒç™»å ´ã™ã‚‹å‰ã‹ã‚‰ä¸€èˆ¬çš„ãªæ–¹æ³•ã ã£ãŸãŸã‚ã€RDBãŒç™»å ´ã—ãŸå½“æ™‚ã®äººã€…ã«ã¨ã£ã¦ã‚‚å—ã‘å…¥ã‚Œã‚„ã™ã„ã‚‚ã®ã§ã—ãŸã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ãŒç”»æœŸçš„ã ã£ãŸç‚¹ã¯ã€ã‚‚ã†ä¸€ã¤ã‚ã‚Šã¾ã™ã€‚
JHashimoto 2017/11/24
DB

ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£
ãƒªãƒ³ã‚¯
Javaã§ã®DBã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ä½œæˆã¯DbSetupãŒæ¥½ - Qiita
Javaã§ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ä½œæˆã«ã¯DBUnitãŒã‚ˆãä½¿ã‚ã‚Œã¾ã™ãŒã€è‡ªåˆ†ã¯DbSetupã‚’ã‚ªã‚¹ã‚¹ãƒ¡ã—ã¾ã™ã€‚ DbSetup ãªãœDBUnitãŒã‚¤ãƒžã‚¤ãƒãªã®ã‹ è‡ªåˆ†ã‚‚æœ€åˆã¯DBUnitã‚’ä½¿ã£ã¦ãŸã®ã§ã™ãŒã€ä»¥ä¸‹ã®ç†ç”±ã‹ã‚‰ã—ã£ãã‚Šæ¥ã¾ã›ã‚“ã§ã—ãŸã€‚ DBã‚’ä½¿ã£ãŸãƒ†ã‚¹ãƒˆã§ã¯å°‘é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä½¿ã†ã“ã¨ãŒå¤šã„ ãƒ›ãƒ¯ã‚¤ãƒˆãƒœãƒƒã‚¯ã‚¹ãƒ†ã‚¹ãƒˆã§å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä½¿ã†ã“ã¨ã¯ã»ã¨ã‚“ã©ãªãã€å˜ä¸€ã¾ãŸã¯è¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã€å°‘é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç”¨æ„ã™ã‚‹ã‚±ãƒ¼ã‚¹ãŒã»ã¨ã‚“ã©ã§ã™ã€‚ãªã®ã§ã€ãƒ†ã‚¹ãƒˆã”ã¨ã«ãƒ•ã‚¡ã‚¤ãƒ«(XML or Excel)ã‚’ç”¨æ„ã™ã‚‹ã®ã¯é¢å€’ã§ã™ã€‚ ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã¨ãƒ‡ãƒ¼ã‚¿ãŒåˆ†é›¢ã—ã¦ã„ã‚‹ ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’å¤–éƒ¨ãƒ•ã‚¡ã‚¤ãƒ«ã«ä¿å˜ã™ã‚‹ãŸã‚ã€ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã¨ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ãŒåˆ†é›¢ã—ã¦ã—ã¾ã£ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚ã€ä½•ã‚’ãƒ†ã‚¹ãƒˆã—ã¦ã„ã‚‹ã®ã‹ãŒåˆ†ã‹ã‚Šè¾›ã„ã§ã™ã€‚ ãã“ã§DbSetup ãã“ã§è¦‹ã¤ã‘ãŸã®ãŒDbSetupã§ã™ã€‚DbSetupã¯ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’J
JHashimoto 2017/05/03
Java

DB

TDD
ãƒªãƒ³ã‚¯
404 Not Found
JHashimoto 2016/11/14
DB

TDD
ãƒªãƒ³ã‚¯
GitHub - alexpodlesny/DBTestDriven: http://www.DBTestDriven.com
JHashimoto 2016/11/14
DB

TDD
ãƒªãƒ³ã‚¯
å˜ä½“ãƒ†ã‚¹ãƒˆã‚’ä½¿ç”¨ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ã‚³ãƒ¼ãƒ‰ã®æ¤œè¨¼
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å˜ä½“ãƒ†ã‚¹ãƒˆã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ™ãƒ¼ã‚¹ãƒ©ã‚¤ãƒ³ã¨ãªã‚‹çŠ¶æ…‹ã‚’è¨å®šã—ãŸå¾Œã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã«å¯¾ã—ã¦ãã‚Œä»¥é™è¡Œã†å¤‰æ›´ã‚’æ¤œè¨¼ã§ãã¾ã™ã€‚ ãƒ™ãƒ¼ã‚¹ãƒ©ã‚¤ãƒ³çŠ¶æ…‹ã‚’ç¢ºç«‹ã™ã‚‹å‰ã«ã€ã¾ãšãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œæˆã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ãƒ†ã‚¹ãƒˆ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œæˆã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’å®Ÿè¡Œã™ã‚‹ä¸€é€£ã® Transact-SQL ãƒ†ã‚¹ãƒˆã‚’è¨˜è¿°ã—ã¾ã™ã€‚ ã“ã‚Œã‚‰ã®ãƒ†ã‚¹ãƒˆã‚’ä½¿ç”¨ã—ã¦ã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã«ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ãƒã‚§ãƒƒã‚¯ã‚¤ãƒ³ã™ã‚‹å‰ã«ã€å‹•ä½œãŒæ£ã—ã„ã‹ã©ã†ã‹ã‚’åˆ†é›¢é–‹ç™ºç’°å¢ƒã§æ¤œè¨¼ã§ãã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã«å¯¾ã™ã‚‹å¤‰æ›´ã‚’æ¤œè¨¼ã™ã‚‹ãƒ†ã‚¹ãƒˆã‚’ä½œæˆã§ãã¾ã™ã€‚ ã•ã‚‰ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é–¢æ•°ã€ãƒˆãƒªã‚¬ãƒ¼ã€ãŠã‚ˆã³ã‚¹ãƒˆã‚¢ãƒ‰ ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’ãƒ†ã‚¹ãƒˆã™ã‚‹ Transact-SQL ã‚³ãƒ¼ãƒ‰ã®ã‚¹ã‚¿ãƒ–ã‚’è‡ªå‹•çš„ã«ç”Ÿæˆã§ãã¾ã™ã€‚ æ³¨æ„ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å˜ä½“ãƒ†ã‚¹ãƒˆã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’é–‹ã‹ãšã«ä½œæˆãŠã‚ˆã³å®Ÿè¡Œã§ã
JHashimoto 2016/11/14
Visual Studio

DB

TDD
ãƒªãƒ³ã‚¯
Database Unit Testing with Team Edition for Database Professionals
JHashimoto 2016/11/14
Visual Studio

DB

TDD
ãƒªãƒ³ã‚¯
tSQLt - Database Unit Testing for SQL Server
Unit testing has been a common and accepted practice in application development for a long time. By testing certain functions and areas â€“ or units â€“ of code, it verifies those functions work as expected, and improves the quality of code. tSQLt brings the same advantages to SQL Server database development, and is compatible with all editions of SQL Server from the 2005 Service Pack 2 edition onward
JHashimoto 2016/11/14
â€œOn this website you will find the information necessary for installing and using tSQLt. Also, you can click on the Articles link on the menu above for more information on database quality.â€

DB

TDD
ãƒªãƒ³ã‚¯
mojoPortal Setup
JHashimoto 2016/09/07
DB

TDD
ãƒªãƒ³ã‚¯
https://www.devdashboard.com/273/access-database-content-from-a-web-page-using-javascript-and-cors
JHashimoto 2016/08/16
â€œWith the growing trend of developing Single Page Applications(SPA), client side database access is an important area. With restdb.io it is easy to create CORS enabled API-keys for client database access.â€

JavaScript

REST

DB
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã‚’htmlå½¢å¼ã§è‡ªå‹•ç”Ÿæˆã™ã‚‹ - Qiita
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã£ã¦ã©ã†ã‚„ã£ã¦ä½œã£ã¦ã„ã¾ã™ã‹ï¼Ÿ æš–ã‹ã¿ã®ã‚ã‚‹æ‰‹ä½œã‚Šã®excel ãã—ã¦å®Ÿéš›ã®CREATE TABLEæ–‡ã‚’ä¿å˜ã—ã¦ã„ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã®ä¹–é›¢ãŒå¿ã³å¯„ã‚Š... ERWinã‚„SI Object Browserã®ã‚ˆã†ãªå•†ç”¨è£½å“ã‚’ä½¿ã† ãã“ãã“ãŠé‡‘ã‹ã‹ã‚‹ & GUIå‰æãªã®ã§ã¯? & ã‚ã¨ãã‚Œgitã¨ã‹ã§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã§ãã‚“ã®? CSE, pgAdmin, A5:SQL Mk-2 ã®ã‚ˆã†ãªæ–°æ—§ã•ã¾ã–ã¾ãªãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã‚’ä½¿ã† UNIXç³»OSã§å®Ÿè¡Œã§ãã¦ã€ã‹ã¤ã€GUIã˜ã‚ƒãªãCLIã§ãªã„ã¨ã€Jenkinsç‰ã®CIã‚µãƒ¼ãƒä¸Šã§ã®è‡ªå‹•å®Ÿè¡ŒãŒé›£ã—ã„ã§ã™ã‚ˆã è»Ÿå¼±è€…ã‚ã€‚CREATEæ–‡ã‚„ALTERæ–‡ã®SQLã•ãˆæ»å®ˆã—ã¦ãŠã‘ã°ã€ã‚ã¨ã¯ä¾‹ãˆã°mysqlã® show tables, show create table foobar ã¿ãŸã„ãªã‚³ãƒžãƒ³ãƒ‰ã‚’ãã®éƒ½åº¦ãŸãŸã‘ã°æ¸ˆã‚€è©±ã ã‚ã€‚ ãã‚‚ãã‚‚ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸
JHashimoto 2016/08/01
â€œã©ã“ã§ã§ã‚‚ãŸã„ã¦ã„ä½¿ãˆã‚‹æ–¹æ³•ã®ä¸€ã¤ãŒã€å®Ÿéš›ã«ç¨¼åƒã—ã¦ã„ã‚‹DBã‚µãƒ¼ãƒã®ãƒ¡ã‚¿æƒ…å ±ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦å…¨è‡ªå‹•ã§ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’é€†èµ·ã“ã—ã™ã‚‹æ‰‹æ³•ã§ã™ã€‚ DBFluteã¨ã„ã†Javaã®O/Rãƒžãƒƒãƒ‘ã«ã¯ã€ãã‚“ãªæ©Ÿèƒ½ãŒä»˜å±žã—ã¦ã„ã¾ã™ã€‚â€

Java

DBFlute

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