[B! ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹] nantanã®ãƒ

nantan id:nantan

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹nantanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä»•çµ„ã¿ (1/3) | POSTD
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒè©±é¡Œã«æŒ™ãŒã‚‹ã¨ãã€ç§ã¯ä½•ã‹ãŒè¶³ã‚Šãªã„ã¨æ€ã‚ãšã«ã¯ã„ã‚‰ã‚Œã¾ã›ã‚“ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚ã‚‰ã‚†ã‚‹ã¨ã“ã‚ã§ä½¿ã‚ã‚Œã¦ãŠã‚Šã€ãã®ç¨®é¡žã‚‚ã€å°è¦æ¨¡ã§ä¾¿åˆ©ãªSQLiteã‹ã‚‰ãƒ‘ãƒ¯ãƒ•ãƒ«ãªTeradataã¾ã§æ§˜ã€…ã§ã™ã€‚ã—ã‹ã—ã€ãã‚ŒãŒã©ã†ã„ã†ä»•çµ„ã¿ã§æ©Ÿèƒ½ã—ã¦ã„ã‚‹ã‹ã‚’èª¬æ˜Žã—ãŸã‚‚ã®ã¨ãªã‚‹ã¨ã€ãã®æ•°ã¯ã”ãã‚ãšã‹ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ä¾‹ãˆã°ã€Œãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ä»•çµ„ã¿ã€ãªã©ã§æ¤œç´¢ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ãƒ’ãƒƒãƒˆæ•°ã®å°‘ãªã•ã‚’å®Ÿæ„Ÿã§ãã‚‹ã¨æ€ã„ã¾ã™ã€‚ã•ã‚‰ã«ãã‚Œã‚‰ã®è¨˜äº‹ã¯çŸã„ã‚‚ã®ãŒã»ã¨ã‚“ã©ã§ã™ã€‚é€†ã«ã€è¿‘å¹´æµè¡Œã—ã¦ã„ã‚‹æŠ€è¡“ï¼ˆãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã€NoSQLã€JavaScriptãªã©ï¼‰ã‚’æ¤œç´¢ã—ãŸå ´åˆã€ãã‚Œã‚‰ã®æ©Ÿèƒ½ã‚’è©³ã—ãèª¬æ˜Žã—ãŸè¨˜äº‹ã¯ãŸãã•ã‚“è¦‹ã¤ã‹ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ã‚‚ã¯ã‚„å¤§å¦ã®æŽˆæ¥ã‚„ç ”ç©¶è«–æ–‡ã€å°‚é–€æ›¸ãªã©ã§ã—ã‹æ‰±ã‚ã‚Œãªã„ã‚ˆã†ãªå¤ãã¦é€€å±ˆãªæŠ€è¡“ãªã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ç§ã¯é–‹ç™ºè€…ã¨ã—ã¦ã€ç†è§£ã—ã¦ã„ãªã„ã‚‚ã®ã‚’
nantan 2015/09/16
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB

SQL
ãƒªãƒ³ã‚¯
ã•ã‚‰ã«æ€ªã—ã„äººåè¾žå…¸ã€€ç§»è»¢ã—ã¾ã—ãŸ
ã•ã‚‰ã«æ€ªã—ã„äººåè¾žå…¸ã€€ç§»è»¢å…ˆ 2022/4/1ã€€å…±æœ‰SSLãŒä½¿ãˆã‚‹ã‚µãƒ¼ãƒãƒ¼ã«ç§»è»¢ã—ã¾ã—ãŸã€‚ 5ç§’å¾Œï¼Œè‡ªå‹•çš„ã«ä¸‹è¨˜ã®ç§»è»¢å…ˆã«ç§»å‹•ã—ã¾ã™ã€‚ https://springsnow.sakura.ne.jp/more.htm
nantan 2015/08/25
äººå

è³‡æ–™

è¾žå…¸

é›‘å¦

åå‰

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
é«˜åº¦ãªã‚¯ã‚¨ãƒªãƒ¼ - Docs-Japanese - 10gen Confluence
æœ€åˆã« Mongo DBã«ã¯å¤šãã®æ©Ÿèƒ½ã‚’æŒã£ãŸãƒªãƒƒãƒãªã‚¯ã‚¨ãƒªãƒ¼ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ãƒšãƒ¼ã‚¸ã¯ãã®ä¸ã®ã„ãã¤ã‹ã®æ©Ÿèƒ½ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ Mongo DBã®ã‚¯ã‚¨ãƒªã¯JSONå½¢å¼ã§è¡¨ç¾ã—ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¿å˜ã—ã¦ã„ã‚‹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã¨ã¦ã‚‚ä¼¼ã¦ã„ã¾ã™ã€‚Â ãŸã¨ãˆã°ã€ // i.e., select * from things where x=3 and y="foo" db.things.find( { x : 3, y : "foo" } );
nantan 2013/01/25
mongodb

find

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

NoSQL

kvs
ãƒªãƒ³ã‚¯
ï½¢è–„ã„ï½£Javaã®O/Rãƒžãƒƒãƒ‘ãƒ¼ã®ç´¹ä»‹ - DbUtilsã€Persistã€Butterfly Persistence - public static void main
Hibernateã€ActiveObjectsã€S2Daoã€Apache Cayenneã€iBATISãªã©ORMãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ãŒç¾¤é›„å‰²æ‹ çŠ¶æ…‹ãªJavaã§ã™ãŒã€ä½¿ã„æ–¹ã‚’å‹‰å¼·ã—ãŸã‚Šè¨å®šãƒ•ã‚¡ã‚¤ãƒ«æ›¸ã„ãŸã‚Šã™ã‚‹ã®ãŒå°‘ã—é¢å€’ã‹ãªã¨æ€ã£ã¦ã„ã‚‹äººãŒã„ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ç‰¹ã«ã¡ã‚‡ã£ã¨ã—ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œã‚‹ãªã‚‰ã°ã€ç´ ã®JDBCã‚’ä½¿ã†ã®ã¯å«Œã ã‘ã©ã€ãã‚Œã«è¿‘ã„å½¢ã§ä½¿ãˆã‚‹ORãƒžãƒƒãƒ‘ãƒ¼ãŒæ¬²ã—ã„ã¨æ€ã†ã“ã¨ãŒãŸã³ãŸã³ã‚ã‚Šã¾ã—ãŸã€‚ ã¨ã„ã†ã“ã¨ã§ä»¥ä¸‹ã®æ¡ä»¶ã§JDBCã‚’è–„ããƒ©ãƒƒãƒ”ãƒ³ã‚°ã—ã¦ã„ã‚‹Javaã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’æŽ¢ã—ã¦ç™ºè¦‹ã—ãŸã‚‚ã®ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã«è‡ªå‹•çš„ã«ãƒžãƒƒãƒ”ãƒ³ã‚°ã—ã¦ãã‚Œã‚‹ ã§ãã‚‹ã ã‘SQLã‚’æ›¸ãé‡ã‚’æ¸›ã‚‰ã™ã“ã¨ãŒã§ãã‚‹ ã„ã–ã¨ãªã£ãŸã‚‰ç”ŸSQLã‚’æ›¸ãã“ã¨ãŒã§ãã‚‹ å°Žå…¥ãŒç°¡å˜ã§ã‚ã‚‹ ä¾å˜ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒå°‘ãªã„ ä»¥ä¸‹ã«æŒ¿å…¥ã€æ¤œç´¢ã€æ›´æ–°ã€å‰Šé™¤ã‚’å®Ÿè¡Œã™ã‚‹ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã„ã¾ã™ã€‚ ä»Šå›žã¯DBãŒMySQLã ã£ãŸã®ã§ã€M
nantan 2012/08/14
Java

ORM

apache

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

ãƒ©ã‚¤ãƒ–ãƒ©ãƒª
ãƒªãƒ³ã‚¯
SQLiteã§å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œã®åŸºç¤Ž - Perlå…¥é–€ã‚¼ãƒŸ
Perl â€º ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ â€º here Perlã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯åˆç´šè€…ãŒå¦ã¶ã«ã¯ä»Šã¾ã§ã¯å°‘ã—æ•·å±…ã®é«˜ã„ã‚‚ã®ã§ã—ãŸã€‚ã¾ãšSQLã®å®Ÿè¡Œç’°å¢ƒã‚’æ§‹ç¯‰ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã™ãã«å‹‰å¼·ã—ãŸã„ã¨ã„ã†éœ€è¦ã‚’æº€ãŸã™ã“ã¨ã¯ã§ãã¦ã„ã¾ã›ã‚“ã§ã—ãŸã€‚ ã§ã™ãŒç¾åœ¨ã¯ã“ã®çŠ¶æ³ã¯å¤‰ã‚ã‚Šã¾ã—ãŸã€‚ç¾åœ¨ã§ã¯ActivePerlã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã¨DBD::SQLiteã¨å‘¼ã°ã‚Œã‚‹SQLiteã‚’åˆ©ç”¨ã™ã‚‹ãŸã‚ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒ³ã‚°ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã¾ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹ãŸã‚ã®ãƒ¦ãƒ¼ã‚¶ã‹ã‚‰è¦‹ãŸã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹éƒ¨åˆ†ã«ã‚ãŸã‚‹DBIã¨ã„ã†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚‚ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒ³ã‚°ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã§ã™ã®ã§ActivePerlã®æœ€æ–°ç‰ˆã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã ã‘ã§ä½•ã®ç’°å¢ƒæ§‹ç¯‰ã‚‚è¡Œã‚ãªã„ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¦ç¿’ã—å§‹ã‚ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ DBD::SQLiteã¨DBIãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã“ã¨ã‚’ç¢ºèªã™ã‚‹ ã¾ãšDBD::SQLiteã¨DBIãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã‹ã©
nantan 2012/06/26
perl

SQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ç¼¶ç¼¶è¾žå…¸
ç¼¶ç¼¶è¾žå…¸ã‚ãç¼¶ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µã‚¤ãƒˆãƒ›ãƒ¼ãƒ ï½œæ–°ç™ºå£²ï½œè²©å£²è€…ï½œè£½é€ è€…ï½œç™ºå£²å…ƒï½œï¼ªï¼¡ï¼®ï½œåˆ†é¡žåˆ¥ï½œåŽŸææ–™ï½œç”¨èªžé›†ï½œãƒªãƒ³ã‚¯ï½œäººæ°—ç¼¶ï½œæ–°ç€æƒ…å ±2023/02/19(æ—¥)1ï¼Ž2ï¼Ž3ï¼Ž1ï¼ŽãƒŸãƒ«ã‚ãƒ¼ã‚«ãƒ•ã‚§ã‚ªãƒ¬(ã‚«ãƒƒãƒ—/200g)ä¸äºŒå®¶2ï¼Žãƒ¤ãƒžã‚¶ã‚ãƒ»ãƒŸãƒ«ã‚¯ã‚ã‚³ãƒ¼ãƒ’ãƒ¼ï½œå¾©åˆ»ãƒ‡ã‚¶ã‚¤ãƒ³(ç¼¶/250g)å±±å´Žãƒ‘ãƒ³3ï¼Žãƒ¤ãƒžã‚¶ã‚ãƒ»ãƒŸãƒ«ã‚¯ã‚»ãƒ¼ã‚ï½œå¾©åˆ»ãƒ‡ã‚¶ã‚¤ãƒ³(ç¼¶/250g)å±±å´Žãƒ‘ãƒ³
nantan 2011/12/14
å›³é‘‘

ç”Ÿæ´»

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

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯NoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸã€‚NewSQLã®ç™»å ´ã¨NoSQLã®çµ‚ã‚ã‚Šã€ã¨ã„ã†äºˆæƒ³
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯NoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸã€‚NewSQLã®ç™»å ´ã¨NoSQLã®çµ‚ã‚ã‚Šã€ã¨ã„ã†äºˆæƒ³ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨PostgreSQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã©ã®ã‚ˆã†ãªæ–°æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã‚‹ã®ã‹ã€æ˜¨æ—¥ã€ä¸€æ˜¨æ—¥ã®2æœ¬ã®è¨˜äº‹ã§ç´¹ä»‹ã—ã¾ã—ãŸã€‚ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯Memcached APIã‚’å‚™ãˆã‚‹ï¼ MySQL Conference & Expo 2011åŸºèª¿è¬›æ¼” PostgreSQLã®ç¾çŠ¶ã¨æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³9.1ã®æ–°æ©Ÿèƒ½ã€‚MySQL Conference & Expo 2011 ã“ã®2ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«å…±é€šã—ã¦ã„ã‚‹ã®ãŒã€NoSQLã®æ©Ÿèƒ½ã‚’å–ã‚Šè¾¼ã‚“ã§ã„ã‚‹ã“ã¨ã§ã™ã€‚NoSQLã«å¯¾ã™ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ˆã‚‹åæ’ƒãŒå§‹ã¾ã£ã¦ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒNoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹MySQL 5.6ã«æè¼‰äºˆå®šã®æ–°æ©Ÿèƒ½ã®1
nantan 2011/05/03
mysql

SQL

DB

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

NoSQL

newsql

postgresql

memcached
ãƒªãƒ³ã‚¯
äºŒæ¬¡å…ƒç”»åƒè©³ç´°æ¤œç´¢
äºŒæ¬¡å…ƒç”»åƒè©³ç´°æ¤œç´¢ ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã«ç”»åƒãŒã‚ã‚‹å ´åˆ æ¤œç´¢ ç”»åƒãƒ•ã‚¡ã‚¤ãƒ«ã‚’æŒã£ã¦ã„ã‚‹å ´åˆ æ¤œç´¢
nantan 2011/04/25
ç”»åƒ

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

æ¤œç´¢

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

ç”»åƒæ¤œç´¢
ãƒªãƒ³ã‚¯
Ruby on Rails : migration æ©Ÿèƒ½ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¹ã‚ãƒ¼ãƒžã‚’å¤‰æ›´ã™ã‚‹ - WebOS Goodies
æœ¬æ—¥ã¯ Ruby on Rails ã«ã‚ˆã‚‹ Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ä½œæˆã®ç¶šãã§ã™ã€‚å‰å›žã®è¨˜äº‹ã§ã¯ã€Scaffold ã‚’ä½¿ç”¨ã—ã¦è¨˜äº‹ãƒ‡ãƒ¼ã‚¿å…¥åŠ›ã®åŸºæœ¬çš„ãªã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã‚’ä½œæˆã™ã‚‹ã¨ã“ã‚ã¾ã§ã‚„ã‚Šã¾ã—ãŸã€‚generate ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’å®Ÿè¡Œã™ã‚‹ã ã‘ã§ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒªã‚¹ãƒˆè¡¨ç¤ºãƒ»é …ç›®ä½œæˆãƒ»ç·¨é›†ãƒ»å‰Šé™¤ã®ã™ã¹ã¦ã®æ“ä½œãŒå®Ÿè£…ã•ã‚Œã‚‹ã®ã¯é©šãã§ã—ãŸãã€‚æœ¬æ—¥ã¯ã€å‰å›žæ‰‹å‹•ã§è¡Œã£ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆä½œæ¥ã‚’ Ruby on Rails ã«ä»»ã›ã‚‹ãŸã‚ã® migration ã¨å‘¼ã°ã‚Œã‚‹æ–¹æ³•ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ migration ã¯ç°¡å˜ã«è¨€ã†ã¨ Ruby ã‚¹ã‚¯ãƒªãƒ—ãƒˆã«ã‚ˆã£ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆã‚„ã‚«ãƒ©ãƒ æ§‹æˆã®å¤‰æ›´ã‚’è¡Œã†æ©Ÿèƒ½ã§ã™ã€‚Scaffold ä¸»ã«å°Žå…¥æ™‚ã®ã‚µãƒãƒ¼ãƒˆã‚’ç›®çš„ã¨ã—ãŸæ©Ÿèƒ½ã§ã—ãŸãŒã€migration ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ§‹æˆã®ç¶æŒç®¡ç†ã‚’ä¸»ç›®çš„ã«ã—ã¦ã„ã¾ã™ã€‚æœ€å¤§ã®ç‰¹å¾´ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ»ã‚«ãƒ©ãƒ æ§‹æˆï¼ˆã‚¹ã‚ãƒ¼ãƒžã¨è¨€ã†ã‚“ã§ã™ã‹ãï¼‰ã«ãƒªãƒ“ã‚¸ãƒ§ãƒ³ç®¡ç†ã®ã‚ˆã†
nantan 2011/04/21
ruby

rails

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

migration
ãƒªãƒ³ã‚¯
ãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ï½œè„†å¼±æ€§è¨ºæ–.jp
ãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ã€å…¥åŠ›ã™ã‚‹æ”»æ’ƒã‚³ãƒ¼ãƒ‰ã«ã‚ˆã£ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ç•°ãªã‚‹ãƒ¬ã‚¹ãƒãƒ³ã‚¹çµæžœã‚’æŠ½å‡ºã™ã‚‹æ”»æ’ƒã§ã™ã€‚ååˆ†ãªã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸å‡¦ç†ãŒè¡Œã‚ã‚Œã¦ã„ã‚‹Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å ´åˆã€Webãƒšãƒ¼ã‚¸ä¸Šã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ã®ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãã®ãŸã‚ã€å˜ç´”ãªSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚’é€ã‚Šè¾¼ã‚“ã§ã‚‚ã€ã©ã®ã‚ˆã†ãªçµæžœã‚’ã‚‚ãŸã‚‰ã—ãŸã‹ã‚’çŸ¥ã‚‹ã“ã¨ã¯å›°é›£ã§ã™ã€‚ãã“ã§ã€ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã®HTTPã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ã‚³ãƒ¼ãƒ‰ã‚„è¡¨ç¤ºã•ã‚ŒãŸç”»é¢ã‹ã‚‰çŠ¶æ³ã‚’åˆ¤æ–ã™ã‚‹ã®ãŒã€ãƒ–ãƒ©ã‚¤ãƒ³ãƒ‰SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®æ‰‹æ³•ã§ã™ã€‚ ãŸã¨ãˆã°ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®æ‰‹æ³•ã§ã¤ãã«çœŸã¨ãªã‚‹æ¡ä»¶ã€Œ' OR 1=1ã€ã‚’ä¸ŽãˆãŸå ´åˆã€æ£å¸¸æ“ä½œæ™‚ã¨åŒæ§˜ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„"ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒå¤‰æ›´ã•ã‚Œã¾ã—ãŸ"ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ãã®ä¸€æ–¹ã§ã€ã¤ãã«å½ã¨ãªã‚‹æ¡ä»¶ã€Œ' OR 1=0ã€ã‚’ä¸ŽãˆãŸå ´åˆ "æŒ‡å®šã®ãƒ¦ãƒ¼ã‚¶ãŒå˜åœ¨ã—ã¾ã›ã‚“"ãªã©ã€æ£å¸¸æ™‚ã¨ã¯ç•°ãªã‚‹ã‚³ãƒ³ãƒ†ãƒ³ãƒ„
nantan 2011/03/28
SQL

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

SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³

ç”¨èªž

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
æ€ªç•°ãƒ»å¦–æ€ªç”»åƒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï½œå›½éš›æ—¥æœ¬æ–‡åŒ–ç ”ç©¶ã‚»ãƒ³ã‚¿ãƒ¼
Copyright (c)2010- International Research Center for Japanese Studies, Kyoto, Japan. All rights reserved.
nantan 2010/06/20
ç”»åƒ

ã¾ã¨ã‚

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
HDDã‚’SSDã«ã—ãŸã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã©ã‚Œã ã‘é€Ÿããªã‚‹ã‹ï¼Ÿ ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€šãŒå®Ÿé¨“
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹éš›ã«ã¯ã€é«˜ã„æ€§èƒ½ã‚’å¼•ãå‡ºã™ãŸã‚ã«ç‰©ç†è¨è¨ˆã‚’ã—ã€ã‚¹ã‚ãƒ¼ãƒžã‚’å·¥å¤«ã—ã€ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã†ã“ã¨ãŒã¤ãã«è¡Œã‚ã‚Œã¦ãã¾ã—ãŸã€‚ æ€§èƒ½ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¯ãŸã„ãŒã„HDDã«ã‚ã‚Šã€ã„ã‹ã«ãã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’å›žé¿ã™ã‚‹ã‹ãŒãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆã§ã™ãŒã€æœ€è¿‘ã§ã¯æ€§èƒ½å‘ä¸Šã®ãŸã‚ã®æ¦å™¨ã¨ã—ã¦ã€HDDã‚ˆã‚Šã‚‚ãšã£ã¨ã‚¢ã‚¯ã‚»ã‚¹æ€§èƒ½ã®é«˜ã„SSDãŒæ³¨ç›®ã•ã‚Œã¦ã„ã¾ã™ã€‚SSDã¯HDDã¨ç½®ãæ›ãˆã‚‹ã ã‘ã§ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¾ã£ãŸãæ‰‹ã‚’åŠ ãˆãšã«æ€§èƒ½å‘ä¸Šã‚’å¯èƒ½ã«ã™ã‚‹æ‰‹æ®µã¨ã—ã¦éžå¸¸ã«é…åŠ›çš„ã§ã™ã€‚ HDDã®ä»£ã‚ã‚Šã«SSDã‚’åˆ©ç”¨ã—ãŸã‚‰ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ€§èƒ½ã¯ã©ã‚Œã ã‘å‘ä¸Šã™ã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€šãŒå…±åŒæ¤œè¨¼ã‚’è¡Œã„ã€ãã®çµæžœã‚’ãƒ›ãƒ¯ã‚¤ãƒˆãƒšãƒ¼ãƒ‘ãƒ¼ã¨ã—ã¦å…ˆé€±ç™ºè¡¨ã—ã¾ã—ãŸï¼ˆå‚è€ƒã€Œæ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€š ãƒ•ãƒ©ãƒƒã‚·ãƒ¥æŠ€è¡“æ´»ç”¨ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é«˜é€ŸåŒ–ã‚’å…±åŒæ¤œè¨¼ã€ï¼‰ã€‚ ãƒ›ãƒ¯ã‚¤ãƒˆãƒšãƒ¼ãƒ‘ãƒ¼ã§ã¯ã€HDDã®ä»£ã‚ã‚Š
nantan 2010/05/18
ã‚µãƒ¼ãƒ

hdd

ssd

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

oracle
ãƒªãƒ³ã‚¯
ãƒ©ãƒ¼ãƒ¡ãƒ³ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
2024å¹´8æœˆ14æ—¥(æ°´)ã€RDBæ–°è¦ç™»éŒ²ã€‚ ã“ã®æ—¥ã¯æ„›è»Š3å·ã¨ã€æœªç™»éŒ²ç”ºä¸è¯å·¡ã‚Šã€‚1è»’ç›®ã¯ã“ã®è¾ºã‚Šã§2åº—èˆ—ã‚’å±•é–‹ã™ã‚‹ç¾Žå‘³é¤¨ã•ã‚“ã¸ã€‚ã¡ã‚‡ã£ã¨ã‚ªã‚·ãƒ£ãƒ¬ç›®ã®å¤§é™¸ç³»ã§ã™ãã€‚æŽ¥å®¢ã®ã‚ªãƒ‹ãƒ¼ã‚µãƒ³ã¯ã€æ—¥æœ¬èªžãŒã™ã”ãæµæš¢ã€‚ 900å††ï¼‹ç¨Žã®éººé£¯ã‚»ãƒƒãƒˆã‚‚é…åŠ›çš„ãªã‚“ã§ã™ãŒã€ä»Šå›žãƒãƒ§ã‚¤ã‚¹ã¯æ•¢ãˆã¦å˜å“ã§ã€ã‚¹ã‚¿ãƒŸãƒŠå°æ¹¾ ãƒ©ãƒ¼ãƒ¡ãƒ³880å††ï¼‹ç¨Žã¨ã—ã¾ã™ã€‚ç„¼ãé¤ƒ... ç¶šãã‚’è¦‹ã‚‹
nantan 2009/08/20
ãƒ©ãƒ¼ãƒ¡ãƒ³

ã‚°ãƒ«ãƒ¡

ã¾ã¨ã‚

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨ã„ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ç®¡ç†ã«ã¤ã„ã¦ - LukeSilviaâ€™s diary
Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯åˆ‡ã£ã¦ã‚‚åˆ‡ã‚Œãªã„ã‚»ãƒƒã‚·ãƒ§ãƒ³æ©Ÿæ§‹ã€‚DB ãƒ™ãƒ¼ã‚¹ã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†ã‚’è¡Œãªã£ã¦å¾—ã‚‰ã‚ŒãŸçŸ¥è¦‹ã¨ã€ãã‚Œã‚’å…ƒã«è€ƒå¯Ÿã—ãŸçµæžœã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã®ç‰¹æ€§ DB ã§ç®¡ç†ã•ã‚Œã‚‹ä»–ã®ãƒ‡ãƒ¼ã‚¿ã«æ¯”ã¹ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã¯ã‹ãªã‚Šç‰¹æ®Šã§ã™ã€‚ä¸»ãªç‰¹å¾´ã¯æ¬¡ã®ã‚ˆã†ãªæ„Ÿã˜ã€‚ ãƒ‡ãƒ¼ã‚¿ãŒå¢—åŠ ã™ã‚‹ã®ãŒé€Ÿã„ å®šæœŸçš„ãªå‰Šé™¤ãŒå¿…è¦ é »ç¹ã«æ›´æ–°ã•ã‚Œã‚‹ ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ¯Žã«èªã¿ã«è¡Œãå¿…è¦ãŒã‚ã‚‹ ã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã‚ãªã„ã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å…¨ä½“ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ããªã„ ã‚¢ã‚¯ã‚»ã‚¹é »åº¦ãŒé«˜ã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ã‚ã¨ã€1ã¤ç›®ã®ç‰¹å¾´ã‹ã‚‰ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã¯æ„è˜çš„ã«ç®¡ç†ã—ã¦ã‚„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ç¾åœ¨ã®ç’°å¢ƒ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é ˜åŸŸãŒå°‘ã—ç‰¹æ®Šã§ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ãŒã‚„ãŸã‚‰ãŸã¾ã‚Šã¾ã™(ãƒ¦ãƒ¼ã‚¶æ•°ä½•ç™¾ä¸‡ã®ã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ãã†ã„ã†ã®ã§ã¯ãªã„ã§ã™)ã€‚ RDBMS MySQL 4.0.22 ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ InnoDB ãƒ¬ã‚³ãƒ¼ãƒ‰æ•° 6åƒä¸‡ ãƒ†ãƒ¼ã‚¿ã‚µ
nantan 2009/07/07
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†

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

mysql
ãƒªãƒ³ã‚¯
ã•ã‚‰ã«MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹7ã¤ã®æ–¹æ³•
MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•ã¨ã„ã†è¨˜äº‹ãŒã¨ã¦ã‚‚å¥½è©•ã ã£ãŸã‚ˆã†ã§ã‚ã‚‹ã€‚è¨˜äº‹ã‚’èªã‚“ã§é ‚ã„ãŸçš†ã•ã‚“ã€ã‚ã‚ŠãŒã¨ã†ã€‚ ã“ã®è¨˜äº‹ã«å¯¾ã™ã‚‹ä¾¿ä¹—ï¼ˆï¼Ÿï¼‰ã§Webå±‹ã®ãƒã‚¿å¸³: PostgreSQLã‚’é«˜é€ŸåŒ–ã™ã‚‹16ã®ãƒã‚¤ãƒ³ãƒˆã¨ã„ã†è¨˜äº‹ã‚’æ›¸ã„ã¦é ‚ã„ãŸã‚ˆã†ã ãŒã€ãã¡ã‚‰ã®æ–¹ã‚‚ã‹ãªã‚Šäººæ°—ã ã£ãŸã‚ˆã†ã§ã‚ã‚‹ã€‚ä»–äººãŒä½œã£ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«æ”¹è‰¯ã‚’åŠ ãˆã‚‹ã¨ã„ã†ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚„ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®ç²¾ç¥žã‚‚åŸºæœ¬ã¯ä¾¿ä¹—ã§ã‚ã‚‹ã®ã§ã€ä¾¿ä¹—ã«ã¤ã„ã¦ã¯å¤§ã„ã«è³›æˆã—ãŸã„ã¨ã„ã†ã‹ã‚€ã—ã‚å–ã‚Šä¸Šã’ã¦ãã‚Œã¦ã‚ã‚ŠãŒã¨ã†ï¼ï¼ã¨æ€ã†ã‚ã‘ã§ã‚ã‚‹ãŒã€ã“ã“ã§ã•ã‚‰ã«ä¿ºã¯ã“ã†è€ƒãˆã‚‹ã€‚ ã¨ã€‚ Webå±‹ã®ãƒã‚¿å¸³ã•ã‚“ã®è¨˜äº‹ã§ã¯16ã®ãƒã‚¤ãƒ³ãƒˆãŒç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ãŒã€æ¼¢ï¼ˆã‚ªãƒˆã‚³ï¼‰ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“ã®è¨˜äº‹ã¯10ã®æ–¹æ³•ã ã£ãŸã®ã§ã‚ã¨6ã¤è¶³ã‚Šãªã„ã€‚ã‚ªãƒˆã‚³ã¯æ•°ã§å‹è² ï¼ï¼ã¨ã„ã†ã‚ã‘ã§ä»Šæ—¥ã¯ãƒã‚¿ã‚’æŒ¯ã‚Šçµžã£ã¦ã•ã‚‰ã«7ã¤ã®MySQLé«˜é€ŸåŒ–ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ 1. ã‚¤ãƒ³ãƒ†ãƒ«ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©
nantan 2009/03/06
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ã¾ã¨ã‚

mysql

SQL

tips

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

DB

é–‹ç™º

é«˜é€ŸåŒ–
ãƒªãƒ³ã‚¯
Ywcafe.net
Ywcafe.net This Page Is Under Construction - Coming Soon! Why am I seeing this 'Under Construction' page? Related Searches: Free Credit Report music videos Migraine Pain Relief Best Mortgage Rates Credit Card Application Trademark Free Notice Review our Privacy Policy Service Agreement Legal Notice Privacy Policy
nantan 2009/03/02
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

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

DB

SQL

postgresql

ã¾ã¨ã‚

é«˜é€ŸåŒ–

é–‹ç™º

tips

development
ãƒªãƒ³ã‚¯
DBViewer Plugin for Eclipse
DBViewer Plugin 1.2.1.v20100421 Released. 2010.04.21New DBViewer Plugin 1.2.0.v20091112 Released. 2009.11.12 DBViewer Plugin 1.1.0.v20090121 Released. 2009.01.21 DBViewer Plugin 1.0.9.v20080914 Released. 2008.09.14 User's Manual "Capter 3:Registrateion of Database Define. And Connect Database" (PDF,94KB) 2008.07.11 User's Manual "Capter 2:Open DBViewer Perspective." (PDF,58KB) 2008.07.11 User's Ma
nantan 2009/02/13
eclipse

plugin

é–‹ç™º

SQL

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

DB
ãƒªãƒ³ã‚¯
1