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

Kanasansoft id:Kanasansoft

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

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

è—© ä¸€è¦§ | å¹•æœ«æœŸè¿‘ä¸–æ‘é ˜åŸŸãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆ
è—© ä¸€è¦§ ãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆã®é ˜åˆ†ä¸€è¦§ã§ã™ã€‚è—©IDãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆã«å«ã¾ã‚Œã‚‹è—©ã«ã¤ã„ã¦ã¯ã€åŒä¸€ã®è—©ã«å±žã™ã‚‹è¤‡æ•°ã®é ˜åˆ†ã‚’çµ±åˆã—ã¦è¡¨ç¤ºã—ã¾ã™ã€‚ãªãŠæ‘æ•°ãŠã‚ˆã³çŸ³é«˜åˆè¨ˆã«ã¤ã„ã¦ã¯ã€è¤‡æ•°ã®é ˜ä¸»ãŒå˜åœ¨ã™ã‚‹æ‘ï¼ˆç›¸çµ¦ï¼‰ã‚’åˆ†ã‘ã¦ã„ã¾ã›ã‚“ã€‚ã‚†ãˆã«çŸ³é«˜åˆè¨ˆã¯è—©ã®å®Ÿéš›ã®çŸ³é«˜ã¨ã¯ç•°ãªã‚Šã¾ã™ã€‚åœ°å›³è¡¨ç¤ºã«ã¤ã„ã¦ã¯ãƒ™ã‚¯ãƒˆãƒ«ã‚¿ã‚¤ãƒ«åœ°å›³ã‚‚ã”åˆ©ç”¨ãã ã•ã„ã€‚ æ¤œç´¢ æ´å²çš„åœ°åï¼ç¾ä»£åœ°åã«ã‚ˆã‚‹çµ±åˆæ¤œç´¢ã§ã¯ã€ç¾ä»£ãŠã‚ˆã³æ´å²çš„ãªå¸‚åŒºç”ºæ‘åã‚„ç¾ä»£ã®ç”ºä¸ãƒ»å—åã«ã‚ˆã‚‹æ¤œç´¢ãŒå¯èƒ½ã§ã™ã€‚ åœ°åï¼ˆã®ä¸€éƒ¨ï¼‰ã‚’å…¥åŠ›ï¼š æ¦‚è¦ å¹•æœ«æœŸè¿‘ä¸–æ‘é ˜åŸŸãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆã¨ã¯ã€å¹•æœ«æœŸï¼ˆæ…¶å¿œå¹´é–“é ƒï¼‰è¿‘ä¸–æ‘ã®é ˜åŸŸãƒ‡ãƒ¼ã‚¿ã¨ç‚¹ãƒ‡ãƒ¼ã‚¿ã‚’å«ã‚€å¹•æœ«æœŸè¿‘ä¸–æ‘é ˜åŸŸãƒ‡ãƒ¼ã‚¿ï¼ˆ02_kyudaka_v2.01ï¼‰ï¼ˆä½œæˆï¼šæœ¬ç”°è¬™ä¸€æ°ï¼‰ã‚’åŠ å·¥ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆã§ã™ã€‚çŸ³é«˜ã«ã¤ã„ã¦ã¯ã€æ—§é«˜æ—§é ˜å–èª¿å¸³ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆå›½ç«‹æ´å²æ°‘ä¿—åšç‰©é¤¨ï¼‰ã‚’å‚ç…§ã—ã¦ã„ã¾ã™ã€‚2025å¹´9æœˆç¾åœ¨ã€è¿‘ä¸–æ‘ï¼66,581ä»¶ã‚’æä¾›ã—ã¦ã„ã¾ã™ã€‚åˆ©ç”¨ä¸Š
Kanasansoft 2025/10/11
é–¢æ±åœã ã‘ã ã‘ã©ã“ã¡ã‚‰ã®ã‚µã‚¤ãƒˆã¯ã‚ˆã‚Šç´°ã‹ã„åˆ†é¡žã§ä¸”ã¤å¢ƒç•Œã¾ã§ã‚ã‹ã‚‹ã®ã§ãŠå‹§ã‚ã€‚ https://koaza.net/maps/

map

history

gis

database

db
ãƒªãƒ³ã‚¯
ã‚³ãƒ¼ãƒ‰ã®å¯¿å‘½ãƒ»ãƒ‡ãƒ¼ã‚¿ã®å¯¿å‘½ãƒ»äº’æ›æ€§ã®å¯¿å‘½
ã“ã‚Œã‚’è¨˜äº‹ã«ã—ã¦ã„ã‚‹ 2025 å¹´ 5 æœˆã®äºŒå¹´ã»ã©å‰ (2023-06-02) ã«ã€ç¸ã‚ã£ã¦æ˜Žæ²»å¤§å¦ æƒ…å ±ç§‘å¦ç§‘ã§ã®ç‰¹åˆ¥è¬›ç¾© [1] ã‚’æ‹…å½“ã•ã›ã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ èº«å†…ã®è©•åˆ¤ã¯æ‚ªããªã‹ã£ãŸã®ã§ã‚¹ãƒ©ã‚¤ãƒ‰ã¯å…¬é–‹ã—ã¦ã„ãŸã‚“ã§ã™ãŒã€å˜ã« Google Slides ã‚’å…¬é–‹çŠ¶æ…‹ã«ã—ãŸã ã‘ã ã£ãŸã‚“ã§ã™ãã€‚ [2] ã“ã‚Œã§ã¯ã‚ã¨ã‹ã‚‰å‚ç…§ãƒ»å¼•ç”¨ã™ã‚‹ã®ã‚‚é›£ã—ãã€ã¡ã‚‡ã£ã¨ã‚‚ã£ãŸã„ãªã„ã‹ã¨æ€ã£ãŸã®ã§ã€ã„ã¾ã•ã‚‰ãªãŒã‚‰è¨˜äº‹ã®å½¢ã§ã¾ã¨ã‚ãªãŠã—ã¦ãŠãã“ã¨ã«ã—ã¾ã—ãŸã€‚ ä¸€å¹´ã‚‚çµŒã¦ã°æƒ…å ±ãŒå¤ããªã£ã¦ã—ã¾ã†ã‚³ã®æ¥ç•Œã§ã™ã€‚è³žå‘³æœŸé™åˆ‡ã‚Œã®è©±ã‚‚ã‚ã‚‹ã¨æ€ã„ã¾ã™ãŒã€è©±ã®ãƒã‚¿ã«ã§ã‚‚ã—ã¦ã‚‚ã‚‰ãˆã‚Œã°å¹¸ã„ã§ã™ã€‚ è¬›ç¾©ã®å¯¾è±¡ã¨ç›®çš„ ã“ã®è¬›ç¾©ã€ç›®çš„ã¯2ã¤ã‚ã£ã¦ã€ã¾ãšã€Œæœ€æ–°ã®æƒ…å ±ç§‘å¦ãƒˆãƒ”ãƒƒã‚¯ã«è§¦ã‚Œã‚‹ã€ã“ã¨ã€‚ ãã‚Œã‹ã‚‰ã€å°±è·æ´»å‹•ãŒå§‹ã¾ã‚‹3å¹´ç”ŸãŒãƒ¡ã‚¤ãƒ³ã®å¯¾è±¡è€…ãªã®ã§ã€ ä»Šå¾Œã®ã‚ãƒ£ãƒªã‚¢ãƒ—ãƒ©ãƒ³ã¨ã‹äººç”ŸæŒ‡é‡ã«é–¢ã™ã‚‹ã„ã‚ã„ã‚ãªè¦–ç‚¹ã‚’æŒã£ã¦ã‚‚ã‚‰ã†ã“ã¨ã§ã™ã€‚ ã“ã®
Kanasansoft 2025/05/23
compatibility

database

programming

data

code

service

development
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
Kanasansoft 2013/04/03
RDBã«é–¢ã™ã‚‹éžå¸¸ã«å¤šãã®ãƒŽã‚¦ãƒã‚¦ãŒè¼‰ã£ã¦ã„ã‚‹ã€‚

db

programming

database

sql

tips
ãƒªãƒ³ã‚¯
ç¬¬1å›žã€€memcachedã®åŸºæœ¬ | gihyo.jp
æ ªå¼ä¼šç¤¾ãƒŸã‚¯ã‚·ã‚£ é–‹ç™ºéƒ¨ ã‚·ã‚¹ãƒ†ãƒ é‹ç”¨ã‚°ãƒ«ãƒ¼ãƒ—ã®é•·é‡Žã§ã™ã€‚æ™®æ®µã¯ãƒŸã‚¯ã‚·ã‚£ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é‹ç”¨ã‚’æ‹…å½“ã—ã¦ãŠã‚Šã¾ã™ã€‚ä»Šå›žã‹ã‚‰æ•°å›žã«ã‚ãŸã‚Šã€æœ€è¿‘Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®åˆ†é‡Žã§è©±é¡Œã«ãªã£ã¦ã„ã‚‹memcachedã«ã¤ã„ã¦ã€å¼Šç¤¾é–‹ç™ºéƒ¨ ç ”ç©¶é–‹ç™ºã‚°ãƒ«ãƒ¼ãƒ—ã®å‰å‚ã¨ã¨ã‚‚ã«ã€ä½¿ã„æ–¹ã‚„å†…éƒ¨æ§‹é€ ã€é‹ç”¨ã«ã¤ã„ã¦è§£èª¬ã•ã›ã¦é ‚ãã¾ã™ã€‚ memcachedã¨ã¯ memcachedã¯ã€LiveJournalã‚’é‹å–¶ã—ã¦ã„ãŸDanga Interactiveç¤¾ã§ã€Brad Fitzpatrickæ°ãŒä¸å¿ƒã¨ãªã£ã¦é–‹ç™ºã•ã‚ŒãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ç¾åœ¨ã§ã¯mixiã‚„ã¯ã¦ãªã€Facebookã€Voxã€LiveJournalãªã©ã€ã•ã¾ã–ã¾ãªã‚µãƒ¼ãƒ“ã‚¹ã§Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’å‘ä¸Šã•ã›ã‚‹é‡è¦ãªè¦ç´ ã«ãªã£ã¦ã„ã¾ã™ã€‚ å¤šãã®Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€RDBMSã«ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã—ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã§ãã®ãƒ‡ãƒ¼ã‚¿
Kanasansoft 2012/09/23
memcached

programming

database

development

server

kvs
ãƒªãƒ³ã‚¯
NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°æŠ€æ³•
NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°æŠ€æ³•.markdown #NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°æŠ€æ³• åŽŸæ–‡ï¼šNoSQL Data Modeling Techniques Â« Highly Scala ble Blog I translated this article for study. contact matope[dot]ono[gmail] if any probl em. NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã€ä¸€è²«æ€§ã¨ã„ã£ãŸæ§˜ã€…ãªéžæ©Ÿèƒ½è¦ä»¶ã‹ã‚‰æ¯”è¼ƒã•ã‚Œã‚‹ã€‚NoSQLã®ã“ã®å´é¢ã¯å®Ÿè·µã¨ç†è«–ã®ä¸¡é¢ã‹ã‚‰ã‚ˆãç ”ç©¶ã•ã‚Œã¦ã„ã‚‹ã€‚ã‚ã‚‹ç¨®ã®éžæ©Ÿèƒ½ç‰¹æ€§ã¯NoSQLã‚’åˆ©ç”¨ã™ã‚‹ä¸»ãªå‹•æ©Ÿã§ã‚ã‚Šã€NoSQLã‚·ã‚¹ãƒ†ãƒ ã«ã‚ˆãé©ç”¨ã•ã‚Œã‚‹CAPå®šç†ãŒãã†ã§ã‚ã‚‹ã‚ˆã†ã«åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ ã®åŸºæœ¬çš„åŽŸå‰‡ã ã‹ã‚‰ã ã€‚ä¸€æ–¹ã§ã€NoSQLãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã¯ã‚ã¾ã‚Šç ”ç©¶ã•ã‚Œã¦ãŠã‚‰ãšã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«è¦‹ã‚‰ã‚Œã‚‹ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒžãƒ†ã‚£ãƒƒã‚¯
Kanasansoft 2012/04/17
data

nosql

database

development

programming
ãƒªãƒ³ã‚¯
ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã€ã§Googleæ¤œç´¢ã—ã¦ä¸Šä½15è¨˜äº‹ã‚’æ¤œè¨¼ã—ãŸ - ockeghem's blog
ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€ãƒãƒƒãƒˆä¸Šã§ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã€ã§Googleæ¤œç´¢ã—ãŸçµæžœã®ä¸Šä½15ã‚¨ãƒ³ãƒˆãƒªã‚’æ¤œè¨¼ã—ãŸçµæžœã‚’å ±å‘Šã—ã¾ã™ã€‚ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ã®å¯¾ç–ã¯ã€æ—¢ã«ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã«ãƒ•ã‚¡ã‚¤ãƒŠãƒ«ã‚¢ãƒ³ã‚µãƒ¼ï¼ˆå¾Œè¿°ï¼‰ã‚’ç¤ºã—ã¦ã„ã¾ã™ãŒã€ã¾ã ã“ã®æ–‡æ›¸ã‚’çŸ¥ã‚‰ãªã„äººãŒå¤šã„ã ã‚ã†ã“ã¨ã¨ã€ã‚„ã‚„ä¸Šç´šè€…å‘ã‘ã®æ–‡æ›¸ã§ã‚ã‚‹ã“ã¨ã‹ã‚‰ã€ã¾ã ååˆ†ã«å®Ÿè·µã•ã‚Œã¦ã¯ã„ãªã„ã¨æ€ã„ã¾ã™ã€‚ ã“ã®çŠ¶æ³ã§ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ã“ã¨ã‚’ã‚ˆãçŸ¥ã‚‰ãªã„äººãŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã—ã‚ˆã†ã¨ã—ãŸå ´åˆã®è¡Œå‹•ã‚’äºˆæ¸¬ã—ã¦ã¿ã‚‹ã¨ã€ã‹ãªã‚Šã®å‰²åˆã®äººãŒGoogleç‰ã§æ¤œç´¢ã—ã¦å¯¾å‡¦æ–¹æ³•ã‚’èª¿ã¹ã‚‹ã¨æ€ã‚ã‚Œã¾ã™ã€‚ãã“ã§ã€ä»¥ä¸‹ã®URLã§SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–æ–¹æ³•ã‚’æ¤œç´¢ã—ãŸçµæžœã®ä¸Šä½ã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ¤œè¨¼ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ç«‹ã¡ã¾ã—ãŸã€‚ http://www.google.co.jp/search?q=SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç– ã©ã“ã¾ã§èª¿ã¹ã‚‹ã‹ã§ã™ãŒã€ä»¥å‰NH
Kanasansoft 2011/11/09
ã€Žã€Œã‚µãƒ‹ã‚¿ã‚¤ã‚ºã€çš„ãªå¯¾ç–ã‚’æŒ™ã’ã‚‹ã€ã€Žãã†ã„ã£ãŸæ¥è€…ã€ã€Žè¡€ç¥ã‚Šã«ã‚ã’ã‚‰ã‚Œã¦ã„ã‚‹ã€ã€Žã“ã®ã‚ãŸã‚Šã®ã“ã¨ã«ã¤ã„ã¦çµè«–ã‚’å‡ºã—ã¦ã„ãŸã ãã¾ã™ã€‚ã€ã€Žã“ã‚Œã‚’èªã‚“ã ç§ã®ãƒ—ãƒ¬ãƒƒã‚·ãƒ£ãƒ¼ã‚’å¯Ÿã—ã¦ã„ãŸã ã‘ã‚‹ã§ã—ã‚‡ã†ã‹ã€‚ã€

sql

security

database
ãƒªãƒ³ã‚¯
www.tamandua-webtools.net is Expired or Suspended.
ã€Œ www.tamandua-webtools.net ã€ã®ãƒšãƒ¼ã‚¸ã¯ã€ãƒ‰ãƒ¡ã‚¤ãƒ³ãŒç„¡åŠ¹ãªçŠ¶æ…‹ã§ã™ã€‚ ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆç®¡ç†è€…ã®æ–¹ã¯ã“ã¡ã‚‰ã‹ã‚‰å¤‰æ›´ãƒ»æ›´æ–°ã‚’è¡Œã£ã¦ãã ã•ã„ã€‚ ã€Œ www.tamandua-webtools.net ã€is Expired or Suspended. The WHOIS is here.
Kanasansoft 2011/02/22
db

database

sql

sqlite
ãƒªãƒ³ã‚¯
https://blogs.oracle.com/xpsoluxdb/2010/12/do_you_play_sudoku.html
Kanasansoft 2010/12/27
æ•°ç‹¬ã‚’è§£ãSQLã€‚

database

puzzle
ãƒªãƒ³ã‚¯
Firefoxã®Placesãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚¢ã‚¤ãƒ‰ãƒ«æ™‚é–“ã«vacuumã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ - Mozilla Flux
Placesã¯Firefoxã®å±¥æ´ã¨ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã‚’ä¿å˜ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€SQLiteã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã‚’åˆ©ç”¨ã—ã¦ã€places.sqliteã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç”Ÿæˆã—ã¦ã„ã‚‹ã€‚ã“ã®ãƒ•ã‚¡ã‚¤ãƒ«ã®è‚¥å¤§åŒ–ã¨æ–ç‰‡åŒ–ãŒFirefoxã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®æ‚ªåŒ–ã‚’æ‹›ãã¨ã¿ã‚‰ã‚Œã¦ãŠã‚Šã€å‰Šé™¤ã•ã‚Œã¦ç©ºã„ãŸãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è©°ã‚ã¦å†é…ç½®ã™ã‚‹vacuumå‘½ä»¤ã«é–¢å¿ƒãŒé›†ã¾ã‚‹ã‚†ãˆã‚“ã ã€‚ ã—ã‹ã—ã€Firefoxã¯ã“ã®vacuumå‘½ä»¤ã‚’è‡ªå‹•çš„ã«ã¯ç™ºè¡Œã—ã¦ãã‚Œãªã„ã€‚ãã®ãŸã‚å±¥æ´ãƒ‡ãƒ¼ã‚¿ã‚„ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã‚’å‰Šé™¤ã—ã¦ã‚‚places.sqliteã®è‚¥å¤§åŒ–ãƒ»æ–ç‰‡åŒ–ã¯é€²ã‚€ä¸€æ–¹ã§ã‚ã‚‹ã€‚ã‚‚ã¡ã‚ã‚“ã€å¤šãã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ã“ã®ã‚ˆã†ãªäº‹æ…‹ã‚’æœ›ã‚“ã§ãŠã‚‰ãšã€Firefoxã®é€Ÿåº¦ä½Žä¸‹ã‚’é˜²ãç°¡å˜ãªæ‰‹æ®µã‚’æ¬²ã—ã¦ã„ãŸã€‚ãˆã‚€ã‚‚ã˜ã‚‰ã€ŽFirefox ã® places.sqlite ã‚’å†èµ·å‹•ã›ãšã« VACUUM ã™ã‚‹æ–¹æ³•ã€ãŠã‚ˆã³ã€ŽPlaces ã‚’ VACUUM ã™ã‚‹æ‹¡å¼µæ©Ÿèƒ½3å€‹
Kanasansoft 2010/05/13
æœ€æ–°ã®Firefoxã§ã¯vacuumã¯ã‚‚ã†ä¸è¦ã€ã‚‚ã—ãã¯è¿‘ã€…ä¸è¦ã«ãªã‚‹ã¿ãŸã„ã€‚

sqlite

firefox

database

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

data

database

db

management

tips

work
ãƒªãƒ³ã‚¯
Rails ã® migration ãƒ•ã‚¡ã‚¤ãƒ«ã§ decimal åž‹ã®ã‚«ãƒ©ãƒ ã‚’ä½œæˆã™ã‚‹ - åƒ•ã¯ç™ºå±•é€”ä¸ŠæŠ€è¡“è€…
ãƒ¡ãƒ¢ä»£ã‚ã‚Šã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã€‚ Google Maps ä¸Šã«ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ—ãƒãƒƒãƒˆã—ãŸãã¦ã€ç·¯åº¦ã¨çµŒåº¦ã‚’ DB ã«ä¿å˜ã—ãŸã„ã®ã ãŒã€Rails ã® migration ãƒ•ã‚¡ã‚¤ãƒ«ã§ def self.up create_table :tests, :force => true do |t| t.column :lat, :float t.column :lng, :float end end ã¨ã—ã¦ã€float åž‹ã® lat ã¨ lng ã‚«ãƒ©ãƒ ã‚’ç”¨æ„ã—ãŸå ´åˆã€èª¤å·®ãŒç”Ÿã˜ã¦ã€å®Ÿéš›ã«ãƒ—ãƒãƒƒãƒˆã—ãŸã„å ´æ‰€ã¨ãšã‚Œã¦è¡¨ç¤ºã•ã‚Œã¦ã—ã¾ã†ã€‚ è§£æ±ºæ–¹æ³•ã¯ã¨ã„ã†ã¨ã€Rails ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒ 1.2.2 ä»¥ä¸Šãªã‚‰ã°ã€:decimal åž‹ãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ã¨ã®ã“ã¨ãªã®ã§ã€ t.column(:price, :decimal, :precision => 17, :scale => 14, :default => 0.0, :
Kanasansoft 2008/02/11
rails

map

google maps

database

mysql
ãƒªãƒ³ã‚¯
SQLã§æœ¨ã¨éšŽå±¤æ§‹é€ ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†â€•â€•å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
Kanasansoft 2007/09/03
algorithm

database

db

programming

tips

sql
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã®ãƒ¢ãƒ‡ãƒªãƒ³ã‚°
Kanasansoft 2007/06/20
database

db

data

model

debian

development
ãƒªãƒ³ã‚¯
Entrance has moved to: http://dbentrance.com
Entrance has moved to: http://dbentrance.com
Kanasansoft 2007/05/10
windows

oss

linux

gui

Java

MacOS X

mysql

database
ãƒªãƒ³ã‚¯
MOONGIFT: Â» è¤‡æ•°DBæ“ä½œã«å¯¾å¿œã—ãŸMySQLãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã€ŒEntranceã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã§MySQLã‚’åˆ©ç”¨ã™ã‚‹å ´é¢ãŒå¢—ãˆã¦ã„ã‚‹ã€‚ã¾ãŸã€å¤§åž‹ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãªã‚Œã°ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒä¸€ã¤ã§ã¯è¶³ã‚‰ãšã€è¤‡æ•°ã«åˆ†ã‘ã‚‹ã“ã¨ã¯æ—¥å¸¸çš„ã«ãªã£ã¦ããŸã€‚ è¤‡æ•°DBã€ã•ã‚‰ã«è¤‡æ•°ã‚µãƒ¼ãƒã«åˆ†ã‹ã‚Œã¦ãã‚‹ã¨ç®¡ç†ãŒéžå¸¸ã«ç…©é›‘ã«ãªã‚‹ã€‚ãã†ã—ãŸæ™‚ã«ä½¿ã£ã¦ã¿ãŸã„ã®ãŒã“ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯Entranceã€è¤‡æ•°DBå¯¾å¿œã‚’å‰æã«ã—ãŸMySQL ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã ã€‚ Entranceã¯MySQL ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã¨ã—ã¦ã€DBæŽ¥ç¶šã€ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚«ãƒ©ãƒ è¿½åŠ /å¤‰æ›´ãªã©ã®æ“ä½œãŒè¡Œãˆã‚‹ã€‚ãã®ã¾ã¾ãƒ‡ãƒ¼ã‚¿ç·¨é›†ã¯ã§ããªã„ãŒã€SQLã‚’å®Ÿè¡Œã™ã‚Œã°ã‚‚ã¡ã‚ã‚“ç·¨é›†ã§ãã‚‹ã€‚ ã—ã‹ã—Entranceã®å‡„ã•ã¯ãã‚Œã ã‘ã§ã¯ãªã„ã€‚æœ€ã‚‚é©šãã®ãŒã€ä»–ãƒ›ã‚¹ãƒˆé–“ã§ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‰ãƒ©ãƒƒã‚°ã‚¢ãƒ³ãƒ‰ãƒ‰ãƒãƒƒãƒ—ã ã€‚ãƒ„ãƒªãƒ¼ã§DBã‹ã‚‰DBã¸ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒ‰ãƒ©ãƒƒã‚°ã‚¢ãƒ³ãƒ‰ãƒ‰ãƒãƒƒãƒ—ã§ç§»å‹•ã§ãã¦ã—ã¾ã†ã€‚ ã¾ãŸã€ show proce
Kanasansoft 2007/05/10
windows

oss

linux

gui

Java

MacOS X

mysql

database
ãƒªãƒ³ã‚¯
1