# Help with a blog application - search for words and score them

**URL:** <https://www.ruby-forum.com/t/help-with-a-blog-application-search-for-words-and-score-them/134821>\
**Category:** Rails\
**Created:** [April 15, 2008, 1:01pm UTC](https://www.ruby-forum.com/t/help-with-a-blog-application-search-for-words-and-score-them/134821 "2008-04-15T13:01:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![R3R3R3](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/d6d6ee/32.png) [@R3R3R3](https://www.ruby-forum.com/u/R3R3R3)\
**Post date:** [April 15, 2008, 1:01pm UTC](https://www.ruby-forum.com/t/help-with-a-blog-application-search-for-words-and-score-them/134821/1 "2008-04-15T13:01:33Z")

</div>

Hi there everyone

I have created a blog using RoR, this being my 4th application that I  
have created. It’s all a learning curve and I am enjoying the  
framework much better that JSP.

I would like to add onto the application a few things.

Here is what I would like to do  
1 - enter the blog  
2 - once blog is entered, search the text for a list of pre-defined  
words, to be stored in a database (e.g. afraid, bored, curious,  
depressed, eager) and highlight them in a different colour (red)  
3 - attach a score to each word found from 1 to 10, that the user  
enters in a pane to the side of the blog  
4 - insert this number in a different colour (blue) after the word  
5 - count the frequency of the word over time for each user (for  
example, have a page that displays the words and their frequency - so  
that I can see how many times this week I have used the word bored)  
6 - be able to query the database externally for the number 5  
requirement

If anyone can give me some database and MVC help, it would be greatly  
appreciated.

Thanks in advance  
Rob
