"The remedy is the experience ..."

So it's about that time when I've come to kick myself in the arse for taking on way too much ... way more than I can handle.

------------
QUICK BREAK, ALLEN SENT ME THE MOST AMAZING VIDEO OF A 3 YEAR OLD KID HAVING MAD BASKETBALL GAME ... CHECK IT OUT!
------------

Ok back to what I'm talking about before. So I have roughly 25 odds and ends to do for Tabulas (some ranging from "taking forever" to others that would require maybe 30 minutes of hacking to implement). I also have audiomatch to work on, and my latest site.

SingItWith.Us is still in a fledling state (uh, it's two days old!), but you can bet your butt I'm going to bust my butt to get it implemented a lot better (a quick plug to lyricstime.com, a recently (re-?)launched lyrics site which I was uber-impressed with.

Anyways, back to my lyrics site. I've barely gotten the core structure of the site running; search, adding, display, corrections all work. However, there's some work left to do with the way artists are maintained and the whole "albums" issue. There is currently NO album grouping at all ...

And search is weak. Actually, it's almost nonexistent. It's utilizing some built-in mySQL functions; ideally I'll write my own PHP to handle that later on.

Most of the management issues for the lyrics site are done; the submission form is pretty well automated so it checks for existing artists and songs and flags them if the script thinks the lyrics already exist.

However, the end-user portion is not done. There are a few key features I want to build in beyond the commenting/voting I've already done. Of course, I want to help promote discussion about individual songs ... so that's always useful, so that functionality needs to be built in.

But thinking 'beyond' the box, it has to be clear to anyone who follows what I'm doing with audiomatch and singitwithus. I want to eventually allow audiomatch creators to create XML feeds that link to singitwithus lyrics so they can easily integrate this into their website. Of course, this relies entirely on me being able to create a script that can somehow parse the massive database and run optimizations on the artists so that it can find similar matches ... and manage not to crash the server that audiomatch, tabulas, singitwithus, and about 160 other sites are on ;)

That will be ultimate tightness. But there is a huge hurdle I have to overcome with audiomatch - namely the ability to scan the database (upwards of 300,000 data entries now) and to 'correct' broken entries so the data remains as pure as possible. Due to the complete inability of people to use id3 tags, it will be difficult to create 100% perfect feeds ... but those users who do use IDv3 tags that are recognized by audiomatch will have an autolink to the lyrics; this should create an easy to use system.

And if I can find someone who can write a short javascript that can do this without having to deal with XML, that would be even better ;) If not, I can write a short little ditty to parse the XML file and create a nice clean file to include into your website.

Tomorrow I'm going to crack at the user's CP for siwu, as well as the main admin management for siwu so I can manage lyrics while I develop the site.

More tomorrow! :)