[B! db] amayanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

amayan id:amayan

dbã«é–¢ã™ã‚‹amayanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (44)

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

å…¨ã¦ã¯æ™‚ã®ä¸ã«â€¦ : ã€SQLã€‘DISTINCTå¥ã®è¨˜è¿°ä½ç½®ã«ã‚ˆã‚‹å®Ÿè¡Œçµæžœã®é•ã„ã«ã¤ã„ã¦
2007/8/2521:27 ã€SQLã€‘DISTINCTå¥ã®è¨˜è¿°ä½ç½®ã«ã‚ˆã‚‹å®Ÿè¡Œçµæžœã®é•ã„ã«ã¤ã„ã¦ DISTINCTã®ä½¿ã„æ–¹ã«ã¯ã€ä»¥ä¸‹ã®2ç¨®é¡žãŒã‚ã‚‹ã€‚ 1.å–å¾—ã™ã‚‹é¸æŠžãƒªã‚¹ãƒˆï¼ˆé …ç›®ãƒªã‚¹ãƒˆï¼‰ã®å‰ã«DISTINCTã‚’è¨˜è¿°ã™ã‚‹ ä¾‹ï¼‰SELECT DISTINCT COUNT(Column_Name) ... 2.é›†è¨ˆé–¢æ•°å†…ã«DISTINCTã‚’è¨˜è¿°ã™ã‚‹ ä¾‹ï¼‰SELECT COUNT(DISTINCT Column_Name) ... ä¸Šè¨˜ã®å®Ÿè¡Œçµæžœã§ã¯ã€é‡è¤‡ã‚’æŽ’é™¤ã™ã‚‹å¯¾è±¡ã«å·®ç•°ãŒç™ºç”Ÿã™ã‚‹ã€‚ ãã®å·®ç•°ã¯ã€ä»¥ä¸‹ã®é€šã‚Šã§ã‚ã‚‹ã€‚ 1.DISTINCT COUNT(Column_Name)ã®å ´åˆã€é¸æŠžé …ç›®ã®çµ„ã¿åˆã‚ã›ãŒé‡è¤‡ã—ãªã„ãƒ¬ã‚³ãƒ¼ãƒ‰ä»¶æ•°ã‚’è¡¨ç¤ºã™ã‚‹ã€‚ 2.COUNT(DISTINCT Column_Name)ã®å ´åˆã€å˜ä½“ã®é …ç›®ï¼ˆColumn_Nameï¼‰ã®é‡è¤‡ã—ã¦ã„ãªã„ä»¶æ•°ï¼ˆç¨®é¡žæ•°ï¼‰ã‚’å–å¾—ã™ã‚‹ã€‚ ä»¥ä¸‹ã€å®Ÿè¡Œçµ
amayan 2011/01/19
SELECT DISTINCT COUNT ã ã¨ãƒ¬ã‚³ãƒ¼ãƒ‰å˜ä½ã§ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªã‚«ã‚¦ãƒ³ãƒˆã€‚SELECT COUNT ( DISTINCT ...) ã ã¨ã€æŒ‡å®šã™ã‚‹ã‚«ãƒ©ãƒ ã«ãŠã„ã¦ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªã‚«ã‚¦ãƒ³ãƒˆã€‚

sql

db
ãƒªãƒ³ã‚¯
FlexåŸºç¤Žè¬›åº§
LCDSåŸºç¤Žè¬›åº§ ç¬¬1ç« ã€€LiveCycle Data Servicesã‚’æ´»ç”¨ã—ãŸPDFå¸³ç¥¨ä½œæˆ AIRåŸºç¤Žè¬›åº§ ç¬¬1ç« ã€€AIRã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½œæˆ ç¬¬2ç« ã€€ç”»é¢ã®ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚º ç¬¬3ç« ã€€ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆ ç¬¬4ç« ã€€ãƒã‚¤ãƒ†ã‚£ãƒ–ãƒ¡ãƒ‹ãƒ¥ãƒ¼ ç¬¬5ç« ã€€ãƒ•ã‚¡ã‚¤ãƒ«ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®åˆ©ç”¨ ç¬¬6ç« ã€€Drag&Drop ç¬¬7ç« ã€€PDFãƒ•ã‚¡ã‚¤ãƒ«ã®è¡¨ç¤º ç¬¬8ç« ã€€SQLiteã§DBæ“ä½œ ç¬¬9ç« ã€€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ç›£è¦– ç¬¬10ç« ã€€ã‚¿ã‚¹ã‚¯ãƒˆãƒ¬ã‚¤ã‚¢ã‚¤ã‚³ãƒ³ã®è¡¨ç¤º ç¬¬11ç« ã€€ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãƒ³ã‚°ã¨RemoteObjectã®åˆ©ç”¨ ç¬¬12ç« ã€€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ›´æ–° ç¬¬13ç« ã€€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è‡ªå‹•èµ·å‹• Flex3åŸºç¤Žè¬›åº§ ç¬¬1ç« ã€€AdvancedDataGridã‚’ä½¿ã† ç¬¬2ç« ã€€OLAPDataGridã‚’ä½¿ã† Flex2åŸºç¤Žè¬›åº§ Flex Builder2ã‚’ä½¿ã£ãŸã€Flex2ã«ã‚ˆã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã®ãŸã‚ã®
amayan 2010/05/10
flex

db

actionscript
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: RDBã§éšŽå±¤æ§‹é€ ã‚’æ‰±ã†ã«ã¯ï¼Ÿ
yukiã§ã™ã€‚ãƒ€ã‚¤ã‚¨ãƒƒãƒˆã‚’å§‹ã‚ã¦3kgæ¸›ã£ãŸã¨æ€ã£ãŸã‚‰ã€é¢¨é‚ªã‚’å¼•ã„ã¦è¦‹äº‹ã«1kgå¢—é‡ã€‚ é‹å‹•ã—ãªã„ã¨é§„ç›®ã§ã™ãã€‚ã‚ã¨æ®‹ã‚Š20kgã€é“ã®ã‚Šã¯é ã„ã§ã™ã€‚ ã•ã¦ä»Šå›žã¯ã€ã€ŒRDBã§éšŽå±¤æ§‹é€ ã‚’æ‰±ã†ã«ã¯ï¼Ÿã€ã§ã™ã€‚ ã‚ã‚‹ã‚µã‚¤ãƒˆã‚’æ§‹ç¯‰ä¸ã«éšŽå±¤æ§‹é€ ã‚’ã‚‚ã£ãŸã‚«ãƒ†ã‚´ãƒªæ§‹é€ ã«ã™ã‚‹ã“ã¨ã«ãªã‚Šã€ã©ã®ã‚ˆã†ã«DBã§æ‰±ã†ã‹æ‚©ã¿ã¾ã—ãŸã€‚ DBã¯MySQLã‚’æŽ¡ç”¨ã—ã¦ã„ãŸã®ã§ã€ã“ã®æ™‚ç‚¹ã§ã±ã£ã¨é ã«æµ®ã‹ã‚“ã é¸æŠžè‚¢ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã§ã—ãŸã€‚ XML-DBã‚’åˆ©ç”¨ã™ã‚‹ è¦ªã‚«ãƒ†ã‚´ãƒªãƒ¬ã‚³ãƒ¼ãƒ‰ã®ãƒ—ãƒ©ã‚¤ãƒžãƒªIDã‚’åã‚«ãƒ†ã‚´ãƒªãƒ¬ã‚³ãƒ¼ãƒ‰ã«æŒãŸã›ã‚‹ è¦ªã‚’å«ã‚ãŸã€Žçµ¶å¯¾ãƒ‘ã‚¹ã€ã‚’åç§°ã¨ã—ã¦æ‰±ã„ã€å–ã‚Šå‡ºã—ãŸå¾Œã«ãƒ‘ãƒ¼ã‚¹ ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã«åŒæ§˜ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ã‚’ä½œã‚Šã€æ¯Žå›žãƒ‘ãƒ¼ã‚¹ã™ã‚‹ (1)ã®XMLDBã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®eXistã‚„Xindiceã€Yggdrasillãªã©æ§˜ã€…ãªé¸æŠžè‚¢ãŒã‚ã‚Šã¾ã—ãŸãŒã€ã‚«ãƒ†ã‚´ãƒªã®ã¿ã®åˆ©ç”¨ãªå‰²ã«ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚³ã‚¹ãƒˆãŒé«˜ã™ãŽã‚‹ã®ã§è¦‹é€ã‚Šã¾
amayan 2009/06/28
rdb

mysql

data

algorythm

db
ãƒªãƒ³ã‚¯
ã‚¦ã‚§ãƒ–ãƒªãƒ–ãƒã‚°ï¼šã‚µãƒ¼ãƒ“ã‚¹ã¯çµ‚äº†ã—ã¾ã—ãŸã€‚
ã€Œã‚¦ã‚§ãƒ–ãƒªãƒ–ãƒã‚°ã€ã¯ 2023å¹´1æœˆ31æ—¥ ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹æä¾›ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ 2004å¹´3æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‚ˆã‚Š19å¹´è¿‘ãã‚‚ã®é–“ã€æ²¢å±±ã®çš†ã•ã¾ã«ã”æ„›ç”¨ã„ãŸã ãã¾ã—ãŸã“ã¨ã‚’å¿ƒã‚ˆã‚ŠãŠç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ä»Šå¾Œã¨ã‚‚ã€BIGLOBEã‚’ã”æ„›é¡§è³œã‚Šã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ç”³ã—ä¸Šã’ã¾ã™ã€‚ â€»å¼•ã£è¶Šã—å…ˆãƒ–ãƒã‚°ã¸ã®ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã‚µãƒ¼ãƒ“ã‚¹ã¯2024å¹´1æœˆ31æ—¥ã§çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ BIGLOBEã®ã‚µãƒ¼ãƒ“ã‚¹ä¸€è¦§
amayan 2009/04/19
dbix-class

perl

dbic

page

db

sql
ãƒªãƒ³ã‚¯
DBIx::Class::ResultSet
mst: Matt S Trout (project founder - original idea, architecture and implementation) castaway: Jess Robinson (lions share of the reference documentation and manuals) abraxxa: Alexander Hartmaier acca: Alexander Kuznetsov acme: Leon Brocard aherzog: Adam Herzog Alexander Keusch alexrj: Alessandro Ranellucci alnewkirk: Al Newkirk Altreus: Alastair McGowan-Douglas amiri: Amiri Barksdale amoore: Andre
amayan 2009/04/19
dbic

perl

dbix-class

db
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹åŠ£åŒ–ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã›ã„ãªã®ã‹!? ã‚’ã¿ã£ã¡ã‚Šæ¤œè¨¼
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹åŠ£åŒ–ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã›ã„ãªã®ã‹!? ã‚’ã¿ã£ã¡ã‚Šæ¤œè¨¼ï¼šãŠã‚‰! ã‚ªãƒ©! Oracleå†æ¤œè¨¼ ï¼ ITå‡ºå¼µæ‰€ï¼ˆ1ï¼‰ï¼ˆ1/4 ãƒšãƒ¼ã‚¸ï¼‰ æœ¬é€£è¼‰ã¯ã€ã‚¤ãƒ³ã‚µã‚¤ãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ãŒç™ºè¡Œã—ã¦ã„ã‚‹ãƒ¡ãƒ¼ãƒ«ãƒžã‚¬ã‚¸ãƒ³ã€ŒãŠã‚‰ï¼ã‚ªãƒ©ï¼ Oracle ã©ã£ã·ã‚Šæ¤œè¨¼ç”Ÿæ´»ã€ã§éŽåŽ»ã«å–ã‚Šä¸Šã’ãŸãƒ†ãƒ¼ãƒžã‚’ã€æœ€æ–°ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚„æ–°ã—ã„åˆ‡ã‚Šå£ã§å†æ¤œè¨¼ã—ã¦ã¿ã‚ˆã†ã¨ã„ã†ä¼ç”»ã§ã™ã€‚æœ€åˆã«å–ã‚Šä¸Šã’ã‚‹ãƒ†ãƒ¼ãƒžã¯ã€ãƒ¡ãƒ«ãƒžã‚¬ã®æ´å²ã®ä¸ã§ã‚‚æœ€ã‚‚å¤ã„ãƒ†ãƒ¼ãƒžã§ã‚ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æ¤œè¨¼ï¼ˆB-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹åŠ£åŒ–ã«é–¢ã™ã‚‹æ¤œè¨¼ï¼‰ã«ã¤ã„ã¦ã§ã™ã€‚ ãƒ¡ãƒ«ãƒžã‚¬ãƒ—ãƒ¬ã‚¤ãƒãƒƒã‚¯ï¼šã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æ¤œè¨¼ ãƒ¡ãƒ¼ãƒ«ãƒžã‚¬ã‚¸ãƒ³ã€ŒãŠã‚‰ï¼ ã‚ªãƒ©ï¼ Oracle ã©ã£ã·ã‚Šæ¤œè¨¼ç”Ÿæ´»ã€ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æ¤œè¨¼ï¼ˆvol.009ã‹ã‚‰vol.016ï¼‰ã¯ã€ã‚¤ãƒ³ã‚µã‚¤ãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã®ç¾TOPã‚»ãƒ¼ãƒ«ã‚¹ãƒžãƒ³ã§ã‚ã‚‹ã¤ã‘ã¾ã„æ°ãŒ2000å¹´6æœˆã‹ã‚‰8å›žã«ã‚ãŸã£ã¦B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹åŠ£åŒ–
amayan 2009/04/08
performance

index

mysql

db
ãƒªãƒ³ã‚¯
ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ - Wikipedia
ã“ã®è¨˜äº‹ã¯æ¤œè¨¼å¯èƒ½ãªå‚è€ƒæ–‡çŒ®ã‚„å‡ºå…¸ãŒå…¨ãç¤ºã•ã‚Œã¦ã„ãªã„ã‹ã€ä¸ååˆ†ã§ã™ã€‚ å‡ºå…¸ã‚’è¿½åŠ ã—ã¦è¨˜äº‹ã®ä¿¡é ¼æ€§å‘ä¸Šã«ã”å”åŠ›ãã ã•ã„ã€‚ï¼ˆã“ã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã®ä½¿ã„æ–¹ï¼‰ å‡ºå…¸æ¤œç´¢?:Â "ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£"Â â€“Â ãƒ‹ãƒ¥ãƒ¼ã‚¹Â Â· æ›¸ç±Â Â· ã‚¹ã‚«ãƒ©ãƒ¼Â Â· CiNiiÂ Â· J-STAGEÂ Â· NDLÂ Â· dlib.jpÂ Â· ã‚¸ãƒ£ãƒ‘ãƒ³ã‚µãƒ¼ãƒÂ Â· TWL (2017å¹´9æœˆ) ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ï¼ˆè‹±: Stored Procedureï¼‰ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§åˆ©ç”¨ã§ãã‚‹ã‚µãƒ–ãƒ«ãƒ¼ãƒãƒ³ã§ã‚ã‚‹ã€‚ã“ã®ã‚ˆã†ãªãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿è¾žæ›¸ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹ã€‚ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ç”¨é€”ã¨ã—ã¦ã¯ã€ãƒ‡ãƒ¼ã‚¿ã®æ¤œè¨¼ï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®çµ±åˆï¼‰ã‚„ã‚¢ã‚¯ã‚»ã‚¹åˆ¶å¾¡ã®ä»•çµ„ã¿ãªã©ãŒã‚ã‚‹ã€‚ã•ã‚‰ã«ã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¯ã€ã‚‚ã¨ã‚‚ã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å®Ÿè£…ã•ã‚Œã¦ã„ãŸãƒã‚¸ãƒƒã‚¯ã‚’çµ±åˆã—ã€ä¸€å…ƒåŒ–
amayan 2009/04/06
db

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

db

optimize
ãƒªãƒ³ã‚¯
DBIx::DataModel
NAME DBIx::DataModel - UML-based Object-Relational Mapping (ORM) framework INTRODUCTION DBIx::DataModel is a framework for building Perl abstractions (classes, objects and methods) that interact with relational database management systems (RDBMS). Working above the DBI module, it provides facilities for generating SQL queries, joining tables automatically, navigating through the results, convertin
amayan 2009/03/17
dbix

db

dbi

sth
ãƒªãƒ³ã‚¯
æ°¸ç¶šåŒ–å¯¾å¿œã®ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªDBã€ŒRedisã€ãŒç™»å ´ ï¼ ï¼ IT
2009/02/26 memcachedã«ä¼¼ãŸã‚ãƒ¼ã¨å€¤ã®å¯¾ã‚’ä¿å˜ã™ã‚‹ã‚¿ã‚¤ãƒ—ã®æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒRedisã€ãŒGoogle Codeã§2æœˆ25æ—¥ã«ãƒ™ãƒ¼ã‚¿ç‰ˆã¨ã—ã¦å…¬é–‹ã•ã‚ŒãŸã€‚é–‹ç™ºã—ãŸã®ã¯ã€ã‚¤ã‚¿ãƒªã‚¢äººã§ãƒ•ãƒªãƒ¼ãƒ©ãƒ³ã‚¹ã®é–‹ç™ºè€…ã€Salvatore Sanfilippoæ°ã€‚åŒæ°ã¯ã‚¤ã‚¿ãƒªã‚¢ã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã‚µã‚¤ãƒˆã‚„ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚µã‚¤ãƒˆã‚’ç«‹ã¡ä¸Šã’ãŸçµŒé¨“ãŒã‚ã‚Šã€ç¾åœ¨ã¯Webã‚µã‚¤ãƒˆã®è¨ªå•è€…ã‚’ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã§è¿½åŠ è¡¨ç¤ºã™ã‚‹ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹æƒ…å ±å–å¾—ã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹ç™ºä¸ã¨ã„ã†ã€‚ Redisã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯ã€GPL2ã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã€‚ANSI Cã§æ›¸ã‹ã‚Œã¦ã„ã¦ã€Linuxã‚„Mac OS Xã‚’å«ã‚€å¤šãã®POSIXã‚·ã‚¹ãƒ†ãƒ ã§å‹•ãã€‚ç¾åœ¨ã€PHPã‚„Rubyã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’é–‹ç™ºä¸ã¨ã„ã†ã€‚ Redisã¯memcachedã®ã‚ˆã†ã«ã‚ãƒ¼ã¨å€¤ã®å¯¾ã‚’ã€ã™ã¹ã¦ãƒ¡ãƒ¢ãƒªä¸Šã«ä¿å˜ã™ã‚‹ã€‚ãŸã ã—ã€memcachedã¨ç•°ãªã‚Šã€åŒæ™‚
amayan 2009/02/26
store

db

redis
ãƒªãƒ³ã‚¯
MySQLã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹æ§‹ç¯‰
ãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã¯ã€2023å¹´10æœˆ1æ—¥ã«LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã«ãªã‚Šã¾ã—ãŸã€‚LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã®æ–°ã—ã„ãƒ–ãƒã‚°ã¯ã“ã¡ã‚‰ã§ã™ã€‚LINEãƒ¤ãƒ•ãƒ¼ Tech Blog ã“ã‚“ã«ã¡ã¯ã€ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³äº‹æ¥éƒ¨ã®Wangã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ï¼ˆä»¥ä¸‹DWHï¼‰ã¨ã„ã†è¨€è‘‰ã«ãªã˜ã¿ã®ãªã„æ–¹ã¯æ¤œç´¢ã—ã¦ã„ãŸã ã„ãŸã»ã†ãŒã‚ˆã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ æ¤œç´¢ã™ã‚‹ã®ãŒã‚ã‚“ã©ã„ã€ã¨ã„ã†æ–¹ã¯ã€ã‹ã¿ç •ã„ãŸè¡¨ç¾ãŒã§ããªãã¦æç¸®ã§ã™ãŒã€ åŸºå¹¹ç³»ã‚·ã‚¹ãƒ†ãƒ ã‹ã‚‰æŠ½å‡ºã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’ç›®çš„ã‚’ã‚‚ã£ã¦å†æ§‹æˆã—ã€ ä½¿ç”¨å¯èƒ½ãªçŠ¶æ…‹ã«ä¿ç®¡ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã®é›†åˆä½“ã€ã¨ãŠè€ƒãˆãã ã•ã„ã€‚ ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯ã€å…·ä½“çš„ã«ã¯å‡ºå“ã€å…¥æœã€è½æœãªã©ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã‚„ã€ ãã‚Œã‚’ã„ã‚ã„ã‚ãªå˜ä½ã§é›†è¨ˆã—ãŸãƒ‡ãƒ¼ã‚¿ãªã©ãŒè©²å½“ã—ã¾ã™ã€‚ ã“ã“ã§ã„ã†å˜ä½ã¨ã„ã†ã®ã¯ãŸã¨ãˆã°ã€æ—¥ã”ã¨ã€é€±ã”ã¨ã€æœˆã”ã¨ã‚„ã€ä»¥å‰ã®è¨˜äº‹ã§ã‚‚ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ ã‚«ãƒ†ã‚´ãƒªã¨ã„ã£ãŸã‚‚ã®ã«ãªã‚Šã¾ã™ã€‚ ã“ã†ã„ã£ãŸãƒ‡ãƒ¼ã‚¿ã¯ã€é‹ç”¨ã€é‹å–¶ã€
amayan 2009/02/10
database

db

mysql

yahoo
ãƒªãƒ³ã‚¯
tanaka-cs.com
tanaka-cs.com 2024 è‘—ä½œæ¨©. ä¸è¨±è¤‡è£½ ãƒ—ãƒ©ã‚¤ãƒã‚·ãƒ¼ãƒãƒªã‚·ãƒ¼
amayan 2009/02/05
db

plagger

mysql

plugin

store
ãƒªãƒ³ã‚¯
DBMã«ã‚ˆã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ - mixi engineer blog
æ£æœˆæ—©ã€…ã‚¤ãƒ³ãƒ•ãƒ«ã‚¨ãƒ³ã‚¶ã«ã‹ã‹ã£ã¦å¯è¾¼ã‚“ã mikioã§ã™ã€‚é›»è»Šã«ä¹—ã‚‹æ™‚ã‚„ç¹è¯è¡—ãªã©ã«å‡ºã‚‹æ™‚ã¯ãƒžã‚¹ã‚¯ç€ç”¨ãŒå¿…é ˆã§ã™ãã€‚ã•ã¦ä»Šå›žã¯ã€Tokyo Cabinetã§å®Ÿè£…ã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«æ–¹å¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚æ„å¤–ã«ã©ã†ã—ã¦å¼·åŠ›ãªæ©Ÿèƒ½ãªã®ã§ã€ã“ã®ãƒã‚¿ã¯é€£è¼‰ã™ã‚‹ã“ã¨ã‚’äºˆå‘Šã—ã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ ç°¡å˜ã«è¨€ãˆã°ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚ˆã†ã«ã€è¤‡æ•°ã®åˆ—ã‹ã‚‰ãªã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ ¼ç´ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚SQLã‚„è¡¨çµåˆãªã©ã®è¤‡é›‘ãªæ©Ÿèƒ½ã¯ã‚µãƒãƒ¼ãƒˆã—ã¾ã›ã‚“ãŒã€ãã®ã¶ã‚“é«˜é€Ÿã«å‹•ä½œã—ã¾ã™ã€‚ã¤ã¾ã‚Šã€DBMã®é€Ÿåº¦ã§å‹•ããƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«é¢¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ï¼ˆåŽ³å¯†ã«ã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã‚ã‚Šã¾ã›ã‚“ï¼‰ã€‚ TCã®åŸºæœ¬ã¨ãªã‚‹ãƒãƒƒã‚·ãƒ¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€å˜ç´”ãªkey/valueåž‹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚Šã€ã¤ã¾ã‚Šã‚ãƒ¼ã«ã‚‚å€¤ã«ã‚‚ã‚¹ã‚«ãƒ©ï¼ˆæ•°å€¤ã‚„æ–‡å—åˆ—ãªã©ã®ç‰¹ã«æ§‹é€ ã‚’æŒãŸãªã„å˜ä¸€ã®å€¤ï¼‰ã—ã‹æ ¼ç´ã™ã‚‹ã“ã¨ã¯ã§ãã¾ã›ã‚“
amayan 2009/01/28
database

tokyocabinet

library

programming

db
ãƒªãƒ³ã‚¯
CodeZine ã«ã¦ KOF 2008 ã®è¨˜äº‹ã¨è£œè¶³ - naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼
å¤§é˜ªå—æ¸¯ATCã§é–‹å‚¬ã•ã‚ŒãŸã€Œé–¢è¥¿ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹2008ã€ã®2æ—¥ç›®ï¼ˆ11æœˆ8æ—¥ï¼‰åˆå‰ä¸ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã€æ ªå¼ä¼šç¤¾ã¯ã¦ãªCTOã®ä¼Šè—¤ç›´ä¹Ÿæ°ãŒã€Œã¯ã¦ãªæµå¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã€ã¨é¡Œã—ãŸç™ºè¡¨ã‚’è¡Œã£ãŸã€‚ CodeZine ã§å…ˆæ—¥ã® KOF 2008 (ã‚ã‚‰ã‹ã˜ã‚è¨€ã£ã¦ãŠãã¾ã™ãŒ King of Fighters ã§ã¯ãªã„ã§ã™ã‚ˆã€é–¢è¥¿ã‚ªãƒ¼ãƒ—ãƒ³ãƒ•ã‚©ãƒ¼ãƒ©ãƒ ã§ã™) ã®ç™ºè¡¨ã‚’è¨˜äº‹ã«ã—ã¦ã„ãŸã ãã¾ã—ãŸã€‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ç™ºè¡¨è³‡æ–™ã¯ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã«ã‚ã‚Šã¾ã™ã®ã§ä¸€ç·’ã«ã”è¦§ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ http://d.hatena.ne.jp/naoya/20081111/1226395400 ã•ã¦ã€è¨˜äº‹å†…å®¹ã«ã¤ã„ã¦å°‘ã—è£œè¶³ã‚’ã—ã¦ãŠããŸã„ã¨æ€ã„ã¾ã™ã€‚ ãƒ¡ãƒ¢ãƒªã¨ãƒ‡ã‚£ã‚¹ã‚¯ã®é€Ÿåº¦æ¯”è¼ƒã«ã¤ã„ã¦ ã€Œãƒ¡ãƒ¢ãƒªã¯ãƒ‡ã‚£ã‚¹ã‚¯ã® 150 å€ã€ã¨ã„ã†è©±ã§ã™ãŒã€ãã®å¾ŒçŸ¥äººã¨è©±ã—ã¦æ¤œç´¢ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã‚·ãƒ¼ã‚¯ã™ã‚‹å ´åˆãªã©ã¯ ms å¯¾ ns ãã‚‰ã„é•
amayan 2008/11/20
http://codezine.jp/article/detail/3315 ã®è£œè¶³

computing

database

db

mysql

server

hatena

naoya
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç”¨ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ Â·Deltasql MOONGIFT
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã«å¯¾ã—ã¦ã¯CVSã‚„SubversionãŒä½¿ã‚ã‚Œã¦ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ãŒè¡Œã‚ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã€‚ã ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ç®¡ç†ã¯ç…©é›‘ã§ã€ãã®ãŸã‚ã«Railsã®Migrationã¨ã„ã†ä»•çµ„ã¿ã¯éžå¸¸ã«ã‚¦ã‚±ãŒè‰¯ã‹ã£ãŸã€‚ ç®¡ç†ç”»é¢ã€‚ãƒ¦ãƒ¼ã‚¶ç®¡ç†ãªã©ã‚‚ã“ã“ã§è¡Œã†ã€‚ ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã«æ‰‹ãŒåŠ ã‚ã‚Œã°ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ã ã£ã¦å¤‰åŒ–ã™ã‚‹å¯èƒ½æ€§ã¯ã‚ã‚‹ã€‚ãã®åˆ»ã€…ã¨ã—ãŸå¤‰åŒ–ã‚’è¿½ã†ã«ã¯ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ãŒå¿…è¦ã ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯Deltasqlã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å±¥æ´ç®¡ç†ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ Deltasqlã¯PHPã§ä½œã‚‰ã‚ŒãŸWebãƒ™ãƒ¼ã‚¹ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã€MySQL/PostgreSQL/SQL Sever/Oracle/Sybaseã«å¯¾å¿œã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ§‹é€ ã®ç®¡ç†ã‚’è¡Œã†ã“ã¨ãŒã§ãã‚‹ã€‚å®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãã®ã¾ã¾ç®¡ç†ã™ã‚‹ã®ã§ã¯ãªãã€ã‚¹ã‚ãƒ¼ãƒžæƒ…å ±ã ã‘ã‚’ç®¡ç†ã™ã‚‹ã¨ã„ã†ã‚¤ãƒ¡ãƒ¼ã‚¸ã ã€‚ãã®
amayan 2008/10/21
db

ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†
ãƒªãƒ³ã‚¯
mixi Engineersâ€™ Blog Â» Lua on Tyrant: DBã‚µãƒ¼ãƒã«LLã‚’çµ„ã¿è¾¼ã‚€
é…ã‚ã®å¤ä¼‘ã¿ã§é‚£é ˆå¡©åŽŸã«è¡Œã£ã¦ããŸmikioã§ã™ã€‚ç‰§å ´ã§ã‚¢ãƒ«ãƒ‘ã‚«ã«è§¦ã£ã¦ããŸã®ã§ã™ãŒã€ã‚ã¡ã‚ƒã‹ã‚ã„ã‹ã£ãŸã§ã™ã€‚ã•ã¦ä»Šå›žã¯ã€Tokyo Tyrantï¼ˆTTï¼‰ã«ã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžLuaã®å‡¦ç†ç³»ã‚’çµ„ã¿è¾¼ã‚“ã§ä½¿ã†æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ ã¤ã‹ã€Luaã£ã¦ä½•ï¼Ÿ Luaï¼ˆå…¬å¼ã‚µã‚¤ãƒˆã«ã‚ˆã‚‹ã¨ã€Œã‚‹ãƒ¼ã‚ï¼ˆLOO-ahï¼‰ã€ã¨ç™ºéŸ³ï¼‰ã¨ã„ã†è¨€èªžã®åå‰ã¯èžã„ãŸã“ã¨ãŒã‚ã£ã¦ã‚‚ã€æ•°ã‚ã‚‹ãƒžã‚¤ãƒŠãƒ¼è¨€èªžã®ã²ã¨ã¤ã¨æ€ã£ã¦ç‰¹ã«æ°—ã«ã‹ã‘ã¦ã„ãªã„äººã‚‚å¤šã„ã¨æ€ã„ã¾ã™ã€‚ç§ã‚‚ãã†ã§ã—ãŸã€‚ã—ã‹ã—ã€ä»Šã§ã¯ã€Cè¨€èªžä½¿ã„ã®ç¬¬2è¨€èªžãƒ»ç¬¬3è¨€èªžã¨ã—ã¦ä½¿ã†ã«ã¯ã¨ã¦ã‚‚æœ‰æœ›ãªè¨€èªžã ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ Luaã«é–¢ã™ã‚‹æ—¥æœ¬èªžã®æƒ…å ±ã¯ã¾ã å¤šãã¯ãªã„ã®ã§ã™ãŒã€ä»¥ä¸‹ã®ã‚µã‚¤ãƒˆã‚’é †ã«èªã‚€ã¨ã ã„ãŸã„ã®é›°å›²æ°—ãŒæŽ´ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ Lua ã§çµ„ã‚“ã§ã¿ã‚‹ Lua 5.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« Luaã¯è¨€èªžä»•æ§˜ãŒå°ã•ã„ã®ã§ã€ã¨ã¦ã‚‚ç¿’å¾—ã—ã‚„ã™ã„ã§ã™ã€‚ä¸Šè¨˜ã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã ã‘èªã‚
amayan 2008/10/06
database

db

lua

mixi

tokyotyrant
ãƒªãƒ³ã‚¯
Drizzleãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ç›®æŒ‡ã™ã‚‚ã®ã€ãã®å…ˆã‚’èªã‚€ï¼ˆ1/3ï¼‰ ï¼ ï¼ IT
ã‚¯ãƒ©ã‚¦ãƒ‰ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ç’°å¢ƒã®ã‚ˆã†ãªâ€œmassively concurrentãªä¸–ç•Œâ€ã§ä½¿ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç›®æŒ‡ã™Drizzleã€‚ãã®é–‹ç™ºã®æ–¹å‘æ€§ã‹ã‚‰ã“ã‚Œã‹ã‚‰ã®Webã‚·ã‚¹ãƒ†ãƒ ã§æ±‚ã‚ã‚‰ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚ã‚Šæ–¹ãŒè¦‹ãˆã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã€‚ä¸€è¶³å…ˆã«Drizzleã«è§¦ã‚Œã¦ã¿ã‚ˆã†ï¼ˆç·¨é›†éƒ¨ï¼‰ Drizzleã¨ã¯ Drizzle ã¨ã¯ã€MySQLã®ã‚‚ã¨ã‚‚ã¨ã®ç›®æ¨™ã§ã‚ã‚‹ã€ä½¿ã„ã‚„ã™ã•ã€ä¿¡é ¼æ€§ã€ãã—ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é‡ç‚¹ã‚’ç½®ã„ãŸMySQLã®æ´¾ç”Ÿãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã€Brian Akeræ°ï¼ˆç±³ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚º CTO/Labsï¼šå…ƒMySQL Director of Architectureï¼‰ã«ã‚ˆã£ã¦ç«‹ã¡ä¸Šã’ã‚‰ã‚Œã¾ã—ãŸã€‚ MySQLã¨æ¯”è¼ƒã—ã¦æ©Ÿèƒ½é¢ã«ãŠã‘ã‚‹Drizzleã®å¤§ããªé•ã„ã¯ã€ã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’ãƒžã‚¤ã‚¯ãƒã‚«ãƒ¼ãƒãƒ«ã«ã™ã‚‹ã“ã¨ã§ã€ã‚µãƒ¼ãƒï¼ˆMySQLã§ã„ã†mysqldï¼‰ã«ã¯å¿…è¦æœ€å°é™ã®æ©Ÿèƒ½ã—ã‹æè¼‰ã›ãšã€ä»£ã‚ã‚Šã«
amayan 2008/09/03
drizzle

db

tmaesaka
ãƒªãƒ³ã‚¯
MySQL AB :: MySQL 4.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«
æ¦‚è¦ ã“ã‚Œã¯ MySQL ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã§ã™ã€‚ MySQL 8.0 ã‹ã‚‰ 8.0.25ã€ãŠã‚ˆã³ NDB ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 8.0 ã‹ã‚‰ 8.0.25-ndb-8.0.25 ã«åŸºã¥ã NDB Cluster ãƒªãƒªãƒ¼ã‚¹ã«ã¤ã„ã¦ãã‚Œãžã‚Œèª¬æ˜Žã—ã¾ã™ã€‚ ã¾ã ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ãªã„ MySQL ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®æ©Ÿèƒ½ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒå«ã¾ã‚Œã¦ã„ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®è©³ç´°ã¯ã€ã€ŒMySQL 8.0 ãƒªãƒªãƒ¼ã‚¹ãƒŽãƒ¼ãƒˆã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ MySQL 8.0 ã®æ©Ÿèƒ½. ã“ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã§ã¯ã€MySQL 8.0 ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«ã‚ˆã£ã¦ã¯å«ã¾ã‚Œã¦ã„ãªã„æ©Ÿèƒ½ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ã“ã®ã‚ˆã†ãªæ©Ÿèƒ½ã¯ã€ã”è‡ªèº«ã«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ä»˜ä¸Žã•ã‚Œã¦ã„ã‚‹ MySQL 8.0 ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«å«ã¾ã‚Œã¦ã„ãªã„å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ MySQL 8.0 ã®ä½¿ç”¨ã—ã¦ã„ã‚‹ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«å«ã¾ã‚Œã‚‹æ©Ÿèƒ½ã«é–¢ã™ã‚‹è³ªå•ãŒã‚ã‚‹å ´åˆã¯ã€MySQL 8.0
amayan 2008/02/12
db

mysql

manual
ãƒªãƒ³ã‚¯
catalyst:dbic [paulownia.jp]
DBIx::Class::Schema::Loaderã‚’å…¥ã‚Œã‚Œã°ã€ãã®ä¸Šã®ï¼“ã¤ã‚‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã‚‹ã€‚DBDã¯ã©ã‚Œã‚’ä½¿ã†ã‹èžã‹ã‚Œã‚‹ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯ã€Œã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãªã„ã€ãªã®ã§ãƒªã‚¿ãƒ¼ãƒ³é€£æ‰“ã—ãªã„ã‚ˆã†ã«æ³¨æ„ã—ã¦ã€‚ã»ã‹ã«ã‚‚ç‰©å‡„ã„å¤§é‡ã®ä¾å˜ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã€‚ Catalystã®DBIã‚µãƒãƒ¼ãƒˆé–¢é€£ã‚¯ãƒ©ã‚¹ã‚’CPANã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« é©å½“ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ã€‚ CREATE TABLE books ( id INTEGER NOT NULL AUTO_INCREMENT, isbn VARCHAR(13), title VARCHAR(255) NOT NULL, author VARCHAR(255), summary TEXT, PRIMARY KEY(id) ) character SET utf8 type=innoDB; ãƒ†ã‚¹ãƒˆç”¨ã«é©å½“ãªãƒ‡ãƒ¼ã‚¿ã‚‚ãƒ–ãƒƒè¾¼ã‚“ã§ãŠã insert into boo
amayan 2008/01/27
catalyst

dbic

db
ãƒªãƒ³ã‚¯
naotaka blog Â» Blog Archive Â» MySQLã®TIMESTAMPåž‹ã«â€NOT NULLâ€
MySQLã®ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆã®ãƒ†ã‚¹ãƒˆä¸ã€â€desc tbl_name\Gâ€ã§è¦‹ã¦ã¿ã‚‹ã¨ã€TIMESTAMPåž‹ã®ã‚«ãƒ©ãƒ ãŒâ€Null: YESâ€ã«ãªã£ã¦ã„ã‚‹ã®ã‚’ç™ºè¦‹ã€‚ãã†ã„ãˆã°ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆæ™‚ã«â€NOT NULLâ€ã‚’ä»˜ã‘ã¦ãªã‹ã£ãŸã®ã‚’æ€ã„å‡ºã—ã€â€NOT NULLâ€ã‚’ä»˜ã‘ã¦æ”¹ã‚ã¦ä½œã‚Šç›´ã™ã‚‚ã€çµæžœã¯åŒã˜ã€‚ *************************** 4. row *************************** Field: date_updated Type: timestamp Null: YES Key: Default: CURRENT_TIMESTAMP Extra: ä½•æ•…ï¼Ÿè¨³ã‚ã‹ã‚“ãªã„ã®ã§èª¿ã¹ã¦ã¿ã‚‹ã¨ã€MySQLã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã«ã—ã£ã‹ã‚Šã¨è¨˜è¿°ãŒã‚ã‚Šã¾ã—ãŸã€‚ TIMESTAMP åž‹ã‚«ãƒ©ãƒ ã§ã¯ã€ä»–ã®ã‚«ãƒ©ãƒ åž‹ã¨ã¯ç•°ãªã‚‹æ–¹æ³•ã§ NULL å€¤ãŒå‡¦ç†ã•ã‚Œã‚‹ã€‚TIMESTA
amayan 2007/12/06
mysql

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