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

rarere id:rarere

DBã«é–¢ã™ã‚‹rarereã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

O/Rãƒžãƒƒãƒ‘ãƒ¼ã«ã‚ˆã‚‹ãƒˆãƒ©ãƒ–ãƒ«ã‚’æœªç„¶ã«é˜²ã
2. copyright Â© 2014 kuwata-lab.com all rights reserved ã¾ãˆãŒã ç¾åœ¨ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã®ç¾å ´ã§ã¯ O/R Mapper (ORM) ãŒæ™®åŠã—ã¦ã„ã¾ã™ã€‚ä»Šå¾Œ ã‚‚ ORM ã‚’ä½¿ã£ãŸé–‹ç™ºã¯ã€å¢—ãˆã‚‹ã“ã¨ã¯ã‚ã£ã¦ã‚‚æ¸›ã‚‹ã“ã¨ã¯ãªã„ã§ã—ã‚‡ã†ã€‚ ã—ã‹ã— ORM ã¯ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºè€…ã«ã¨ã£ã¦ã¯ä¾¿åˆ©ã§ã‚‚ã€DB ç®¡ç†è€… (DBA) ã‹ ã‚‰ã¿ãŸã‚‰ãƒˆãƒ©ãƒ–ãƒ«ã®ç¨®ã§ã‚‚ã‚ã‚Šã¾ã™ã€‚ãã‚ŒãŒç‰¹ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é–¢ã™ã‚‹å•é¡Œã§ã‚ã‚‹ã“ ã¨ãŒå¤šã„ãŸã‚ã€é–‹ç™ºè€…ã¨ DBA ãŒå¯¾ç«‹ã™ã‚‹ã“ã¨ã‚‚çã—ãã‚ã‚Šã¾ã›ã‚“ã€‚ ã¨ã¯ã„ãˆã€ORM ã«ã‚ˆã‚‹å•é¡Œã¯ã™ã§ã«è§£æ±ºç–ãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚æœ¬å½“ã® å•é¡Œã¯ã€ã™ã§ã«å˜åœ¨ã™ã‚‹è§£æ±ºç–ãŒã‚ã¾ã‚ŠçŸ¥ã‚‰ã‚Œã¦ã„ãªã„ã“ã¨ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ãã“ã§æœ¬ç™ºè¡¨ã§ã¯ã€ORM ã«ã‚ˆã£ã¦ã©ã®ã‚ˆã†ãªå•é¡ŒãŒèµ·ã“ã‚Šã‚„ã™ã„ã‹ã€ã©ã†è§£æ±ºãƒ»äºˆé˜² ã™ã‚Œã°ã„ã„ã‹ã€ãã—ã¦ ORM
rarere 2014/12/22
DB

sql
ãƒªãƒ³ã‚¯
Adminer - Database management in a single PHP file
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, Mongo DB and others via plugin. Features, Requirements, Skins, References Why is Adminer better than phpMyAdmin? Replace phpMy
rarere 2014/09/04
MySQL

php

DB
ãƒªãƒ³ã‚¯
mysqldump ã®çµæžœã‚’ãã®ã¾ã¾åœ§ç¸®ã—ãŸã‚Šè»¢é€ã—ãŸã‚Šã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ä¾‹ | ãƒã‚·ãƒ£ãƒã‚°ã€‚
ã¡ã‚‡ã£ã¨é…ã‚ã®å¤ä¼‘ã¿ã‚’ã‚‚ã‚‰ã£ã¦å…«ä¸ˆå³¶ã«è¡Œã£ã¦ãã¾ã—ãŸ nakamura ã§ã™ï¼ã„ã„æ‰€ã™ãŽã¦å±ã†ããã®ã¾ã¾ç§»ä½ã™ã‚‹ã¨ã“ã‚ã§ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç§»è¡Œã‚’ã™ã‚‹éš›ã¿ãªã•ã‚“ã©ã‚“ãªæµã‚Œã§ä½œæ¥ã—ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ã€‚ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§ãƒ€ãƒ³ãƒ—ã‚’å–ã£ã¦ã€ã‚µã‚¤ã‚ºãŒå¤§ãã‹ã£ãŸã‚‰ gzip ã§åœ§ç¸®ã—ã¦ã€WinSCP ã§ãã‚Œã‚’ãƒãƒ¼ã‚«ãƒ«ã«è½ã¨ã—ã¦ãã¦ã€ãã‚Œã‚’ã¾ãŸåˆ¥ã®ã‚µãƒ¼ãƒã«ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¦ãƒ»ãƒ»ãƒ»ãƒ»ãªã‚“ã¦äº‹ã—ã¦ãŸã‚Šã—ã¾ã›ã‚“ã‹ï¼Ÿ ã‚·ã‚§ãƒ«ã®ãƒ‘ã‚¤ãƒ—ã‚„ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã‚’ã†ã¾ãä½¿ã£ã¦ã‚ã’ã‚Œã°ã€ã“ã®è¾ºã‚Šã¯ã‚³ãƒžãƒ³ãƒ‰ä¸€ç™ºã§ã„ã‘ã¡ã‚ƒã£ãŸã‚Šã™ã‚‹ã®ã§ã™ã€‚ä»Šæ—¥ã¯ãã‚“ãªã‚³ãƒžãƒ³ãƒ‰ä¾‹ã®ã”ç´¹ä»‹ã§ã™ã€‚ å®Ÿéš›ã«ã‚ˆãä½¿ã†ã‚³ãƒžãƒ³ãƒ‰ã®ä¾‹ã‚’ç®‡æ¡æ›¸ãã§ã€‚ ã¨ã‚Šã‚ãˆãšãƒ€ãƒ³ãƒ—ã®çµæžœã‚’ãã®ã¾ã¾åœ§ç¸®ã™ã‚‹ã€‚ mysqldump -udb_user db_name -pdb_pass | gzip > db_name.dump.sql.gz ç‰¹å®šã®æ–‡å—åˆ—ã‚’ç½®æ›ã—ãŸä¸Šã§åœ§ç¸®ã™ã‚‹ã€‚ MT
rarere 2014/06/09
DB
ãƒªãƒ³ã‚¯
Windowsä¸Šã§Mojoliciousã®é–‹ç™ºã‚’å§‹ã‚ã¦ã€ã•ãã‚‰ã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã§å…¬é–‹ã™ã‚‹ã¾ã§ã®æ‰‹é † - Perlå…¥é–€ã‚¼ãƒŸ
Perl â€º Mojolicious Windowsä¸Šã§Mojoliciousã¨ã„ã†Webãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’ä½¿ã£ã¦Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™ºã‚’è¡Œã„ã€ã•ãã‚‰ã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã®ãƒ©ã‚¤ãƒˆãƒ—ãƒ©ãƒ³ã§å…¬é–‹ã™ã‚‹ã¾ã§ã®æ‰‹é †ã‚’æ›¸ããŸã„ã¨æ€ã„ã¾ã™ã€‚ãƒ©ã‚¤ãƒˆãƒ—ãƒ©ãƒ³ã¯ï¼‘ãƒ¶æœˆã‚ãŸã‚Š125å††ãªã®ã§æ°—è»½ã«Webãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’è©¦ã—ã¦ã¿ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ç¾ä»£çš„ãªWebãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’ä½¿ã£ã¦ã€æ°—è»½ã«Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œæˆã§ãã‚‹ã®ã¯Perlã®è‰¯ã„ã¨ã“ã‚ã§ã™ãã€‚ ã¾ãŸSQLiteã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚‚ä½¿ã£ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ç’°å¢ƒæ§‹ç¯‰ ActivePerlã«ã¯DBD::SQLiteã¨DBIãŒå«ã¾ã‚Œã¦ã„ã¾ã™ã‹ã‚‰ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–¢é€£ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã¾ãŸã•ãã‚‰ã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã§ã‚‚SQLiteãŒæœ€åˆã‹ã‚‰åˆ©ç”¨ã§ãã¾ã™ã®ã§ã€ã“ã¡ã‚‰ã‚‚ä½•ã®æº–å‚™ã‚‚ã™ã‚‹å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ è¡Œã†ã“ã¨ã¯Mojoliciousã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰
rarere 2014/05/18
Mojolicious

DB
ãƒªãƒ³ã‚¯
SQLZoo
Tutorials: Learn SQL step by step 0 SELECT basics Some simple queries to get you started 1 SELECT name Some pattern matching queries 2 SELECT from World In which we query the World country profile table. 3 SELECT from Nobel Additional practice of the basic features using a table of Nobel Prize winners. 4 SELECT within SELECT In which we form queries using other queries. 5 SUM and COUNT In which we
rarere 2014/02/26
sql

DB

*ã‚ã¨ã§
ãƒªãƒ³ã‚¯
MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®åŸºæœ¬
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å‹‰å¼·ä¼š#2 (#bkstudy) ã§ã®ç™ºè¡¨è³‡æ–™ã§ã™ã€‚ http://atnd.org/event/bkstudy02 MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®åŸºæœ¬çš„ãªå†…å®¹ã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã„ã¾ã™ã€‚Read less
rarere 2014/01/16
MySQL

DB

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—
ãƒªãƒ³ã‚¯
MySQLã§å‚ç…§ã®è² è·åˆ†æ•£ã‚’è¡Œã†slaveã¯3å°ã‹ã‚‰æ§‹æˆã™ã‚‹ã®ãŒã‚ˆã„ã®ã§ã¯ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
å‰å›žã®è¨˜äº‹ MySQLã‚’master:slave=1:1æ§‹æˆã«ã—ã¦å‚ç…§ã‚’slaveã«å‘ã‘ã‚‹ã®ãŒãªãœè‰¯ããªã„ã‹ ã®ç¶šãã§ã™ã€‚ master : slave = 1 : 1 ã§å‚ç…§ã‚’ slave ã«åˆ†æ•£ã—ã¦ã‚‚ã¾ã£ãŸãç¾Žå‘³ã—ããªã„ã‚ã‘ã§ã™ãŒã€ã§ã¯å‚ç…§ã®è² è·åˆ†æ•£ã‚’è¡Œã„ãŸã„å ´åˆã® slave ã¯ä½•å°ã§æ§‹æˆã™ã‚‹ã¨ã‚ˆã„ã®ã‹è€ƒå¯Ÿã—ã¦ã¿ã¾ã™ã€‚å…·ä½“çš„ã«ã¯ slave 2å°ã®å ´åˆã¨ 3å°ã®å ´åˆã§ã©ã¡ã‚‰ãŒãŠå¾—ã‹ã€‚ å°æ•°ã‚’å¢—ã‚„ã™ã¨ã„ã†ã“ã¨ã¯ã€ã©ã“ã‹ã«éšœå®³ãŒç™ºç”Ÿã™ã‚‹ç¢ºçŽ‡ãŒé«˜ã¾ã‚‹ã€ã¨ã„ã†ã“ã¨ã§ã™ã€‚1å°ã® slave ã«éšœå®³ãŒç™ºç”Ÿã—ã¦ãƒ€ã‚¦ãƒ³ã—ãŸå ´åˆã®ã“ã¨ã‚’è€ƒãˆã¦ã¿ã¾ã™ã€‚ slave * 2 â†’ æ®‹ã‚Š 1å°ã§å‡¦ç†ç¶™ç¶š ç”Ÿãæ®‹ã£ãŸ1å°ã‚ãŸã‚Šã®å‡¦ç†ãŒ 2å€ã«ãªã‚‹ slave * 3 â†’ æ®‹ã‚Š 2å°ã§å‡¦ç†ç¶™ç¶š ç”Ÿãæ®‹ã£ãŸ1å°ã‚ãŸã‚Šã®å‡¦ç†ãŒ 1.5å€ã«ãªã‚‹ ãŸã¨ãˆã° 1å°ã‚ãŸã‚Šæœ€å¤§ 1000qps ã®å‡¦ç†èƒ½åŠ›ãŒã‚ã‚‹ã¨ã—ã¾ã™ã€‚sla
rarere 2014/01/15
MySQL

DB
ãƒªãƒ³ã‚¯
MySQLã‚’master:slave=1:1æ§‹æˆã«ã—ã¦å‚ç…§ã‚’slaveã«å‘ã‘ã‚‹ã®ãŒãªãœè‰¯ããªã„ã‹ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
MySQLã®masterã¨slave 1:1ã«ã—ã¦å‚ç…§ã‚’slaveå‘ã‘ã‚‹ã®ã£ã¦ã‚„ã‚ŠãŸãŒã‚‹äººå¤šã„ã¿ãŸã„ã ã‘ã©ã€æ€§èƒ½ãŸã„ã—ã¦ä¸ŠãŒã‚‰ãªã„å‰²ã«å¯ç”¨æ€§è½ã¡ã‚‹ã ã‘ã ã‹ã‚‰ã‚„ã‚ã‚ˆã†ã‚ãƒ£ãƒ³ãƒšãƒ¼ãƒ³ 2011-06-19 00:16:30 via YoruFukurou MySQL ã¯ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒç°¡å˜ã«æ§‹æˆã§ãã‚‹ã®ã§ã™ãŒã€æ™‚æŠ˜ master 1å° ã«å¯¾ã—ã¦ slave 1å°ã€æ›´æ–°å‡¦ç†ã¯ master ã«ã€å‚ç…§ã¯ slave ã«ã€ã¨ã„ã†æ§‹æˆã‚’ç›®ã«ã—ã¾ã™ã€‚ å€‹äººçš„ã«ã¯ã“ã®æ§‹æˆã¯ãŠå‹§ã‚ã§ãªã„ã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã€ãã®ç†ç”±ã‚’è€ƒå¯Ÿã—ã¦ã¿ã¾ã™ã€‚ 1. å¯ç”¨æ€§ãŒè½ã¡ã‚‹ å½“ç„¶ã§ã™ãŒã€master, slave ã®ã©ã¡ã‚‰ãŒè½ã¡ã¦ã‚‚å½±éŸ¿ã‚’å—ã‘ã‚‹ãŸã‚ã«å¯ç”¨æ€§ãŒä½Žä¸‹ã—ã¾ã™ã€‚ 2. å…¨ä½“ã®æ€§èƒ½ãŒã»ã¨ã‚“ã©ä¸ŠãŒã‚‰ãªã„ master 1å°ã§ã™ã¹ã¦ã®ã‚¯ã‚¨ãƒªã‚’å‡¦ç†ã™ã‚‹å ´åˆã¨æ¯”ã¹ã¦ã€å¯ç”¨æ€§ãŒè½ã¡ã‚‹å¼•ãæ›ãˆã¨ã—ã¦è¦‹åˆã£ãŸæ€§èƒ½å‘ä¸ŠãŒå¾—ã‚‰ã‚Œã‚‹ã‹ã€ã¨ã„ã†
rarere 2014/01/15
MySQL

DB
ãƒªãƒ³ã‚¯
ç„¡ç²¾ã§çŸæ°—ã§å‚²æ…¢ãªãƒ—ãƒã‚°ãƒ©ãƒž perl+DBI ãƒ—ãƒã‚°ãƒ©ãƒ ã®é‰„å‰‡ - fetchrow_arrayref ã‚’ä½¿ãˆ
perl+DBI ãƒ—ãƒã‚°ãƒ©ãƒ ã®é‰„å‰‡ ã®ã¤ã¤ãã€‚ é‰„å‰‡ãã®3. while ( my $arr_ref = $sth->fetchrow_arrayref ){ my ($hoge, $fuga) = @$arr_ref; ... } SELECT æ™‚ã¯ä¸Šè¨˜ã®ã‚ˆã†ã« fetchrow_arrayref ã‚’ä½¿ã†ã“ã¨ã€‚ãã—ã¦å¿…ãšã‚¹ã‚«ãƒ©ãƒ¼ã« ä»£å…¥ã™ã‚‹ã“ã¨ã€‚ã›ã£ã‹ã fetchrow_arrayref ã‚’ä½¿ã£ã¦ã„ã¦ã‚‚ while ( my $arr_ref = $sth->fetchrow_arrayref ){ print "$$arr_ref[0] $$arr_ref[1]\n"; } ãªã©ã¨æ›¸ã„ã¦ã¯å°ç„¡ã—ã§ã‚ã‚‹ã€‚é…åˆ—ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§æŒ‡å®šã™ã‚‹ã¨å–å¾—ã‚«ãƒ©ãƒ ã® å¢—æ¸›ã«éžå¸¸ã«å¼±ã„ã€‚ãã—ã¦ãªã‚Šã‚ˆã‚Šã€$$arr_ref[1] ãŒä½•ã‚’æ„å‘³ã™ã‚‹ã®ã‹ ã•ã£ã±ã‚Šã‚ã‹ã‚‰ãªã„ã€‚ fetchrow_array ã¯ä½¿ã‚ãª
rarere 2014/01/01
Perl

DB
ãƒªãƒ³ã‚¯
å…¨å›½åœ°åã®ãƒãƒ¼ãƒžå—è¡¨è¨˜ãƒ‡ãƒ¼ã‚¿ - yanok.net
æ¦‚è¦ å…¨å›½ã®åœ°åã®ãƒãƒ¼ãƒžå—è¡¨è¨˜ã‚’è¨˜ã—ãŸCSVå½¢å¼ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æä¾›ã—ã¾ã™ã€‚ã“ã®CSVãƒ•ã‚¡ã‚¤ãƒ«ã«ã¯ä¾‹ãˆã°ã€Œæ±äº¬ã€ã«å¯¾å¿œã™ã‚‹ã€ŒTÅkyÅã€ã€ã€ŒTÃ´kyÃ´ã€ã¨ã„ã£ãŸãƒãƒ¼ãƒžå—ç¶´ã‚ŠãŒåŽéŒ²ã•ã‚Œã¦ã„ã¾ã™ã€‚ åœ°åã®ç¨®é¡žã¯ã€éƒ½é“åºœçœŒåã€å¸‚åŒºç”ºæ‘åã€ç‰ã§ã™ã€‚ä¸‹è¨˜ã«è©³è¿°ã—ã¦ã„ã¾ã™ã€‚ ãƒãƒ¼ãƒžå—ã®ç¶´ã‚Šæ–¹ã¯ã€ãƒ˜ãƒœãƒ³å¼ã€è¨“ä»¤å¼ã®ä¸¡æ–¹ã«å¯¾å¿œã—ã¾ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä»¥ä¸‹ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ã“ã‚Œã‚‰3ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¯å†…å®¹ã¯åŒä¸€ã§ã€ãƒ•ã‚¡ã‚¤ãƒ«ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã ã‘ãŒç•°ãªã‚Šã¾ã™ã€‚ å…¨å›½åœ°åãƒãƒ¼ãƒžå—è¡¨è¨˜CSV (UTF-8ç‰ˆ) å…¨å›½åœ°åãƒãƒ¼ãƒžå—è¡¨è¨˜CSV (EUC-JIS-2004ç‰ˆ) å…¨å›½åœ°åãƒãƒ¼ãƒžå—è¡¨è¨˜CSV (Shift_JIS-2004ç‰ˆ) ã“ã‚Œã‚‰ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€JIS X 0213ã§è¿½åŠ ã•ã‚ŒãŸã€ŒÅã€ã‚„ã€ŒÃ´ã€ã¨ã„ã£ãŸç¬¦å·ã¤ãã®ã‚¢ãƒ«ãƒ•ã‚¡ãƒ™ãƒƒãƒˆã‚’å«ã‚“ã§ã„ã¾ã™ã€‚JIS X 0213ã®æ–‡å—ã«å¯¾å¿œã—ãŸç’°å¢ƒã§ã”ä½¿ç”¨ãã ã•ã„ã€‚ åˆ©
rarere 2013/12/29
DB
ãƒªãƒ³ã‚¯
Rediså‹‰å¼·ä¼šè³‡æ–™(2015/06 update)
Rediså‹‰å¼·ä¼šã®è³‡æ–™ã§ã™ã€‚2013å¹´ã«åˆç‰ˆã‚’ã‚¢ãƒƒãƒ—ã—ã¾ã—ãŸã€‚2015å¹´6æœˆã«Redis-Clusterã®å†…å®¹ã‚’è¿½è¨˜ã—ã¦å†ã‚¢ãƒƒãƒ—ã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚Read less
rarere 2013/10/31
DB
ãƒªãƒ³ã‚¯
å‰Šé™¤ãƒ•ãƒ©ã‚°ã®ã¯ãªã—
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
rarere 2013/10/29
DB

PostgreSQL
ãƒªãƒ³ã‚¯
SqlPackage - SQL Server
SqlPackage is a command-line utility that automates the database development tasks by exposing some of the public Data-Tier Application Framework (DacFx) APIs. The primary use cases for SqlPackage focus on database portability and deployments for the SQL Server, Azure SQL, and Azure Synapse Analytics family of databases. SqlPackage can be automated using Azure Pipelines and GitHub actions or other
rarere 2013/10/11
Windows

DB

server
ãƒªãƒ³ã‚¯
/.Jã«èžã‘ï¼šSQL/DBã®æ£ã—ã„å¦ã³æ–¹ã¯ï¼Ÿ | ã‚¹ãƒ©ãƒ‰ IT
æŠ€è¡“ç•‘ã®äººé–“ãŒæ–°ãŸã«PostgreSQLã§SQL/DBã‚’å¦ã¶ã®ã«æœ€è‰¯ã®æ–¹æ³•ã¯æœ¬ã ã‚ã†ã‹ã€ãã‚Œã¨ã‚‚ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã ã‚ã†ã‹ï¼Ÿã‚‚ã—ãã¯ãã‚Œã‚ˆã‚Šã‚‚è‰¯ã„ç–ãŒä»–ã«ã‚ã‚‹ã ã‚ã†ã‹ã€‚ ä»Šã¾ã§ã¯ä»–ã®äººã®æ›¸ã„ãŸã‚³ãƒ¼ãƒ‰ã‚’èªã‚“ã ã‚Šã€å®Ÿéš›ã«ã„ã‚ã„ã‚è©¦ã—ãŸã‚Šã€PostgreSQLãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ç›®ã‚’é€šã—ãŸã‚Šã—ã¦å¦ã‚“ã§ããŸã€‚ãã®ç”²æ–ã‚‚ã‚ã£ã¦ã‹DBã‚’ç†è§£ã—ã¦ããŸãŒã€ã¾ã å¤šãã®ã“ã¨ã‚’çŸ¥ã‚‰ãªã„ã—é–“é•ã£ã¦èº«ã«ä»˜ã„ã¦ã„ã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã ã‚ã†ã€‚ãã®è¨¼æ‹ ã«ã‚¹ãƒ©ãƒ‰ã§DBã®ã‚¹ãƒˆãƒ¼ãƒªãƒ¼ã‚’èªã‚€ã¨åˆã‚ã¦ç›®ã«ã™ã‚‹ç”¨èªžãŒçµæ§‹ã‚ã‚‹ã€‚ ãªãŠã€è‡ªåˆ†ã¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã«é–¢ã—ã¦ã¯è¤‡æ•°è¨€èªžã§é•·å¹´ã®çµŒé¨“ãŒã‚ã‚‹ãŒã€SQLã«é–¢ã—ã¦ã¯PostgreSQLã‚’é€šã˜ã¦å¤šå°‘ã„ã˜ã£ãŸç¨‹åº¦ã§ã‚ã‚‹ã€‚æ•°å¦ã¯ä¸‰è§’æ³•ã€ä»£æ•°ã€å°‘ã€…ã®çµ±è¨ˆã‚’ã‹ã˜ã£ãŸãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ãŒã‚ã‚‹ã€‚ ã¾ãŸã€è¿‘ãã«é€šãˆã‚‹å¤§å¦ã¯ãªãã€DBã«è©³ã—ã„äººã‚‚å‘¨ã‚Šã«ã„ãªã„ãŸã‚ç‹¬å¦ã›ã–ã‚‹ã‚’å¾—ãªãã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã¨æœ¬ãŒé ¼ã‚Šãªã®ãŒå®Ÿæƒ…ã§ã‚ã‚‹ã“ã¨ã‚’
rarere 2013/07/17
DB
ãƒªãƒ³ã‚¯
Visual Studio Code and Docker - Visual Studio Code - Site Home - MSDN Blogs
In Visual Studio 2022 17.10 Preview 2, weâ€™ve introduced some UX updates and usability improvements to the Connection Manager. With these updates we provide a more seamless experience when connecting to remote systems and/or debugging failed connections. Please install the latest Preview to try it out. Read on to learn what the Connection ...
rarere 2013/06/26
å—ãŒå°ã•ãã¦ã€ãŠã˜ã•ã‚“ã«ã¯æ‹¡å¤§ã—ãªã„ã¨ãã¤ã„ãªã€‚/æŒ‡å®šã§ãã‚‹ã®çŸ¥ã‚‰ãªã‹ã£ãŸãªã€‚ã‚„ã‚ã†ã€‚

server

DB

Windows
ãƒªãƒ³ã‚¯
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚´ãƒ«ãƒ• - ãªã‚“ã¨3æ–‡å—ã§èªè¨¼å›žé¿ãŒå¯èƒ½ã«
æ˜¨æ—¥ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚´ãƒ«ãƒ• - èªè¨¼å›žé¿ã®æ”»æ’ƒæ–‡å—åˆ—ã¯ã©ã“ã¾ã§çŸãã§ãã‚‹ã‹?ã€ã«ã¦ã€èªè¨¼å›žé¿ã®æ”»æ’ƒæ–‡å—åˆ—ãŒ5æ–‡å—ã«ã§ãã‚‹ï¼ˆã€Œ'OR'1ã€ï¼‰ã“ã¨ã‚’ç¤ºã—ã¾ã—ãŸãŒã€@masa141421356ã•ã‚“ã¨ã€ã‚„ã¾ã–ãã•ã‚“ï¼ˆãŠäºŒäººã¨ã‚‚æ‹™è‘—ã®ãƒ¬ãƒ“ãƒ¥ã‚¢ãƒ¼ã§ã™ï¼‰ã‹ã‚‰ã€idã¨pwdã«ã¾ãŸãŒã£ãŸæ”»æ’ƒä¾‹ã‚’ç¤ºã—ã¦ã„ãŸã ãã¾ã—ãŸã€‚ã‚„ã¾ã–ãã•ã‚“ã®ä¾‹ã¯ã€MySQLé™å®šãªãŒã‚‰ã€ãªã‚“ã¨3æ–‡å—ã§ã™ã€‚ã“ã‚Œã¯ã™ã”ã„ã€‚ @masa141421356ã•ã‚“ã®æ”»æ’ƒä¾‹ @masa141421356ã•ã‚“ã®ãƒ„ã‚¤ãƒ¼ãƒˆã‚’å¼•ç”¨ã—ã¾ã™ã€‚ @ockeghem å¤§æŠµã®DBã§id=''OR' AND pwd='>' ' ãŒé€šã‚‹ã¨æ€ã„ã¾ã™ï¼ˆidå´ã«ã€Œ'ORã€, pwdå´ã«ã€Œ>' ã€ã§6æ–‡å—ï¼‰ã€‚é•·ã•0ã®æ–‡å—åˆ—ãŒNULLæ‰±ã„ã•ã‚Œãªã„DBãªã‚‰æœ€å¾Œã®ã‚¹ãƒšãƒ¼ã‚¹ã‚’æ¶ˆã—ã¦5æ–‡å—ã§ã™ã€‚ â€” masa141421356 (@masa141421356) June
rarere 2013/06/25
security

DB
ãƒªãƒ³ã‚¯
Tiny Tiny RSS ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
å‰æ OS: Debian Squeeze Apache ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ¸ˆã¿ PostgreSQL ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ¸ˆã¿ ãƒ‰ãƒ¡ã‚¤ãƒ³å: example.comÂ (é©å®œèªã¿æ›¿ãˆ) ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å ´æ‰€: /opt/tt-rss (é©å®œèªã¿æ›¿ãˆ) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å: ttrss_db (é©å®œèªã¿æ›¿ãˆ) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ¦ãƒ¼ã‚¶ãƒ¼å: ttrss_user (é©å®œèªã¿æ›¿ãˆ) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰: ttrss_password (é©å®œèªã¿æ›¿ãˆ) 1. ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ Tiny Tiny RSS ã‚ˆã‚Š tt-rss-*.*.*.tar.gz ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ 2. ä»»æ„ã®å ´æ‰€ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« /opt/tt-rss ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ä»®å®š tar xzvf tt-rss-*.*.*.tar.gz sudo mv tt-rss-*.*.* /opt/tt-rss 3. Tiny Tiny RSS è¨å®š 3.1. è¨å®šãƒ•
rarere 2013/06/17
postgresqlã‚ã‹ã‚‰ã‚“ã‹ã£ãŸã‹ã‚‰åŠ©ã‹ã‚‹ã€‚

DB

server
ãƒªãƒ³ã‚¯
rktSQLite : SQLiteã®SQLã‚³ãƒžãƒ³ãƒ‰ä¸€è¦§
SQLiteã§ä½¿ç”¨ã§ãã‚‹SQLã‚³ãƒžãƒ³ãƒ‰ã®ç°¡å˜ãªèª¬æ˜Žã¨ã‚µãƒ³ãƒ—ãƒ«ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ è©³ã—ãã¯æœ¬å®¶ã‚µã‚¤ãƒˆã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚
rarere 2013/03/20
DB

ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ãƒªãƒ³ã‚¯
1