[B! SQL] hitrokã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hitrok id:hitrok

SQLã«é–¢ã™ã‚‹hitrokã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

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

æ–°äººãƒ—ãƒã‚°ãƒ©ãƒžå‘ã‘ãƒ»ã‚¹ã‚ãƒ«å‘ä¸Šã®ãŸã‚ã®å…·ä½“çš„ãªã‚¢ãƒ—ãƒãƒ¼ãƒã¨è€ƒãˆæ–¹ - give IT a try
ã¯ã˜ã‚ã«ï¼šã€Œåƒ•ã«ã‚‚ãã‚“ãªé ƒãŒã‚ã£ãŸã€ å…ˆæ—¥ã€è¥¿è„‡.rbï¼†ç¥žæˆ¸.rbã®åˆåŒå‹‰å¼·ä¼šã¨ã—ã¦ã€ŒRailsãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQLå‹‰å¼·ä¼šã€ã‚’é–‹å‚¬ã—ã¾ã—ãŸã€‚ ã“ã®å‹‰å¼·ä¼šã¯å‡ºé¡Œè€…ï¼ˆï¼åƒ•ï¼‰ãŒå‡ºã—ãŸSQLå•é¡Œã‚’ä»–ã®å‚åŠ è€…ãŒè§£ãã€ã¨ã„ã†ã‚¹ã‚¿ã‚¤ãƒ«ã®å‹‰å¼·ä¼šã§ã™ã€‚ å‚åŠ è€…ã®æ–¹ã®ä¸ã«ã¯æœ€è¿‘ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’å§‹ã‚ãŸã€ã¨ã„ã†äººã‚‚ä½•äººã‹ã„ã¾ã—ãŸã€‚ ãã†ã„ã†äººã«ã¨ã£ã¦ã¯å•é¡ŒãŒã¡ã‚‡ã£ã¨é›£ã—ã‹ã£ãŸã®ã§ã€ã¨ãã©ãåƒ•ãŒã‚µãƒãƒ¼ãƒˆã«å›žã£ã¦è³ªå•ã«ç”ãˆãŸã‚Šã€è§£ãæ–¹ã‚’ã‚ã‚‹ç¨‹åº¦æ•™ãˆãŸã‚Šã—ã¦ã„ã¾ã—ãŸã€‚ ã¾ãŸã€è©±ãŒã¡ã‚‡ã£ã¨è„±ç·šã—ã¦ã€Œåƒ•ãŒä½œã£ãŸã“ã‚Œãã‚‰ã„ã®Webã‚¢ãƒ—ãƒªã¯ã€ä¼Šè—¤ã•ã‚“ãªã‚‰ä½•æ™‚é–“ãã‚‰ã„ã§ä½œã‚Œã¾ã™ã‹ï¼Ÿã€ã¿ãŸã„ãªè³ªå•ã‚’å—ã‘ãŸã‚Šã‚‚ã—ã¾ã—ãŸã€‚ ãã®ä¸ã§è¨€ã‚ã‚ŒãŸã®ãŒã€ ã€Œèª¬æ˜Žã•ã‚ŒãŸã‚‰ã‚ã‹ã‚‹ã‘ã©ã€è‡ªåˆ†ä¸€äººã§ã“ã®ç”ãˆã«ãŸã©ã‚Šç€ãã®ã¯ç„¡ç†ã§ã™ã€ ã€Œãˆã£ã€ãã‚“ãªçŸã„æ™‚é–“ã§ä½œã‚Œã‚‹ã‚“ã§ã™ã‹ã€ ã¨ã„ã£ãŸã‚ˆã†ãªã‚³ãƒ¡ãƒ³ãƒˆã§ã™ã€‚ ãã†ã„ã£ãŸã‚³ãƒ¡ãƒ³ãƒˆã‚’èžãã¨ã€ã€Œã‚ãƒ¼ã€åƒ•ã«ã‚‚
hitrok 2017/01/24
ãƒ—ãƒã‚°ãƒ©ãƒž

æ•™è‚²

Rails

SQL
ãƒªãƒ³ã‚¯
ã€SlackÃ—Re:dashã€‘ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ KPIé€šçŸ¥ã‚’ã‚³ãƒ¼ãƒ‰0è¡Œã§å®Ÿç¾ã™ã‚‹ - Gunosyãƒ‡ãƒ¼ã‚¿åˆ†æžãƒ–ãƒã‚°
ãƒ‡ãƒ¼ã‚¿åˆ†æžéƒ¨ã§éƒ¨é•·ã‚’ã—ã¦ã„ã‚‹@cou_zã§ã™ã€‚æœ€è¿‘ã¯LIBROã®ãƒžã‚¤ã‚¯ãƒãƒ•ã‚©ãƒ³ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ©ãƒ¼ã‚’ã‚ˆãè´ã„ã¦ã„ã¾ã™ã€‚ Gunosyã«ãŠã‘ã‚‹ãƒ—ãƒãƒ€ã‚¯ãƒˆæ”¹å–„ã¯ã€ãƒ‡ãƒ¼ã‚¿å¯è¦–åŒ–ã«ã‚ˆã‚‹ç¾çŠ¶æŠŠæ¡ã‹ã‚‰å§‹ã¾ã‚‹ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚ ãƒã‚°ã‚’åŽé›†ã—ã¦ã€ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã§KPI(é‡è¦æ¥ç¸¾æŒ‡æ¨™)ã‚’å¯è¦–åŒ–ã™ã‚‹ã“ã¨ã¯ã€ä»Šã§ã¯å½“ãŸã‚Šå‰ã®ã“ã¨ã«ãªã£ã¦ã„ã‚‹ã¨æ€ã„ã¾ã™ã€‚æ·±å¤œãƒãƒƒãƒã§KPIã‚’é›†è¨ˆã—ã¦ã€ç¿Œæœã«ç¢ºèªã™ã‚‹ã“ã¨ã¯é‡è¦ã§ã™ãŒã€KPIã‚’ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã«çŸ¥ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã€ç¾çŠ¶æŠŠæ¡ãŒã•ã‚‰ã«é€²ã‚€ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ã—ã‹ã—ã€ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã«KPIã‚’é›†è¨ˆã§ããŸã¨ã—ã¦ã‚‚ã€å®Ÿéš›ã«ãã‚Œã‚‰ã‚’ç¢ºèªã™ã‚‹ã¨ã¯é™ã‚Šã¾ã›ã‚“ã€‚é »ç¹ã«ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã‚’è¦‹ã‚‹ã®ã¯ã¨ã¦ã‚‚å„„åŠ«ã§ã€æ¬¡ç¬¬ã«è¦‹ãªããªã£ã¦ã—ã¾ã„ãŒã¡ã§ã™ã€‚ãã“ã§ã€æ—¥å¸¸çš„ã«é–‹ã„ã¦ã„ã‚‹ãƒãƒ£ãƒƒãƒˆã«KPIãŒãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã«é€šçŸ¥ã•ã‚Œã‚‹ã¨ã€ç¢ºèªã®éš›ã®è² æ‹…ã‚’è»½æ¸›ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ Gunosyã§ã¯ã€ãƒãƒ£ãƒƒãƒˆãƒ„ãƒ¼ãƒ«ã«Slackã‚’ãƒ€ãƒƒã‚·ãƒ¥ãƒœ
hitrok 2016/08/26
dash

KPI

slack

SQL

chart
ãƒªãƒ³ã‚¯
SQLiteã‹ã‚‰CSVãƒ•ã‚¡ã‚¤ãƒ«ã«SQLã‚’æŠ•ã’ã¦ã¿ãŸ | DevelopersIO
SQLite3.14(å††å‘¨çŽ‡Ï€ã¨åŒã˜ã§ã™ã!)ãŒ2016/08/08ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ ãƒªãƒªãƒ¼ã‚¹ãƒŽãƒ¼ãƒˆã«ã‚ˆã‚‹ã¨ã€CSVä»®æƒ³ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾å¿œã—ãŸã¨ã‚ã‚Šã¾ã—ãŸã®ã§ã€æ—©é€Ÿä½¿ã£ã¦ã¿ã¾ã—ãŸã€‚ Added the CSV virtual table for reading RFC 4180 formatted comma-separated value files. ã“ã®æ©Ÿèƒ½ã‚’ä½¿ã†ã¨ã€CSVå½¢å¼ã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«SQLã§å•ã„åˆã‚ã›ã‚‹ã¨ã„ã£ãŸã“ã¨ãŒç°¡å˜ã«ã§ãã¾ã™ã€‚ ä»®æƒ³ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¤ã„ã¦ ä»®æƒ³ãƒ†ãƒ¼ãƒ–ãƒ«(Virtual Table)ã¯SQLiteã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ç®¡ç†ã•ã‚Œã¦ã„ãªã„ãƒ‡ãƒ¼ã‚¿ã‚’ä»®æƒ³çš„ã«ç®¡ç†ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã«è¦‹ã›ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã™ã€‚ ä»®æƒ³ãƒ†ãƒ¼ãƒ–ãƒ«ã§ç®¡ç†ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã¯ã€é€šå¸¸ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã¨åŒã˜ã‚ˆã†ã« SQL ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã§æ“ä½œã§ãã¾ã™ã€‚ SQLite ã§ã¯ å…¨æ–‡æ¤œç´¢ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ R-Trees
hitrok 2016/08/17
SQL

sqlite

database
ãƒªãƒ³ã‚¯
TechCrunch | Startup and Technology News
Live Nation says its Ticketmaster subsidiary was hacked. A hacker claims to be selling 560 million customer records. An autonomous pod. A solid-state battery-powered sports car. An electric pickup truck. A convertible grand tourer EV with up to 600 miles of range. A â€œfully connected mobility deviceâ€ for young urban innovators to be built by Foxconn and priced under $30,000. The next Popemobile. Ov
hitrok 2013/09/05
ã„ã¤ã‹ä½¿ã„ãŸã„

amazon

SQL
ãƒªãƒ³ã‚¯
Railsã®deleteã¨destroyã®é•ã„ã‚’ãŠã•ã‚‰ã„ã™ã‚‹ - pochi's weblog
deleteã¨destroyã®é•ã„ã‚’ã¡ã‚‡ã“ã¡ã‚‡ã“å¿˜ã‚Œã‚‹ã®ã§ãƒ¡ãƒ¢ã€‚ delete ActiveRecordã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä»‹ã•ãšã«å‰Šé™¤ã™ã‚‹ã€‚ï¼ˆç›´æŽ¥SQLã‚’ç™ºè¡Œã™ã‚‹ã‚¤ãƒ¡ãƒ¼ã‚¸ï¼‰ ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆåŒå£«ã«ä¾å˜é–¢ä¿‚ãŒãªã„å ´åˆã¯ã“ã£ã¡ã‚’ä½¿ã£ãŸæ–¹ãŒActiveRecordã® ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ç”Ÿæˆã—ãªã„åˆ†æ—©ã„ã€‚ destroy ActiveRecordã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä»‹ã—ã¦å‰Šé™¤ã™ã‚‹ã€‚ ã“ã‚Œã¯ä¾å˜é–¢ä¿‚ã‚‚ä¸€ç·’ã«å‰Šé™¤ã—ãŸã„å ´åˆã«åˆ©ç”¨ã™ã‚‹ã¨ã„ã„ã€‚ destroy_allã‚’å‘¼ã¶ã¨çµæ§‹æ™‚é–“ã‹ã‹ã‚‹ã€‚
hitrok 2013/08/06
MySQL

rails

ActiveRecord

SQL
ãƒªãƒ³ã‚¯
Active Recordã§è¤‡æ•°ã‚«ãƒ©ãƒ ã®AVGã‚’ä¸€ç™ºã§å–å¾—ã™ã‚‹
hitrok 2013/01/10
Rails

SQL
ãƒªãƒ³ã‚¯
Rails3 ã§å¤§é‡ã®ä¸€æ‹¬Insert
ãŒã§ãã‚‹ã‚‰ã—ã„ã€‚ https://github.com/zdennis/activerecord-import ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ã¯ãªã„ã‚ˆã†ãªã®ã§ v0.2.4 ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã‚³ãƒ”ãƒ¼ã€‚Wikiã«è¼‰ã£ã¦ã„ã‚‹ã‚ˆã†ãªä½¿ã„æ–¹ã‚‚ã§ãã‚‹ã‘ã‚Œã©ã€å€‹äººçš„ã«ã¯ columns = [:first_name, :family_name] values Â = [["John", "Smith"], ["Jane", "Due"], ["Gonbe", "Nanashi"]] Person.import columns, values ã®ã‚ˆã†ãªä½¿ã„æ–¹ã®ã»ã†ãŒãƒ¡ãƒ¢ãƒªåŠ¹çŽ‡ãŒã‚ˆã•ã’ã‹ãªã¨ã€‚ æŠ¼ã—ã¦ãã£â†’Bl ogPeopleã€Œè¶£å‘³ã®ä¸–ç•Œã€ãƒ–ãƒã‚°ãƒ©ãƒ³ã‚ãƒ³ã‚°
hitrok 2011/12/07
Rails

SQL
ãƒªãƒ³ã‚¯
1