A Memory: Elementary School Gifted Program

My elementary school had a program called “SOAR” which stood for Students On Active Research (whatever that means).

In second grade you were invited to go if you excelled enough. The program would bus you off to another location one day a week where they aggregated all the elementary schools in the area into the program. In all there were about 20-30 kids from each school.

So they send me to this thing and I can’t even remember everything we did, but I remember I thought what we were doing was too easy to really be for smart kids. The logical conclusion, then, was that it was actually for stupid kids and they had lied to me to make me feel special and willing to go.

I cried my eyes out over this. I was convinced that while they had removed the poor performers from class, the other kids were advancing unhindered by us. My parents and my teacher all tried to assure me that wasn’t the case, but for about a month I didn’t believe them.

A few years after I left elementary school I heard some minority parents accused the program of being racist (even though there were certainly minorities with me in the program). The parents yelled and screamed until they changed the program so that all kids were in the “smart” program.

New TV Series

I took a break from working yesterday to check out a few new shows for this fall… some are good, some bad, and some I’m not sure about yet.

Flash Forward (ABC / 60 min length / Thu @ 8PM EST) – This one comes from a book written over a decade ago and is about a worldwide simultaneous unconsciousness that lasts for 2 minutes and 17 seconds where everyone sees what they are doing roughly 6 months in the future. Overall I liked the first episode and think there is potential, though it does seem like ABC is trying to make this the “new” Lost (which ends next year). Definitely one of those things where the audience knows very little about what is going on with subtle clues and no shortage of cliffhangers. Also it has at least a few Lost actors playing parts, as well as (believe it or not) Seth Mcfarlane who plays an FBI agent. This is one that has gone into my Hulu queue and I would suggest others to check out.

Community (NBC / 30 min length / Thu @ 9:30PM EST) – This is Joel McHale’s delve into non-The Soup-related TV where he plays a disbarred lawyer attending community college in an attempt to get his old life back and ends up accidentally bringing together a group of misfits while he was trying to get into another student’s pants. The writing is actually really funny, though it mostly centers around McHale’s character’s narcissism and ability to talk his way out of (or into) anything he wants. McHale doesn’t have to pull the show completely by himself, though, as it does also have Chevy Chase playing a perverted old man who wants to be cool more than anything else. Overall it’s difficult to relate to the characters, but that may just be me. I don’t know if I see this series lasting long, but it is funny enough to enjoy while it does.

Modern Family (ABC / 30 min length / Wed @ 9PM EST) – This one caught me by surprise since I had heard little about it before clicking on the first episode in Hulu. It’s about three families connected by one of them being the biological father of members of the other two: a gay couple who just adopted a Vietnamese daughter; a husband and wife with three teenage-or-younger kids and a dad trying SO hard to be “cool”; and an old man (played by Ed O’Neill of Al from Married with Children fame) married to a Hispanic woman and mother as old as his children. I kept wanting to say “this show is dumb” but it really brought the funny. Rotating through focus on the three unique families at once keeps the show moving and not boring. As for the future of the show, I completely don’t know… it could really go either way depending if it catches on or not. I think it has the quality, but they need to make sure people know to watch it.

Cougar Town (ABC / 30 min length / Wed @ 9:30PM EST) – This one I had low expectations for and it didn’t really disappoint. This is Courtney Cox’s new show where she plays a recent divorcee in a town littered with 40+-something single women and young 20-something men with which to have sex. I gave the show a shot because it’s done by Bill Lawrence who also did Scrubs. I really liked how quirky Scrubs was (until it dragged on to long) so thought maybe despite a silly premise he could recapture that. It is certainly quirky, and actually has a good bit of funny, but none of that overcame the awkward and ridiculous premise to me. On the other hand, how long has Desperate Housewives been going on? This show could very well tap into that market and be very successful, it’s just not for a male edging out 30 I guess.

Glee (Fox / 60 min length / Wed @ 9PM EST) – Ok, I know, but hear me out. This one isn’t near as bad as I was expecting, though it does have me face-palming at times. It’s about a newly-formed Glee club at a High School that has nothing going for it except an internationally-competing cheerleading squad, and how the Glee club continues to better the school against all odds. One of the best parts about the show is the head of the cheerleading squad played by Jane Lynch, who you will know as Paula (the boss) from The 40 Year Old Virgin. The show is a heaping mess of dysfunction, unrequited love, high school drama (without being too terribly angsty), and, of course, musical numbers. It’s an oddly fun show, though I don’t see myself continuing to watch it. There are 4 episodes so far and at the end of each one I would say to myself “Ok, we can stop now” but then I’d watch the next one. Personally I think it’d be a lot better in a 30 minute time slot rather than a 60 minute one. Also they need to get rid of the main character’s wife because she simply brings TOO much dysfunction to the show (even faking a pregnancy). It’s another one where it can be difficult to relate to some of the characters, and I just don’t see it being strong enough to survive Fox’s axe.

So that’s what I’ve seen lately. Another one to look out for is V on ABC which is a reimagining of an 80’s show of the same name about a race of aliens who show up to Earth touting peace and harmony, and a group of people who don’t buy into that and form a resistance. It premieres on November 3 and may be an additional Lost replacement for ABC given what I’ve seen about it so far and that it has a number of Lost people playing parts in it. It also has the hot prostitute chick from Firefly/Serenity in it playing the main alien.

Fall TV

Just found this list of network season premiers. Here are the parts of the list I’m interested in:

  • 30 Rock (Season 4) October 15th NBC
  • American Dad (Season 5) September 27th FOX
  • Bones (Season 5) September 17th FOX
  • Dollhouse (Season 2) September 25th FOX
  • Family Guy (Season 8 ) September 27th FOX
  • Fringe (Season 2) September 17th FOX
  • House (Season 6) September 21st FOX
  • The Cleveland Show (Season 1) September 27th FOX
  • The Office (Season 6) September 17th NBC
  • The Simpsons (Season 21) September 27th FOX

Other than that, I look forward to Dexter’s Season 4 premier on Sept 27 on Showtime.

Make your list, set your DVRs, check your Hulu queue, whatever.

Backyard – Labor Day 2008/2009

I just took a couple pics of our new pinestraw mulch islands in the back. 20 bales of pinestraw made the trees look a lot better. When I uploaded the pics to Picasa, I noticed that last year Labor Day was when I really started working on the back yard. Up to that point, it was pretty crappy. So I thought I’d show two pics for comparison:

Labor Day 2008
Labor Day 2008

Labor Day 2009
Labor Day 2009

Pretty big changes back there within a year. I’m hoping by next year the grass situation will have been mostly corrected, but we’ll see.

I explain LEFT JOIN to a friend

A guy I know comes to me every now and then when he has PHP questions. He doesn’t do coding as a job, just for fun on side projects to learn new stuff. Well, the past couple days he was getting my help on how to best get data from his database in a usable format. I write him a quick query and he goes “Whoa, what is that LEFT JOIN part?” So, here was my response to him in helping him better understand databases and why we need JOINs.

So, we make databases to avoid duplicate information that spreadsheets create. For instance, if you had a group of persons and a group of things that the persons owned, a spreadsheet would need to have a person fully represented for each thing owned.

For example:

name | sex | age | thing | thing property | thing cost
Josh | male | 28 | couch | brown | $800
Josh | male | 28 | TV | large | $1300
Susie | female | 25 | car | white | $15000
Susie | female | 25 | shoes | Nike | $80

So that’s a spreadsheet… but see how the person is fully represented over and over again. This is a waste of space, so we split the person off into another table and they become represented by a number and a relationship to the other table. It’s a LOT more efficient. The person table would then look like:

id | name | sex | age
1 | Josh | male | 28
2 | Susie | female | 25

And in the table of things, 3 columns would be replaced by just the numbers 1 and 2 that represent Josh and Susie like this:

people_id | thing | thing property | thing cost
1 | couch | brown | $800
1 | TV | large | $1300
2 | car | white | $15000
2 | shoes | Nike | $80

However, when it comes time to USE the information, we have to again think about what’s efficient. Multiple queries is inefficient, and loading data into memory is relatively cheap (as long as the data isn’t insanely large, like millions of rows). So, we have two tables efficiently held in a database, but what we want to see is the data in spreadsheet form again.

That’s where JOIN comes in. There are a lot of different kinds of joins, but by far I use LEFT JOIN the most. Think of it like having one table, and then pushing information from another table into each of the first table’s rows.

So in the previous example, what we have is things, and each thing has an owner. The owner is a property of the thing. So we would LEFT JOIN the people table into the things table like this:

SELECT * FROM things LEFT JOIN people ON things.people_id = people.id;

That essentially makes our two tables look like the first spreadsheet. Capitalized words are SQL special words. When I’m telling it the relationship of the two tables (after the keyword ON), form is [table name].[column name]. If all columns have unique names between the two tables, you can leave off [table name], however sometimes it’s better to just do it just in case. Similarly, if you wanted only the person’s name and the cost of the item, instead of SELECT *, you could SELECT people.name, things.thing_cost FROM …

One important thing to realize here is that in a LEFT JOIN you’ll end up with as many rows as you started with in the first table. That’s why we started with the things table instead of the people table. If we did it the other way, we’d have only two rows even though we have four things. Also, if we have a person who didn’t have any things, he would not be in our joined table. On the other hand, if we had a thing that didn’t have an owner, those fields would be NULL after the join (remember, since we LEFT JOINed people to things, there will always be as many rows as there were in the things table).

There are ways around these various problems/implications with other joins… however, these are advanced database topics and even I have only used them in database classes (with few exceptions).

LEFT JOIN is a great tool to master. It opens the world of databases to you. Just always test your queries in phpmyadmin first so you know you got it right.

I could have taken it a step further and had a table of things, people, and a relation table mapping people to things, but that was outside the scope of his question.

Subscribe to RSS Feed Wanna be bored by my life?