Stores SMS from your phone in an sqlite database

Categories: actually useful

How many SMS can your mobile store? My Nokia 5300 can take about 800, then it gives up (I've admittedly never tried moving them all to some archive). Well, I got fed up to decide whether I should delete my old SMS or not. So I did what a geek is bound to do: I used gnokii to get the stuff off of my phone, and then spent an afternoon to parse the output, reassemble linked SMS (gnokii doesn't support them :( ) and store them in a SQLite-database for later usage :)

Tested with gnokii 0.6.28cvs (from 2009-04-24), SQLite 3.6.10 and Python 2.6

Download (8.42 Kbytes)