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,
    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?

    kingofss, Feb 8, 2011 IP
  2. AstarothSolutions

    AstarothSolutions Peon

    Likes Received:
    Best Answers:
    Trophy Points:
    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