Showing a Column as a UNIX Timestamp in MySQL

I often need to store a timestamp in the UVFood database. There are lots of things I need timestamps for – recording the time that a user account was made or a modification was made, for instance.

While MySQL has quite an assortment of date and time formats which it supports, I usually find it most convenient to store timestamps as an INT and just put the UNIX seconds since the epoch value in there. I don’t need to do funky searches on the timestamps, I just need to do simple comparisons.

A drawback is that sometimes when I’m working with the database by hand it’s annoying to see the timestamps as big numbers – sometimes it would be very helpful to see them as dates and times.

Fortunately there’s a MySQL function that helps with this problem. The “FROM_UNIXTIME()” function will interpret a numeric column’s value as a UNIX seconds-from-the-epoch value and show it as a date and timestamp.

Using it I can easily do things like:


SELECT URL, FROM_UNIXTIME(Timestamp) FROM AccessLog;

and see it as:


+---------------------------+--------------------------+
| URL | FROM_UNIXTIME(timestamp) |
+---------------------------+--------------------------+
| explore/users/94 | 2008-10-05 22:49:39 |
+---------------------------+--------------------------+

rather than


+---------------------------+------------+
| URL | timestamp |
+---------------------------+------------+
| explore/users/94 | 1223261379 |
+---------------------------+------------+

MacOS X DVDs – Versions and Saving a Little Money on Them

A brief discussion on a private mailing list I’m on reminded me that there might be some interest in this.

MacOS X Leopard has been out for a while, but there are still a lot of folks who haven’t upgraded to it.

The upgrade comes in two versions, the single user licensed one and the “family pack”.

The single user licensed version is as it says, licensed for use on a single Apple computer and lists for $129.99. The family pack is licensed for use for up to five machines in one household, and lists for $199, a pretty good deal for staying legal at less than the cost of two single user licenses. While you can buy the single user and family packs directly from Apple with no shipping fees, Amazon usually has a better deal. At the time I wrote this, they were charging $26 less than list for the single user edition and $44.51 less than list for the family pack, both with free shipping.

If you’re coming to it from the Windows world, you’ll find that Mac OS X Leopard is a pleasure to install. It requires no serial numbers or product activation. You won’t have to worry about matching the particular distribution to the particular CD key.

You should be forewarned that, in my experience, the restore DVD that comes with a computer will only work with that computer or class of computers. So if you have a MacBook restore DVD it likely will refuse to install on an iMac.

Amazon also has a pretty good deal on Leopard Server: $104.51 off the 10 user version (normal list price $499) and $168.46 off the unlimited user version (normal list price $999). Leopard Server does have a serial number and will detect multiple copies of itself running on the same network.

I don’t expect the next version of MacOS X (“Snow Leopard”) to be out for another 9 to 15 months. Snow Leopard is targeted at providing performance and stability rather than feature enhancements, and will only run on Intel machines. It should be a worthwhile upgrade (who doesn’t want performance and stability?) but I wouldn’t hold my breath waiting for it.

Working Through a Catalyst View Rendering Problem

I’ve been adding some belated email notifications to UVFood and in the process I ran into a frustrating problem: it wasn’t working at all.

The email notifications are for things like messages people send through the contact form, new user signups, errors. After those are working I’m finally adding welcome emails, confirmation emails and eventually optional weekly summaries of changes to users’ favorites.

Continue reading

Keeping Your Warcraft Addons Up To Date

wowmatrix.jpg

While I’m on the subject of World of Warcraft, I want to take a moment to mention the software I use to keep the add-ons I use up to date.

One of the most wonderful things about World of Warcraft is the extensible user interface. The UI is written in LUA and users can install add-ons which add new functionality to it or change existing functionality. Some people screens are entirely different from the stock World of Warcraft UI. I don’t change mine that much, but I do use quite a few convenience add-ons.

The set I use started out as “GrimPack” from “GrimPickle” – it’s a good set of add-ons which have been tested with one another (and in some cases fixed to work better together). You can download it from http://www.grimpickle.com

If you install it, the first time you start World of Warcraft afterwards, your screen will probably be a complete mess. If I have the time, someday I’ll write up a guide telling which modules to disable… I wouldn’t hold my breath waiting for that, though. Instead, I suggest turning off all of them and then gradually turning on the ones that look the most useful to you.

Once you’ve got a good set of add-ons working for you, you can use WoWMatrix to keep them up to date. WoWMatrix scans the add-ons you have installed and downloads updated copies of them when updates are released. It’s very useful and very easy to use. It runs under MacOS X, Linux and Windows, so all bases should be covered. And it’s free, with a couple of small ads embedded.

You can download WoWMatrix from http://www.wowmatrix.com.

World of Warcraft: Wrath of the Lich King Is Out on November 13th

"World of Warcraft: Wrath of the Lich King Expansion Pack"

Blizzard has announced that the new expansion pack, Wrath of the Lich King, will be released on November 13th, 2008.

The new expansion allows players to increase their level to level 80, including new abilities, talents and skills. Players can also create a new class of character, the “Death Knight”, which starts at level 55 and is a tanking class with magical abilities. The expansion also includes new PvP options including siege engines. It also introduces a new “achievements” system, where you get points for achieving certain milestones, like exploring areas or being the first to reach a level on your server.

There are two versions of the new expansion. The normal version is just that. The “collector’s edition” includes a 208 page book, a key to unlock a special baby frost wyrm pet, a DVD with developer interviews, the official soundtrack CD, a mousepad and two starter decks of cards including two cards only available in the collector’s edition. Both versions work on Windows and Macintosh.

You can order the "World of Warcraft: Wrath of the Lich King Expansion Pack" for $3 under the normal price, or "World of Warcraft: Wrath of the Lich King Collector’s Edition" for full price, with a limit of one per household. Both have free shipping and a price guarantee – you’ll get the best price that Amazon offers the product at between the time you place the order and the time it ships.

Wrath of the Lich King requires that you already have a copy of the original "World of Warcraft" and the first expansion, "World Of Warcraft Expansion: Burning Crusade". If you need both, you can save $10 by getting the "World of Warcraft Battlechest" which has both.

I know where my productivity is going on November 13th.

%d bloggers like this:
var _gaq = _gaq || []; var pluginUrl = '//www.google-analytics.com/plugins/ga/inpage_linkid.js'; _gaq.push(['_require', 'inpage_linkid', pluginUrl]); _gaq.push(['_setAccount', 'UA-239812-12']); _gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://' : 'http://') + 'stats.g.doubleclick.net/dc.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); })();