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

Don't let Google track your entire browsing history

By -
So Google has recently publicized the "+1" button for websites, which "competes" [1] with the Facebook [Like] button and the Twitter tweet button. This is a much more worrisome phenomenon than we give it credit for. Notice how the Facebook like button is instantly able to tell you which of your friends have liked that page? That is because Facebook is able to correlate your Facebook login with every page you visit. In order to see if any of your friends have liked that page, Facebook has to correlate the URL to your friend list. So even if you haven't clicked [Like], even if none of your friends have clicked [Like], just to be sure of that fact, Facebook will send the URL and your Facebook login to its servers, building up your entire browsing history. And now Google has done it. Twitter did it even before Facebook. I implore you, do not let these corporations track you everywhere you go. This will only end badly. Fortunately there is an easy fix. Add
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