[B! database] Nyohoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Nyoho id:Nyoho

databaseã«é–¢ã™ã‚‹Nyohoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (17)

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

æ¼¢å—å—ä½“è¦ç¯„å²ãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆ
æ¼¢å—å—ä½“è¦ç¯„å²ãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆã®æ¦‚è¦ ã“ã®ã‚µã‚¤ãƒˆã¯ã€ã€Œæ¼¢å—å—ä½“è¦ç¯„å²ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆHanzi Normative Glyphsï¼‰ã€ï¼ˆå…¬é–‹æœŸé–“ï¼š2005-2015å¹´ï¼‰ã®å‰èº«ã§ã‚ã‚‹ã€ŒçŸ³å¡šæ¼¢å—å—ä½“è³‡æ–™ã€ã®æƒ…å ±ã‚«ãƒ¼ãƒ‰ã®ç”»åƒã€æ¼¢å—å—å½¢ã®åˆ‡ã‚ŠæŠœãç”»åƒã€åŠã³ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ã‚’ã€Œæ¼¢å—å—ä½“è¦ç¯„å²ãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆã€ã¨ç§°ã—ã¦å…¬é–‹ã™ã‚‹ãƒªãƒã‚¸ãƒˆãƒªã§ã™ã€‚ ã€ŒçŸ³å¡šæ¼¢å—å—ä½“è³‡æ–™ã€ã¯ã€å„æ™‚ä»£ãƒ»å„åœ°åŸŸï¼ˆå›½ï¼‰ã«ã¯æ¼¢å—å—ä½“ã®æ¨™æº–ãŒå˜åœ¨ã—ã€ãã®æ¨™æº–ãŒå¤‰é·ã™ã‚‹ã“ã¨ã‚’å®Ÿè¨¼ã™ã‚‹ãŸã‚ã€åŒ—æµ·é“å¤§å¦åèª‰æ•™æŽˆçŸ³å¡šæ™´é€šæ°ãŒåœ¨è·ä¸ã®å›½èªžå¦æ¼”ç¿’ç‰ã§ä½œæˆã—ãŸã‚‚ã®ã§ã™ã€‚ã€ŒçŸ³å¡šæ¼¢å—å—ä½“è³‡æ–™ã€ã¯ã€æƒ…å ±ã‚«ãƒ¼ãƒ‰ã§æ•´ç†ã•ã‚Œã€2005å¹´9æœˆã®æ™‚ç‚¹ã§ã€æ¼¢ç±ãƒ»ä»å…¸ãƒ»å›½æ›¸ç‰ã®å…¸ç±67è³‡æ–™ã€ç·ç”¨ä¾‹æ•°ç´„40ä¸‡å—ã«é”ã—ãŸè³‡æ–™ç¾¤ã§ã™ã€‚ ã€ŒçŸ³å¡šæ¼¢å—å—ä½“è³‡æ–™ã€ã¯ã€æƒ…å ±ã‚«ãƒ¼ãƒ‰ã®åŠ£åŒ–ã«ã‚ˆã‚‹ä¿å˜ã¨ã€å¦ç•Œã¸ã®ãƒ‡ãƒ¼ã‚¿æä¾›ã®ãŸã‚ã€2000å¹´é ƒã‹ã‚‰åŒ—æµ·é“å¤§å¦æ–‡å¦éƒ¨è¨€èªžæƒ…å ±å¦è¬›åº§æœ‰å¿—ã«ã‚ˆã£ã¦ã€é›»ååŒ–ãŒç€æ‰‹ã•ã‚Œã¾ã—
Nyoho 2018/07/28
æ¼¢å—

database
ãƒªãƒ³ã‚¯
#ronsakucasual DBã®è«–ç†å‰Šé™¤ã«ã¤ã„ã¦ã²ãŸã™ã‚‰å…±æœ‰ã™ã‚‹ è«–ç†å‰Šé™¤ Casual Talks #1 ã«ã„ã£ã¦ããŸã¾ã¨ã‚ - ã‚‚ãã‚ã½ã‚ã
åå‰ ã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚° ç›®çš„ ã‚¨ãƒ³ãƒ‰ãƒ¦ãƒ¼ã‚¶ã‹ã‚‰è¦‹ã‚‹ã¨ãƒ‡ãƒ¼ã‚¿ãŒãªã„ã“ã¨ã«ã—ãŸã„ã‘ã©ã€å®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿ã¯æ¶ˆã—ãŸããªã„ å‰Šé™¤ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’æ¤œç´¢ã—ãŸã„ ãƒ‡ãƒ¼ã‚¿ã‚’æ¶ˆã•ãšã«ãƒã‚°ã«æ®‹ã—ãŸã„ èª¤ã£ãŸæ“ä½œã‚’ãªã‹ã£ãŸã“ã¨ã«ã—ãŸã„ã€ç›´ãã«å…ƒã«æˆ»ã—ãŸã„ ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ ä¾‹ãˆã°is_deletedã¨ã„ã†ã‚«ãƒ©ãƒ ãŒtrueã®å ´åˆã¯å‰Šé™¤ã•ã‚Œã¦ã„ã‚‹ã¨ã¿ãªã™ ãƒ¡ãƒªãƒƒãƒˆ updateæ–‡ãªã‚‰ãƒ‡ãƒ¼ã‚¿ãŒç°¡å˜ã«å…ƒã«æˆ»ã›ã‚‹æ°—ãŒã™ã‚‹ã®ã§ãªã‚“ã¨ãªãå®‰å¿ƒ -> ä¿ºã®updateæ–‡ã§ãªã‚“ã¨ã‹ãªã‚‹ï¼ï¼ èµ·ã“ã‚‹ã“ã¨ SELECTã™ã‚‹ã¨ãã«ã¯å¸¸ã«WHEREå¥ãŒè¿½åŠ ã§å¿…è¦ã«ãªã‚Šã€ã‚³ãƒ¼ãƒ‰ãŒå‰Šé™¤ãƒ•ãƒ©ã‚°ã ã‚‰ã‘ã«ãªã‚‹ å…¨å“¡ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã«ç²¾é€šã—ã¦ã‚‹ã‚ã‘ã§ã¯ãªã„ã®ã§ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚ˆã£ã¦å‰Šé™¤ãƒ•ãƒ©ã‚°ã®æœ‰ç„¡ãŒã‚ã£ãŸã‚Šã—ãŸå ´åˆã€èªè˜ã®é½Ÿé½¬ã‚’ç”Ÿã¿ã‚„ã™ã„ ä¾‹ãˆã°rubyã§default_scopeã‚’ç”¨ã„ã¦ã€ã‚ˆã‹ã‚Œã¨ãŠã‚‚ã£ã¦ã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ™ãƒ«ã§ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚’å¤‰ãˆãŸã‚‰ãƒã‚°ãŒãŸãã•ã‚“å‡ºã¦ãã‚‹
Nyoho 2015/09/01
db

database
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ å¹»ã®ç¬¬26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ 26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€ 2015/08/31 @ GMO Yours #ronsakucasual https://atnd.org/events/68902
Nyoho 2015/09/01
è«–ç†å‰Šé™¤

db

database
ãƒªãƒ³ã‚¯
è«–ç†å‰Šé™¤ Casual Talks #1 ã§ã€Œè«–ç†å‰Šé™¤ã—ãªã„ã€ã¨ã„ã†è©±ã‚’ã—ã¾ã—ãŸ - moroã®ãƒ–ãƒã‚°
äº’ã„ã®å‰è·ã§ã®å…ˆè¼©å¾Œè¼©ã§ã‚ã‚‹ @kenchan ã¨ä¼ç”»ã—ãŸè«–ç†å‰Šé™¤ Casual Talks #1ã§ã€ã€Œè«–ç†å‰Šé™¤ã—ãªã„ã€ã¨ã„ã†è©±ã‚’ã—ã¦ãã¾ã—ãŸã€‚ è©±ã™å†…å®¹ãŒå„è©±è€…ã§é¢ç™½ã„ã»ã©ã‹ã¶ã£ã¦ã„ãŸã®ã§ãªã‹ãªã‹å¤§å¤‰ã§ã—ãŸãŒã€æ™®æ®µã‹ã‚‰è¨€ã£ã¦ã„ã‚‹ã€Œè«–ç†å‰Šé™¤ã™ã‚‹ãªã€ã€Œå‰Šé™¤ã˜ã‚ƒãªã„ã‹ã‚‰ã¡ã‚ƒã‚“ã¨æ©Ÿèƒ½ã‚’è¨è¨ˆã—ã¾ã—ã‚‡ã†ã€ã¨ã„ã†å†…å®¹ã‚’è©±ã—ã¦ãã¾ã—ãŸã€‚ ä»–ã®æ–¹ã®è©±ã‚‚ã€ã‹ã¶ã£ã¦ã„ã‚‹ã‚ˆã†ã§æ–°ã—ã„è¦–ç‚¹ã‚‚ã‚ã£ã¦ã€ã„ã¡å‚åŠ è€…ã¨ã—ã¦ã‚‚ãŸã„ã¸ã‚“å‹‰å¼·ã«ãªã‚Šã¾ã—ãŸã€‚
Nyoho 2015/09/01
ãªã‚‹ã»ã©ã€Œãƒ‡ãƒ¼ã‚¿ã®çµ‚ã‚ã‚Šæ–¹ã€ã‚’è¨è¨ˆã§ãã¦ãªã„ã‹ã‚‰è«–ç†å‰Šé™¤ã¨ã„ã†å®Ÿã¯ãªã„ã‚‚ã®ã§ãµã‚ã£ã¨æ›–æ˜§ã«ã—ã¦ã—ã¾ã£ã¦ã„ãŸã®ã‹ã€œã€‚

DB

database
ãƒªãƒ³ã‚¯
ã€ŽCassandraã®ãƒ‡ãƒ¼ã‚¿è¨è¨ˆã§æ³¨æ„ã—ã¦ã„ã‚‹ã“ã¨ã€
Ameba Smart Phone Platformã®APIé–‹ç™ºã‚’æ‹…å½“ã—ã¦ã„ã‚‹ç‹é–“ã¨ç”³ã—ã¾ã™ã€‚ä»Šå›žã¯Ameba Smart Phone Platformã§ä½¿ç”¨ã—ã¦ã„ã‚‹Cassandraã®ãƒ‡ãƒ¼ã‚¿è¨è¨ˆæ™‚ã«æ°—ã‚’ã¤ã‘ã¦ã„ã‚‹ã“ã¨ã‚’å®Ÿéš›ã«èµ·ããŸäº‹ä¾‹ã‚’äº¤ãˆã¦ãŠè©±ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ Cassandraã®verstionã¯1.1.5ã‚’ä½¿ç”¨ã—ã¦ã„ã¦ã€100å°æ§‹æˆã®ã‚¯ãƒ©ã‚¹ã‚¿ã‚’çµ„ã‚“ã§ã„ã¾ã™ã€‚ãƒ”ãƒ¼ã‚¯å¸¯ã§ã¯ãŠã‚ˆã50000write/secã€40000read/secã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’å‡¦ç†ã—ã¦ã„ã¦ã€ãŠã‚ˆã45TBã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿æŒã—ã¦ã„ã¾ã™ã€‚ãã®ã‚ˆã†ãªæ¡ä»¶ä¸‹ã§ç™ºç”Ÿã—ãŸäº‹ä¾‹ã¨å¯¾å‡¦æ–¹æ³•ã‚’ç´¹ä»‹ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚
Nyoho 2014/08/26
cassandra

database

design
ãƒªãƒ³ã‚¯
Scheman - r7km/s
Schemanã¨ã„ã†ã€Rubyè£½ã®SQLãƒ‘ãƒ¼ã‚µã‚’ã¤ãã£ãŸã€‚ ä¾‹ æ–‡ç« ã§èª¬æ˜Žã™ã‚‹ã‚ˆã‚Šè¦‹ãŸã»ã†ãŒæ—©ã„ã ã‚ã†ã¨ã„ã†ã“ã¨ã§ã€ä¾‹ã‚’ç”¨æ„ã—ãŸã€‚ require "scheman" require "yaml" parser = Scheman::Parsers::Mysql.new schema = parser.parse(<<SQL) CREATE TABLE `users` ( `id` INTEGER(11) NOT NULL PRIMARY KEY AUTO INCREMENT, `name` VARCHAR(255) NOT NULL ); SQL puts schema.to_hash.to_yaml æ§‹æ–‡è§£æžçµæžœã¯Hash, Array, Symbol, Stringã®çµ„åˆã›ã§è¡¨ç¾ã•ã‚Œã‚‹ (â€»å¯èªæ€§ã®ãŸã‚ã«YAMLå½¢å¼ã§è¡¨ç¤ºã—ãŸ) --- - :create_table: :name:
Nyoho 2014/07/10
Rubyè£½ã®SQLãƒ‘ãƒ¼ã‚µã ã¨â€¦!

dsl

database

sql

Ruby
ãƒªãƒ³ã‚¯
å„ç¨®DBã®Macç”¨GUIã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ - komagataã®ãƒ–ãƒã‚°
å†…éƒ¨ãƒ„ãƒ¼ãƒ«ï¼ˆåƒ•ã‚‰ã§ã„ãˆã°256interns.comã¨ã‹ï¼‰ã¯ç®¡ç†ç”»é¢ä½œã‚‰ãšGUIã‚¢ãƒ—ãƒªã§å¤‰æ›´ã¨ã‹çµæ§‹ä¾¿åˆ©ã§ã™ã€‚ã¨ã¯ã„ãˆã€railsãªã©ã®ã‚¢ãƒ—ãƒªå´ã®ã¿ã§validationã—ã¦ã‚‹ã¨ä¸æ•´åˆãŒèµ·ãã‚‹ã®ã§è¦æ³¨æ„ã€‚ã“ã‚Œå‰æã§åˆ¶ç´„è¿½åŠ ã™ã‚‹ã®ã‚‚ã„ã„ã‹ã‚‚ï¼Ÿ Sequel Pro MySQLã®GUIã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã€‚ã“ã‚Œã‚’æ•™ãˆã¦ã‚‚ã‚‰ã£ã¦è¨ã—ã’ã«ä½¿ã£ã¦ã¿ãŸã‚“ã§ã™ãŒã€ä»Šé¢¨ã®Macã®ä½¿ã„å‹æ‰‹ã§ä½¿ãˆã‚‹ã®ãŒã™ã”ãæ°—ã«å…¥ã£ã¡ã‚ƒã„ã¾ã—ãŸã€‚ SSLçµŒç”±ã‚„sshã§å…¥ã£ãŸã‚µãƒ¼ãƒãƒ¼è¸ã¿å°ã«ã—ã¦ã®æŽ¥ç¶šã‚‚ä¸€ç™ºã§ãã¦ä¾¿åˆ©ã€‚ PG Commander PostgreSQLã®GUIã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã€‚Sequel Proã«æ¯”ã¹ã‚‹ã¨ä½¿ã„å‹æ‰‹ã¯è‰¯ããªã„ã‘ã©ã€Herokuã®DBã«æŽ¥ç¶šã§ãã‚‹ï¼ã“ã‚ŒãŒãƒ‡ã‚«ã‚¤ã€‚ æŽ¥ç¶šå…ˆã®ãƒ–ã‚¯ãƒžã‚’ï¼•å€‹ä»¥ä¸Šä¿å˜ã—ã¦ãŠãã«ã¯Lisenceã‚’è²·ã†å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚Herokuã‚’å¤šç”¨ã™ã‚‹ã‹ã‚‰ï¼•å€‹ã‚ã£ã¨ã„ã†é–“ã«è¶…ãˆã¡ã‚ƒã†ã®ã§è²·ã„ã¾ã—ãŸã€‚ B
Nyoho 2014/04/20
db

mac

heroku

Rails

database
ãƒªãƒ³ã‚¯
Facebookã‚„Googleã€ã€ŒWebScaleSQLã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹
ç±³Facebookã¯3æœˆ27æ—¥ï¼ˆç¾åœ°æ™‚é–“ï¼‰ã€ç±³Googleã€ç±³Twitterã€ç±³LinkedInã¨å”åŠ›ã—ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒMySQLã€ã®ãƒ–ãƒ©ãƒ³ãƒã€ŒWebScaleSQLã€ã‚’GitHubã§å…¬é–‹ã—ãŸã¨ç™ºè¡¨ã—ãŸã€‚ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯GNU General Public License Ver.2ã€‚ WebScaleSQLã¯ã€MySQLã‚’å¤§è¦æ¨¡ãªã‚·ã‚¹ãƒ†ãƒ ã§ä½¿ã†4ç¤¾ãŒç›´é¢ã™ã‚‹å…±é€šã®å•é¡Œã‚’è§£æ±ºã™ã‚‹ç›®çš„ã§å…±åŒé–‹ç™ºã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€MySQLã«å¤§è¦æ¨¡ãªç’°å¢ƒã¸ã®å°Žå…¥ã«ç‰¹åŒ–ã—ãŸæ©Ÿèƒ½ã‚’è¿½åŠ ã—ãŸã‚‚ã®ã¨ã„ã†ã€‚ é–¢é€£è¨˜äº‹ Facebookã€æ–°ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã€ŒHackã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ FacebookãŒç¤¾å†…ã§ä½¿ã£ã¦ã„ã‚‹PHPãƒ™ãƒ¼ã‚¹ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã€ŒHackã€ã‚’BSDãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§å…¬é–‹ã—ãŸã€‚ Twitterã€MySQLã®ç‹¬è‡ªãƒ„ãƒ¼ãƒ«ã‚’GitHubã§å…¬é–‹ TwitterãŒã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹My
Nyoho 2014/03/29
database
ãƒªãƒ³ã‚¯
Database Encryption - r7kamura per second
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æš—å·åŒ–ç•Œéšˆã®è©±ã‚’èª¿ã¹ãŸã®ã§Q&Aå½¢å¼ã§ã¾ã¨ã‚ãŸã€‚ ãªãœæš—å·åŒ–ã‚’è¡Œã†ã®ã‹ï¼Ÿ ä¸€èˆ¬çš„ã«ã¯ã€ä»¥ä¸‹ã®æ§˜ãªæƒ…å ±ã®æ¼æ´©ã‚’é˜²ããŸã‚ã€‚ å€‹äººãŒè˜åˆ¥ã§ãã‚‹æƒ…å ± å€‹äººã®è¡Œå‹•å±¥æ´ è²¡å‹™æƒ…å ± çŸ¥çš„è²¡ç”£ è²¡ç”£ ãã®ä»–é–‹ç¤ºã•ã‚Œã¦ã„ãªã„æƒ…å ± æœ€è¿‘æ—¥æœ¬ã§å¤§ããªæƒ…å ±æ¼æ´©è¢«å®³ã«ã‚ã£ãŸä¼æ¥ä¾‹ã¯ï¼Ÿ Sony (PlayStation Network) Yahoo! Japan LINE 2ch @PAGES ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æš—å·åŒ–ã«ãŠã‘ã‚‹ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã¯ï¼Ÿ StackOverflowç‰ã®æ„è¦‹ã‚’é›†ã‚ãŸé™ã‚Šã€ã“ã®è¾ºã‚’å…¨éƒ¨ã‚„ã‚‹ã¨ã„ã†ã®ãŒãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã¨ã„ã†é›°å›²æ°—ã€‚ é€šä¿¡ãƒ‡ãƒ¼ã‚¿ã®æš—å·åŒ–: SSL æ ¼ç´ãƒ‡ãƒ¼ã‚¿ã®æš—å·åŒ–: FDE + TDE (å¾Œè¿°) æ ¼ç´ãƒ‡ãƒ¼ã‚¿ã®æš—å·åŒ–æ©Ÿèƒ½ã‚’æä¾›ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã®ä¾‹ã¯ï¼Ÿ Amazon RDS for Oracle Amazon RDS for SQL Server Amazon S3 G
Nyoho 2014/03/16
database

security

encryption
ãƒªãƒ³ã‚¯
Git: the NoSQL Database
Check out the video for this talk: https://vimeo.com/56645405 We all know that Git is amazing for storing code. It is fast, reliable, flexible, and iâ€¦
Nyoho 2013/12/28
Git ã‚’ NoSQL ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ä½¿ãŠã†ã€ã ã¨â€¦

git

database

NoSQL
ãƒªãƒ³ã‚¯
A New Concept of Consistency in Distributed Database and Implementation in Riak
Web+DB forum æŠ€è¡“å ±å‘Š by Basho
Nyoho 2013/12/01
database

riak
ãƒªãƒ³ã‚¯
MimicDB
>>> c = S3Connection(KEY, SECRET) >>> bucket = c.get_bucket('bucket_name') >>> start = time.time() >>> bucket.get_all_keys() >>> print time.time() - start 0.425064992905 >>> c = S3Connection(KEY, SECRET) >>> bucket = c.get_bucket('bucket_name') >>> start = time.time() >>> bucket.get_all_keys() >>> print time.time() - start 0.000198841094971 Works with Python and Boto MimicDB wraps every S3 API cal
Nyoho 2013/11/21
redis

database
ãƒªãƒ³ã‚¯
é•·å¹´ã®è°è«–ã«çµ‚æ¢ç¬¦ -- MySQLã¨MariaDBã®é•ã„ä¸€è¦§ - æŠ€è¡“ãƒ¡ãƒ¢ç½®ãå ´
(2014.12.3è¿½è¨˜ï¼šã“ã®blogã®å†…å®¹ã¯ã€ä»¥ä¸‹ã®æ›¸ç±ã«ã‚‚åæ˜ ã•ã›ãŸã€‚) SQLãƒ¬ãƒ™ãƒ«ã®å·®ç•° MariaDB5.5ã¨MySQL5.5ã§ã¯SQLãƒ¬ãƒ™ãƒ«ã§ã®é•ã„ã¯ã»ã¨ã‚“ã©ãªã‹ã£ãŸã€‚autoincrementã®æœ€å¤§å€¤ã®æ‰±ã„ãã‚‰ã„ã€‚ ãŸã ã—ã€MariaDB10.0ã§REGEXPãŒãƒžãƒ«ãƒãƒã‚¤ãƒˆå¯¾å¿œã«ãªã£ãŸã®ã§ã€ã‚¢ãƒ—ãƒªå´ã¯æ³¨æ„ã€‚ é …ç›® MySQL MariaDB Autoincrement æœ€å¤§å€¤ã«é”ã™ã‚‹ã¨ã€ä»¥é™ã¯æœ€å¤§å€¤ã‚’ç¹°ã‚Šè¿”ã™ã€‚Warningã®ã¿ã€‚ã‚¨ãƒ©ãƒ¼ã«ãªã‚‰ãªã„ã€‚tinyintãªã‚‰â€¦,125,126,127,127,127â€¦ æœ€å¤§å€¤-1ã¾ã§ã€‚ä»¥é™ã¯ã‚¨ãƒ©ãƒ¼ã‚’è¿”ã™ã€‚tinyintãªã‚‰â€¦,125,126,ERROR,ERROR,â€¦ EXPLAINæ–‡ JSONå½¢å¼ ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œ Optimizer Trace ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œï¼ˆãŸã ã—ã€MariaDBã®ã»ã†ãŒã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶
Nyoho 2013/09/20
mariadb

MySQL

database

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
Devsã®å¸¸è˜ã€DBAã¯éžå¸¸è˜
PostgreSQLã‚’Kubernetesä¸Šã§æ´»ç”¨ã™ã‚‹ãŸã‚ã®Operatorç´¹ä»‹ï¼ï¼ˆCloud Native Database Meetup #3 ç™ºè¡¨è³‡æ–™ï¼‰
Nyoho 2013/09/15
MySQL

database
ãƒªãƒ³ã‚¯
MySQL Indexå‹‰å¼·ä¼šå¤–éƒ¨å…¬é–‹ç”¨
PostgreSQL14ã® pg_stat_statements æ”¹å–„ï¼ˆç¬¬23å›žPostgreSQLã‚¢ãƒ³ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹@ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ ç™ºè¡¨è³‡æ–™ï¼‰
Nyoho 2013/09/13
performance

mysql

database

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
Herokuã§DBã®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ - ã‚¢ã‚¤ãƒ³ã‚·ãƒ¥ã‚¿ã‚¤ãƒ³ã®é›»è©±ç•ªå·
Herokuã‚¢ãƒ—ãƒªã®DBã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã«ã¯pgbackupsã¨ã„ã†ã‚¢ãƒ‰ã‚ªãƒ³ã‚’åˆ©ç”¨ã™ã‚‹ã€‚æ˜¨æ—¥æ›¸ã„ãŸæ–¹æ³•ã¨ã®ä¸»ãªé•ã„ã¯ã€ä»Šå›žã®ã¯Herokuã®ã‚µãƒ¼ãƒãƒ¼ä¸Šã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã•ã‚Œã‚‹ã“ã¨ã¨ã€ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã®å¤‰æ›ã¯ã§ããªã„ã“ã¨ã€ã‚ãŸã‚Šã‹ãªã€‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å‡¦ç†ã‚’è‡ªå‹•åŒ–ã™ã‚‹å ´åˆã¯ä»Šå›žã®æ–¹æ³•ãŒè‰¯ã„ã¿ãŸã„ã€‚ ã‚¢ãƒ‰ã‚ªãƒ³è¿½åŠ ã¾ãšã€herokuã‚³ãƒžãƒ³ãƒ‰ãŒä½¿ãˆã‚‹gemã®herokuã‚’æœ€æ–°ã®çŠ¶æ…‹ã«ã™ã‚‹ã€‚ $ gem update heroku æ¬¡ã«ã€å¯¾è±¡ã®Herokuã‚¢ãƒ—ãƒªã«pgbackupsã‚¢ãƒ‰ã‚ªãƒ³ã‚’è¿½åŠ ã™ã‚‹ã€‚Basicã‚¿ã‚¤ãƒ—ã¯ç„¡æ–™ã€‚ $ heroku addons:add pgbackups:basic --app heroku-hello-world ã“ã‚Œã§æº–å‚™å®Œäº†ã€‚ Heroku(Amazon S3)ä¸Šã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹ã€‚ $ heroku pgbackups:capture -
Nyoho 2013/03/08
Heroku

database

backup
ãƒªãƒ³ã‚¯
heroku ã§åˆ©ç”¨ä¸ã® DB ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚º - Qiita
ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ãŒçŸ¥ã‚ŠãŸã„ã®ã ã‘ã‚Œã©ã€heroku info ã‚³ãƒžãƒ³ãƒ‰ã§ã¯æ¬²ã—ã„å€¤ãŒå¾—ã‚‰ã‚Œãªã„ã€‚heroku ãŒæä¾›ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç„¡æ–™é ˜åŸŸã¯ <del> 5MB ã¨ã„ã†ã‚ã¾ã‚Šã«ã‚‚è²§å¼±ãªå®¹é‡ãªã®ã§ã€ã“ã®ã¾ã¾ã§ã¯å®‰å¿ƒã—ã¦éŠã¹ãªã„ã€‚</del> ç¾åœ¨ã® PostgreSQL : Dev Plan ã§ã¯ "10,000 row limit" ã¨ã®ã“ã¨ã€‚ ãã“ã§è¦‹ã¤ã‘ãŸã‚¨ãƒ³ãƒˆãƒª herokuã§ã®Webã‚¢ãƒ—ãƒªé–‹ç™ºã¨é‹ç”¨ï¼ˆãã®4ï¼šãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚ºè‚¥å¤§åŒ–ã®å¯¾å‡¦ï¼‰ heroku run console å¾Œã«ä¸‹è¨˜ã‚’å®Ÿè¡Œã—ã¦ ( å®Ÿéš›ã«ã¯ä¸€è¡Œ ) ActiveRecord::Base.connection.select_all( "SELECT relname, relkind, to_char(reltuples, '999,999,999') as rows, to_char(pg_relation_size
Nyoho 2013/03/08
Heroku

database
ãƒªãƒ³ã‚¯
1