Grimm's weblog

Set list:

Heysatan
Glosoli
Ny batteri
Vid Spilum Endalaust
Hoppipolla
Med blodnasir
Festival
Fljotavik
Untitled 6 (E-bow)
Inní Mér Syngur Vitlesingur
Saeglopur
Untitled 8 (Popplagid)
Illgresi
Gobbledigook

The iPhone stores it's SMS message history in an SQLite3 DB file located in the following directory:

/private/var/mobile/Library/SMS/sms.db

Once you have grabbed the sms.db file, you can open it with your favourite SQLite3 management program (I endorse Sqliteman), and can then proceed to query your data to your hearts content.

Here are some fun queries to try:
(Note: In some of these queries I'm using % LIKE wildcard for matching because some numbers get +1 prepended to them in the phone book)

View all of your messages:
select * from message order by date;

Tally up how many messages you've exchanged with each person, and order the list by the message count:
select * from (select count(address) as count, address from message group by group_id) order by count desc;

View full message thread with specific person:
select * from message where address like "%4165551234" order by date asc

How many messages you sent someone:
select count(*) from message where address like "%4165551234" and association_id = 0

And how many they sent back:
select count(*) from message where address like "%4165551234" and association_id != 0

Tally total messages from each area code:

select substr(address,-10,3) as areacode, sum(count) as total from (select count(address) as count, address from message group by group_id) where areacode group by areacode order by count desc;

And just for fun, here is a graph generated from this data showing which area code sent me the most messages:

1) Go to this directory: /System/Library/TextInput/
2) Rename the sub directory TextInput_en.bundle to TextInput_en.backup

So the current ruling party just dismantled parliament to waste money and time on a new election based on their speculation that they might get more votes this time around.

Seriously? Can we make a new rule that says if you just quit your fucking job as Prime Minister you can't run for re-election for the same job again?

Not much, but its a start : )