Well, it’s been a while since I’ve posted here. I’ve been pretty busy with life and such. Besides that, I’m losing interest in the whole web development front altogether. I do have some side work coming up that may re-spark my php/MySQL interest however. I spend most of my day working with Coldfusion, C#, SQL Server, Java and a slew of other languages and they just don’t inspire me to do anything. Perhaps this side work will respark my interest in development altogether.

I did start to investigat Ruby though. More specifically; Ruby on Rails. I do have some schema issues with Ruby on Rails framework however and it’s making it kind of tricky to get into. Things like Ruby on Rails like table names to be plural (i.e. Artists, Albums, etc) where I’m use to the singular (Artist, Album). I suppose it makes more sense to use plural since a table contains a collection of things (plural). Furthermore (and I haven’t fully investiaged this aspect), Ruby on Rails expects unique IDs to have the same name for every table (with the exception of foreign keys… well, they’re not TRUE foreign keys in MySQL… unless you use InnoDB tables…). Personally, I find it more difficult to have any IDENTITY column in your database named ID.

SELECT
    AR.Name,
    AB.Title,
    T.Title
FROM    Artists     AR

JOIN    Albums      AB
ON      AB.Artist_ID = AR.ID

JOIN    Tracks      T
ON      T.Album_ID = AB.ID

I dunno, just seems like this statement would be easier to read if you could use

AR.ArtistID = AB.ArtistID

.

Well, it’s hot in the house and I’m growing impatient. That’s the problem with owning a 60 year old house… no central A/C (unless you put one in… which we have not). It’s probably close to 80° in the house while it’s a cool 64° outside :-\

• Tweet