Questions tagged [sqlite]

The tag has no usage guidance.

9 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
289 views

Does Safari browser history DB contain transition type?

The browser history of Safari is stored in ~/Library/Safari/History.db which is a regular SQLite database. For example, it can be viewed using SQLite Browser or queried using Python. The database ...
3
votes
0answers
112 views

Extracting data out of an old app on iOS

I have an app from which I'd like to extract some data, it's no longer being updated and will stop working as soon as I upgrade to iOS 11 due to sun setting of 32 bit support. The app contains two ...
2
votes
0answers
27 views

Any solution for a DBMS App on iPhone?

I have been trying to find an application to create a database (preferably sqlite) And I would like to create relational databases and query, however, I haven’t found any on the App Store to enable me ...
2
votes
0answers
271 views

Applescript - Reminders - Unbearably Slow

I wanted to write a script to "push" reminders back by an hour. I came up with this: tell application "Reminders" launch set c to current date set newtime to c + 3600 set the remind ...
1
vote
0answers
2k views

iOS 5 now encrypts my text message backup?

I've always used MesaSQLite to open the SQLite database that stores my iPhone's text messages. I've also used python's sqlite3 module to programmatically do some things with my text messages. After I ...
0
votes
0answers
58 views

Converting .accdb to sqlite on a mac - open to using terminal or homebrew

How would you convert a Microsoft Access database .accdb to SQLite on a Mac? (High Sierra)
0
votes
0answers
190 views

AppleScript Database Events, SQL query

I'm discovering Database Events and I created a script to store data daily: tell application "Database Events" tell database "Stats" set theRecord to make new record with properties {name:...
0
votes
0answers
37 views

iCloud contains many hidden sensitive notes that I can't delete

When I delete notes from Notes.app, I expect them to be deleted. However, it's clear that iCloud is storing lots of old, deleted, confidential information, and I don't know how to get rid of it. I ...
0
votes
1answer
49 views

Pictures are stored but not displayed in Camera Roll

Well, I've been running low space for a long time and this led to a sudden disappearing of old photos (actually 5000 of them - the oldest ones) in camera roll. I don't know how how that worked - maybe ...