hi all, while trying to figure out how to tag a blog post with a single sql statement here, the following thought crossed my mind: using a relation table tag2post that references tags by id as follows just isn't necessary: tags +-------+-----------+ | tagid | tag | +-------+-----------+ | 1 | news | | 2 | top-story ...
Machine tags are more precise tags: http://www.flickr.com/groups/api/discuss/72157594497877875. They allow a user to basically tag anything as an object in the format object:property=value Any tips on a rdbms schema that implements this? Just wondering if anyone has already dabbled with this. I imagine the schema is quite similar to imp...
How do websites like Digg, Del.icio.us, and StackOverflow implement tagging? I know this other question has an accepted answer of a many-to-many relation with a cross ref table. But how do the "big boys" do it? The same way? How is it scaling? ...
I want to add a text field to a web page that lets users add space delimited tags. much like del.icio.us. I am more interested in how I get them off the page and into the database using VB.NET and SQL. Can anyone point me at any articles or code snippets on how I can achieve this using vb.net and sql 2005? ...
Thunderbird tags my email, Flicker tags my images. I use the same tags and have to repeat them for every webapplication that I use, I'm too lazy for this. Is there any remedy for this ? ...
I am creating a blogging functionality to my website running on a cms. My requirement is this: When a person has written an article, he must automatically provided with 'suggested tags'. These words must come from the article. How can I implement this functionality? I thought some ideas. Like: Suggest words which are the longest. Us...
I need a way to tag photos in a Delphi desktop application the way Facebook does it. That includes some way to easily add the tags over the people, and then hovering the mouse over the person in the photo to show the tag. The two suggestions in the answer given to: "Delphi Components for Face Identification and Tagging" don't solve th...
The search feature on the site seems pretty awful. Are there any external sites that do a better job of categorizing projects with tags, etc? Or maybe I'm just not using GitHub correctly? ...
What is the actual procedure for attaching multiple tags to a particular content in a project development. What is this tagging all about??? I need to create a tag cloud for my project in .NET using c#. Help me out as a beginner for basic tagging concept. ...
I'm working on a PHP project with solid unit-tests coverage. I've noticed, that last time, I'm making very tricky manipulations with unit-tests Command-Line Test Runner' --filter command. Here is this command's explanation from official documentation: --filter Only runs tests whose name matches the given pattern. The ...
I have a need to have a tag-like system that operates very similarly to how Live Mail does email addresses. For those who don't know, Live Mail provides a textbox in which you can enter email addresses. As you finish typing in an email address, Live Mail changes the address from being plain text into a div that has a border and has the ...
I read a lot about tagging in CakePHP but I can't find a "clean" way to save a Post and the Tags to this post. I have all which is necessary the Post Table, Model and Controller, the Tag table, Model and Controller and the posts_tags table. I created the HABTM Associations in the Post and the Tag Model. If I want to save a new post, I w...
Many sites offer some statistics like "The hottest topics in the last 24h". For example, Topix.com shows this in its section "News Trends". There, you can see the topics which have the fastest growing number of mentions. I want to compute such a "buzz" for a topic, too. How could I do this? The algorithm should weight the topics which a...
How has SO implemented the tagged search? Is it using Lucene or any other open-source search engine library for tagged searching? What is the best way to search document (PDF, XML, HTML, MS Word) or database? ...
Hi all I'm developing a script that extracts the messages from the message archive of a particular meetup.com group of which I'm a member - http://www.meetup.com/opencoffee/messages/archive/ The idea is to dynamically add these to a wordpress site and allow people to search messages, auto tag messages etc. The issue I have is how best...
I have the classic 3 table - entity, tag and entitytag - database structure. In order to find all entities tagged with certain tags I am using the following Linqtosql code: string[] myTags = {"tag1","tag2"}; var query = from m in entity where m.entitytag.Where(c => myTags.Contains(c.tag.TagName)).Count() == myTags.Count() ...
Hello! I've built a news site: - The articles are shown on the front page ordered by date. The newest one first. - The news are in the table "news" with the fields "id", "title", "text" and some other ones. - All articles are tagged with 1-5 relevant tags. - The tags are in the table "tags" with the fields "id", "tag", "article" and...
Hello! With your perfect help here I've already found out how to compute trending topics (standard score + floating average). My next problem: I have the terms (consisting of 1-3 words) in my database connected with the time they were mentioned. But the trending topics are always only 1-word terms since one part of a term is ALWAYS men...
When I bookmark http://dbpedia.org/About, del.icio.us suggests "xml" and "programming" as tags. How does it know that the URL relates to these topics? ...
Hi, I'm trying to get a Tag Cloud architecture working in NHibernate. public class Tag : Entity { public virtual int Id { get; set; } public virtual string Text { get; set; } } This table will map to a few entities in my schema so I don't want to add a collection to the Tag class for each association. I do however want to qu...