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

Setting coordinates in Phaser where the body and the sprite are offset from each other

By -
Image
If you're using Phaser with matter physics , sometimes you might need to set a body of a different size from your sprite. That's pretty easy, simply by setting the width and height of the body. But if your physics body is offset from where the sprite is, then one has to use the setOrigin method to fix this. This can be tricky. This diagram might help explain how origin is used, where 'visual' is the sprite, and 'body' is the physics hitbox: And finally, if you do some algebra to find the origin, you can use the following code: // SPDX-License-Identifier: Apache-2.0 const visualX = 150; const visualY = 150; const visualWidth = 120; const visualHeight = 120; const bodyX = 200; const bodyY = 200; const bodyWidth = 180; const bodyHeight = 180; const originX = (bodyX - visualX) / visualWidth + 0.5; const originY = (bodyY - visualY) / visualHeight + 0.5; const sprite = this.matter.add.sprite(bodyX, bodyY, '...
Read more

Windows Task Manager is lying to you, and I don't know how to make it stop

By -
Image
If you use Windows, you might be intimately familiar with Windows Task Manager, which has a performance tab that shows the utilization percentage of various hardware in your system. Today, we're looking at CPU utilization. It looks a bit like this: The problem is that the meaning of the word utilization is very tricky. There can be multiple meanings: At the current time, with the current settings, what fraction of time is it executing instructions vs lying idle? At any time, with the most optimum settings, this CPU could practically complete a number a instructions at a certain rate. What percentage of that rate is it currently working at? I think the Windows Task Manager is currently using definition #1 above. This is useful for a person to look at the graph and understand "is there a runaway process on my system that is pegging my CPU"? However, consider the alternate use-cases: I am trying to run a long-running program, am I getting my money's worth out of this CPU...
Read more