Author Archives: Torleif

MySQL tables for continent names, country names and their ISO-3166 codes

Posted on by
27

Here is a MySQL table containing continent names, country names and their ISO-3166 codes.

Needed one a while ago, but the ones I found were either kind of lacking or kind of old. So I made one myself by converting a datafile on Wikipedia into the format I wanted. Used some regular expressions and manual corrections. Later I also went through newsletters with Updates on ISO 3166. Hopefully I got it all right, and hopefully it can save you and others some time as well.

If you find any mistakes or updates I’ve missed, please let me know :)

Continue reading →

10 myths about introverts

Posted on by
5

For those who know me, I don’t think it would be a big surprise if I told them I am a bit of an introvert. I stumbled over a very interesting book review today on a book called The Introvert Advantage: How to Thrive in an Extrovert World, and it looks very interesting. I’ve already added it to my Amazon wish list and will probably buy it pretty soon :P

Continue reading →

Getting a GUI in Ubuntu Server

Posted on by
4

Wanted to try out Ubuntu Server, but with a GUI.

Continue reading →

PHP: What’s a valid JavaScript identifier (or function name)?

Posted on by
Reply

After another reply to a question I’ve had on StackOverflow for a while, I decided that I perhaps should add another level of security to my method of providing JSONP from PHP. The way I did it before, I didn’t do any checking on the provided callback. This means that someone could technically put whatever they wanted in there, including malicious code. So, therefore it might be a good idea to check if the callback, which should be a function name, actually is a valid function name. But,

Continue reading →

Rock solid weather device

Posted on by
Reply

Just thought I could share this brilliant weather device. I would think it’s highly accurate as well! Probably depends on where you install it though…

Continue reading →

SQL for listing all WordPress tags

Posted on by
3

When writing a post I sometimes find it difficult to choose what I should tag it with. I try reuse tags I already have to prevent a total mess, and sometimes I just don’t really remember what tags I have used so far. When writing a post in WordPress you can get a list of the most used ones, but once in a while I write a post on subject I haven’t written a lot about. So, instead of going to the Post Tags page and look through all the pages of tags, I decided to just connect to my blog database and run a query.

Continue reading →

Some speedy WordPress fixes

Posted on by
Reply

Used Page Speed for FireFox the other day to analyze my blog. Found a couple of issues and a couple were very simple to fix. If these will work for you, depends a bit on where your WordPress site is hosted and what your web server does already. So, be brave and analyze your own site. Look through the results and see if you can fix some of it without too much hassle :)

Continue reading →