1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Feeding RSS into a database

Discussion in 'Black Hat SEO' started by squelsh, Apr 23, 2009.

  1. squelsh

    squelsh Regular Member

    Joined:
    Mar 19, 2009
    Messages:
    349
    Likes Received:
    170
    I guys,

    I came across a thread here a while back that mentioned this - it was an explanation on how to make money from adsense and it mentioned creating MYSQL databases from Google trends.

    Ive found some nice software for creating RSS feeds. I want to feed these into an online non-indexded database (ideally 100% private) and then use the database to monitor trends,not just from Google trends but that is a good example.

    I think this could be a good way of monitoring a niche and its trends, especially if you have several information sources and know how to create the rss feed properly.

    If someone can tell me how to feed the rss into a database that would be amazing! If it does turn out to a reasonably useful, I will gladly post any results back here. :)
     
  2. jimbobo2779

    jimbobo2779 Jr. VIP Jr. VIP Premium Member

    Joined:
    Sep 17, 2008
    Messages:
    3,239
    Likes Received:
    2,394
    Occupation:
    Software Engineer
    Location:
    UK
    Home Page:
    To be honest as you are asking you may not be proficient in a coding language so it would probably have to be a bought script, though I don't know of any that would do what you are looking at.

    Getting something like this coded could cost a little bit so it really depends on how much use you would get out of this?

    Jim
     
  3. trapmuzik

    trapmuzik Junior Member

    Joined:
    Mar 20, 2009
    Messages:
    192
    Likes Received:
    22
    should be pretty easy with php and MySQL. All you really need to do is setup a table(s) for the data you want to extract from the feed to store and use a feed parser like SimplePie to parse the feed and insert it into the database.
     
  4. sandchica

    sandchica Regular Member

    Joined:
    Sep 25, 2008
    Messages:
    223
    Likes Received:
    235
    I was wondering the same, do you think this is what you are looking for? If so, maybe you could teach me how to use it too.

    Code:
    http://snippets.dzone.com/posts/show/3534
     
  5. sandchica

    sandchica Regular Member

    Joined:
    Sep 25, 2008
    Messages:
    223
    Likes Received:
    235
    I found a copy of rss2mysql but I can't figure out how to put it up on rapidshare. If someone can pm me who knows how to upload to rapidshare I can give them a link to it from my own web server. I could also use a little help installing it if this will work.
     
  6. squelsh

    squelsh Regular Member

    Joined:
    Mar 19, 2009
    Messages:
    349
    Likes Received:
    170
    Hi Sandchica,

    Im taking a look at this now.. Not sure if ill be able to get it to work this way as I am away from my own computer, but as soon as I work it out I will let you know..

    Doesnt look too difficult so hopefully it will be exactly what Im after. :D
     
  7. sandchica

    sandchica Regular Member

    Joined:
    Sep 25, 2008
    Messages:
    223
    Likes Received:
    235
    Cool, I purchased the rss2mysql and emailed the owner. Told him what I wanted it to do. He replied that he would also be getting back to me. If I hear anything good, I'll let you know.
     
  8. Carepolice

    Carepolice Power Member

    Joined:
    Mar 25, 2009
    Messages:
    576
    Likes Received:
    618
    Location:
    ZonSidekick.com
    Any updates on this?