[B! WEBåˆ¶ä½œ][mysql] kana321ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kana321 id:kana321

WEBåˆ¶ä½œã¨mysqlã«é–¢ã™ã‚‹kana321ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

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

MySQLãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãŸã‚ã®PostgreSQLå¯¾å¿œè¡¨ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
æ¯Žå›žã‚ã‹ã‚‰ãªããªã£ã¦ã‚°ã‚°ã£ã¦ã‚‹ã‹ã‚‰ä»Šåº¦ã‹ã‚‰ã“ã“ã«è¿½è¨˜ã—ã¦ã„ãã€‚ MySQL PostgreSQL SHOW DATABASES; \l USE dbname \c dbname SHOW TABLES; \dt SELECT * FROM tblname\G \x on SELECT * FROM tblname; SELECT * FROM information_schema.processlist; SELECT * FROM pg_stat_activity; KILL <pid>; SELECT pg_terminate_backend(pid); KILL QUERY <pid>; SELECT pg_cancel_backend(pid); table / column ã®æƒ…å ± MySQL PostgreSQL SHOW TABLE STATUS FROM dbname; ã‚
kana321 2014/10/28
PostgreSQL

reference

unread

MySQL

hatena

db

SQL

webåˆ¶ä½œ

ã‚ã¨ã§èªã‚€

development
ãƒªãƒ³ã‚¯
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹CMSã€Žconcrete5ã€ã‚’ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå‘ã‘ã«å¼·åŒ–ã™ã‚‹ï¼ï¼”ã¤ã®æœ‰å„Ÿæ©Ÿèƒ½ã‚’çŸ¥ã‚‹ | Webæ‹…å½“è€…Forum
ç›´æ„Ÿçš„ãªæ“ä½œã¨æŸ”è»Ÿãªã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºæ€§ã‚’å‚™ãˆã€å°Žå…¥äº‹ä¾‹ãŒå¢—åŠ ä¸ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹CMSã€Žconcrete5ã€ã€‚ä½¿ã„ã‚„ã™ã•ãŒä¸€ç•ªã®é…åŠ›ã®CMSã§ã™ãŒã€å®Ÿã¯ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºç”¨é€”ã®CMSã¨ã—ã¦ã‚‚ååˆ†ãªæ©Ÿèƒ½ã‚’æƒãˆã¦ã„ã¾ã™ã€‚ concrete5ã‚’é–‹ç™ºã™ã‚‹PortlandLabsã¯ã€concrete5ã«è¿½åŠ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå‘ã‘æœ‰å„Ÿæ©Ÿèƒ½ã¨ã—ã¦ã€å¤§è¦æ¨¡ã‹ã¤ã‚»ã‚ãƒ¥ã‚¢ãªWebã‚µã‚¤ãƒˆã®CMSã«æ±‚ã‚ã‚‰ã‚Œã‚‹é™çš„HTMLå‡ºåŠ›æ©Ÿèƒ½ã¨ãƒ‡ã‚¸ã‚¿ãƒ«ã‚¢ã‚»ãƒƒãƒˆç®¡ç†ï¼ˆDAMï¼‰æ©Ÿèƒ½ã‚’ãƒ©ã‚¤ãƒ³ãƒŠãƒƒãƒ—ã«è¿½åŠ ã—ã¾ã—ãŸã€‚ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹CMSã®ä½¿ã„ã‚„ã™ã•ã¨åˆ©ç‚¹ã‚’ä¿ã£ãŸã¾ã¾ã€ä¼æ¥ã‚µã‚¤ãƒˆã¸ã‚‚å°Žå…¥ã§ãã‚‹ã®ãŒconcrete5ã®é…åŠ›ã§ã™ã€‚ä»Šå›žã¯ã€ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå‘ã‘ã«ç”¨æ„ã•ã‚ŒãŸï¼”ã¤ã®æœ‰å„Ÿæ©Ÿèƒ½ã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ concrete5ã®ï¼”ã¤ã®ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå‘ã‘è¿½åŠ æ©Ÿèƒ½é™çš„HTMLå‡ºåŠ›ï¼ˆHTML Exporterï¼‰concrete5ã‚’ã¯ã˜ã‚ã¨ã™
kana321 2014/08/12
concrete5ã¯ã€é™çš„HTMLå‡ºåŠ›æ©Ÿèƒ½ã¨ãƒ‡ã‚¸ã‚¿ãƒ«ã‚¢ã‚»ãƒƒãƒˆç®¡ç†ï¼ˆDAMï¼‰æ©Ÿèƒ½ã‚’ã€ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå‘ã‘æœ‰å„Ÿæ©Ÿèƒ½ã¨ã—ã¦æ–°ãŸã«æä¾›é–‹å§‹ã—ã¾ã—ãŸã€‚

japan

*webãƒ‡ã‚¶ã‚¤ãƒ³

concrete5

webåˆ¶ä½œ

OpenSource

CMS

ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹

*Web

PHP

MySQL
ãƒªãƒ³ã‚¯
Ruby on Railsã§å¯æ„›ã„åãŒé›†ã¾ã‚‹ã‚¨ãƒã‚µã‚¤ãƒˆã‚’å…¬é–‹ã™ã‚‹ã¾ã§ã®ï¼’ï¼”ï¼¨
kana321 2013/09/19
rails

å‹•ç”»

Ruby

MyInterest

programming

WEBåˆ¶ä½œ

Webã‚µãƒ¼ãƒ“ã‚¹

ã‚¦ã‚§ãƒ–åˆ¶ä½œ

MySQL
ãƒªãƒ³ã‚¯
PHPã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹ã¨ãã®ã¾ã¨ã‚ - Qiita
ã€2021/10/15 è¿½è¨˜ã€‘ ã“ã®è¨˜äº‹ã¯æ›´æ–°ãŒåœæ¢ã•ã‚Œã¦ã„ã¾ã™ã€‚ç¾åœ¨ã§ã¯ç†è€…ã®æ€æƒ³ãŒå¤‰åŒ–ã—ã¦ã„ã‚‹é¢ã‚‚ã‚ã‚Šã¾ã™ã®ã§ï¼ŒéŽåŽ»ã®è¨˜äº‹ã¨ã—ã¦å‚è€ƒç¨‹åº¦ã«ã”è¦§ãã ã•ã„ã€‚PDO ã«é–¢ã—ã¦ã¯å¤§ããå¤‰ã‚ã£ã¦ã„ãªã„éƒ¨åˆ†ãŒå¤šã„ã¨ã¯æ€ã„ã¾ã™ãŒï¼Œ PHP 8.x ä»¥é™ã§ã®å‹•ä½œä¿è¨¼ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã‚ã‚‰ã‹ã˜ã‚èªã‚“ã§ãŠããŸã„è¨˜äº‹ Qiita - ã€PHPè¶…å…¥é–€ã€‘ã‚¯ãƒ©ã‚¹ï½žä¾‹å¤–å‡¦ç†ï½žPDOã®åŸºç¤Ž by @7968 åˆå¿ƒè€…ãŒã‚„ã‚ŠãŒã¡ãªãƒŸã‚¹ ä»¥ä¸‹ã®ã©ã‚Œã‹ã«1ã¤ã§ã‚‚å½“ã¦ã¯ã¾ã‚‹ã‚³ãƒ¼ãƒ‰ã¯è¦‹ç›´ã™å¿…è¦ãŒã‚ã‚Šã¾ã™ï¼Žä»˜éŒ²ã«ãƒªãƒ³ã‚¯ã‚’è²¼ã£ã¦ãŠãã¾ã—ãŸã®ã§ï¼Œã€Œè©²å½“ã™ã‚‹ã‹ã‚‚ï¼Ÿã€ã¨ã„ã†äººã¯ã‚¯ãƒªãƒƒã‚¯ã—ã¦é£›ã‚“ã§èªã‚“ã§ãã ã•ã„ï¼Žå¤ªå—ã«ã—ã¦ã‚ã‚‹ã‚‚ã®ã¯è„†å¼±æ€§ã«ç›´çµã™ã‚‹å±é™ºåº¦ã®é«˜ã„ã‚‚ã®ã§ã™ï¼Ž mysql_query ãªã©ã®éžæŽ¨å¥¨é–¢æ•°ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ SET NAMES ã‚ã‚‹ã„ã¯ SET CHARACTER SET ãªã©ã§æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’æŒ‡å®šã—ã¦ã„ã‚‹ ãã‚‚ãã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
kana321 2013/09/07
ãƒ—ãƒã‚°ãƒ©ãƒ

()

MySQL

php

Qiita

mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

Webåˆ¶ä½œ

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åŸºç¤Žã‚’ç†è§£ã—ã‚ˆã†ï¼ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°æœªçµŒé¨“ã‹ã‚‰å§‹ã‚ã‚‹PHPå…¥é–€
ã¯ã˜ã‚ã« æœ¬é€£è¼‰ã§ã¯ã€PHPã¾ãŸã¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°åˆå¿ƒè€…ã®æ–¹ã‚’å¯¾è±¡ã«ã€PHPã‚’ç”¨ã„ãŸWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½œæˆæ–¹æ³•ã‚’èª¬æ˜Žã—ã¦ã„ãã¾ã™ã€‚ä»Šå›žã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨SQLã«é–¢ã—ã¦ã€ã€ŒãŠã™ã™ã‚ãƒ¬ã‚¹ãƒˆãƒ©ãƒ³ä¸€è¦§ã‚’é–²è¦§ã§ãã‚‹Webã‚µã‚¤ãƒˆã‚’åˆ¶ä½œã™ã‚‹å ´åˆã€ã‚’ä¾‹ã«ã—ã¦ã€èª¬æ˜Žã‚’ã—ã¦ã„ãã¾ã™ã€‚ å¯¾è±¡èªè€… ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãŒåˆã‚ã¦ã§ã“ã‚Œã‹ã‚‰å¦ç¿’ã™ã‚‹äºˆå®šã®æ–¹ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®çµŒé¨“ã¯ã‚ã‚‹ãŒPHPã‚’åˆã‚ã¦å¦ç¿’ã™ã‚‹æ–¹ ã“ã®è¨˜äº‹ã®å†…å®¹ ã¯ã˜ã‚ã« å¯¾è±¡èªè€… å‹•ä½œç¢ºèªç’°å¢ƒ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ä½•ã‹ï½¥ï½¥ï½¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã©ã‚“ãªå½¹å‰²ï¼Ÿ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œã®åŸºç¤Žï½¥ï½¥ï½¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨€èªžã€ŒSQLã€ã¨ã¯ SQLåŸºç¤Žï¼šãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆï½¥ï½¥ï½¥CREATEæ–‡ã‚’ä½¿ã£ã¦ã¿ã¾ã—ã‚‡ã† SQLåŸºç¤Žï¼šãƒ¬ã‚³ãƒ¼ãƒ‰è¿½åŠ ï½¥ï½¥ï½¥INSERTæ–‡ã‚’ä½¿ã£ã¦ã¿ã¾ã—ã‚‡ã† SQLåŸºç¤Žï¼šãƒ¬ã‚³ãƒ¼ãƒ‰æ¤œç´¢ï½¥ï½¥ï½¥SELECTæ–‡ã‚’ä½¿ã£ã¦ã¿ã¾ã—ã‚‡ã† SQLåŸºç¤Žï¼šãƒ¬ã‚³ãƒ¼ãƒ‰æ›´æ–°ï½¥ï½¥ï½¥UPDATEæ–‡ã‚’ä½¿ã£ã¦ã¿ã¾ã—
kana321 2013/07/01
php

ã¾ã¨ã‚

WEBåˆ¶ä½œ

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

å‹‰å¼·

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

programming

MySQL

ã‚ã¨ã§èªã‚€

DB
ãƒªãƒ³ã‚¯
Windowsï¼‹Apacheï¼‹MySQLï¼‹PHP/Perl/Pythonç’°å¢ƒã‚’ç°¡å˜ã«æ§‹ç¯‰ã§ãã‚‹ã€ŒAMPPSã€NOT SUPPORTED
kana321 2013/05/31
web

php

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

apache

MySQL

Windows

Python

Perl

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

webåˆ¶ä½œ
ãƒªãƒ³ã‚¯
PHP 5.5 ã§ mysql æ‹¡å¼µãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒéžæŽ¨å¥¨ã«ãªã‚Šã€å°†æ¥ã«ãŠã„ã¦ WordPress ã‚’ç†é ã«ã•ã¾ã–ã¾ãª CMS ã®ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ä½œæ¥ãŒå¿…è¦ã«ãªã‚Šã¾ã™
PHP 5.5 ã§ mysql æ‹¡å¼µãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒéžæŽ¨å¥¨ã«ãªã‚Šã€E_DEPRECATED ã‚¨ãƒ©ãƒ¼ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚å°†æ¥ã® PHP ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§å‰Šé™¤ã•ã‚Œã¾ã™ã€‚ mysql æ‹¡å¼µãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«ä¾å˜ã™ã‚‹ CMS ã‚’ä½¿ã£ã¦ã‚µã‚¤ãƒˆã‚’é‹ç”¨ã—ã¦ã„ã‚‹å ´åˆã€å°†æ¥ã€é‹ç”¨ã‚µãƒ¼ãƒãƒ¼ã«å°Žå…¥ã•ã‚Œã¦ã„ã‚‹ PHP ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®åˆ‡ã‚Šæ›¿ãˆã«å‚™ãˆã¦ã€ mysqli ã‚‚ã—ãã¯ PDO ã«å¯¾å¿œã—ãŸ CMS ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¸ã®ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã™ã‚‹ã‹ã€åˆ¥ã® CMS ã‚„ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒ“ã‚¹ã«åˆ‡ã‚Šæ›¿ãˆã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ å¤šãã® PHP è£½ã® CMS ãŒå…±æœ‰ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ãŠã‚Šã€å…±æœ‰ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã¯æ¯”è¼ƒçš„å¤ã„ PHP ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®ã‚µãƒãƒ¼ãƒˆã‚’ç¶šã‘ã‚‹å‚¾å‘ã«ã‚ã‚Šã¾ã™ãŒã€å¤ã„ PHP ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ä½¿ã„ç¶šã‘ã‚‹å ´åˆã€PHP ã®ãƒã‚°ã‚„ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®æœªå¯¾å¿œã€ã‚ˆã‚Šæ–°ã—ã„ PHP ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’æœ€å°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨ã™ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚„ CMS ã‚’å°Ž
kana321 2013/04/11
MySQL

unicode

WordPress

php

MySQL

wordpress

cms

Webåˆ¶ä½œ

DB

pdo
ãƒªãƒ³ã‚¯
PHPã‚„MySQLã‚„ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¯¾ç–ãŒåˆ†ã‹ã£ãŸæ°—ã«ãªã‚‹15å†Š | DECONCEPTER
HTML5ã¨ã‹JavaScriptãŒã‚‚ã¦ã¯ã‚„ã•ã‚Œã¦ã‚‹ã‘ã©ã‚„ã£ã±PHPã ã‚ˆãã£ã€‚ä¸€äººã§WEBã‚µãƒ¼ãƒ“ã‚¹ä½œã‚Œã¡ã‚ƒã†äººã¨ã‹ã‚«ãƒƒã‚³ã‚¤ã‚¤ã‚£ã‚£ã‚£ã‚£ã€‚ãƒ‡ã‚¶ã‚¤ãƒ³ã¯Twitter Bootstrapã§ã‚£ã‚£ã—ã€ã‚„ã£ã±ã‚µãƒ¼ãƒãƒ¼ã‚µã‚¤ãƒ‰å‡ºæ¥ã‚‹äººãŒè¼ã„ã¦ã‚‹ã…ã‚¦ã‚£ãƒªãƒªãƒªãƒªãƒªã€‚ ã¿ãŸã„ãªä¼šè©±ãŒå„åœ°ã§èžã“ãˆã¦ãã‚‹æ˜¨ä»Šã§ã™ãŒã€PHPã¯ã¾ã ã¾ã ç¾å½¹ã§æ´»èºã—ã¦ã„ãè¨€èªžã ã¨æ€ã„ã¾ã™ã€‚Facebookã‚‚ä»Šã®ã¨ã“ã‚PHPã§ä½œã‚‰ã‚Œã¦ã„ã¾ã™ã—ã€ä½•ã‚ˆã‚Šã‚‚ã¿ã‚“ãªå¤§å¥½ãWordPressã‚’ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã™ã‚‹ãŸã‚ã®åŸºç¤ŽçŸ¥è˜ã¨ã—ã¦PHPã‚’çŸ¥ã£ã¦ãŠãã«è¶Šã—ãŸã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ PHPã®æœ¬ã‚‚ã¨ã¦ã‚‚å¤šã„ã§ã™ãã€‚SmartyãŒã„ã„ã¨ã‹PEARã‚’ä½¿ãˆã¨ã‹æ–°æ—§è‰²ã€…ãªæƒ…å ±ãŒæ··åœ¨ã—ã¦ã„ã¾ã™ã€‚ã–ã£ãã‚ŠçŸ¥ã‚ŠãŸã„äººå‘ã‘ã‹ã‚‰ã€ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯è§£èª¬ã®è‰¯æ›¸ã‚„ã—ã£ã‹ã‚Šã—ãŸã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®æœ¬ã¾ã§ãƒ”ãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã¦ã¿ã¾ã™ã€‚ ã¨ã«ã‹ãã¨ã‚Šã‚ãˆãšã©ã‚“ãªã‚‚ã‚“ã‹çŸ¥ã‚ŠãŸã„ è‡ªåˆ†ã¯ãƒ—ãƒã‚°ãƒ©ãƒžã«ãªã‚‹æ°—ã¯ãª
kana321 2012/11/16
*ã¾ã¨ã‚

book

php

mysql

webã‚µãƒ¼ãƒ“ã‚¹

æœ¬

æ›¸ç±

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

ã¾ã¨ã‚

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

opensource

.net

cms

php

ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹

webåˆ¶ä½œ

web

mysql

Concrete5
ãƒªãƒ³ã‚¯
ã‚¯ãƒªã‚¢ãƒã‚ªã®å£ã‚³ãƒŸã£ã¦ä¿¡ã˜ã¦ã„ã„ï¼ŸåŠ¹æžœã¯ç¢ºå®Ÿãªã®ï¼Ÿ | æ„›ã¨å°ç”º
ã‚¯ãƒªã‚¢ãƒã‚ªã®ç‰¹å¾´ ç„¡æ·»åŠ ãƒ»ç„¡ç€è‰²ã ã‹ã‚‰è‚ŒãŒå¼±ã„äººã§ã‚‚å®‰å¿ƒ ãƒ¯ã‚ã‚¬ã‚„å«Œãªè‡ã„ã®åŽŸå› ã¨ãªã‚‹èŒã‚’æ®ºèŒãƒ»æ¶ˆæ¯’ ãŠå¾—ãªå®šæœŸã‚³ãƒ¼ã‚¹ã¯ã€è³¼å…¥ç¸›ã‚Šãªã—ï¼ã„ã¤ã§ã‚‚è§£ç´„å¯èƒ½ ä½“è‡ã®æ‚©ã¿ã¯è€è‹¥ç”·å¥³å•ã‚ãšå…±é€šã®æ‚©ã¿ã§ã™ãŒã€ä»–äººã«ã¯ç›¸è«‡ã—ã«ãã„ã®ã§1äººã§æ‚©ã‚“ã§ã„ã‚‹äººãŒå¤šã„ã‚“ã§ã™ã€‚ ä½“è‡ã£ã¦ã€è‡ªåˆ†ã§ãƒ‹ã‚ªã‚¤ãŒæ°—ã«ãªã£ãŸæ™‚ã¯ã€ä»–ã®äººã¯ã‚‚ã£ã¨ã‚¯ã‚µã‚¤ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ã‚‚ã—ã‚ãªãŸãŒã€è‡ªåˆ†ã§ãƒ¯ã‚ã‚¬ã‹ã‚‚â€¦ã¨æ€ã†ã®ã§ã‚ã‚Œã°ã€å‘¨ã‚Šã®äººã¯ã‚ãªãŸã®ãƒ‹ã‚ªã‚¤ã«æ°—ã¥ã„ã¦ã„ã‚‹ã‹ã‚‚â€¦ ã‚¯ãƒªã‚¢ãƒã‚ªã¯ã€ãã‚“ãªãƒ¯ã‚ã‚¬è‡ã‚„è¶³ã®ãƒ‹ã‚ªã‚¤ãªã©ã€ã‚¤ãƒ¤ãƒ¼ãªä½“è‡å…¨èˆ¬ã‚’10ç§’ã§ã‚«ãƒƒãƒˆã—ã¦ãã‚Œã‚‹ã‚“ã§ã™ã€‚ ã‚¯ãƒªã‚¢ãƒã‚ªã®åŠ¹æžœã‚„å£ã‚³ãƒŸã‚’èª¿æŸ»ã—ã¾ã—ãŸã®ã§å¾¹åº•è§£èª¬ã—ã¾ã™ã€‚ è³¼å…¥æ™‚ã«ç‰¹å…¸ãŒä»˜ã„ã¦ãã‚‹ã®ã§ãŠå¾— å…¬å¼ã‚µã‚¤ãƒˆã¯ã‚³ãƒãƒ© â€»ç‰¹å…¸ã¯æ¯Žæœˆå¤‰ã‚ã‚‹ã®ã§å…¬å¼ã‚µã‚¤ãƒˆã§ã”ç¢ºèªãã ã•ã„ ã‚¯ãƒªã‚¢ãƒã‚ªã¯ã©ã‚“ãªäººã«ãŠã™ã™ã‚ï¼Ÿ ã‚¯ãƒªã‚¢ãƒã‚ªã®æ®ºèŒçŽ‡ã¯ã€ãªã‚“ã¨99.999%ï¼ä½“è‡ã®æ‚©ã¿ã‚’è§£æ¶ˆã—ã¦ãã‚Œã‚‹ã‚¯ãƒª
kana321 2012/07/24
MySQL

Web

DB

*ã‚ã¨ã§èªã‚€

*ã‚ã¨ã§è©¦ã™

MySQL

SQL

é‹ç”¨

webåˆ¶ä½œ

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
MySQLã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¨ç”ŸPHPã«ã‚ˆã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ
çš†ã•ã‚“ã€ã“ã‚“ã°ã‚“ã¯ã€‚ç¬¹äº€ã§ã™ã€‚ 7æœˆã‚‚ã‚ã£ã¨ã„ã†é–“ã«10æ—¥é–“ãŒéŽãŽã¦ã€å¤çœŸã£ç››ã‚Šã«ãªã£ã¦ãã¾ã—ãŸã€‚ è‡ªåˆ†ã‚‚å¤å¯¾ç–ã§ã‚¢ã‚¤ã‚¹çœ ã¨ã„ã†ãƒžãƒƒãƒˆãƒ¬ã‚¹ã‚’è³¼å…¥ã—ã¦å¤ã‚’ä¹—ã‚Šè¶Šãˆã‚ˆã†ã¨æ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ ã•ã¦ã€æœ¬æ—¥ã¯ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã«ã¤ã„ã¦æ¤œè¨¼ã‚’ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¨ã¯ã€ä¸€é€£ã®SQLæ–‡ã‚„å‡¦ç†ã«åå‰ã‚’ã¤ã‘ã¦ä¿å˜ã—ãŸã‚‚ã®ã§ã™ã€‚ PHPã®é–¢æ•°ã¨åŒã˜ã§SQLã‚’é–¢æ•°ã¿ãŸã„ã«ã—ãŸã‚‚ã®ãŒã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã«ãªã‚Šã¾ã™ã€‚ MySQLã§ã¯ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¯MySQLã§ã¯5.0ã‹ã‚‰åˆ©ç”¨ãŒå¯èƒ½ã§ã™ã€‚ ä»Šå›žã¯MySQLã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ä½¿ã„æ–¹ã ã‘ã§ã¯ãªãã€ ç”ŸPHPã§è¨˜è¼‰ã—ãŸã¨ãã¨ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ¯”è¼ƒã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ MySQLã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’å‘¼ã³å‡ºã—ã¦å‡¦ç†ã‚’ã™ã‚‹PHPãƒ—ãƒã‚°ãƒ©ãƒ ã¨ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã§ä½œæˆã—ãŸã‚‚ã®ã¨åŒã˜SQLã‚’å®Ÿè¡Œã™ã‚‹PHPãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ä½œæˆã—ã¾ã™ã€‚ ä¸Šè¨˜ï¼’ã¤ã®ãƒ—
kana321 2012/07/11
*ã‚ã¨ã§èªã‚€

webåˆ¶ä½œ

DB

mysql

test

php

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

ã‚ã¨ã§èªã‚€

sql

database
ãƒªãƒ³ã‚¯
MySQLã®ç›£è¦–ã¯Cacti+Percona Monitoring PluginsãŒãŠã™ã™ã‚(ç›£è¦–ã‚µãƒ¼ãƒæ§‹ç¯‰ç·¨)
MySQLã®ç›£è¦–ã¯Cacti+Percona Monitoring PluginsãŒãŠã™ã™ã‚(ç›£è¦–ã‚µãƒ¼ãƒæ§‹ç¯‰ç·¨) 2012-05-18 MySQLã‚’ãƒªã‚½ãƒ¼ã‚¹ç›£è¦–ã™ã‚‹ä»•çµ„ã¿ã«ã¯ã„ãã¤ã‹ã‚ã‚‹ãŒã€å¯¾è±¡ã®MySQLã‚µãƒ¼ãƒãŒ5å°ä»¥ä¸Šã‚ã‚‹å ´åˆã¯CactiãŒãŠã™ã™ã‚ã€‚å°Žå…¥ã®ã—ã‚„ã™ã•ã ã‘ã§Muninã‚’é¸ã¶äººãŒå¤šã„æ°—ãŒã™ã‚‹ãŒã€ãã®é¸æŠžåŸºæº–ã¯é–“é•ã£ã¦ã„ã‚‹ï¼ Cactiã®ã„ã„ã¨ã“ã‚ã‚‹ã„ã¨ã“ å¤šæ•°ã®ã‚°ãƒ©ãƒ•ã‚’è¦‹ã‚„ã™ãä¸¦ã¹ã‚‰ã‚Œã‚‹ muninã¨æ¯”ã¹ã¦å¤šæ•°ã®ã‚µãƒ¼ãƒã‹ã‚‰è»½å¿«ã«æƒ…å ±ã‚’åŽé›†ãƒ»è¡¨ç¤ºã§ãã‚‹ ç›£è¦–å¯¾è±¡ã«ã¯ã€MySQLã®ãƒ¦ãƒ¼ã‚¶ã‚’è¿½åŠ ã™ã‚‹ã ã‘ã§ã‹ãªã‚Šã®é …ç›®æ•°ã‚’ç›£è¦–ã§ãã‚‹ ãƒ‡ãƒ¼ã‚¿ã®ä¿å˜ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå¿…é ˆã ã£ãŸã‚Šã—ã¦ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ãŒã‚„ã‚„é¢å€’ æ…£ã‚Œã‚‹ã¾ã§ç›£è¦–ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’æ›¸ãã®ã«æ‰‹é–“å–ã‚‹ Muninã®ã„ã„ã¨ã“ã‚ã‚‹ã„ã¨ã“ ç›£è¦–ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’æ›¸ãã®ãŒç°¡å˜ ç›£è¦–ã‚µãƒ¼ãƒã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãªã©ãŒå¿…è¦ãªãã€ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ãŒç°¡å˜ ã‚°ãƒ©ãƒ•ã®ä¸¦ã³æ–¹ãªã©ãŒ
kana321 2012/05/18
net

ã‚µãƒ¼ãƒç›£è¦–

perl

php

webã‚µãƒ¼ãƒ“ã‚¹

webåˆ¶ä½œ

mysql

ç›£è¦–

cacti

ã‚µãƒ¼ãƒ
ãƒªãƒ³ã‚¯
1