O'Reilly Radar > Database War Stories #3: Flickr
Continuing my series of queries about how "Web 2.0" companies used databases, I asked Cal Henderson of Flickr to tell me "how the folksonomy model intersects with the traditional database. How do you manage a tag cloud?" He replied: "lots of the 'web 2.0' feature set doesn't fit well with traditional normalised db schema design. denormalization (or heavy caching) is the only way to generate a tag
jQuery File Tree
Search the Notebook Recent Notebook EntriesPopular EntriesjQuery File TreejQuery Context Menu PluginjQuery MultiSelectjQuery Right-click PluginExternal Popup Links Using jQueryRelated EntriesjQuery Context Menu PluginParsing a JSON String Results in an ‘Invalid Label’ Error Determine the Parent Directory of a Path in PHP$.getPOST() for jQueryUsing json_encode() and json_decode() in PHP4 Archives
PHP Mysql tips
PHP Mysql tips Monday, 23 July 2007 Continuing from my earlier post on PHP performance, I thought I’d share a few Mysql tips that I’ve learnt over the years. Hope it helps someone and please leave a comment with your own tips or provide any corrections to the ones mentioned. Word searching 1. SELECT * FROM table WHERE MATCH (`field`) AGAINST ('Keyword') (Fastest) 2. SELECT * FROM table WHERE MATCH
Roppongi.JS #1: Days on the Moon
ã•ã‚‹ 3 月 15 æ—¥ã«é–‹ã‹ã‚ŒãŸ Roppongi.JS ã® jQuery コードリーディングã«ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§ä¸€éƒ¨å‚åŠ ã—ã¾ã—ãŸã€‚途ä¸å‚åŠ ã«é€”ä¸é€€å®¤ã€ä¸€éƒ¨ã“ã¡ã‚‰ã®éƒ½åˆã§éŸ³å£°ãªã—ã§ã®ä¸ç¶™è¦–è´ã¨ã‚ã‚ãŸã ã—ã‹ã£ãŸã‚‚ã®ã®ã€jQuery ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’ã˜ã£ãã‚Šèªã‚€ã„ã„機会ã«ãªã‚Šã¾ã—ãŸã€‚ jQuery オブジェクト 今回個人的ã«ã‚ã‹ã£ãŸã®ã¯ jQuery オブジェクトã€ã™ãªã‚ã¡ jQuery(...) 㨠jQuery 関数 (ã¾ãŸã¯ $ 関数) を呼ã³å‡ºã—ãŸã¨ãã«è¿”ã£ã¦ãるオブジェクトã¯ä½•ãªã®ã‹ã¨ã„ã†ã“ã¨ã€‚jQuery オブジェクトã¯é…列ã®ã‚ˆã†ãªã‚ªãƒ–ジェクトã§ã‚ã‚Šã€length プãƒãƒ‘ティ㨠0 ～ n (n 㯠length - 1) ã¾ã§ã®æ•°å€¤çš„ãªåå‰ã®ãƒ—ãƒãƒ‘ティをæŒã¡ã¾ã™ã€‚é…列ã¨ã—ã¦ã®å„è¦ç´ (数値的プãƒãƒ‘ティ) 㯠DOM ノードオブジェクトを指ã—ã¦ã„ã¾ã™ã€‚ jQuery オブジェクト自身ã¯ã¯
Firefox3MemoryUsage - Firefox 3 ã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡
Firefox3MemoryUsage - Firefox 3 ã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ 目次 ã“ã®æ–‡æ›¸ã«ã¤ã„㦠Firefox 3 ã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ ç§ãŸã¡ã®ã‚„ã£ãŸã“㨠メモリæ–片化ã®å‰Šæ¸› 循環コレクタã«ã‚ˆã‚‹å¾ªç’°ã®å›žé¿ ã‚ャッシュã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ç”»åƒãƒ‡ãƒ¼ã‚¿ã®ä¿å˜æ–¹æ³•èª¿æ•´ リーク狩り メモリ使用é‡ã®æ¸¬å®š テスト方法 çµæžœ ã¾ã¨ã‚ è¬è¾ž Firefox 3 ã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ ã“ã®æ–‡æ›¸ã«ã¤ã„㦠Stuart Parmenter "Firefox 3 Memory Usage" ã®æ—¥æœ¬èªžè¨³ã§ã™. http://blog.pavlov.net/2008/03/11/firefox-3-memory-usage/ 推敲æ“è¿Ž: 誤訳, タイãƒ, 訳語ã®ä¸çµ±ä¸€, ãã®ã»ã‹... Web ã‚„ Web ブラウザãŒæˆç†Ÿã™ã‚‹ã«ã¤ã‚Œ, 人々ã¯ãã“ã«ãªã‹ã£ãŸã‚‚ã®ã‚’期待ã™ã‚‹ã‚ˆã†ã«ãªã£ãŸ. ã¯ã˜ã‚㦠Firefox ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œ
1000万件ã®ãƒ‡ãƒ¼ã‚¿ã¨é—˜ã†ã«ã¯ - hoge1e3ã®æ—¥è¨˜
仕事ã§1000万件超ã®ãƒ‡ãƒ¼ã‚¿ã‚’扱ã£ã¦ã„ã‚‹ã¨ã„ã†çŸ¥ã‚Šåˆã„ã‹ã‚‰ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¤ã„ã¦ã„ã‚ã„ã‚ã¨èžã„ã¦ã¿ãŸï¼Ž データベースを速ãã™ã‚‹ã‚³ãƒ„ã¯? DBサーãƒã¨ã‚¢ãƒ—リケーションサーãƒã‚’分ã‘ã‚‹ã¨24時間ã‹ã‹ã£ã¦ã„ãŸã‚‚ã®ãŒ2時間ã«ãªã£ãŸ ãŠãらã，1ã¤ã®ã‚¿ã‚¹ã‚¯ã«é›†ä¸ã—ãŸã»ã†ãŒã‚ャッシュã®ãƒ’ット率ãŒã‚ãŒã‚‹ã‹ã‚‰ï¼Ÿ Materialized View ã„ãら1000万件ã®ç”Ÿãƒ‡ãƒ¼ã‚¿ã‚’ã‚‚ã£ã¦ã„ã¦ã‚‚，ãれら直接扱ã†ã“ã¨ã¯ã‚„ã£ã±ã‚Šç¨€ã‚‰ã—ã„．普段ã¯é›†è¨ˆæ¸ˆã¿ã®ãƒ‡ãƒ¼ã‚¿ã‚’扱ã†ã‚‰ã—ã„． 集計内容ã¨ç”Ÿãƒ‡ãƒ¼ã‚¿ã¯æ•´åˆæ€§ãŒãªã„ã¨ã„ã‘ãªã„．ã§ã‚‚Viewを使ã†ã®ã¯é…ã„，ã¨ã„ã†ã¨ãã«ã¯ Materialized View ã¨ã„ã†ã‚‚ã®ãŒã‚るらã—ã„．簡å˜ã«ã„ã†ã¨ã‚¯ã‚¨ãƒªã®çµæžœã‚’特定ã®ãƒ†ãƒ¼ãƒ–ルã«ã¨ã£ã¦ãŠã„ã¦ï¼ŒãŸã¾ã«æ›´æ–°ã‚’ã‹ã‘る，ã¨ã„ã†ã‚‚ã®ï¼Ž Oracle ã«ã¯ create materialized view ãŒã‚るらã—ã„． http://www.a
blog.endflow.net
Cold Brew (水出ã—) 2.0 アイスコーヒー 2.0を書ã„ãŸã®ãŒ 2020 å¹´ã®å¤ãªã®ã§ã€ãã“ã‹ã‚‰ 2 年も経ã£ã¦ã—ã¾ã£ãŸãªã‚“ã¦é©šãã 。 今回も懲りãšã«ã€Œ2.0ã€ã‚·ãƒªãƒ¼ã‚ºã‚’書ã„ã¦ã„ãã‚“ã ã‘ã©ã€ãªã‚“㧠Cold Brew ãªã®ã‹ã¨ã„ã†ã¨ã€ã“ã“数ヶ月通ã£ã¦ã„ã‚‹ Definitive. ãŒå‡ºã™ Cold Brew ã«ã‚ˆã£ã¦è‡ªåˆ†ã®ä¸ã®å¸¸è˜ãŒå¤‰ã‚ã£ã¦ã—ã¾ã£ãŸã‹ã‚‰ã€‚ ã“ã‚Œã¾ã§è±†ã®ãƒãƒ†ãƒ³ã‚·ãƒ£ãƒ«ã‚’最大é™å‘³ã‚ã„ãŸã„ãªã‚‰ãƒ•ã‚£ãƒ«ã‚¿ãƒ¼ï¼ˆãƒ›ãƒƒãƒˆã®ãƒ‰ãƒªãƒƒãƒ—）をé¸ã¶ã“ã¨ãŒå¤šã‹ã£ãŸã€‚ ã ã‘ã© Definitive.ã® Cold Brew ã¯ãƒ•ã‚£ãƒ«ã‚¿ãƒ¼ã§æ·¹ã‚ŒãŸã‚³ãƒ¼ãƒ’ーã¨åŒã˜ãらã„複雑ãªã‚¢ãƒãƒžã¨æ§˜ã€…ãªãƒ•ãƒ¬ãƒ¼ãƒãƒ¼ã€ã‚¢ãƒ•ã‚¿ãƒ¼ã®è¤‡é›‘ã•ã€æ¸©åº¦å¤‰åŒ–ã«ã‚ˆã‚‹ãƒ•ãƒ¬ãƒ¼ãƒãƒ¼ã®å¤‰é·ã‚‚楽ã—ã‚€ã“ã¨ãŒã§ãる。 ã¨ã„ã†ã“ã¨ã§ã€ãŠåº—ã®å‘³ã‚’完全å†ç¾ï¼ã¨ã¾ã§ã¯ã„ã‹ãªã„ã‚‚ã®ã®ã€è±†ã«å¿œã˜ã¦å¥½ã¿ã® Cold Brew を作れるよã†ã«ãªã£ã¦ããŸã®ã§ã€ãƒ¬ã‚·ãƒ”ã¨
メンテナンス
ãŠçŸ¥ã‚‰ã›
障害
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Installing The Amazon MP3 Downloader On Ubuntu Gutsy Gibbon
http://blog.tofu-kun.org/080318101851.php
http://www.ohmiyapatriots.com/blog/2008/03/21/firefox3-beta4%E3%82%92%E5%85%A5%E3%82%8C%E3%81%A6%E3%81%8B%E3%82%89%E3%82%84%E3%81%A3%E3%81%9F%E3%81%93%E3%81%A8%E3%81%BE%E3%81%A8%E3%82%81-%E6%8B%A1%E5%BC%B5%E7%B7%A8/
Django Menuing System
{{#tags}}- {{label}}
{{/tags}}