Backing up external hard drives on Apple Time Machine

Time Machine advertises itself as able to backup external hard drives, which is exactly what I need because I store all my raw pictures and video on an external hard drive. However, after plugging in my external, Time Machine never picked it up. Turns out that that external hard drive needs to be formatted as “Mac OS Extended (Journaled)”. I think I’d formatted it initially as NTFS.. i don’t remember. Sooo, luckily I have enough hard drive space to copy all the data from my external to my laptop, format the external, then copy everything back. It’s a little bit of a pain in the ass, but it’s all in the name of keeping these pictures and videos secure.

Friday Frankosh.0

I think I’m going to start with a weekly featured video cuz there’s a lot of stuff I want to share.  And for the next few weeks, I really want to showcase some of the random music I used to listen to on the radio.  In particular: Power102, El Paso’s #1 station for hip hop and r&b.  But honestly, back in the 90’s it was a lot different.  Por ejemplo:

This is the kinda music kids in El Paso grew up to in the 1990’s.  We had a little Facebook wall conversation among a few El Paso friends about how this song just brought back memories.  You know, school dances and such, lol.  Kristine told me that they played country music at her school in Beaumont, and that sure as hell wouldn’t fly at a school dance in El Paso.

Anyway, there’s a few more hits in Español which I will highlight in later weeks.

Can you turn this excel spreadsheet into a web application?

The phrase above basically sums up my existence at my job. There’s all sorts of important information that people have been storing in an Excel Spreadsheet and now, they have no easy way of extracting that data and/or connecting that data to other data sources.

In my continuing quest to figure out a better way to display a spreadsheet-like interface on a webpage, I found this article which was published a couple months ago.

http://roberto.open-lab.com/2010/01/18/javascript-grid-editor-i-want-to-be-excel/

It’s pretty much a roundup of all these different grid/spreadsheet javascript libraries which all have their pros and cons… I’m hoping to find something I can seriously use now. Something that will drastically reduce the load-time due to the number of DOM elements on these gigantic grids which my application is asked to handle.

Anyway, I’ll let you know what I come up with.

Nested Left Joins?!

I didn’t know you could write MySQL queries like this, but I just did:

SELECT it.*,a.name parent_primary_attribute,d.value primary_value FROM itemtype it
LEFT JOIN (primaryattribute pa
LEFT JOIN (itemtypeattribute_default d, itemtypeattribute a)
ON (pa.attribute_id=d.attribute_id AND pa.attribute_id=a.id)
) ON (it.parent_id=pa.type_id AND d.type_id=it.id)
WHERE it.id=’$id'”;