[B! db] syqueã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

syque id:syque

dbã«é–¢ã™ã‚‹syqueã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (13)

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

äº‹æ¥ã®æˆé•·ã«ã‚¢ãƒ©ã‚¤ãƒ³ã™ã‚‹ãŸã‚ã«AWS DMSã‚’æ´»ç”¨ã—ã¦DBçµ±åˆã—ãŸè©± - Techtouch Developers Blog
ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å…¼ä¸‡å¹´ãƒ€ã‚¤ã‚¨ãƒƒã‚¿ãƒ¼ã®Â taisaÂ ã§ã™ã€‚æ¯Žæœåã©ã‚‚ã®å¹¼ç¨šåœ’ãƒã‚¹é€ã‚Šã®ã¤ã„ã§ã«çŸè·é›¢ãƒ€ãƒƒã‚·ãƒ¥ã—ã¦é‹å‹•ã—ã¦ã¾ã™ã€‚ã¯ãŸã‹ã‚‰è¦‹ã‚‹ã¨å¤‰ãªäººã§ã™ãŒã€ãƒã‚¹ã‚’è¿½ã£ã‹ã‘ã‚‹ã‚ˆã†ã«ãƒ€ãƒƒã‚·ãƒ¥ã™ã‚‹ã¨å¹¼ç¨šåœ’ãƒã‚¹ã®åã©ã‚‚ãŸã¡ã¯å–œã‚“ã§ãã‚Œã¾ã™ã€‚ ãƒ†ãƒƒã‚¯ã‚¿ãƒƒãƒã¯ä»¥å‰ã€ãƒžã‚¤ã‚¯ãƒã‚µãƒ¼ãƒ“ã‚¹ã®åˆ‡ã‚Šç›´ã—å¾Œã« DB çµ±åˆã‚’å®Ÿæ–½ã—ã¾ã—ãŸã€‚æœ¬è¨˜äº‹ã§ã¯ã€ãƒ†ãƒƒã‚¯ã‚¿ãƒƒãƒãŒã©ã†ã„ã£ãŸãƒ—ãƒã‚»ã‚¹ã§ DB çµ±åˆã‚’å®Ÿæ–½ã—ãŸã‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ã¾ãŸã€AWS DMS ã‚’åˆ©ç”¨ã™ã‚‹éš›ã«æ°—ã‚’ã¤ã‘ã‚‹ãƒã‚¤ãƒ³ãƒˆã«ã¤ã„ã¦ã‚‚åˆã‚ã›ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒžã‚¤ã‚¯ãƒã‚µãƒ¼ãƒ“ã‚¹åˆ‡ã‚Šç›´ã—è¨˜äº‹ã®ãŠã•ã‚‰ã„ ãªãœ DB çµ±åˆã—ãŸã‹ Before After DB çµ±åˆã®å‰ææ¡ä»¶ ã‚„ã‚ŠãŸã„ã“ã¨ åˆ¶ç´„ DB ã®ç‰¹å¾´ ã‚µãƒ¼ãƒ“ã‚¹ã®ç‰¹æ€§ AWS DMSï¼ˆDatabase Migration Serviceï¼‰ã¨ã¯ ã©ã®ã‚ˆã†ã« DB çµ±åˆã—ãŸã‹ Phase1ï¼šDMS ã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é–‹å§‹ã™
syque 2024/10/08
db

blog
ãƒªãƒ³ã‚¯
å…¨ç¤¾å“¡ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿åŸºç›¤ã¸ã®å•ã„åˆã‚ã›ãŒæ®ºåˆ°ã—ã¦2äººã§ã¯æŒã‘ãªããªã£ãŸã®ã§ä»•çµ„ã¿ã§è§£æ±ºã™ã‚‹è©±ã€œdatatech-jp Casual Talks #2 ç™»å£‡å¾Œè¨˜ã€œ - MonotaRO Tech Blog
ãƒ‡ãƒ¼ã‚¿åŸºç›¤ã‚°ãƒ«ãƒ¼ãƒ—ã®å‰æœ¬ã§ã™ã€‚ ä»Šå›žã¯å…ˆæ—¥é–‹å‚¬ã•ã‚ŒãŸdatatech-jp Casual Talksã§ç™»å£‡ã—ãŸå†…å®¹ã«ã¤ã„ã¦è£œè¶³ã‚‚å«ã‚ç´¹ä»‹ã—ã¾ã™ã€‚ datatech-jp.connpass.com ç™ºè¡¨è³‡æ–™ã¯ã“ã¡ã‚‰ã§ã™ã€‚ ãƒ†ã‚™ãƒ¼ã‚¿åŸºç›¤ã«é–¢ã‚ã‚‹å•ã„åˆã‚ã›å¯¾å¿œã‚’ä»•çµ„ã¿ã¦ã‚™è§£æ±ºã™ã‚‹ from æ ªå¼ä¼šç¤¾MonotaRO Tech Team www.slideshare.net ç™ºè¡¨å†…å®¹ã®èƒŒæ™¯ï¼ˆå•ã„åˆã‚ã›å¯¾å¿œã«ãŠã‘ã‚‹èª²é¡Œï¼‰ ç™ºè¡¨ã—ãŸã“ã¨ ç™ºè¡¨ã®åéŸ¿ æœ€å¾Œã« datatech-jpã¯ä¸»ã«ãƒ‡ãƒ¼ã‚¿ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã‚„ãƒ‡ãƒ¼ã‚¿æ´»ç”¨ã«é–¢ã‚ã‚‹æ–¹ãŒå‚åŠ ã™ã‚‹ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã§ã€DWHã‚„ãƒ‡ãƒ¼ã‚¿ãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆã€ãƒ‡ãƒ¼ã‚¿ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã«é–¢ã‚ã‚‹æŠ€è¡“ã€ãƒ„ãƒ¼ãƒ«ãªã©ã«ã¤ã„ã¦çŸ¥è¦‹ã‚’å…±æœ‰ã—ãŸã‚Šã€è¼ªèªä¼šã‚„LTä¼šã®ã‚ˆã†ãªã‚¤ãƒ™ãƒ³ãƒˆã‚’å®Ÿæ–½ã—ã¦ã„ã¾ã™ã€‚ ã‚ªãƒ¼ã‚¬ãƒŠã‚¤ã‚¶ãƒ¼ã¨ã—ã¦åŒç¤¾åŒåƒšã®å‰ç”°(id:syou6162)ãŒå‚åŠ ã—ã¦ã„ã¾ã™ã€‚ ãã®ä¸ã§Casual
syque 2024/09/09
blog

data

db

development

DMBOK
ãƒªãƒ³ã‚¯
dbtã§è¦‹ã‚„ã™ã„ERå›³ã‚’ç”Ÿæˆã™ã‚‹ - yasuhisa's blog
èƒŒæ™¯: dbtã‚’ä½¿ã£ã¦ã„ã¦ã‚‚ERå›³ã¯æ¬²ã—ã„! ã©ã†ã‚„ã£ã¦ERå›³ã‚’ç”Ÿæˆã™ã‚‹ã‹ ã©ã†ã‚„ã£ã¦ERå›³ã‚’è¦‹ã‚„ã™ãã™ã‚‹ã‹ ã¾ã¨ã‚ èƒŒæ™¯: dbtã‚’ä½¿ã£ã¦ã„ã¦ã‚‚ERå›³ã¯æ¬²ã—ã„! dbtã¯ãƒ¢ãƒ‡ãƒ«é–“ã®ãƒªãƒãƒ¼ã‚¸ãªã©å¯è¦–åŒ–ãŒå¾—æ„ãªãƒ„ãƒ¼ãƒ«ã§ã¯ã‚ã‚Šã¾ã™ãŒã€ä¸‡èƒ½ãªã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãƒ¢ãƒ‡ãƒ«ã®ç”ŸæˆéŽç¨‹ãªã©ã¯ãƒªãƒãƒ¼ã‚¸ã§æ‹…ä¿ã§ãã¾ã™ãŒã€åˆ†æžæ™‚ã«ã€Œã©ã‚Œã¨ã©ã®ãƒ¢ãƒ‡ãƒ«ãŒJOINã§ãã¦ã€JOINã™ã‚‹éš›ã®ã‚ãƒ¼ã¯ã“ã‚Œã‚’ä½¿ã£ã¦ã€ã¨ã„ã†ERå›³ã§æ‰±ã†ã‚ˆã†ãªå¯è¦–åŒ–ã¯ãƒ‡ã‚£ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ã§ãã¾ã›ã‚“ã€‚ DWHã‚’ä½œã£ã¦ã„ã‚‹å´ã‹ã‚‰ã™ã‚‹ã¨ã€Œã“ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ã‚ã®è¾ºã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ä¸€ç·’ã«ä½¿ã†ã¨ä¾¿åˆ©ã§ã€ã„ã¤ã‚‚ã‚ã®ã‚ãƒ¼ã§JOINã—ã¦ã€ã¨ã„ã†ã®ãŒé ã®ä¸ã«å…¥ã£ã¦ã„ã‚‹ã“ã¨ãŒå¤šã„ãŸã‚ã€ERå›³ãŒãªãã¦ã‚‚ã©ã†ã«ã‹ãªã‚‹ã“ã¨ã‚‚å¤šã„ã§ã—ã‚‡ã†ã€‚ã—ã‹ã—ã€åˆ†æžã«æ…£ã‚Œã¦ã„ãªã„äººã‚„åˆ†æžã«æ…£ã‚Œã¦ã„ã‚‹äººã§ã‚ã£ã¦ã‚‚ã€æ™®æ®µã¨ç•°ãªã‚‹ãƒ‰ãƒ¡ã‚¤ãƒ³ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è§¦ã‚‹ã¨ãã¯ERå›³ãŒæä¾›ã—ã¦ãã‚Œã‚‹æƒ…å ±ã¯æœ‰ç”¨ã§ã™ã€‚ã¡ãªã¿ã«
syque 2024/02/05
er

dbt

database

db

documentation

uml
ãƒªãƒ³ã‚¯
å‰Šé™¤ãƒ•ãƒ©ã‚°ã®ã¯ãªã—
6. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 8. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 3 honda xxx FALSE
syque 2011/08/10
(ãƒ¡ãƒ¢) â– å‰Šé™¤ãƒ•ãƒ©ã‚°ã®æŒã¡æ–¹ ãƒ»"is_deleted" ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œæˆã—ã¦ç®¡ç† ãƒ»"is_deleted" ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œæˆã—ã¦ç®¡ç†ã€False ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã¯ 1 ä»¶ã®ã¿è¨±å¯ ãƒ»"user_id" ãŒãƒã‚¬ãƒ†ã‚£ãƒ–ãªã‚‰å‰Šé™¤æ¸ˆã¿ã¨è§£é‡ˆã™ã‚‹ ãƒ»å±¥æ´ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã¦ãƒˆãƒª

DB

tips

presentation

slideshare

MySQL

method
ãƒªãƒ³ã‚¯
è‰²ã€…ãªPHPãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ¯”è¼ƒ - cakephperã®æ—¥è¨˜(CakePHP, Laravel, PHP)
PHPãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®é€Ÿåº¦æ¯”è¼ƒã§ã¯ã€HelloWorldã‚’è¡¨ç¤ºã™ã‚‹ã®ã¿ã®å˜ç´”ãªã‚¢ãƒ—ãƒªã‚’ç”¨ã„ãŸè¨ˆæ¸¬ã‚’å…ƒã«æ¯”è¼ƒè¡¨ãŒä½œã‚‰ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ã€‚ç‰¹ã«å¾Œç™ºã®ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã¯åˆ†ã‹ã‚Šã‚„ã™ã„ç‰¹å¾´ä»˜ã‘ã¨ã—ã¦é€Ÿåº¦ã‚’ã‚¢ãƒ”ãƒ¼ãƒ«ã™ã‚‹å‚¾å‘ã«ã‚ã‚‹ãŸã‚ã€ãã®æ¯”è¼ƒè¡¨ã‚’å…ƒã« Nå€é€Ÿã„ã¨ã„ã†ã‚¢ãƒ”ãƒ¼ãƒ«ã‚’ã—ã¦ã„ã¾ã™ã€‚ PHPãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’ä½¿ã†ã¨ã„ã†ã“ã¨ã¯ã€DBã¾ã§çµ¡ã‚ãŸWebã‚¢ãƒ—ãƒªã‚’ä½œã‚‹ã“ã¨ãŒã»ã¨ã‚“ã©ãªãŸã‚ã€HelloWorldã‚¢ãƒ—ãƒªã®æ¯”è¼ƒã‚ˆã‚Šã¯ã€DBã‹ã‚‰ãƒ¬ã‚³ãƒ¼ãƒ‰å–å¾—ã—ã¦è¡¨ç¤ºã™ã‚‹ã¾ã§ã®å‡¦ç†é€Ÿåº¦ã‚’æ¯”è¼ƒã—ãŸã»ã†ãŒã‚ˆã‚Šç¾å®Ÿã«è¿‘ã„æŒ‡æ¨™ã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ç‰¹ã«CakePHP1ç³»ã§ã¯DBã®ãƒ‡ãƒ¼ã‚¿å–å¾—ã‚‚ç‹¬è‡ªãƒ‰ãƒ©ã‚¤ãƒã«ãªã£ã¦ã„ã¾ã™ã—ã€ãƒ¢ãƒ‡ãƒ«ã®å‡¦ç†ã‚‚é‡ã„ã®ã§ãã“ã¾ã§å«ã‚ã¦ä»–ã¨æ¯”è¼ƒã—ãŸã»ã†ãŒè‰¯ã„ã¨æ€ã£ã¦ã¾ã™ã€‚ ä»Šå›žã¯DBã‹ã‚‰1ãƒ¬ã‚³ãƒ¼ãƒ‰å–å¾—ã—ã¦è¡¨ç¤ºã™ã‚‹ã¨ã„ã†ç°¡å˜ãªã‚¢ãƒ—ãƒªã§å„ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®é€Ÿåº¦ã‚’è©•ä¾¡ã—ã¾ã—ãŸã€‚ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã«å‚™ã‚ã£ã¦ã„ã‚‹Viewã‚ãƒ£ãƒƒã‚·ãƒ¥
syque 2011/08/03
(ã‚³ãƒ¡ãƒ³ãƒˆ) CakePHP ã¯æ„å¤–ã¨é…ã„ã‚‰ã—ã„ã€‚ãã‚Œãžã‚Œã®ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã¯ã€ä½•ã‚‰ã‹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã™ã‚‹ã“ã¨ã§é€Ÿåº¦ãŒé€Ÿããªã£ãŸã‚Šã™ã‚‹ã®ã ã‚ã†ã‹ï¼Ÿæœ¬äººã‚‚æ›¸ã„ã¦ã„ã‚‹ã‚ˆã†ã«ã€ã¾ã å©ãå°ã¨ã„ã†ã“ã¨ã§å‚è€ƒç¨‹åº¦ã«ç•™ã‚ã¦ãŠã“ã†

CakePHP

framework

PHP

DB

SQL

performance

report

draft
ãƒªãƒ³ã‚¯
MongoDBå…¨æ©Ÿèƒ½è§£èª¬1
This document contains links to Mongo DB documentation pages about sharding, databases, collections, inserting, querying, updating, indexing, replication, and backups. It includes a link to a slideshare presentation on Mongo DB sharding and links to pages explaining replica set internals and operations.Read less
syque 2011/05/16
MongoDB å…¨æ©Ÿèƒ½è§£èª¬ 1

MongoDB

DB

presentation

reference
ãƒªãƒ³ã‚¯
eoï¼ˆã‚¤ã‚ªï¼‰ | ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚µãƒãƒ¼ãƒˆ
syque 2011/01/17
sqlite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ GUI ã§æ“ä½œã§ãã‚‹ PupSQLite ã®ä½œæˆè€…

sqlite

DB

tool

windows
ãƒªãƒ³ã‚¯
Google Spreadsheets ã‚’ç°¡æ˜“ SQL DB ã«ï¼ã€ŒGoogle Visualization APIã€ - WebOS Goodies
WebOS Goodies ã¸ã‚ˆã†ã“ãï¼ WebOS ã¯ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã®æœªæ¥å½¢ã€‚ã‚ã‚‰ã‚†ã‚‹ Web ã‚µã‚¤ãƒˆãŒç¹‹ãŒã‚Šã€å…±æœ‰ã—ã€å”åŠ›ã—ã¦å‰µã‚Šä¸Šã’ã‚‹ã€ã²ã¨ã¤ã®å·¨å¤§ãªæƒ…å ±ã‚·ã‚¹ãƒ†ãƒ ã§ã™ã€‚ãã“ã§ã¯ã€ã‚ã‚‰ã‚†ã‚‹æƒ…å ±ãŒãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ä¸Šã«è“„ç©ã•ã‚Œã€æˆ‘ã€…ã¯ã„ã¤ã§ã‚‚ã€ã©ã“ã‹ã‚‰ã§ã‚‚ã€å¤šå½©ãªãƒ‡ãƒã‚¤ã‚¹ã‚’ä½¿ã£ã¦ãã‚Œã‚‰ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã¾ã™ã€‚ WebOS Goodies ã¯ã€ã•ã¾ã–ã¾ãªæƒ…å ±æä¾›ã‚„ãƒ„ãƒ¼ãƒ«é–‹ç™ºã‚’é€šã—ã¦ã€ãã‚“ãªä¸–ç•Œã®å®Ÿç¾ã«å°‘ã—ã§ã‚‚è²¢çŒ®ã™ã‚‹ã¹ãæ´»å‹•ã—ã¦ã„ãã¾ã™ã€‚ çš†ã•ã‚“ã€ Google Docs ã®ã‚¬ã‚¸ã‚§ãƒƒãƒˆæ©Ÿèƒ½ã¯ã‚‚ã†ä½¿ã£ã¦ã¿ã¾ã—ãŸã§ã—ã‚‡ã†ã‹ã€‚ãƒ‡ãƒ¼ã‚¿ã‚’ã•ã¾ã–ã¾ãªæ–¹æ³•ã§å¯è¦–åŒ–ã™ã‚‹ã‚¬ã‚¸ã‚§ãƒƒãƒˆã‚’ã‚·ãƒ¼ãƒˆä¸Šã«é…ç½®ã§ãã‚‹ã¨ã„ã†ã‚‚ã®ã§ã€ã“ã®ã‚¬ã‚¸ã‚§ãƒƒãƒˆã¯è‡ªä½œã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ï¼ˆiGoogle ã‚¬ã‚¸ã‚§ãƒƒãƒˆãƒ™ãƒ¼ã‚¹ï¼‰ã€‚ãã®éš›ã«ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®æƒ…å ±ã‚’å–å¾—ã™ã‚‹ãŸã‚ã«ä½¿ã‚ã‚Œã‚‹ã®ãŒã€æœ¬æ—¥ã”ç´¹ä»‹ã™ã‚‹ Google Visualization API ã§
syque 2010/10/05
è¡¨ç¤ºå°‚ç”¨(SELECT)ã ãŒ SQL ã‚¯ã‚¨ãƒªã§ spreadsheet ã®å†…å®¹ã‚’å–å¾—ã§ãã‚‹

google

API

SQL

DB

spreadsheet

javascript
ãƒªãƒ³ã‚¯
MOONGIFT: Â» SQLiteã‚’GUIã§ç®¡ç†ã€ŒSQLite Database Browserã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
SQLiteã¯DLLãƒ•ã‚¡ã‚¤ãƒ«ã ã‘ã§ã™ãã«åˆ©ç”¨ã§ãã‚‹ç°¡æ˜“çš„ãªDBã§ã¯ã‚ã‚‹ãŒã€æ€ã£ã¦ã„ã‚‹ã‚ˆã‚Šã‚‚ã—ã£ã‹ã‚Šã¨å‹•ä½œã—ã¦ãã‚Œã‚‹ã€‚ ä»–ã®DBã®ã‚ˆã†ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚æ‰‹é–“ã‚‚ãªãã™ãã«åˆ©ç”¨ã§ãã‚‹ã®ãŒä¾¿åˆ©ã ã€‚æœ€è¿‘ã¯PHP5ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒã‚‚å¢—ãˆãŸã®ã§ã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¢ãƒƒãƒ—ã™ã‚‹ã ã‘ã§ã™ãã«åˆ©ç”¨ã§ãã‚‹ã¨ã„ã†ã®ã‚‚æ‰‹è»½ã§ã„ã„ã€‚ ãã‚“ãªSQLiteã§ã‚ã‚‹ãŒã€ç®¡ç†ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã¯æ¨™æº–ã§ã¯ç”¨æ„ã•ã‚Œã¦ã„ãªã„ã€‚æ™®åŠã®ãŸã‚ã«ã¯é«˜æ©Ÿèƒ½ã€ã‹ã¤æ‰‹è»½ãªç®¡ç†ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã®å˜åœ¨ã¯æ¬ ã‹ã›ãªã„ã ã‚ã†ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯SQLite Database Browserã€SQLiteã‚’GUIã§æ“ä½œã§ãã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ SQLite Database Browserã‚’ä½¿ã†ã¨ã€GUIãƒ™ãƒ¼ã‚¹ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆã¯ã‚‚ã¡ã‚ã‚“ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¨è¨ˆã‚„ãƒ‡ãƒ¼ã‚¿ã®ç·¨é›†ãŒã§ãã‚‹ã€‚SQLã‚’å®Ÿè¡Œã—ã¦çµæžœã‚’è¦‹ã‚‹ã“ã¨ã‚‚å¯èƒ½ã ã€‚ã‚‚ã¡ã‚ã‚“ã€æ—¥æœ¬èªžã«å¯¾å¿œ
syque 2009/10/29
sqlite

database

SQL

db

Windows

Mac

linux

csv

develop
ãƒªãƒ³ã‚¯
SQLite ControlCenter æ—¥æœ¬èªžç‰ˆ
SQL C Library ã® SQLite ã® DB ã‚’ GUI ã§å‚ç…§ã§ãã‚‹ãƒ„ãƒ¼ãƒ« SQLiteCC (SQLite Control Center) ã‚’æ—¥æœ¬èªžåŒ–ã—ãŸã‚‚ã®ã§ã™ï¼Žæœ¬å®¶ã® SQLiteCC ã§ã¯å¯¾å¿œã—ã¦ã„ãªã„ SQLite3 ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚‚æ‰±ãˆã¾ã™ï¼Ž æœ¬å®¶ SQLiteCC ã®ç‰¹å¾´ æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆï¼Œæ—¢å˜ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã®ä½œæˆãŒå¯èƒ½ è¡¨ãƒ‡ãƒ¼ã‚¿ï¼Œãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ï¼Œã‚¹ã‚ãƒ¼ãƒžï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼Œãƒˆãƒªã‚¬ãƒ¼ã‚’å‚ç…§å¯èƒ½ ã‚°ãƒªãƒƒãƒ‰ä¸Šã§è¡¨ãƒ‡ãƒ¼ã‚¿ã‚’ç·¨é›†å¯èƒ½ æ–‡æ³•è§£æžã«ã‚ˆã‚‹ãƒã‚¤ãƒ©ã‚¤ãƒˆå¯èƒ½ãªã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼æè¼‰ æ—¥æœ¬èªžç‰ˆã®ç‰¹å¾´ æ—¥æœ¬èªžè¡¨ç¤ºã§ãã‚‹ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ è¡¨ã«æ—¥æœ¬èªž (UTF-8/Shift-JIS) ãŒè¡¨ç¤ºã§ãï¼Œè¡¨ã§ç›´æŽ¥å¤‰æ›´ã™ã‚‹éƒ¨åˆ†ã‚‚æ—¥æœ¬èªžãŒé€šã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ ã‚¯ã‚¨ãƒªãƒ¼éƒ¨ã«ã‚‚æ—¥æœ¬èªžãŒä½¿ãˆã¾ã™ï¼Ž SQLiteCC3 ç³»ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚‚æ“ä½œå¯èƒ½ï¼Ž ã‚°ãƒªãƒƒãƒ‰ã‚„ã‚¨ãƒ‡ã‚£ã‚¿éƒ¨ã®ãƒ•ã‚©
syque 2009/10/27
æ—©é€Ÿ DL ã—ã¦ Redmine 0.8.6 ã® DB ã‚’é–‹ã“ã†ã¨ã—ãŸã‚‰è½ã¡ãŸã€‚sqlite3 ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã‹ã‚‰ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®å•é¡Œã¯ç„¡ã„ã¯ãšãªã®ã ãŒã€ã€ã€

sqlite

db

SQL

database

develop

software

tool
ãƒªãƒ³ã‚¯
æ°¸ç¶šåŒ–å¯¾å¿œã®ã‚ªãƒ³ãƒ¡ãƒ¢ãƒªKey-Valueãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹Â·Redis MOONGIFT
ä»¥å‰ã«èªã‚“ã Googleã«é–¢ã™ã‚‹æœ¬ã«ã‚‚åŒã˜ã‚ˆã†ãªæŠ€è¡“ã«é–¢ã™ã‚‹è¨˜è¿°ãŒã‚ã£ãŸï¼ˆã‚¿ãƒ–ãƒ¬ãƒƒãƒˆè¾ºã‚Šã ã‚ã†ã‹ï¼‰ã€‚Googleã§ä½¿ã‚ã‚Œã¦ã„ã‚‹æŠ€è¡“ã¯Googleã ã‹ã‚‰ã“ãï¼ˆåœ§å€’çš„å°æ•°ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã€ãã®éœ€è¦ãªã©ï¼‰ã§ãã‚‹ã“ã¨ã ãŒã€ãã®è«–æ–‡ã‚’å…ƒã«åŒæ§˜ã®æŠ€è¡“ã‚’ä¸€èˆ¬ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚‚åˆ©ç”¨ã§ãã‚‹ãƒ¬ãƒ™ãƒ«ã«è½ã¨ã—è¾¼ã‚“ã§ãã‚Œã‚‹äººãŸã¡ãŒã„ã‚‹ã€‚ ã‚µãƒ¼ãƒã‚’èµ·å‹•ã—ãŸæ‰€ ã‚ªãƒ³ãƒ¡ãƒ¢ãƒªã®Key-Valueãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨è¨€ãˆã°memcachedãŒæœ‰åã ã€‚ã ãŒmemcachedã¯å†èµ·å‹•ã™ã‚Œã°ãã®å†…å®¹ãŒæ¶ˆãˆã¦ã—ã¾ã†ã€‚é€†ã«å¸¸ã«HDDã«æ›¸ãè¾¼ã‚ã°å†…å®¹ã¯ä¿æŒã•ã‚Œã‚‹ãŒã€ãƒ‡ã‚£ã‚¹ã‚¯ã‚¢ã‚¯ã‚»ã‚¹ãŒå¤šããªã£ã¦ã—ã¾ã„åˆ©ç‚¹ãŒæ´»ã‹ã›ãªããªã‚‹ã€‚ãã®ä¸é–“ã‚’æ‹…ã†ã®ãŒRedisã ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯Redisã€æ°¸ç¶šåŒ–ã«ã‚‚å¯¾å¿œã—ãŸã‚ªãƒ³ãƒ¡ãƒ¢ãƒªKey-Valueãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã ã€‚ Redisã¯Key-Valueã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã‚ã‚‹ãŒã€ä¸€
syque 2009/10/04
ram

software

tool

db

Cache
ãƒªãƒ³ã‚¯
SQLiteå…¥é–€:SQLiteã®ãƒ‡ãƒ¼ã‚¿åž‹:SQLiteã§åˆ©ç”¨å¯èƒ½ãªãƒ‡ãƒ¼ã‚¿åž‹
ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¯å€¤ã‚’æ ¼ç´ã™ã‚‹ãŸã‚ã®ã‚«ãƒ©ãƒ ã‚’å®šç¾©ã—ã¾ã™ãŒã€ã©ã®ã‚«ãƒ©ãƒ ã«ã©ã®ã‚ˆã†ãªå€¤ã‚’æ ¼ç´ã™ã‚‹ã‹ã«å¿œã˜ã¦ãƒ‡ãƒ¼ã‚¿åž‹ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã“ã“ã§ã¯ SQLite ã®ã‚«ãƒ©ãƒ ã§æŒ‡å®šå¯èƒ½ãªãƒ‡ãƒ¼ã‚¿åž‹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ æ ¼ç´ã•ã‚Œã‚‹å€¤ã®ãƒ‡ãƒ¼ã‚¿åž‹ å¤šãã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã‚«ãƒ©ãƒ æ¯Žã«ãƒ‡ãƒ¼ã‚¿åž‹ã‚’æŒ‡å®šã—ã¾ã™ã€‚ãã®ç‚ºã€ã‚«ãƒ©ãƒ æ¯Žã«æ ¼ç´ã§ãã‚‹å€¤ãŒæ±ºã‚ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚SQLite ã§ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å®šç¾©ã™ã‚‹æ™‚ã«ã‚«ãƒ©ãƒ æ¯Žã«ãƒ‡ãƒ¼ã‚¿åž‹ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ã¯å¿…é ˆã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãƒ‡ãƒ¼ã‚¿åž‹ã‚’æŒ‡å®šã—ãªã‹ã£ãŸã‚«ãƒ©ãƒ ã«ã¯è‰²ã€…ãªåž‹ã®å€¤ãŒæ ¼ç´ã•ã‚Œã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ãŸã ãƒ‡ãƒ¼ã‚¿åž‹ã‚’æŒ‡å®šã—ãªã‹ã£ãŸå ´åˆã§ã‚‚ã‚«ãƒ©ãƒ ã«æ ¼ç´ã•ã‚ŒãŸå€¤ãŒã©ã‚“ãªãƒ‡ãƒ¼ã‚¿åž‹ãªã®ã‹ã¯åŒºåˆ¥ã—ã¦ã„ã¦ã€ŒNULLã€ã€ŒINTEGERã€ã€ŒREALã€ã€ŒTEXTã€ã€ŒBLOBã€ã®5ç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿åž‹ã«åˆ†é¡žã—ã¾ã™ã€‚ NULL NULLå€¤ INTEGER ç¬¦å·ä»˜æ•´æ•°ã€‚1, 2, 3, 4, 6, or 8 ãƒã‚¤ãƒˆã§æ ¼ç´ R
syque 2009/10/04
db

sqlite

Develop

SQL
ãƒªãƒ³ã‚¯
ã¤ã‚†ã ãã®SQLite
ã‚¹ãƒãƒ³ã‚µãƒ¼ãƒ‰ãƒªãƒ³ã‚¯ SQLite3ã‚’ã¤ã‹ã£ã¦ã¿ã‚ˆã† SQLiteã¨ã¯ http://www.sqlite.org/ ã«ã¯ SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine Â Â SQLiteã¯ã€è‡ªå·±å®Œçµçš„ã§çµ„ã¿è¾¼ã¿å¯èƒ½ãªè¨å®šãŒå¿…è¦ãªã„SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã‚’å®Ÿè£…ã™ã‚‹å°ã•ãªC libraryã§ã™ ã¨ã‚ã‚Šã¾ã™(è¨³ã¯è‡ªåˆ†ãªã‚Šã«ãŒã‚“ã°ã£ã¦ã¿ã¾ã—ãŸ)ã€‚ å€‹äººçš„ã«ã¯ã€SQLiteã¯DBãŒï¼‘ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã§ã™ã®ã§ã€"ãƒ•ã‚¡ã‚¤ãƒ«ã‚’SQLã§æ“ä½œã™ã‚‹ãŸã‚ã®C library" ã¨ã„ã†ã‚«ãƒ³ã‚¸ã§ã™ã€‚ ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãƒ‘ãƒ–ãƒªãƒƒã‚¯ãƒ‰ãƒ¡ã‚¤ãƒ³ã§ã™ã®ã§è‡ªç”±ã«ä½¿ã†äº‹ãŒå¯èƒ½ã§ã™ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒ2ç³»ã¨3ç³»ãŒã‚ã‚Šã¾ã™ãŒã€ä»Šã‹ã‚‰ä½¿ã†ã®ã§ã—ãŸã‚‰3ç³»ã‚’ä½¿ã†
syque 2009/10/04
SQL

Develop

sqlite

db
ãƒªãƒ³ã‚¯
1