MySQL is a relational database management system that you probably hear tons upon tons about but if you’re reading this, you probably aren’t sure how to even begin picking at it. After all, there aren’t even any vowels in that word – that’s overwhelming enough! Well, because I’m only barely a step ahead of you (or in some cases, probably a step behind), I can promise you that it’s really not as scary as it looks. With the foundation laid out by my previous posts, we should be able to tame this beast pretty smoothly. Today we will introduce ourselves and familiarize ourselves with some MySQL controls – not necessarily database controls like we discussed in my initial post, but we’re just going to see if we can get our database to give us some information using a few key phrases.

Just note that this WILL be a bit of a longer post – so feel free to read it in simple segments and take breaks in-between. We’ve got a lot to cover! Read more »

Just like with any design – whether graphical or in programming – you’ve really got to make yourself a roadmap to be successful. Databases aren’t that different. After all, just like with graphics design, they fall into information architecture. That is, the most successful databases are the ones which effectively organize your information.

In this post, I will discuss relationships between information, as well as how to effectively normalize your database so that each table avoids redundancy between each datum. Before we begun, let’s define a few key terms! Read more »

So, recently I’ve been learning a little bit at a time about SQL, and I felt that it’d be best to record my findings and really chew on them by writing about them. After all, I’m the kind of person who learns best by regurgitation. Thus, in this post I will explore (and regurgitate) some basic ideas and commands behind SQL and database language, but don’t expect to be programming a database at the end – that’ll come in time.

Understand that this is after a few hours of inquiry – so this post is going to be very, very basic and in a very dried-out format. I realize that my understanding of SQL is not especially in-depth just yet, but here I have compiled some readings I did, and general information that I found through various means. Feel free to correct me, and I will edit the post accordingly (and my notes!) Read more »

So, this week I began writing my first application with Cocoa in Objective C. To say the least, it was an experience.

I began first by checking out Apple’s Reference Library and Cocoa tutorials, found here, which gave me a decent understanding of how Objective-C in particular works and gave me a real preview of XCode. Truth be told, however, I’ve already learned a fairly decent amount of programing (having have started learning C at some point around 2005). So, to be fair, this tutorial is not for beginners; if you lack this amount of experience, however, This PDF tutorial (PDF linked) will get you started – it’s one I’m currently browsing, mostly because, while I have programming experience, I’m honestly no expert. Read more »

Generally speaking, WordPress doesn’t like to create two post pages. It takes getting the platform out of its comfort zone to force it to make it do something it doesn’t like.

Technically, my own site has two post pages. It displays the first few characters of a post (first one thousand characters, to be exact) and displays them on the home page, and then takes the rest of my posts (all content included) and displays it on my Blog page. However, to be really savvy, it just takes a little bit of PHP plus maybe a plugin, and your web site’s guests will never know the difference! Read more »