YappoLogs: Tagã®æ¤œç´¢ã‚’Senna+MySQLã§Tagã®æ¤œç´¢ã‚’Senna+MySQL㧠kazeburoã•ã‚“ã®æ‰€ã§fulltext使ã£ã¦tagを実装ã™ã‚‹ãƒã‚¿ãŒã‚¢ãƒ„ã‚ãªã®ã§ã¡ã‚‡ã‚ã£ã¨æ›¸ã„ã¦ã¿ã‚‹ã€‚ Sennaã®MySQL 2indパッãƒã‚’使ã†ã¨ã€æ—¢å˜ã®indexã¨Sennaã®index両方をåŒæ™‚ã«ä½¿ã†ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ãã‚ŒãŒå‡ºæ¥ã‚‹ã¨ä½•ãŒè‰¯ã„ã¨è¨€ã†ã¨ã€user idã§çµžã‚Šè¾¼ã¿ã¤ã¤tag検索ãŒå¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ create table ft_tags( id int unsigned not null auto_increment primary key, user_id int unsigned not null, tags text, index user_id(user_id), fulltext tags(tags) )ã¨ã„ã†ãƒ†ãƒ¼ãƒ–ルを用æ„ã—ã¦ãŠã。 user idãŒ2ã®äººã®ã‚¿ã‚°æ¤œç´¢ã‚’ã™ã‚‹ã¨ãã«select id from ft_tag
Tags: Database schemas
{{#tags}}- {{label}}
{{/tags}}