Awesometoast.com

The multipurpose website of Aaron W. Herd

Posts by forgreatjustice

Make MySQL’s UNIX_TIMESTAMP() work in PostgreSQL

And FROM_UNIXTIME(), too!

Maybe you’re like me, and you’re migrating something from MySQL over to PostgreSQL. Maybe, like me, you’re swearing a great deal and experiencing high blood pressure, too.
(Or maybe not.)

I’ve seen numerous threads that just tell you how you can change all your code to use Postgres’s epoch_something_something_aint_nobody_got_time_fo_dat() function instead, but epic hero Janusz Slota has a better way. He shows … Keep reading »

Posted under: Fixing Stuff | No Comments »

iTunes 11: Restore track skipping with Repeat One turned on (OSX)

In iTunes 10, you could skip to the next/previous track when Repeat One was turned on. In 11, they assume that by “skip ahead”, you really mean “rewind this track”.

This really bothers some people.
Do not judge us, we have our reasons!

And here’s one way to fix it.

It took some work, but I finally came up with some … Keep reading »

Posted under: Fixing Stuff | 2 Comments »

Ever met a chronic insomniac?

Posted under: General Stuff | No Comments »

How to downgrade to iTunes 10.7 from iTunes 11 [OSX]

iTunes 11 is out, and most people seem to think it’s great. You and I are different, however. We hate it and we have our reasons. (Mine happens to be the inability to skip tracks while Repeat One is on. Yup, deal-breaker for me. UPDATE: Fixed that!) So let’s … Keep reading »

Posted under: Fixing Stuff | No Comments »

“Aaron” vs. “Erin”. (Usually?)

Though the other day, some guy managed to spell it Aeryn. Points for uniqueness!

Update: Since posting this, it has come to my attention that male Erins do, in fact, exist. However, in my part of the world, this is unheard of. Neither I, nor any other of the many Aarons I know, have ever met or even heard … Keep reading »

Posted under: General Stuff | No Comments »

Back when lecture made sense…

The full quote comes from Sebastian Thrun, the tenured Stanford Professor who left in order to begin exploring new teaching methods online.

During the era when universities were born, “the lecture was the most effective way to convey information. We had the industrialization, we had the invention of celluloid, of digital media, and, miraculously, professors today teach exactly the … Keep reading »

Posted under: General Stuff | No Comments »

Rockin’ the shades

Posted under: General Stuff | No Comments »

Anyone else have this problem?

Posted under: General Stuff | No Comments »

NOMS

Threw this together on Thanksgiving. Because it’s true.

Feel free to take and use. (Click for bigger version.)

Posted under: General Stuff | No Comments »

Productivity Technique: The Obsessive Calendar

So, among other productivity methods I’ve been trying this month, I also tried the Hipster PDA method, where essentially you use a small stack of index cards with a big clip to keep track of what you need to get done. (Optionally also with the Getting Things Done and 43 Folders philosophies.)

Most people react to this … Keep reading »

Posted under: General Stuff, Reviews | No Comments »
Page 1 of 512345