Kakariko Village by ellebirdy23

Failure to Boot on a Mac, White Screen of Death...

Had a few friends who have run into a white screen on bootup for their Macs after dropping it or having a power failure.  Rather than have to send in for repair (time + money), a much easier fix is detailed at The Pabster's Notebook.
The basic idea is that the Hard Drive boot sector got corrupted, but the Mac continues to try to boot from it.  The system disc doesn't help because the OS doesn't try to boot from anything else unless the hard drive is first disconnected.
Once that...[More]

Freedom wants power.  Power wants purpose.  Purpose wants freedom.

그녀의 작은 섬 by 김홍집

The heart longs to move forward but does not understand.
The mind is all-knowing but does not think it can.

Just a bit background on why I bother - had a disappointing upgrade from the Samsung 64GB SSD that came with my Dell XPS M1330 to Intel's 320 80GB SSD.  The Samsung drive was already several years old, so I thought it'd be worth upgrading to a modest SSD - Intel seemed safe.  Turns out after running the drive for a while, I noticed programs tended to load rather slowly.  I had installed my Samsung drive to another computer and decided to start up the same programs in parallel - the Samsung drive was up to a quarter faster at times.  Definitely not very happy about that, considering it was several years older (did technology downgrade over the years???)

Anyways, for space reasons again, I went out to upgrade to another SSD.  This time to the Mushkin Chronos which is rated generally among the same speeds as the top performing drives currently, though much less expensive.  Fairly content with it so far.  It is definitely faster than the Intel at least and seems about the same speed as the older Samsung I had.

Here are the load times in seconds (run twice each for good measure):

Task Intel 320    Mushkin Chronos Bootup   25, 25 22, 25 Photoshop   5, 2 3, 2 Premiere   18, 6 10, 5 You'd think 3-4 years would be safe to just upgrade to any current product, but I'll definitely be benchmarking my upgrades in the future just to be sure.

The Time Machine by Klaus Badelt

Just spent all evening looking through EQ tutorials.  Fun stuff.

This one was most helpful imo: http://www.youtube.com/watch?v=ESVRCT28d5o

You really do need an analyzer to pick out the bad frequencies to cut.  I wish I knew this stuff sooner - would save me a lot of headaches trying to make my stuff sound cleaner.

Current song in experimentation is "Nightfall."  We'll see how clean I can make this next piece...

You spend your life solving the mazes around you... Sometimes, after finding yourself in the same maze yet again, you just want to break the walls down - but then others interpret it as your defeat.

Leave a footprint so large, no realizes it exists.

Had this whole script idea in my dream this morning.  It was like watching a live-action movie with really good effects. It even came with an ending credits song - recorded a bit of it, maybe will make it a full fledge song later one day.

=================================
An advanced society is led by one man (the leader) who seems to have invented a means for everything (free energy, robots, etc).  He himself seems immortal and omnipotent now from his own inventions.  His daughter - he turned into part machine so she does not grow old.  His company headquarters is actually a giant parked spaceship in the city.

One day, however,...[More]

Stop speculating and find the truth.

3 cans (18oz) of red bean paste.
2 cans (14oz) of condensed milk.
Equal water to all cans used.

Mix and stir until boiling.
Freeze for popsicles or serve as drink.

Picked up a new Optoma PK320 pocket projector after my first one (PK301) broke down after lending it out (colors all green). Maybe for the better - this new one is twice as strong so I don't even need to turn out the lights anymore.


In the future though, if you do borrow it from me, please be more careful with it.

Edit: After some usage, I have to say I prefer the older PK301.  The newer one, while brighter, actually is a little blurier (for when you have to project something of high detail).  It also tends to not detect the correct aspect ratio, forcing you to manually switch from 4:3 to 16:9 and vice versa if your video changes.

Two friends have known each other since childhood.  One has always been a bit weaker and slightly ill with an unknown virus.  The other friend makes the promise to one day find a cure to the other's condition and studies to become a doctor.

Twenty years later, the doctor gets close to understanding the nature of the illness and finding a cure.  Both are excited at the prospect, but as the cure is applied, the friend seems to gradually get weaker.  The doctor scrambles to figure out what went wrong, but each day that passes, the friend seems to slowly lose grasp on the world.  Eventually the friend becomes bedbound and the doctor caring daily for the friend.

Over time, the doctor notices that, although the friend is losing mental capacity, the friend seems physically fine.  In fact, as the friend becomes healthier, the friend becomes less mentally stable, as if gradually fading away.

The doctor...[More]

I don't jinx people.  I just predict their future.

You clamored for freedom, but what you really wanted was power. What good is freedom if you can't actually do anything?

Printing postcards, posters, buttons, bags, t-shirts, cups, etc, etc

     Just my reference on what I've gone with over the years.  Not necessarily the cheapest or the best quality but what best suites what I needed (maybe cheapest for that particular item or whatnot).
Postcards
GotPrint.net...[More]

Love, Midna - by ellebirdie23

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:

However, this returns a flat 5 records total, not per album.

Took me a bunch of playing around to finally come up with something like this:

So far this works but I'm not sure whether it's the most efficient way to go about it.  Any improvements are definitely welcome.  Hopefully this helps those of you also looking for the same solution but having trouble find it.