SQLite on iPhone

By -

It seems that many of the internal stores on the iPhone are actually SQLite databases.

The database that stores your text messages are located in /private/var/mobile/Library/SMS/sms.db and can be manipulated with any SQLite client. Similarly, Voicemail database is located at /private/var/mobile/Library/Voicemail/voicemail.db. That same folder also contains all your voicemail audio files, so you can back them up too, if you want.

Comments

Post a Comment

Popular posts from this blog

Laptop Surprises: Lenovo Yoga Slim 7i

By -
I recently bought a Lenovo Yoga Slim 7i (Model 14ITL05). I really like it. I am trying to write down everything that surprised me about the laptop in here. These are mostly things that did not understand about the machine from the product page on Lenovo when ordering. I'll start off with the pleasant surprises: There is some sort of radar sensor on the top on the screen, in the webcam area. When I come and sit on my chair in front of the laptop, it wakes the screen and then Windows Hello logs me in with face ID. This is great! There is a feature called Battery Conservation Mode . What it does is: it pauses charging the battery when it reaches somewhere between 55 and 60%. So you can get the full performance out the CPU without adding a lot of wear on the battery. It allows the CPU to go to full performance with all the wattage coming from the AC adapter without worrying about battery wear. However, I would like to know more about this, and exactly why the battery percent
Read more

Dark Fonts and Colors for light theme in VS 11

By -
Image
Update: The VS 2012 Color Theme editor has a lot more options and subsumes the functionality of this settings file. Check it out! ——————————————— Visual Studio 11 comes in two themes: dark and light. I like how the code looks in the dark theme (since it is easy on the eyes), but I like how the menus and toolbars look in the light theme (the buttons look sufficiently different from each other.) So if you want to use the colors and fonts of the dark theme with the light theme UI, you would think you could just export out the fonts, change the theme, and import them back in. However, this has the bizarre side effect of causing all the fonts to become bold. So I went into the theme file and manually changed all the BoldFont="Yes" invocations, and finally I have a theme I like. You can download this settings file if you like, it has only the Fonts and Colors, so it should not mess up any of your other settings. Download Visual Studio 11 Dark Fonts and colors settings fi
Read more

Trouble installing KB2881553

By -
EDIT: The error is back :( These instructions did not help. EDIT 2: The error is mysteriously gone :) I think Microsoft did some magic on their end. I am back on automatic updates! For a long time, I was having trouble installing KB2881553: Update for the English Input Personalization Dictionary on Windows 8.1. These are rough notes on how I resolved it . The problem: KB2881553 is supposed to be only offered on machines that have a touch keyboard with lots of usage. I think it was offered on my desktop accidentally, because I also use a tablet PC with touch on the same Microsoft Account. If you hide the update, it doesn't go away, because a new version of the file is offered on Windows Update within a few days, on the same KB number. The error code was 6B2. The solution: I was mostly guided by this very helpful post . The gist of the problem is that the previous update .msi cannot be found, so you have to convince Microsoft that either (i) your package is up to
Read more