1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

A Lyrics site and Youtube Video optimization

Discussion in 'C#' started by kingofss, Feb 8, 2011.

  1. #1
    Hi All,
    SEMrush
    These days we are working on a lyrics site. I bought some databases from this forum. We decided to use on of them which has about 700k lyrics in it.

    It was sql so we converted it to access format. But now we have a problem.

    We wish to share the song's video links at Youtube. But it is nearly impossible to manuelly find the youtube link and write it to our database. I am curious that is there an automatic way to do that?

    Thanks
     
    kingofss, Feb 8, 2011 IP
    SEMrush
  2. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,681
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #2
    First of all, go back to using SQL; Access is rarely ever a suitable RDMS for anything other than a couple of users on a local network.

    You could write a small application that uses the YouTube Data API (http://code.google.com/apis/youtube/getting_started.html) to search for videos but you would need to read the T&Cs as free services like this normally have a cap on the number of requests you can make and 700,000 may well exceed that.
     
    AstarothSolutions, Feb 8, 2011 IP