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

mut00tum id:mut00tum

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

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

ã€Žãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿åˆ†æžãƒ»æ´»ç”¨ã®ãŸã‚ã®SQLãƒ¬ã‚·ãƒ”ã€ã¯ãƒ‡ãƒ¼ã‚¿åˆ†æžã§SQLã‚¯ã‚¨ãƒªã‚’å©ãäººãªã‚‰å¿…èªã®é»’é”è¡“å¤§å…¨ - æ¸‹è°·é§…å‰ã§åƒããƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ãƒ†ã‚£ã‚¹ãƒˆã®ãƒ–ãƒã‚°
ã“ã¡ã‚‰ã®æœ¬ã‚’ã”æµè´ˆã„ãŸã ãã¾ã—ãŸã€‚ ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿åˆ†æžãƒ»æ´»ç”¨ã®ãŸã‚ã®SQL ãƒ¬ã‚·ãƒ” ä½œè€…: åŠ åµœé•·é–€,ç”°å®®ç›´äººå‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: ãƒžã‚¤ãƒŠãƒ“å‡ºç‰ˆç™ºå£²æ—¥: 2017/03/27ãƒ¡ãƒ‡ã‚£ã‚¢: Kindleç‰ˆã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚°ã‚’è¦‹ã‚‹ ä¸€èˆ¬çš„ãªSQLã®æœ¬ã¨ã„ã†ã®ã¯DBç®¡ç†ã®ä¸€ç’°ã¨ã—ã¦ã®ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã®æŠ€è¡“æ›¸ã§ã‚ã‚‹ã“ã¨ãŒå¤šãã€æ„å¤–ã«ã‚‚ãƒ‡ãƒ¼ã‚¿åˆ†æžã‚’ä¸»ç›®çš„ã¨ã—ãŸSQLã®ä½¿ã„æ–¹ã‚„ã‚¯ã‚¨ãƒªã®å·¥å¤«ã®ä»•æ–¹ã«ã¤ã„ã¦æ›¸ã‹ã‚ŒãŸæœ¬ã¨ã„ã†ã®ã¯ã‚ã¾ã‚Šå¤šããªã„ã‚“ã§ã™ã‚ˆãã€‚æ•…ã«ã€å¤šãã®ãƒ‡ãƒ¼ã‚¿åˆ†æžè€…ã¯é›£è§£ãªãƒ†ãƒ¼ãƒžã‚’å®Ÿç¾ã™ã‚‹ã‚¯ã‚¨ãƒªã‚’æ›¸ããŸãã¦ã‚‚å‚è€ƒã«ãªã‚‹è³‡æ–™ãŒä¹ã—ãã€é€”æ–¹ã«æš®ã‚Œã‚‹ã‚ã‘ã§ã™ã€‚åƒ•ã‚‚Hive / Redshift / BigQueryã®ã‚¯ã‚¨ãƒªã‚’æ›¸ããªãŒã‚‰ã€Œã“ã‚“ãªåˆ†æžãŒã—ãŸã„ã‚“ã ã‘ã©ã€ãã‚Œã‚’å®Ÿç¾ã§ãã‚‹ã‚¯ã‚¨ãƒªã£ã¦ãªã„ã‚ˆãªãã€‚ã€‚ã€‚ã€ã¨ä½•åº¦å¤©ã‚’ä»°ã„ã ã“ã¨ã‹ã€‚ ãã‚“ãªã¨ã“ã‚ã«çªç„¶é™ã£ã¦æ¹§ã„ã¦ããŸã®ãŒã“ã¡ã‚‰ã®æ–°åˆŠæ›¸ã€‚ã‚‚ã†ç›®æ¬¡ã‚’è¦‹ãŸã
mut00tum 2017/04/18
SQL

DB
ãƒªãƒ³ã‚¯
ãã®é¸æŠžã€ã¡ã‚‡ã£ã¨å¾…ã£ãŸï¼NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ä¹—ã‚Šæ›ãˆã‚‹å‰ã«æ¤œè¨Žã™ã¹ã3ã¤ã®ãƒã‚¤ãƒ³ãƒˆ
æœ€è¿‘ã€ã©ã†ã‚‚å®‰æ˜“ã«ã€ŒNoSQLã«ã™ã‚Œã°åŽ„ä»‹ãªDBè¨è¨ˆã‹ã‚‰é–‹æ”¾ã•ã‚Œã‚‹ã€ã¨è€ƒãˆã¦ã„ã‚‹äººãŒå¤šã„ã‚ˆã†ã«æ€ãˆã¦ä»•æ–¹ãŒãªã„ã€‚ã ãŒå¾…ã£ã¦æ¬²ã—ã„ã€‚æœ¬å½“ã«NoSQLã¨å‘¼ã°ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ãˆã°ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™ºãƒ»é‹ç”¨ã®è‹¦ã—ã¿ã‹ã‚‰é€ƒã‚Œã‚‰ã‚Œã‚‹ã®ã ã‚ã†ã‹ã€‚ã‚‚ã¡ã‚ã‚“ã€Œãã‚“ãªã“ã¨ã¯ç„¡ã„ï¼ï¼çµ¶å¯¾ã«ã ï¼ï¼ã€ã¨ç§ã¯è€ƒãˆã‚‹ã€‚ä»Šæ—¥ã¯ãã®ç†ç”±ã«ã¤ã„ã¦èªžã‚ã†ã¨æ€ã†ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å…ˆæ—¥ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã‘ã‚‹DBè¨è¨ˆã«ã¤ã„ã¦ã‚»ãƒŸãƒŠãƒ¼ã§è§£èª¬ã—ãŸã°ã‹ã‚Šã ãŒã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ã®æ•´åˆæ€§ã¯ä½•ã‚‚DBè¨è¨ˆã ã‘ãŒæ‹…ä¿ã—ã¦ã„ã‚‹ã‚ã‘ã§ã¯ãªã„ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã¨åŒã˜ã‹ãã‚Œä»¥ä¸Šã«æ¬ ã‹ã›ãªã„ã®ãŒãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒã‚ã‚‹ãŠã‹ã’ã§ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³çµ‚äº†å¾Œã®ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ã¯ã€ŒæˆåŠŸã€ã‹ã€Œå¤±æ•—ã€ã®2ã¤ã—ã‹ãªã„ã¨ã„ã†ã“ã¨ãŒä¿è¨¼ã•ã‚Œã‚‹ã€‚ã™ãªã‚ã¡ã‚ªãƒ¼ãƒ«ãƒ»ã‚ªã‚¢ãƒ»ãƒŠãƒƒã‚·ãƒ³ã‚°ã ã€‚ã‚‚ã—ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®é€”ä¸ã§ä½•ã‚‰ã‹ã®
mut00tum 2016/01/26
DB

MongoDB
ãƒªãƒ³ã‚¯
Amazon.co.jp: åŸºç¤Žã‹ã‚‰ã®MySQL æ”¹è¨‚ç‰ˆ (åŸºç¤Žã‹ã‚‰ã‚·ãƒªãƒ¼ã‚º): è¥¿æ²¢å¤¢è·¯: æœ¬
mut00tum 2015/11/02
MySQL

æœ¬

DB
ãƒªãƒ³ã‚¯
ã‚¢ãƒ—ãƒªã‚’ä½œã‚‹ã¨ãã«æ°—ã‚’ã¤ã‘ãŸã‹ã£ãŸDBè¨è¨ˆã®ã“ã¨ - ãƒãƒ§ãƒ¢ãƒ©ãƒ³ãƒžã«ç™»ã‚‹ã«ã¯ã€‚
ã“ã‚“ã«ã¡ã¯ã€‚ æœ€è¿‘ç§‹æ™´ã‚Œã®æ—¥ãŒç¶šã„ã¦æ°—æŒã¡ãŒã„ã„ã§ã™ãã€‚ ç´…è‘‰ãŒå¾…ã¡é ã—ã„ã§ã™ã€‚ mineæ”¹ä¿®ã®é€²æ—çŠ¶æ³ ã•ã¦åƒ•ã®ä¸€ã¤ç›®ã®ã‚¢ãƒ—ãƒªã€mineã®æ”¹ä¿®ä½œæ¥ã‚’åˆã‚ã¦ä½•é€±é–“çµŒã¡ã¾ã—ãŸã§ã—ã‚‡ã†ã‹ã€‚ å‰²ã¨æ—©ãçµ‚ã‚ã‚‹ã‹ãªã¨æ€ã„ãã‚„ã€çµå±€ãšã‚‹ãšã‚‹ã¨æ™‚é–“ãŒã‹ã‹ã£ã¦ã„ã¾ã™ã€‚ çµå±€ä½•ã«æ™‚é–“ãŒã‹ã‹ã‚‹ã®ã‹ã¨ã„ã†ã¨ã€ãƒ‡ãƒ¼ã‚¿ã®ç§»è¡Œã¨ã‹ã€å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨ã®å…¼ãåˆã„ã‚’è€ƒæ…®ã—ãªã„ã¨ã„ã‘ãªã„ç‚¹ãªã‚“ã§ã™ãã€‚ å‰ã‹ã‚‰ä½¿ã£ã¦ã„ã‚‹äººãŒä»Šå›žã®å¤§è¦æ¨¡ãªã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã«ã‚ˆã£ã¦ä½¿ãˆãªããªã£ãŸã‚Šã€ãƒ‡ãƒ¼ã‚¿ãŒãŠã‹ã—ããªã£ãŸã‚Šã—ãªã„ã‚ˆã†ã«æ°—ã‚’ã¤ã‘ãªãã¦ã¯ã„ã‘ã¾ã›ã‚“ã€‚ ã“ã®ç‚¹ã§ã¯å…ˆã«ãƒãƒ£ãƒƒãƒˆãƒŽãƒ™ãƒ«ã§çµæ§‹ã‚„ã‚‰ã‹ã—ã¦ã—ã¾ã£ãŸã®ã§ã€ä½™è¨ˆã«ã³ã³ã£ã¦ã„ã¾ã™ã€‚ ã§ã‚‚æ™®é€šã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆãªã‚‰åˆ¥ã«ãã‚“ãªæ°—ã«ã™ã‚‹ã“ã¨ã¯ãªã„ã¨æ€ã†ã‚“ã§ã™ã€‚ ã˜ã‚ƒã‚ãªãœåƒ•ã¯ã“ã‚“ãªã«æ°—ã‚’ä½¿ã£ã¦ã„ã‚‹ã‹ã¨ã„ã†ã¨ã€ä½œã‚‹ã¨ãã«ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã®è¨è¨ˆã‚’é–“é•ãˆã¦ã—ã¾ã£ãŸã‚“ã§ã™ã€‚ ã¤ã¾ã‚Šãƒ‡ãƒ¼ã‚¿ã‚’ã©ã†æ‰±ã†ã‹ã£ã¦ã„ã†ã¨ã“ã‚
mut00tum 2015/10/16
DB
ãƒªãƒ³ã‚¯
Realm for Swift ã¾ã¨ã‚å®Œå…¨ç‰ˆ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
mut00tum 2015/08/18
Realm

DB

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
ç›®çš„ã®RealmDBã®ä¸èº«ã‚’RealmBrowserã§ä¸€çž¬ã§é–‹ãæ–¹æ³• - Qiita
Realmé–¢é€£ã®å°ãƒã‚¿ã§ã™ã€‚ iOSã‚·ãƒŸãƒ¥ãƒ¬ãƒ¼ã‚¿ã§ã‚¢ãƒ—ãƒªã‚’é–‹ç™ºã—ã¦ã„ã‚‹æ™‚ã«RealmDBã®ä¸èº«ã‚’ä¸€çž¬ã§ç¢ºèªã§ãã¾ã™ã€‚ æ‰‹å…ƒã®ç’°å¢ƒ Xcode 6.3.1 ã§å‹•ä½œç¢ºèªã—ã¾ã—ãŸã€‚ãã‚Œä»¥å¤–ã®ç’°å¢ƒã§ã®å‹•ä½œç¢ºèªã¯è¡Œã£ã¦ã„ã¾ã›ã‚“ã€‚ æº–å‚™1: Realm Browser ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« 2015/07/27 æ›´æ–° Realm Browser ãŒ Mac App Store ã‹ã‚‰DLå¯èƒ½ã«ãªã‚Šã¾ã—ãŸï¼ï¼ï¼ ã‚„ã‚‹ã“ã¨ï¼šRealm Browser ã‚’ãƒ‘ã‚¹ãŒé€šã£ãŸã¨ã“ã‚ã«é…ç½®ã™ã‚‹ 1. http://realm.io/ ã‹ã‚‰ Objective-C ã‚ã‚‹ã„ã¯ Swift ç”¨ã®zipãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ 2. zipã‚’è§£å‡ã—ã¦ã€browser ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã®ä¸ã«ã‚ã‚‹ "Realm Browser" ã‚’ãƒ‘ã‚¹ãŒé€šã£ãŸã¨ã“ã‚ã«é…ç½®ã™ã‚‹ï¼ˆä¾‹ãˆã°ã€/Applications) 4. Finder ã‹ã‚‰ "Realm
mut00tum 2015/08/18
Realm

DB

ã‚¢ãƒ—ãƒª
ãƒªãƒ³ã‚¯
SwiftDataã‚’å¾¹åº•çš„ã«è§£èª¬ï¼ã“ã‚Œã§DBæ€–ããªã„ï¼ï¼ˆæ°¸ä¹…ä¿å˜ç‰ˆï¼‰ | 3URPRISE.BLOG
ã©ã†ã‚‚3urpriseã®ãƒ¤ãƒžã‚µã‚ã§ã™ã€‚ ã‚¿ã‚¤ãƒˆãƒ«ã«ã‚ã‚‹é€šã‚Šç§ã®è‹¦æ‰‹ãªDBã‚’å…‹æœã™ã‚‹ã¹ãæµè¡Œã‚Šã®SwiftDataã‚’å¾¹åº•è§£èª¬ã—ã¾ã™ã€‚ ã¾ã•ã«æ°¸ä¹…ä¿å˜ç‰ˆãªã®ã§ç§å«ã‚ãŸåˆå¿ƒè€…ã¯ç©´ãŒã‚ãã»ã©çœºã‚ã‚‹ã®ã‚’ãŠå‹§ã‚ã—ã¾ã™ã€‚ SwiftDataã¨ã¯ Objective-Cæ™‚ä»£ã«DBã¨ã‚’ä½¿ã†ã¨è¨€ãˆã°CoreDataã‹SQLiteã®FMDBãŒä¸»æµã ã£ãŸã¨æ€ã„ã¾ã™ã€‚ ï¼ˆã‚ãã¾ã§ä¸»è¦³ã§ã™ã€ã¡ãªã¿ã«ç§ãŸã¡ã®ä½œæˆã‚¢ãƒ—ãƒª iDrawer ã¯SQLiteã®FMDBã‚’ä½¿ã£ã¦ã„ã¾ã™ï¼‰ SwiftData : å•†ç”¨å¯èƒ½ , ç„¡æ–™ , SQLiteãƒ©ãƒƒãƒ‘ãƒ¼ ,Â è¨˜è¿°ãŒå°‘ã—ã§æ¸ˆã‚€ ã†ã€œã‚“ã€æœ€é«˜ã§ã™ãã€‚ä½¿ã‚ãªã„è¨³ãŒç„¡ã„ã€‚ é–‹ç™ºè€…æ§˜ã€ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ï¼ ãã‚Œã§ã¯ç°¡å˜ãªèª¬æ˜Žã‚‚çµ‚ã‚ã‚Šã¾ã—ãŸã®ã§æœ¬é¡Œã®è§£èª¬ã«å…¥ã‚Šã¾ã™ã€‚ ã¾ãšã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚²ãƒƒãƒ„ã—ã¾ã™ã€‚ https://github.com/ryanfowler/SwiftData å³ä¸‹ã®ZI
mut00tum 2015/08/08
SQLite

DB

Swift
ãƒªãƒ³ã‚¯
SQLiteå…¥é–€
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã® SQLite ã®ä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ SQLite ã¯ã‚µãƒ¼ãƒã¨ã—ã¦å‹•ä½œã•ã›ã‚‹ã®ã§ã¯ãªãå˜ç‹¬ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã—ã¦å‹•ä½œã•ã›ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚ç°¡å˜ãªä¸Šã«éžå¸¸ã«ã‚³ãƒ³ãƒ‘ã‚¯ãƒˆãªãŸã‚ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ä¸€ç·’ã«é…å¸ƒã™ã‚‹ã¨ã„ã£ãŸåˆ©ç”¨ã‚‚æ•°å¤šãã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã“ã§ã¯ SQLite ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆæ–¹æ³•ã€ãã—ã¦ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã—ãŸã‚Šå–å¾—ã—ãŸã‚Šã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ä¸€ã¤ä¸€ã¤è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚
mut00tum 2015/08/08
DB

SQLite
ãƒªãƒ³ã‚¯
RealmSwiftã‚’è©¦ã—ãŸã‘ã©ã‚‚ã†CoreDataã¯ä½¿ã‚ãªããªã‚‹ã‹ã‚‚ã—ã‚Œãªã„ - ã—ã‚é¯–æ—¥è¨˜
RealmSwiftè©¦ã—ãŸæ„Ÿæƒ³ã¨ãƒ¡ãƒ¢æ›¸ãã§ã™ã€‚ CRUDãã‚‰ã„ã—ã‹ã‚„ã£ã¦ãªã„ã®ã§ã™ãŒä½¿ã†ã®ãŒã™ã”ã„ç°¡å˜ã™ãŽã¦æ„Ÿå‹•ã—ãŸã®ã§ãã®è¾ºã‚Šæ›¸ã„ã¦è¡Œã“ã†ã¨æ€ã„ã¾ã™ã€‚ åˆ©ç”¨ã—ãŸRealmã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯0.93.1ã«ãªã‚Šã¾ã™ã€‚ Realmã¨ã¯ SQLiteã®ä»£æ›¿ã«ãªã‚‹ã¨è¨€ã‚ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚ æµ·å¤–ã§ã¯Zyngaã€å›½å†…ã§ã¯Chatworkç‰ã§åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ æ§‹æ–‡ã®çŸã•ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®å®šç¾©ã®ç°¡å˜ã•ãŒé…åŠ›ã§ã™ã€‚ RealmSwiftã¨ã¯ RealmSwiftã¨ã¯Swiftã§æ›¸ã‹ã‚ŒãŸRealmã‚’ä½¿ã†ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã™ã€‚ 2015å¹´5æœˆã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ RealmSwiftã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Podfileã«ä¸‹è¨˜ã‚’è¨˜è¼‰ã—ã¦pod installã‚’ã™ã‚‹ã ã‘ã§ã™ã€‚ CocoaPodsã®0.37.1ä»¥ä¸ŠãŒå¿…è¦ãªã®ã§ã€å¤ã„CocoaPodsã‚’ä½¿ã£ã¦ã„ã‚‹å ´åˆã¯æ›´æ–°ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ pod 'RealmS
mut00tum 2015/08/03
Realm

Swift

DB
ãƒªãƒ³ã‚¯
RealmSwiftã§ç°¡å˜ãªGPSãƒã‚¬ãƒ¼ä½œã£ã¦ã¿ãŸã®ã§ãƒ¡ãƒ¢ - koogawa blog
2017.2.6 è¿½è¨˜ï¼šSwift 3å¯¾å¿œç‰ˆã®è¨˜äº‹ã‚’æ›¸ãã¾ã—ãŸï¼ blog.koogawa.com ä»¥å‰ã‹ã‚‰æ°—ã«ãªã£ã¦ã„ãŸ Realm ã§ã™ãŒã€å…ˆæ—¥å—è¬›ã—ãŸå²¸å·å…ˆç”Ÿã®æŽˆæ¥ã‚’ãã£ã‹ã‘ã«ã€å®Ÿéš›ã«è§¦ã£ã¦ã¿ãŸããªã‚Šã¾ã—ãŸã€‚ Realm ã‚’ç†è§£ã™ã‚‹ã«ã¯ä½•ã‹ä½œã£ã¦ã¿ã‚‹ã®ãŒä¸€ç•ªã£ã¦ã“ã¨ã§ã€ç°¡å˜ãªGPSãƒã‚¬ãƒ¼ã‚’ä½œã£ã¦ã¿ã¾ã—ãŸã€‚ æ¬¡ã®ã‚ˆã†ãªæ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚ Startãƒœã‚¿ãƒ³ã‚’æŠ¼ã™ã¨ä½ç½®æƒ…å ±ã‚’è¨˜éŒ²é–‹å§‹ ã‚¢ãƒ—ãƒªã‚’ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ã«è½ã¨ã—ã¦ã‚‚è¨˜éŒ²ã—ç¶šã‘ã‚‹ ä½ç½®æƒ…å ±ãŒå–å¾—ã•ã‚Œã‚‹ã¨åœ°å›³ã«ã‚‚ãƒ”ãƒ³ãŒç«‹ã¤ distanceFilter ã¯ã¨ã‚Šã‚ãˆãš 100m ã«ã‚»ãƒƒãƒˆ 1æ—¥çµŒéŽã—ãŸãƒ‡ãƒ¼ã‚¿ã¯è‡ªå‹•å‰Šé™¤ Stopãƒœã‚¿ãƒ³ã‚’æŠ¼ã™ã¨ä½ç½®æƒ…å ±ã®å–å¾—çµ‚äº† ï¼Šï¼Šï¼Š ä»¥ä¸‹ã€ãƒ¡ãƒ¢ã§ã™ã€‚ 2015.9.23 UPDATE: Swift 2.0 ã«å¯¾å¿œã—ãŸã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’è¿½è¨˜ã—ã¦ã„ã¾ã™ã€‚ RealmSwift ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« æ¬¡ã®ã‚ˆã†ãª Podfile
mut00tum 2015/08/03
Swift

DB

GPS
ãƒªãƒ³ã‚¯
Welcome to the Atlas Device SDK Docs - Atlas Device SDKs
Atlas Device SDKs are deprecated. Refer to the deprecation page for details. Atlas Device SDK is a suite of app development tools optimized for data access and persistence on mobile devices. Use the SDKs to build data-driven mobile, web, desktop, and IoT apps. The SDKs provide tools to read and write Atlas data from devices. Your app can sync automatically with Mongo DB Atlas and other devices usin
mut00tum 2015/08/03
Swift

DB

Realm
ãƒªãƒ³ã‚¯
JavaScriptãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼»TaffyDBï¼½
æœ¬ã‚³ãƒ¼ãƒŠãƒ¼ã¯ã€æŠ€è¡“è©•è«–ç¤¾ç™ºè¡Œã®æ›¸ç±ã€ŽJavaScriptãƒ©ã‚¤ãƒ–ãƒ©ãƒªå®Ÿè·µæ´»ç”¨ï¼»åŽ³é¸111ï¼½ã€ã®ä¸ã‹ã‚‰ã€ç‰¹ã«Build Insiderã®èªè€…ã«æœ‰ç”¨ã ã¨è€ƒãˆã‚‰ã‚Œã‚‹é …ç›®ã‚’ç·¨é›†éƒ¨ãŒé¸ã³ã€åŒç¤¾ã®è¨±å¯ã‚’å¾—ã¦è»¢è¼‰ã—ãŸã‚‚ã®ã§ã™ã€‚ ã€ŽJavaScriptãƒ©ã‚¤ãƒ–ãƒ©ãƒªå®Ÿè·µæ´»ç”¨ï¼»åŽ³é¸111ï¼½ã€ã®è©³ç´°ã‚„è³¼å…¥ã¯æŠ€è¡“è©•è«–ç¤¾ã®ã‚µã‚¤ãƒˆã‚„ç›®æ¬¡ãƒšãƒ¼ã‚¸ã‚’ã”è¦§ãã ã•ã„ã€‚
mut00tum 2015/06/29
TaffyDB

JavaScript

DB
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŸºç¤Žã€ãƒ¢ãƒ‡ãƒ«ã¨ãƒ“ã‚¸ãƒã‚¹ãƒã‚¸ãƒƒã‚¯ã®é–¢ä¿‚ ãƒ¼ãƒ¼ã€Œéžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®èµ·æ¥å®¶ãŒçŸ¥ã£ã¦ãŠãã¹ããƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®çŸ¥è˜ #09ã€ - BRIDGEï¼ˆãƒ–ãƒªãƒƒã‚¸ï¼‰ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ï¼†ã‚¹ã‚¿ãƒ¼ãƒˆã‚¢ãƒƒãƒ—æƒ…å ±
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŸºç¤Žã€ãƒ¢ãƒ‡ãƒ«ã¨ãƒ“ã‚¸ãƒã‚¹ãƒã‚¸ãƒƒã‚¯ã®é–¢ä¿‚ ãƒ¼ãƒ¼ã€Œéžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®èµ·æ¥å®¶ãŒçŸ¥ã£ã¦ãŠãã¹ããƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®çŸ¥è˜ #09ã€ ç·¨é›†éƒ¨æ³¨ï¼šæœ¬ç¨¿ã¯åˆå¿ƒè€…å‘ã‘ã«ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚„Webãƒ‡ã‚¶ã‚¤ãƒ³ã®è¬›åº§ã‚’é–‹å‚¬ã—ã¦ã„ã‚‹ TechAcademyï¼ˆãƒ†ãƒƒã‚¯ã‚¢ã‚«ãƒ‡ãƒŸãƒ¼ï¼‰ã«ã‚ˆã‚‹é€£è¼‰ä¼ç”»ã€‚ã€Œéžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®èµ·æ¥å®¶ãŒçŸ¥ã£ã¦ãŠãã¹ããƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®çŸ¥è˜ã€ã¨ã„ã†ãƒ†ãƒ¼ãƒžã§æ•°å›žã«åˆ†ã‘ã¦æ¥µã‚ã¦åŸºç¤Žçš„ãªãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®åŸºç¤ŽçŸ¥è˜ã‚’ãŠä¼ãˆã™ã‚‹ã€‚å…¨é€£è¼‰ã¯ã“ã¡ã‚‰ã‹ã‚‰ photo credit: tec_estromberg via photopin cc ã€Œéžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒçŸ¥ã£ã¦ãŠãã¹ããƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®çŸ¥è˜ã€ã¨ã„ã†ãƒ†ãƒ¼ãƒžã§ã€10å›žã«åˆ†ã‘ã¦ãŠå±Šã‘ã™ã‚‹é€£è¼‰ä¼ç”»ã€‚ç¬¬9å›žç›®ã®ãƒ†ãƒ¼ãƒžã¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åŸºç¤Žã€ã§ã™ã€‚ å‰å›žã¯ã€Œã“ã‚Œã‹ã‚‰å§‹ã‚ã‚‹Rubyã®ã‚¨ãƒƒã‚»ãƒ³ã‚¹ã€ã¨ã„ã†ãƒ†ãƒ¼ãƒžã§ãŠé€ã‚Šã—ã¾ã—ãŸã€‚ä»Šå›žã¯ã€PHPã‚„Rubyãªã©ã‚µãƒ¼ãƒãƒ¼ã‚µã‚¤ãƒ‰ã§å‹•ä½œã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
mut00tum 2015/06/18
ãƒ“ã‚¸ãƒã‚¹ãƒã‚¸ãƒƒã‚¯

ã‚ã¨ã§èªã‚€

ç”¨èªž

DB

MEMO

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã€Œãƒ‰ãƒ©ã‚´ãƒ³ãƒœãƒ¼ãƒ«ã¯ãƒ•ãƒªãƒ¼ã‚¶ç·¨ã§çµ‚ã‚ã£ã¦ãŸã‚‰åä½œã ã£ãŸã€ã¨ã‹ã®ãŸã¾ã†è¼©ã«é‰„æ§Œã‚’ä¸‹ã—ãƒ–ã‚¦ç·¨ãŒã„ã‹ã«æœ€çµ‚ç« ã¨ã—ã¦ç´ æ™´ã‚‰ã—ã„ã‹ã‚’åŠ›èª¬ã™ã‚‹ãŸã‚ã®è¦šãˆæ›¸ã - éŠ€æ²³å¤å…äº
ï¼ˆã‚³ãƒ¡æ¬„ç‰ã®æŒ‡æ‘˜ã§ã€Œã‚¢ãƒ€ãƒ«ãƒˆãƒãƒ«ãƒ‰ãƒ¬ãƒ³ã€ã¨ã„ã†å˜èªžã«ã¤ã„ã¦å®Œå…¨ãªå‹˜é•ã„ã®å…ƒã«ç››å¤§ã«èª¤ç”¨ã—ã¦ã„ãŸã“ã¨ã‚’æ•™ãˆã¦é ‚ã„ãŸã®ã§è¨‚æ£ã—ã¾ã—ãŸï¼‰ ã©ã†ã‚‚ã€‚ãƒ–ãƒã‚°ã§ã¯ä¹…æ–¹ã¶ã‚Šã®ã‚ã§ã®ã„ã§ã™ã€‚ãƒ‰ãƒ©ã‚´ãƒ³ãƒœãƒ¼ãƒ«ã§ä½•ç·¨ãŒä¸€ç•ªå¥½ãã‹èžã‹ã‚ŒãŸã‚‰ãƒŽãƒ¼ã‚¿ã‚¤ãƒ ã§ãƒ–ã‚¦ç·¨ã¨å³ç”ã™ã‚‹ã‚ã§ã®ã„ã§ã™ã€‚ ãã†ãƒ–ã‚¦ç·¨ãªã‚“ã§ã™ã‚ˆã€‚æœ€çµ‚ç« ã§ã™ã‚ˆã€‚ãƒ–ã‚¦ç·¨ã‚‚å¥½ãã€ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãƒ–ã‚¦ç·¨ã€ŒãŒã€ä¸€ç•ªå¥½ãã§ã™ã€‚ ã€Œâ—‹â—‹ç·¨ã§çµ‚ã‚ã£ã¦ã‚Œã°åä½œã ã£ãŸã€ã¨è¨€ã‚ã‚ŒãŒã¡ãªã‚¸ãƒ£ãƒ³ãƒ—é•·æœŸé€£è¼‰æ¼«ç”»ã§æœ€çµ‚ç« ã‚’ä¸€ç•ªå¥½ãã«ãªã£ã¦ã—ã¾ã†ã¨ãªã‹ãªã‹è‚©èº«ãŒç‹ã„æ€ã„ã‚’ã™ã‚‹ã‚‚ã®ã§ã™ãŒã€ãƒ‰ãƒ©ã‚´ãƒ³ãƒœãƒ¼ãƒ«ãªã‚“ã¦ã®ã¯ãã®æœ€ãŸã‚‹ä¾‹ã®ï¼‘ã¤ã§ã—ã‚‡ã†ã€‚ æ—¥ã€…ãã‚“ãªè‚©èº«ã®ç‹ã„æ€ã„ã‚’ã—ã¦ã„ã‚‹ç§ã§ã™ãŒã€å…ˆæ—¥ã“ã‚“ãªãƒ‹ãƒ¥ãƒ¼ã‚¹è¨˜äº‹ã‚’è¦‹ã‹ã‘ã¾ã—ã¦ãã€‚ ã¤ã„ã«ãƒˆãƒªã‚·ãƒžç·¨é›†é•·ãŒèªã‚ãŸï¼ã€Œãƒ‰ãƒ©ã‚´ãƒ³ãƒœãƒ¼ãƒ«ã¯ãƒ•ãƒªãƒ¼ã‚¶ç·¨ã§çµ‚ã‚ã‚‹ã¹ãã ã£ãŸã€ ä½•ãŸã‚‹ã“ã¨ã‹ã¨ã€‚æ€’é«ªå¤©ã‚’è¡ãã¨ã¯ã“ã®ã“ã¨ã‹ã¨ã€‚ ä»¶ã®ç•ªçµ„ãã®ã‚‚ã®ã«é–¢ã—ã¦ã¯å®Ÿéš›ã«è¦‹ãŸ
mut00tum 2015/06/09
DB

ç´ æ™´ã‚‰ã—ã„
ãƒªãƒ³ã‚¯
HG ãƒ¤ãƒ ãƒãƒ£ | ãƒ—ãƒ¬ãƒŸã‚¢ãƒ ãƒãƒ³ãƒ€ã‚¤ | ãƒãƒ³ãƒ€ã‚¤å…¬å¼é€šè²©ã‚µã‚¤ãƒˆ
å…¨ä¸–ç•Œå¾…æœ›ï¼ã‚µã‚¤ãƒ¤äººç·¨ã®ãƒ¤ãƒ ãƒãƒ£ãŒè¶…çµ¶ã‚¯ã‚ªãƒªãƒ†ã‚£ã§ç«‹ä½“åŒ–ï¼ æƒ³åƒã‚’è¶…ãˆã‚‹é€ åž‹ã¨å½©è‰²ã«ã‚ˆã‚Šã€ã‚ã®ãƒ¯ãƒ³ã‚·ãƒ¼ãƒ³ã‚’å®Œå…¨å†ç¾ã€‚ é£¾ã‚Šæ–¹ã¯è‡ªç”±è‡ªåœ¨ã€‚è²´æ–¹ã®æ—¥å¸¸ã®ã‚ã‚Šã¨ã‚ã‚‰ã‚†ã‚‹å ´æ‰€ã«åœ§å€’çš„ãªæˆ¦å ´æ„Ÿã‚’æ¼”å‡ºã„ãŸã—ã¾ã™ã€‚ ã€ã‚»ãƒƒãƒˆå†…å®¹ã€‘ ãƒ•ã‚£ã‚®ãƒ¥ã‚¢ï¼‘ä½“ ã€ç´ æã€‘ ãƒ•ã‚£ã‚®ãƒ¥ã‚¢ï¼šPVC ã€å¯¾è±¡å¹´é½¢ã€‘ 15æ³ä»¥ä¸Š ã€ã‚µã‚¤ã‚ºã€‘ å…¨é•·ã€€ç´„102mm ã€ç”Ÿç”£å›½ã€‘ ä¸å›½ â€»å•†å“ã®ä»•æ§˜ã«é–¢ã—ã¦â€» ï½¥æŽ²è¼‰å†™çœŸã¯è©¦ä½œå“ã§ã™ã€‚å®Ÿéš›ã®å•†å“ã¨ã¯ç•°ãªã‚‹å ´åˆãŒã”ã–ã„ã¾ã™ã®ã§ã”äº†æ‰¿ãã ã•ã„ã€‚ ï½¥æœ¬å•†å“ã¯ã‚¬ã‚·ãƒ£ãƒãƒ³ã§ã®è²©å£²äºˆå®šã¯ã”ã–ã„ã¾ã›ã‚“ã€‚ â€»ã”æ³¨æ–‡æ¡ä»¶ã«é–¢ã—ã¦â€» ï½¥å•†å“ä»•æ§˜ã‚„ç™ºé€æ—¥ã¯äºˆå‘Šãªãå¤‰æ›´ã«ãªã‚‹å ´åˆãŒã”ã–ã„ã¾ã™ã€‚äºˆã‚ã”äº†æ‰¿ãã ã•ã„ã€‚
mut00tum 2015/03/26
ãƒ—ãƒãƒ€ã‚¯ãƒˆ

ãƒã‚¿

ã‚¯ã‚ªãƒªãƒ†ã‚£

DB
ãƒªãƒ³ã‚¯
ã‚ãƒªãƒ³ ãƒ¡ãƒƒãƒ„ ã‚¹ãƒšã‚·ãƒ£ãƒ«ã‚µã‚¤ãƒˆï½œã‚ãƒªãƒ³
ã‚ã®ç¹”ç”°ä¿¡æˆãŒï¼ï¼Ÿã‚¬ãƒãƒ£ãƒ”ãƒ³ãŒï¼ï¼Ÿã§ã‚“ã±çµ„.incãŒï¼ï¼Ÿçˆ½å¿«ã«å¼¾ã‘ã‚‹ï¼ï¼ï¼Ÿã“ã“ã§ã—ã‹è¦‹ã‚Œãªã„ã‚¹ãƒšã‚·ãƒ£ãƒ«ãƒ ãƒ¼ãƒ“ãƒ¼ãŒæº€è¼‰ï¼ã‚ãƒªãƒ³ ãƒ¡ãƒƒãƒ„ ã‚¹ãƒšã‚·ãƒ£ãƒ«ã‚µã‚¤ãƒˆå…¬é–‹ä¸ï¼
mut00tum 2015/03/06
ã“ã‚Œã¯ã™ã”ã„

å‹•ç”»

DB

ã‚¢ãƒ‹ãƒ¡ãƒ¼ã‚·ãƒ§ãƒ³

ã‚¯ãƒªã‚¨ã‚¤ãƒ†ã‚£ãƒ–
ãƒªãƒ³ã‚¯
DBè¨è¨ˆã§ã“ã ã‚ã‚ŠãŸã„ä¸‰ã¤ã®è¦ç´
http://connpass.com/event/10849/ ã—ã‚‡ã¼ã¡ã‚€ã«ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«è¨è¨ˆã«ã¤ã„ã¦æ•™ãˆã¦ãã ã•ã„ã®ä¼š #syoboben ã§è©±ã—ãŸè³‡æ–™ã§ã™ã€‚Read less
mut00tum 2015/02/23
DB

ãƒãƒ¼ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã€WordPressã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã‚’æ“ä½œã—ãŸã„ã®ã§åˆã‚ã®ä¸€æ©ã‹ã‚‰å‹‰å¼·ã—ã¦ç†è§£ã—ã¦ã„ã¾ã™ã€‘ï½œä»Šæ‘ã ã‘ãŒã‚ˆãã‚ã‹ã‚‹ãƒ–ãƒã‚°
ã¨ã“ã‚ã§ã§ã™ãŒã€MySQL,PostgreSQL,oracleãªã©ã®DBMSã¯ã€ã“ã‚Œã¾ã§ä¸€é€šã‚Šè§¦ã£ã¦ãã¾ã—ãŸã€‚ã§ã™ã®ã§ã€åˆæ©çš„ãªäºˆå‚™çŸ¥è˜ã¯ã‚ã‚‹ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ãŒã€ç§å€‹äººçš„ã«WordPressã«é–¢ã—ã¦ã¯ã€ã€ŒWordPressã‚’æ§‹æˆã—ã¦ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã®ç†è§£ã€ã‚’ã—ãªã„ã¨ã€ã†ã¾ãæ‰±ãˆãªã„ã€‚å‰ã«é€²ã‚ãªã„ãªã€ã¨æ„Ÿã˜ã¦ã„ã¾ã™ã€‚ å½“ãŸã‚Šå‰ã‹ã‚‚ã—ã‚Œãªã„ã§ã™ã‘ã©ã‚‚ãƒ»ãƒ»ãƒ» WordPressã®DBã«é–¢ã™ã‚‹ç†è§£ç§ã®ç¾çŠ¶ã®ç†è§£ã¯ã€ WordPressã¯DBMSã¨ã—ã¦MySQLã‚’æŽ¡ç”¨ã—ã¦ã„ã¦ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«æ±ºã‚ãŸDBã«ã€WordPressã‚’æ§‹æˆã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹codexã®ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ã‚’å‚è€ƒã«ã€ã¡ã‚‡ã£ã¨ã ã‘DBã®å€¤ã‚’å¼•ã£å¼µã£ã¦ãã‚‹ç¨‹åº¦ã£ã¦ãã‚‰ã„ã§ã™ã€‚ ã‚ã€ã‚ã¨WordPressã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«ä½œã‚‰ã‚Œã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«åã‚‚ã€å‰å›žèª¿ã¹ã¾ã—ãŸã€‚ï¼ˆæ˜”PostgreSQLã§æ§‹ç¯‰ã™ã‚‹æ–¹æ³•ã‚‚ã‚ã‚‹ã®ã¯ã©ã“ã‹ã§è¦‹ãŸã‘ã©ã€ãã“ã¯
mut00tum 2014/10/09
WordPress

DB
ãƒªãƒ³ã‚¯
1