Touhou Music Database

I’ve created a new project, which I’ve dubbed the touhou music database.  Well, it doesn’t actually contain the raw MP3 files or anything, however.  I collected the track listings of over 1200 touhou music/remix albums and entered them into a database.  Given the name of a song, you can find what albums it can be found on.

Also, when you view a track’s page, I attempt a search of Youtube to see if the track can be found on Youtube, so you can immediately find music videos for most of the more popular songs!  Additionally, I have a page that shows the some of the most recent Touhou music videos from Youtube.  I love the Youtube data API.

Links: Main site Most recent videos

Job Hunting: A practical use for aggregated RSS feeds

A friend of mine was semi-recently laid off from his retail sales job, and I was wondering if I could use any of my knowledgeto help him in his search for jobs.  Then it hit me: RSS feeds!   I could create an RSS feed of the latest job postings in our area from the sites he checks for jobs.  This way he would save time in his search.  Since he mainly used craigslist and Washington WorkSource, I only needed to pull feeds from two sites.  To keep the RSS feeds relevant, I limited categories pulled.  Now there was one minor hitch with this idea.


My absence

Sorry for the lack of updates, I’ve been working on a pretty large project that has eaten much of my time.  Posting should be a little more regular in a couple of weeks, and I should plop in some new stuff soon.

Yahoo Pipes + CSV = Aggregated RSS

You can use Yahoo Pipes to create an aggregated RSS feed from a CSV file you maintain.  It’s fairly easy too, which is awesome.  For those who are not familiar with Yahoo Pipes, it’s a beta product by Yahoo that makes it easy to create simple mashups of content available on the Internet, read more about it on the Yahoo Pipes homepage if you so please.


Simple aggregated RSS Feed with Pipes

Answering a question that was posed at work regarding RSS feeds and Yahoo Pipes.

Q: How can I make an aggregated RSS feed in Pipes?

A: If you have a set of RSS feeds you’d like to include in an aggregated feed, simply drag the fetch feed module into the workspace and click the addition (plus) button to add more source URLs for the module.  Then send the output to the pipe output. When you name and save the pipe, you’ll be able to get it as an RSS feed, or in a multitude of other formats.

linker – Decoupled Link List Management

Occasionally, you’ll have a project where one of the last minute ideas is to add a manageable list of links to a webpage or series of webpages.  Nothing fancy, just a list of links that can be plopped into a layout.

Well, this little project allows you to quickly set up a web-based administration for simple link lists.  This isn’t a full blown manager, but simply a piece of a larger project.  Should readily integrate into existing solutions if you’re willing to do some code.  At any rate, you provide the links in an easy to use back-end and then can pull that list in a variety of formats by hitting index.php (or whatever you choose to actually pull the list, it’s fairly easy to change.)  Currently by default it can give you a raw html list, an rss feed, or the list in javascript form.  Simply unpack it, make sure the data folder is writeable, set the password in config.php and then hit admin.php and off you go.  A demo is available. It’s reset every half hour, and the password is ‘demo’.

I plan to release a version with some link generators for this in the coming weeks, until then you’ll need to hand-write the actual URLs to pull the lists.

Download Project – linker