█ █ █ 26,692 Embeddable Music Videos Database + Artist Biographies [HIGH QUALITY] █ █
Music Videos Database
For sale is a database of over 26,692 embeddable music videos in 30 categories by 7,704 different artists. It also includes a biography on 5,124 (66%) of the artists. These are not the actual video files. Since the videos are scraped from Yahoo music, you simply use their embed code to show the video. This is probably my best database yet. You won't find anything like this on the web. It's hard to scrape this data, but with it you will be able to make some very potent sites.
What You Can Do With It
Features
As I said, if you don't like this schema or have different needs, I included a denormalization script to convert everything into one table.
If you would like your database in a form other than MySQL (I support CSV, CSV for excel, Open Document Spreadsheets, XML, YAML), just let me know.
Why I'm Not Offering a Script with the Database
If you're familiar with my other databases, you know that I usually include a script with each database. But I've decided not to do that here. The beauty of this database is that it can be used in a huge number of different ways, so that nobody really interferes with somebody else using the database. If I were to include a script, I would be encouraging you to use that one method, and eventually everyone using it would run each other into the
ground.
However, I am making sure that setting a script up around this database is as easy as possible. That's why I included a functions file. And of course, I am always here to answer any questions you have about using it!
Pricing
Price: $39
Remember, this is the only database of its kind!
Payment via PayPal only. PM me or post here to purchase.
Music Videos Database
For sale is a database of over 26,692 embeddable music videos in 30 categories by 7,704 different artists. It also includes a biography on 5,124 (66%) of the artists. These are not the actual video files. Since the videos are scraped from Yahoo music, you simply use their embed code to show the video. This is probably my best database yet. You won't find anything like this on the web. It's hard to scrape this data, but with it you will be able to make some very potent sites.
What You Can Do With It
- Make a content site for indexing power. Eli (Bluehatseo) recommends using databases just like this to quickly build vast content sites. You can easily create thousands of pages for google to index. Then you can put a link on every page, giving you immense indexing power. Combine this with my other databases for maximum potency.
- Make a video autoblog. Feed these videos, along with the artist biographies, to a blog for lots and lots of fresh content. If you choose not to spin the biographies, there is a field in the database for the author of the biography so you can properly cite him/her.
- Combine the database with a lyrics site. If you have (or want to have!) a lyrics site compiled from one of the many lyrics databases out there, this is a great addition. Add a video to any song that has a video associated with it. Give yourself a leg up on other run-of-the-mill lyrics sites.
- Know what YouTube videos to scrape or post on. If you are using any kind of blackhat YouTube method - comment spamming, or the like - you may want to target music videos for ringtone offers. Use this database to search for all the songs that have videos.
Features
- Massive. With 26,692 videos from 30 categories by 7,704 different artists, this is not just the ONLY embeddable music videos database on the web, but it's by far the biggest! It has everything from 1980's rap to modern pop, from all the biggest artists.
- Normalized and optimized. The database structure is normalized and optimized for fast, efficient querying.
- Includes "slugs" for URLs. If you don't know what slugs are, they are URL friendly strings. For instance, the slug for "30 Seconds To Mars" is "30SecondsToMars" and "American Hi-Fi" is "American-Hi-Fi." These can be a real pain to generate on-the-fly, so are included for both artist names and video titles. This way you can make your site the most SEO friendly possible by including artist names and video titles in your URLs.
- Videos are embeddable. This is definitely the best feature. Since they are embedded, and hosted at Yahoo, you know that they are safe and will last for a long time.
- Video thumbnails. Each video entry includes a thumbnail URL to the image hosted on Yahoo's site.
- Complete and comprehensive readme file. To help you set everything up as fast as possible, I included a very comprehensive and detailed readme file with the database.
- A functions.php file to show you how to query the database. To assist in getting your site up and running ASAP, there is a functions.php file filled with common functions for querying the database. Functions include getVideosByArtistId, simpleSearchVideosByTitle, getEmbedCode, and more.
- A denormalization script to put everything in one table. If you don't want your data to be normalized for some reason (maybe you need to plug it into a content generation script), and you want one table instead of three, just run this script! It takes less than 30 seconds and you will have everything in one table.
As I said, if you don't like this schema or have different needs, I included a denormalization script to convert everything into one table.
Code:
CREATE TABLE IF NOT EXISTS `artists` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`biography` text NOT NULL,
`bio_author` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `slug` (`slug`),
KEY `name` (`name`,`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7707 ;
CREATE TABLE IF NOT EXISTS `categories` (
`id` int(11) NOT NULL auto_increment,
`category` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
CREATE TABLE IF NOT EXISTS `videos` (
`id` int(11) NOT NULL auto_increment,
`artist_id` int(11) NOT NULL,
`category_id` int(11) NOT NULL,
`yahoo_id` varchar(30) NOT NULL,
`title` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
`thumb_url` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`),
KEY `artist_id` (`artist_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=26693 ;
Why I'm Not Offering a Script with the Database
If you're familiar with my other databases, you know that I usually include a script with each database. But I've decided not to do that here. The beauty of this database is that it can be used in a huge number of different ways, so that nobody really interferes with somebody else using the database. If I were to include a script, I would be encouraging you to use that one method, and eventually everyone using it would run each other into the
ground.
However, I am making sure that setting a script up around this database is as easy as possible. That's why I included a functions file. And of course, I am always here to answer any questions you have about using it!
Pricing
Price: $39
Remember, this is the only database of its kind!
Payment via PayPal only. PM me or post here to purchase.