[B! Database] babydaemonsã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

babydaemons id:babydaemons

Databaseã«é–¢ã™ã‚‹babydaemonsã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (85)

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

ActiveRecordã§ç”ŸSQLã‚’ä½¿ã„ãŸã„ã¨ãã«ä¾¿åˆ©ãªãƒ¡ã‚½ãƒƒãƒ‰é” - Qiita
Ruby ã§ DB ã‚’æ‰±ã†ã¡ã‚‡ã£ã¨ã—ãŸã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ãã¨ãã€ActiveRecord ã§ç”ŸSQLã‚’ä½¿ã†ã¨è‰²ã€…æ—ã‚‹ã“ã¨ãŒå¤šã„ã€‚ ãã®ãŸã‚ã®ãƒ¡ã‚½ãƒƒãƒ‰ã‚’ã¾ã¨ã‚ã¦ã¿ãŸã€‚ äº‹å‰æº–å‚™ï¼š establish_connection ä½œæˆãƒ»æ›´æ–°ç³»ï¼š execute æ¤œç´¢ç³»ï¼š select_all, select_one, select_rows, select_values, select_value ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ï¼š sanitize_sql_array äº‹å‰æº–å‚™ establish_connection DBã¨ã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’ç¢ºç«‹ã™ã‚‹ã€‚'mysql2', 'postgresql', 'redshift' ãªã©æ§˜ã€…ãªã‚¢ãƒ€ãƒ—ã‚¿ãŒä½¿ãˆã‚‹ã€‚ ä»¥ä¸‹ã¯æŽ¥ç¶šè¨å®šã®ä¸€ä¾‹ã€‚ [MySQL] (è¦ mysql2 gem) require 'active_record' config = { adapter: 'mysql2
babydaemons 2016/09/27
ActiveRecord

Rails

MySQL

Database
ãƒªãƒ³ã‚¯
ç¬¬1å›žã€€memcachedã®åŸºæœ¬ | gihyo.jp
æ ªå¼ä¼šç¤¾ãƒŸã‚¯ã‚·ã‚£ é–‹ç™ºéƒ¨ ã‚·ã‚¹ãƒ†ãƒ é‹ç”¨ã‚°ãƒ«ãƒ¼ãƒ—ã®é•·é‡Žã§ã™ã€‚æ™®æ®µã¯ãƒŸã‚¯ã‚·ã‚£ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é‹ç”¨ã‚’æ‹…å½“ã—ã¦ãŠã‚Šã¾ã™ã€‚ä»Šå›žã‹ã‚‰æ•°å›žã«ã‚ãŸã‚Šã€æœ€è¿‘Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®åˆ†é‡Žã§è©±é¡Œã«ãªã£ã¦ã„ã‚‹memcachedã«ã¤ã„ã¦ã€å¼Šç¤¾é–‹ç™ºéƒ¨ ç ”ç©¶é–‹ç™ºã‚°ãƒ«ãƒ¼ãƒ—ã®å‰å‚ã¨ã¨ã‚‚ã«ã€ä½¿ã„æ–¹ã‚„å†…éƒ¨æ§‹é€ ã€é‹ç”¨ã«ã¤ã„ã¦è§£èª¬ã•ã›ã¦é ‚ãã¾ã™ã€‚ memcachedã¨ã¯ memcachedã¯ã€LiveJournalã‚’é‹å–¶ã—ã¦ã„ãŸDanga Interactiveç¤¾ã§ã€Brad Fitzpatrickæ°ãŒä¸å¿ƒã¨ãªã£ã¦é–‹ç™ºã•ã‚ŒãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ç¾åœ¨ã§ã¯mixiã‚„ã¯ã¦ãªã€Facebookã€Voxã€LiveJournalãªã©ã€ã•ã¾ã–ã¾ãªã‚µãƒ¼ãƒ“ã‚¹ã§Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’å‘ä¸Šã•ã›ã‚‹é‡è¦ãªè¦ç´ ã«ãªã£ã¦ã„ã¾ã™ã€‚ å¤šãã®Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€RDBMSã«ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã—ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã§ãã®ãƒ‡ãƒ¼ã‚¿
babydaemons 2013/02/06
memcached

server

database

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
KVSç³»NoSQLã®ã¾ã¨ã‚ï¼ˆHibariã€Dynamoã€Voldemortã€Riakç·¨ï¼‰
åº ç« ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã®æ™‚ä»£ ç¬¬1ç« NOSQLã¨ã¯ä½•ã‹? ç¬¬2ç« NOSQLã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« ç¬¬3ç« ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®åŸºæœ¬æ¦‚å¿µã¨æŠ€è¡“ ç¬¬4ç« Hadoopã¯NOSQL? ç¬¬5ç« ä¸»ãªNOSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ ç¬¬6ç« NOSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é¸æŠžåŸºæº– ç¬¬7ç« NOSQLã‚’ä½¿ã†ãƒ“ã‚¸ãƒã‚¹ æœ¬é€£è¼‰ã¯æ›¸ç±ã€ŽNOSQLã®åŸºç¤ŽçŸ¥è˜ã€ï¼ˆãƒªãƒƒã‚¯ãƒ†ãƒ¬ã‚³ãƒ åˆŠã€ISBNï¼š978-4897978871ï¼‰ã§è§£èª¬ã•ã‚Œã¦ã„ã‚‹å†…å®¹ã‹ã‚‰ä¸€éƒ¨ã‚’æŠœç²‹ã—ã€æœ¬é€£è¼‰å‘ã‘ã«ä¸€éƒ¨å†ç·¨é›†ã—ã¦æŽ²è¼‰ã—ãŸã‚‚ã®ã§ã™ã€‚ æ›¸ç±ã§ã¯ã€ä¸€èˆ¬ã«NoSQLã¨å‘¼ã°ã‚Œã¦ã„ã‚‹å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“ã«ã¤ã„ã¦ã€åŸºæœ¬æ¦‚å¿µã‹ã‚‰ä¸»è¦ãªãƒ—ãƒãƒ€ã‚¯ãƒˆã®ç‰¹æ€§ã€ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯çµæžœã¾ã§ã‚’ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã‚„ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®é•ã„ã¨ã„ã£ãŸåŸºæœ¬æ¦‚å¿µã‹ã‚‰ã€å„ãƒ—ãƒãƒ€ã‚¯ãƒˆã®ç‰¹å¾´ã‚’ç†è§£ã§ãã‚‹å†…å®¹ã«ãªã£ã¦ã„ã¾ã™ã€‚ æœ¬é€£è¼‰ã§ã¯ã€ã“ã®æ›¸ç±ã®å†…å®¹ã‹ã‚‰ã€ä¸»è¦ãƒ—ãƒãƒ€ã‚¯ãƒˆã‚’ç´¹ä»‹ã—ã¦ã„ã‚‹ç¬¬5ç« ã‚’æŠœç²‹ã—ã€ãã®ã‚¨ãƒƒ
babydaemons 2012/11/06
NoSQL

kvs

database

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
Wikipedia:ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ - Wikipedia
ã‚¦ã‚£ã‚ãƒšãƒ‡ã‚£ã‚¢ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ãªã©ã®ãƒ‡ãƒ¼ã‚¿ã¯ã€å†é…å¸ƒã‚„å†åˆ©ç”¨ã®ãŸã‚ã«åˆ©ç”¨ã§ãã‚‹ä¸€å…ƒåŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ãƒ€ãƒ³ãƒ—ã§ã®æä¾›ãŒè¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚ã‚¯ãƒãƒ¼ãƒ©ã‚’ç”¨ã„ã¦ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’åŽé›†ã—ãªã„ã§ãã ã•ã„ã€‚ã“ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ãƒ€ãƒ³ãƒ—ã®ç”Ÿæˆã¯ä¸å®šæœŸã«è¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚ ã‚¦ã‚£ã‚ãƒšãƒ‡ã‚£ã‚¢ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¯ Creative Commons Attribution-ShareAlike 4.0 International License (CC BY-SA 4.0) ãŠã‚ˆã³ GNU Free Documentation License (GFDL) ã®ä¸‹ã«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã•ã‚Œã¦ã„ã¾ã™ï¼ˆWikipedia:è‘—ä½œæ¨©ã¨åˆ©ç”¨è¦ç´„ã‚’å‚ç…§ï¼‰ã€‚ç”»åƒãªã©ã®ãƒ¡ãƒ‡ã‚£ã‚¢ãƒ•ã‚¡ã‚¤ãƒ«ã¯ç•°ãªã‚‹ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§æä¾›ã•ã‚Œã‚‹ã“ã¨ã‚‚ã‚ã‚Šã€ãƒ•ã‚¡ã‚¤ãƒ«ãƒšãƒ¼ã‚¸ã§æ˜Žè¨˜ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã‚ˆã‚Šè©³ã—ã„è§£èª¬ã¯meta:Data dumpsï¼ˆè‹±èªžï¼‰ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ å…¨ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ãƒ€ãƒ³ãƒ—ï¼šdu
babydaemons 2012/07/17
ä¼šç¤¾ã‹ã‚‰è½ã¨ã™ã¨ã€ãŠã†ã¡ã«æ¯”ã¹ã¦ä¸€æ¡é…ã„ã£ã™ã€‚orz

Wikipedia

database
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
babydaemons 2011/10/12
Database

performance

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
How do I make a column unique and index it in a Ruby on Rails migration?
I would like to make a column unique in Ruby on Rails migration script. What is the best way to do it? Also is there a way to index a column in a table? I would like to enforce unique columns in a database as opposed to just using :validate_uniqueness_of.
babydaemons 2011/09/29
migrateãƒ•ã‚¡ã‚¤ãƒ«ã§UNIQUE INDEXã‚’å¼µã‚‹å ´åˆã®æŒ‡å®šæ–¹æ³•

Ruby

Rails

Database
ãƒªãƒ³ã‚¯
NoSQLã¨ã—ã¦MySQLã‚’ä½¿ã†DeNAãŒã€memcachedã‚ˆã‚Šã‚‚é«˜é€Ÿãª75ä¸‡ã‚¯ã‚¨ãƒªï¼ç§’ã‚’å®Ÿç¾
ãƒ¢ãƒã‚²ãƒ¼ã§çŸ¥ã‚‰ã‚Œã‚‹DeNAã¯ã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«NoSQLã‚’ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚ãªãœã‹ï¼Ÿ ãã‚Œã¯MySQL/InnoDB 5.1ã®ç’°å¢ƒã§ç§’é–“75ä¸‡ã‚¯ã‚¨ãƒªã¨ã„ã†ã€å¤šãã®NoSQLã§ã‚‚å®Ÿç¾ã§ããªã„ã‚ˆã†ãªé«˜æ€§èƒ½ã‚’å®Ÿç¾ã—ã¦ã„ã‚‹ã‹ã‚‰ã€‚DeNAã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ã¯ã€è‡ªèº«ã®ãƒ–ãƒã‚°ã«ã“ã‚“ãªå†…å®¹ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒUsing MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity serverã€ï¼ˆè‹±èªžï¼‰ã‚’ãƒœã‚¹ãƒˆã—ã¦ã„ã¾ã™ã€‚ Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server æ¾ä¿¡æ°ãŒæŒ‡æ‘˜ã™ã‚‹ã‚ˆã†ã«ã€å¤§è¦æ¨¡ãªãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã‚‹ä¼æ¥ã®å¤šãã¯åˆ†æ•£ç’°å¢ƒã§
babydaemons 2011/04/18
NoSQL

MySQL

memcached

performance

DeNA

Database
ãƒªãƒ³ã‚¯
SSDå°‚ç”¨ã«è¨è¨ˆã•ã‚ŒãŸã€ŒReThinkDBã€ã€ãƒãƒƒã‚¯ã‚‚ãƒã‚°ã‚‚ä½¿ã‚ãªã„æ–°ã—ã„ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£
SSDå°‚ç”¨ã«è¨è¨ˆã•ã‚ŒãŸã€ŒReThinkDBã€ã€ãƒãƒƒã‚¯ã‚‚ãƒã‚°ã‚‚ä½¿ã‚ãªã„æ–°ã—ã„ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ SSDãŒHDDã«ä»£ã‚ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¨ã—ã¦æ™®åŠã—ã‚ˆã†ã¨ã—ã¦ã„ã‚‹ã“ã¨ã‚’èƒŒæ™¯ã«ã€SSDã«ç‰¹åŒ–ã—ãŸã¾ã£ãŸãæ–°ã—ã„ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’å‚™ãˆãŸãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é–‹ç™ºã—ã‚ˆã†ã¨ã—ã¦ã„ã‚‹ä¼æ¥ãŒã‚ã‚Šã¾ã™ã€‚ã€ŒReThinkDBã€ã§ã™ã€‚ æ˜¨å¹´7æœˆã«ã€Publickeyã§ã¯ReThinkDBã®æ¦‚è¦ã‚’è¨˜äº‹ã€ŒSSDã«æœ€é©åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒRethinkDBã€ã€ãƒãƒƒã‚¯ã‚‚ãƒã‚°ã‚‚ä½¿ã‚ãšã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å®Ÿç¾ã€ã§ä¼ãˆã¾ã—ãŸã€‚ ãã®è¨˜äº‹ã®ä¸ã§ã¯ã€ReThinkDBãŒãƒãƒƒã‚¯ã‚’ä½¿ã‚ãšã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å®Ÿç¾ã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ©ç”¨ä¸ã§ã‚‚ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆãŒã¨ã‚Œã€ã¾ãŸç•°å¸¸çµ‚äº†ã—ã¦ã‚‚å®¹æ˜“ã«å¾©å¸°ã§ãã‚‹æ©Ÿèƒ½ã‚’å‚™ãˆã¦ã„ã‚‹ã€ã¨ã„ã£ãŸã“ã¨ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ 4æœˆã«ç±³ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§ã«è¡Œã‚ã‚ŒãŸã€ŒMySQL Conference & Ex
babydaemons 2011/04/17
SSD

DB

ReThinkDB

Database

architecture
ãƒªãƒ³ã‚¯
SSDã¨Oracle Database 11gã®çµ„ã¿åˆã‚ã›ã§ã€ã©ã“ã¾ã§æ€§èƒ½å‘ä¸ŠãŒå¯èƒ½ãªã®ã‹ï¼Ÿã€€å‰ç·¨ã€€OSã‚«ãƒ¼ãƒãƒ«NFSã¯æƒ³å®šå¤–ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ï¼ | oracletech.jp
ã‚µãƒ¼ãƒã¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®æ€§èƒ½å‘ä¸Šã«ä¼´ã„ã€ãã‚Œã¾ã§è¤‡æ•°ã®ã‚µãƒ¼ãƒã§å‡¦ç†ã—ã¦ã„ãŸã‚‚ã®ã‚’1å°ã®é«˜æ€§èƒ½ãªã‚µãƒ¼ãƒã«ã¾ã¨ã‚ã‚‹ã€Œã‚µãƒ¼ãƒçµ±åˆã€ã¯ã€æ•°å¹´å‰ã‹ã‚‰å¤§ããªãƒˆãƒ¬ãƒ³ãƒ‰ã®1ã¤ã«ãªã£ã¦ã„ã‚‹ã€‚ã‚µãƒ¼ãƒçµ±åˆã«ã‚ˆã‚Šã‚µãƒ¼ãƒã®åˆ©ç”¨çŽ‡ãŒå‘ä¸Šã—ã€ã¾ãŸç›£è¦–ã™ã¹ããƒã‚¤ãƒ³ãƒˆãŒ1ã‚«æ‰€ã«ãªã‚‹ãŸã‚é‹ç”¨ã‚³ã‚¹ãƒˆã®å‰Šæ¸›ã«ãªã‚Šã€ç®¡ç†ã™ã¹ãå¯¾è±¡ã‚‚æ¸›ã‚‹ãŸã‚ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®å‘ä¸Šã«ã‚‚ã¤ãªãŒã‚‹ãŸã‚ã ã€‚
babydaemons 2011/04/17
çœŸã®ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚·ã‚¹ãƒ†ãƒ ã¯NASã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãªã‚“ã‹ä½¿ã‚ãšã«SANã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ä½¿ã†ã‚“ã§ãªã„ã‹ã„ï¼Ÿã¨å¦„æƒ³ã—ã¦ã¿ãŸã€‚

SSD

Oracle

Database

NFS

OS
ãƒªãƒ³ã‚¯
sqlite: SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ä¼šè©±ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ
sqlite: SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç®¡ç†ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ (This page was last modified on 2003/06/29 16:11:13 UTC) SQLite ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«ã¯ sqlite ã¨ã„ã†ã‚·ãƒ³ãƒ—ãƒ«ãªã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ãŒå«ã¾ã‚Œã¾ã™ã€‚ã“ã‚Œã‚’ä½¿ã†ã¨ã€ãƒ¦ãƒ¼ã‚¶ã¯æ‰‹ä½œæ¥ã§ SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã—ã¦ SQL ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã§ãã¾ã™ã€‚ã“ã®æ–‡æ›¸ã§ã¯ sqlite ã®ä½¿ã„æ–¹ã«é–¢ã™ã‚‹æ¦‚ç•¥ã‚’ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ èµ·å‹•ã™ã‚‹ sqlite ã‚’èµ·å‹•ã™ã‚‹ã«ã¯å˜ã« "sqlite" ã¨ã‚¿ã‚¤ãƒ—ã—ã€ãã®å¾Œã‚ã« SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¿æŒã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«åã‚’ä»˜ã‘ã¾ã™ã€‚ãƒ•ã‚¡ã‚¤ãƒ«ãŒå˜åœ¨ ã—ãªã„å ´åˆã¯ã€è‡ªå‹•çš„ã«æ–°ã—ãä½œã‚‰ã‚Œã¾ã™ã€‚èµ·å‹•å¾Œ sqlite ãƒ—ãƒã‚°ãƒ©ãƒ ã¯ã€SQL ã‚’ã‚¿ã‚¤ãƒ—ã™ã‚‹ãŸã‚ã®ãƒ—ãƒãƒ³ãƒ—ãƒˆã‚’è¡¨ç¤ºã—ã¾ã™ã€‚ SQL ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆï¼ˆçµ‚äº†ã¯ã‚»ãƒŸã‚³ãƒãƒ³ï¼‰ã‚’ã‚¿ã‚¤ãƒ—ã—ã€ "E
babydaemons 2010/03/04
SQLite

database

tutorial

Tips
ãƒªãƒ³ã‚¯
SQLiteç”¨ãƒ–ãƒ©ã‚¦ã‚¶ã¯TkSQLiteã«æ±ºå®š - bokut.in
SQLiteCCã—ã‹ãªã„ã‹ã¨æ€ã£ã¦ã„ã¾ã—ãŸã€‚ SQLite ManagementToolsã‚’ã¿ãŸã‚‰æ²¢å±±ã‚ã£ã¦ã€é©šãã¾ã—ãŸã€‚ ã—ã‹ã‚‚SQLiteCCã¯ã™ã§ã«ã€ŒInactive or Unsupportedã€ã«ãªã£ã¦ã‚‹ï¼ PlaneDisaster.NETãƒ»ãƒ»ãƒ»sjisãŒãƒ€ãƒ¡ã€‚ SQLite2007 Proãƒ»ãƒ»ãƒ»sjisãŒãƒ€ãƒ¡ã€‚ SQLite Administratorãƒ»ãƒ»ãƒ»SJISãŒé€šã‚‹ã€‚ SQLite Database Browserãƒ»ãƒ»ãƒ»sjisãŒãƒ€ãƒ¡ SQLiteSpyãƒ»ãƒ»ãƒ»sjisãŒãƒ€ãƒ¡ã€‚ SQLiteSpyãƒ»ãƒ»ãƒ»sjisãŒãƒ€ãƒ¡ã€‚ SQLiteToolãƒ»ãƒ»ãƒ»ä½¿ã„ã‹ãŸãŒåˆ†ã‹ã‚‰ãªã„ã€‚ TkSQLiteãƒ»ãƒ»ãƒ»æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚‚ãƒãƒƒãƒã‚·ã€‚ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚‚æ—¥æœ¬èªžã€‚èµ·å‹•ã‚‚é€Ÿã„ã€‚ãƒ•ã‚©ãƒ³ãƒˆãŒé›£ç‚¹ã‹ã€‚Vié¢¨ã‚ãƒ¼ãƒã‚¤ãƒ³ãƒ‰ãŒã‚‹ã®ãŒã‚¹ãƒ†ã‚ã€‚
babydaemons 2010/02/12
sqlite

browser

database

db
ãƒªãƒ³ã‚¯
scientificcommons.orgÂ -Â ãƒªã‚½ãƒ¼ã‚¹ãŠã‚ˆã³æƒ…å ±
scientificcommons.org ã¯ã€ã‚ãªãŸãŒãŠæŽ¢ã—ã®æƒ…å ±ã®å…¨ã¦ã®æœ€æ–°ã‹ã¤æœ€é©ãªã‚½ãƒ¼ã‚¹ã§ã™ã€‚ä¸€èˆ¬ãƒˆãƒ”ãƒƒã‚¯ã‹ã‚‰ã“ã“ã‹ã‚‰æ¤œç´¢ã§ãã‚‹å†…å®¹ã¯ã€scientificcommons.orgãŒå…¨ã¦ã¨ãªã‚Šã¾ã™ã€‚ã‚ãªãŸãŒãŠæŽ¢ã—ã®å†…å®¹ãŒè¦‹ã¤ã‹ã‚‹ã“ã¨ã‚’é¡˜ã£ã¦ã„ã¾ã™ï¼
babydaemons 2009/11/08
Web Service

Research

Database
ãƒªãƒ³ã‚¯
å„ªè‰¯ä¼æ¥ã¯ãªãœHadoopã«èµ°ã‚‹ã®ã‹
ã¡ãªã¿ã«ã€ã“ã®åˆ†æžã®ãŸã‚ã«å¿…è¦ã¨ã•ã‚Œã‚‹MapReduceã®ã‚³ãƒ¼ãƒ‰ã§ã‚ã‚‹ãŒã€ãã®ã‚µã‚¤ã‚ºã¯ã‚ãšã‹20ã‚¹ãƒ†ãƒƒãƒ—ã ã¨ã„ã†ã€‚Yahoo!ã®ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚¿ãƒ¼ã§ã‚ã‚‹ã€ã‚¨ãƒªãƒƒã‚¯ãƒ»ãƒãƒ«ãƒ‡ã‚·ãƒ¥ãƒã‚¤ãƒ©ãƒ¼æ°ã«ã‚ˆã‚‹ã¨ã€ãŸã¨ãˆçµŒé¨“ã®æµ…ã„ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã£ã¦ã‚‚ã€MapReduceã«ã‚ˆã‚‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã¯å¯èƒ½ã§ã‚ã‚‹ã¨ã•ã‚Œã‚‹ã€‚ ã¾ãŸã€VISAã®ã‚¸ãƒ§ãƒ¼ãƒ»ã‚«ãƒ‹ãƒ³ã‚¬ãƒ æ°ã‹ã‚‰ã‚‚ã€è²´é‡ãªãƒ‡ãƒ¼ã‚¿ãŒæä¾›ã•ã‚Œã¦ã„ãŸã®ã§ä»¥ä¸‹ã«ç´¹ä»‹ã™ã‚‹ã€‚åŒç¤¾ã§ã¯ã€1æ—¥ã«1å„„ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒç™ºç”Ÿã™ã‚‹ãŸã‚ã€2å¹´é–“ã§700å„„å¼·ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒã‚°ãŒè“„ç©ã•ã‚Œã€ãã®ãƒ‡ãƒ¼ã‚¿é‡ã¯36ãƒ†ãƒ©ãƒã‚¤ãƒˆã«è‡³ã‚‹ã¨ã„ã†ã€‚ã“ã†ã—ãŸã‚¹ã‚±ãƒ¼ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã€å¾“æ¥ã®RDBã‚’ç”¨ã„ã¦åˆ†æžã™ã‚‹ã«ã¯ã€ç´„1ã‚«æœˆã®æ™‚é–“ãŒå¿…è¦ã¨ã•ã‚Œã¦ããŸãŒã€Hadoopã‚’ç”¨ã„ã‚‹ã“ã¨ã§13åˆ†ã«çŸç¸®ã•ã‚ŒãŸã¨ã„ã†ã€‚ ã“ã‚Œã¾ã§ã¯ã€Yahoo!ã«ã—ã‚VISAã«ã—ã‚ã€è†¨å¤§ãªãƒ‡ãƒ¼ã‚¿ã‚’RDBã«æŠ¼ã—è¾¼ã‚€ã»ã‹ã«æ–¹æ³•ã¯ãªãã€ãã®åˆ†æžã«æ•°åæ—¥ã‚’è¦ã™ã‚‹
babydaemons 2009/10/17
Hadoop

Ruby

MapReduce

Google

amazon

network

Database

business

OSS
ãƒªãƒ³ã‚¯
http://w033.seesaa.net/category/1190016-1.html
babydaemons 2008/05/09
Computing

Database

SQL Server
ãƒªãƒ³ã‚¯
SQL Server 7.0 ã§ãƒˆãƒªã‚¬ã‚’ä½œæˆã™ã‚‹
Microsoft SQL Server 7.0 ã®æ©Ÿèƒ½ã®ä¸€ã¤ã§ã‚ã‚‹ãƒˆãƒªã‚¬ã«ã¤ã„ã¦ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã«é–¢ã™ã‚‹ãŠè©±ã‚’æ›¸ã„ã¦ã¿ã¾ã™ã€‚ ã‚°ãƒ©ãƒ•ã‚£ã‚«ãƒ«ãªç®¡ç†ãƒ„ãƒ¼ãƒ« "Enterprise Manager" ã«ã¯ãªãœã‹ãƒˆãƒªã‚¬ã«é–¢ã™ã‚‹æ“ä½œã‚’è¡Œã†æ©Ÿèƒ½ãŒæ¬ ã‘ã¦ã„ã‚‹ã‚ˆã†ãªã®ã§ã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ä»¥å¤–ã®ã“ã¨ã‚‚è»½ãè§¦ã‚Œã¦ã¿ã¾ã™ã€‚ ãƒˆãƒªã‚¬ã¨ã¯ã€ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ“ä½œã—ãŸéš›ã«ã‚ã‚‰ã‹ã˜ã‚å®šã‚ã¦ãŠã„ãŸãƒ—ãƒã‚°ãƒ©ãƒ ï¼ˆTransact-SQLï¼‰ ã‚’è‡ªå‹•çš„ã«å®Ÿè¡Œã•ã›ã‚‹ãŸã‚ã®ä»•çµ„ã¿ã§ã™ã€‚ã“ã‚Œã‚’ç”¨ã„ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã€ãƒ‡ãƒ¼ã‚¿ã®çŸ›ç›¾ã€ãƒ—ãƒã‚°ãƒ©ãƒ ã®è² æ‹…ãªã©ã‚’æŠ‘åˆ¶ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒˆãƒªã‚¬ã‚’ç”¨æ„ã§ãã‚‹æ“ä½œã¯ INSERT, UPDATE, DELETE ã‚¯ã‚¨ãƒªã«å¯¾ã—ã¦ã§ã€ã“ã‚Œã‚‰ã®ã‚¯ã‚¨ãƒªãŒã‚µãƒ¼ãƒã«ç™ºè¡Œã•ã‚Œã‚‹ã¨ã€ã‚µãƒ¼ãƒã¯é–¢é€£ä»˜ã‘ã‚‰ã‚ŒãŸãƒˆãƒªã‚¬ã‚’è‡ªå‹•çš„ã«å®Ÿè¡Œã—ã¦ãã‚Œã¾ã™ã€‚ Microsoft SQL Server 7.0 ã«ä»˜å±žã—ã¦ã„ã‚‹ "Enterpris
babydaemons 2008/04/30
Computing

Database

SQL Server
ãƒªãƒ³ã‚¯
2005-05-06
è¥¿æš¦ã¨å’Œæš¦ã®å¤‰æ›ã«ã¤ã„ã¦ã¯SQLServerã§ã¯ å‚™ã‚ã£ã¦ã„ãªã„ã¨ã„ã†ã“ã¨ã§ã€ ã»ã¨ã‚“ã©ã®äººãŒè‡ªä½œã—ã¦ã„ã‚‹ä¸ã€ ã€Œæ±Žç”¨æ€§ãŒã»ã—ãƒã€ã°ã£ã‹ã‚Šã«ãªã‚“ã¨ã‹ VBã®Formaté–¢æ•°ã‚’ä½¿ãˆãªã„ã‹ã¨è‰²ã€…ã¨æŽ¢ã£ã¦ã¿ã¦ã¯ è©¦è¡ŒéŒ¯èª¤ã—ã¦ã¿ã¾ã—ãŸã€‚ sp_OACreateã‚’ä½¿ç”¨ã—ã¦ VBScript(MSScriptControl.ScriptControl)ã‚’ è©¦ã—ã¦ã¿ãŸã‚Š... çµå±€ã¯Excelã«å‚™ã‚ã£ã¦ã„ã‚‹TEXTé–¢æ•°ãŒVBä¸Šã®Format ã®ã‚ˆã†ãªã®ã§ã€ã“ã‚„ã¤ã¨OLEé€£æºã—ã¦ã¿ã‚‹ã“ã¨ã«ã€‚ ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã—ã¦å®Ÿè¡Œã—ã¦ã¿ã‚‹ã¨ã€ 2147024891 (0x80070005) ODSOLE Extended Procedure ã‚¢ã‚¯ã‚»ã‚¹ãŒæ‹’å¦ã•ã‚Œã¾ã—ãŸã€‚ ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã€‚ç™ºç”Ÿç®‡æ‰€ã¯ sp_OACreate 'Excel.Application' ã£ã¦æœ€åˆã˜ã‚ƒãªã„ã‹ãƒã£Î£Î£(ã‚œÐ´ã‚œlll)ã‚ºã‚¬ãƒ¼ãƒ³!! è‰²ã€…
babydaemons 2008/03/19
Computing

Database
ãƒªãƒ³ã‚¯
gr.jp
This domain may be for sale!
babydaemons 2008/03/05
Computing

Database
ãƒªãƒ³ã‚¯
Microsoft Support
babydaemons 2007/12/19
Computing

Database
ãƒªãƒ³ã‚¯
Microsoft â€“ ã‚¯ãƒ©ã‚¦ãƒ‰ã€ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãƒ¼ã€ã‚¢ãƒ—ãƒª & ã‚²ãƒ¼ãƒ
babydaemons 2007/11/26
Computing

Database

SQL Server
ãƒªãƒ³ã‚¯
http://japan.internet.com/developer/20060420/25.html
babydaemons 2007/11/26
Computing

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