Blabberbox:Random blog-like posts from pftq.Share on Twitter

Love, Midna

January 11th, 2012 | Posted by pftq in Stuck in My Head | #
Love, Midna - by ellebirdie23
445 unique view(s)

Limiting Per Each Group in MySQL

January 9th, 2012 | Posted by pftq in Blabberbox | #
Not sure what this type of query is actually called.  The basic idea is you have multiple tables linked together, but you want to only grab n rows from Table C per iteration of each row in Table A.

A more illustrative explanation: Suppose you have a table listing 10 albums and a table listing 100 records.  You only want 5 records per each album.

As you might expect, Googling such a solution was pretty hard.  A common solution was:
Code:
SELECT r.* FROM albums as a
LEFT JOIN (
SELECT * FROM records LIMIT 5) r ON r.album_id=a.album_id
...[More]
1128 unique view(s)

Laruto's Lament

December 27th, 2011 | Posted by pftq in Stuck in My Head | #
Laruto's Lament by ellebirdy23
389 unique view(s)

Ignorance on MIDI - It is Not Sound

December 25th, 2011 | Posted by pftq in Blabberbox | #
There seems to be a trend going on lately that whatever was used back in the 90s must be dated and irrelevant today.  This isn't just on MIDI but more on that maybe some other time.

Some of the more frustrating comments I've heard these days is that somehow MIDI "sounds" dated or cheesy.  There is always so much surprise when someone finds out I use MIDI to record my music but worse is when they suggest *not* using MIDI as a way to improve the quality of the sound.

Now you can say - sure, there's always going to be misconception about various things, especially technology related.  The more troubling thing is this was being taught in a few university classes I took on music and computers.  Hard part is hearing the lecturer rant against MIDI as some old way of making music that sounds cheap to the ear, when really MIDI does not "sound" like anything at all.  It is merely a sequence of recorded notes in digital form (like digital...[More]
1071 unique view(s)

Toma mi Mano esta Noche

December 12th, 2011 | Posted by pftq in Stuck in My Head | #
418 unique view(s)

Sleeping Entity

November 28th, 2011 | Posted by pftq in Thought of the Day | #
Society is a collective entity yet to become self aware.
331 unique view(s)

Imperfect Genesis

November 13th, 2011 | Posted by pftq in Stories | #
In the beginning, the world was but a blank canvas, a fresh landscape for gods to shape as they saw fit.  After they added life and other final touches to their work, they decided to strip themselves of their power, join their creation as mortals, so that their emotions and imperfections do not allow them to destroy what they so cherished, perhaps as they once did in another time.  What they did not realize, however, was that the capacity for their destructive nature came not from their omnipotence but from their ability to reason.  Thus even without their power, the destruction they feared for their creation came to be nonetheless, only this time they would not remember it.
342 unique view(s)

Wanting Everything

October 6th, 2011 | Posted by pftq in Thought of the Day | #
You may feel like you want nothing from the world... but then you realize what you actually want is just unattainable.
360 unique view(s)

Growing Up

September 14th, 2011 | Posted by pftq in Thought of the Day | #
Sometimes you wish you didn't have to grow up.  But you do want to grow up.  You just don't want to become a different person.
320 unique view(s)

Meaning of Effect

August 19th, 2011 | Posted by pftq in Thought of the Day | #
Meaning is nothing without effect.
328 unique view(s)

Machine with No Confidence

August 18th, 2011 | Posted by pftq in Thought of the Day | #
Work like a machine, yet have no confidence. What good is that?
494 unique view(s)

Left Unsaid

August 15th, 2011 | Posted by pftq in Thought of the Day | #
So many things left unsaid... so many things written but left unread.
336 unique view(s)

What If I Can't

August 7th, 2011 | Posted by pftq in Stuck in My Head | #
360 unique view(s)

Waltz of Shadows

July 31st, 2011 | Posted by pftq in Stuck in My Head | #
Waltz of Shadows by TommyUlysesGrant
342 unique view(s)

Longing

July 19th, 2011 | Posted by pftq in Stuck in My Head | #
Longing by Stargenx
333 unique view(s)

Head in the Clouds

July 18th, 2011 | Posted by pftq in Thought of the Day | #
Some watch the clouds and say they're beautiful.
Others stick their heads in and can't see a thing.
338 unique view(s)

Speak For Yourself

July 5th, 2011 | Posted by pftq in Thought of the Day | #
Stop saying 'we' and say 'I'.  Speak for yourself before you speak for others.
332 unique view(s)

The Love of Marion

June 15th, 2011 | Posted by pftq in Stuck in My Head | #
The Love of Marion - by Bosa and Hania
349 unique view(s)

Greed and Evil

June 7th, 2011 | Posted by pftq in Thought of the Day | #
Greed is not evil.  The evil are just often greedy.
367 unique view(s)

Dreams of Flight

June 6th, 2011 | Posted by pftq in Thought of the Day | #
I woke in my dream and was surprised I could fly.
I woke up this morning and wondered why I couldn't.
339 unique view(s)