Questions tagged [sqlite]
The sqlite tag has no usage guidance.
46
questions
0
votes
0
answers
39
views
Help recovering old iMessages MacBook Pro
I have an old MacBook pro. Like really old. It's running Sierra 10.12.6
Please understand I don't know anything about this, so if you explain how to use SQLite or terminal or anything more complex ...
1
vote
0
answers
94
views
(MACOS/SQLITE3/KEXT) Want to revoke my MacOS trust on installer (prompt again to allow permission adding kernel component) & dealing read-only error
What do you do when this happens (when trying to delete the entry in database)?
“Error: stepping, attempt to write a readonly database (8)”
My try (based on @lx07 2020 post: Revoke permission to run ...
- 53
4
votes
1
answer
677
views
Changing Notification Center preferences programatically or from the command line
(There's plenty of questions about toggling Do Not Disturb programmatically, this is different)
Is there a plist file or sqlite DB that can be modified to change these settings programmatically? ...
- 8,263
2
votes
2
answers
1k
views
How can I compile sqlite3 from source on macOS?
I'm trying to build a copy of sqlite3 from source on my M1 Mac Mini running macOS Monterey 12.4 (21F79). The reason I want to do this (instead of using a precompiled build or installing via Homebrew ...
- 2,683
0
votes
0
answers
192
views
How to export links (url's) or other data from specific iPhone chat?
I recently learned how to use sqlite3 in the command line to export a .csv of url's from my icloud_tabs.db
I would like to do something similar with a specific iPhone chat. I use Messages as storage ...
0
votes
0
answers
163
views
Where to find the unread message count in chat.db for messages.app
I'm trying to find the number of unread messages in messages.app. The number should match the number on the badge of the app.
I've approached this by accessing chat.db, a sqlite db which lists all ...
- 1
16
votes
3
answers
28k
views
How (specificially) do I read a chat.db file?
Like everyone else who uses Apple's Messages app, I have a chat.db file. I'd like to read the file but nothing seems to yeild the expected results.
Here is what I've tried so far:
The CLI approach of ...
- 273
1
vote
1
answer
230
views
Help in understanding a command line search of all sqlite files on os x device
I was listening to a Talk Python To Me podcast that had Simon Willison as the guest. Willison discussed two projects he is developing, Datasette and DogSheep Beta, both of which allow you pull in data ...
- 273
0
votes
0
answers
65
views
Finding encryption key for Apple Messages chat
I'm trying to back up some message transcripts, including photos. I found I the chat transcripts from ~/Library/Messages/ can be opened on another Mac, but the images don't load. I searched my local ...
- 249
1
vote
0
answers
426
views
Is there any way to recover overwritten notes on mac?
I pasted something on top of a note on my Mac that had some moderately important stuff, switched notes (which means no ctrl-z), and I'm trying to recover it. My first mistake is that I unfortunately ...
- 11
0
votes
0
answers
199
views
In the iPhone's messages list, where does the date come from?
This is maybe a weird question. In the iPhone's "Messages" app, the first view is a list of all the chats, sorted by the most recent messages in each chat. To the right of each chat entry is a date (...
- 1
0
votes
1
answer
992
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 ...
4
votes
0
answers
1k
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 ...
- 101
2
votes
1
answer
1k
views
Macos Kernel Extension whitelisting issues
Trying to whitelist a kernel extension for an agent I'm trying to install. I'm using Mojave as the client machine and Profile Manger on a Mac server I've set up. I can enroll the client machine fine ...
- 31
1
vote
1
answer
394
views
How do I extract and combine messages from Time Machine backups of ~/Library/Messages?
I have many backups that contain versions of ~/Library/Messages. Each one contains 3 files and a directory similar to this:
XYZ:Messages user$ tree -a -L 1
.
├── Attachments
├── chat....
- 673
2
votes
2
answers
4k
views
Is there a way to view/edit Outlook for Mac's SQLite database to edit the signature file?
I am looking to edit the file or reference that is used in the SQLite database that Outlook uses on the Mac. Instead of having to copy and paste an HTML signature in the Outlook program, I would like ...
- 31
0
votes
3
answers
506
views
Give local PHP Full Disk Access in Mojave
I have a PHP webpage running on the local apache installation. The page uses shell_exec to access the messages/chat.db via sqlite3.
shell_exec("sudo -u ben sqlite3 ~/Library/messages/chat.db \"...
- 153
2
votes
0
answers
54
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 ...
- 21
0
votes
0
answers
56
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 ...
- 501
3
votes
0
answers
369
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 ...
1
vote
1
answer
1k
views
Corrupted iOS backup - notes.sqlite is encrypted!
Well, one of my clients made an iTunes backup of her old iPhone right before she wipe and sell it. She never expected that the backup is corrupted till she got a new iPhone and tried to restore that ...
2
votes
1
answer
277
views
Console log is telling me that database is locked for many apps. How do I unlock?
I'm trying to diagnose a MacMini that is painfully slow to start up.
I already check the filesystem (fsck) and the disk (Disk Warrior).
I am running High Sierra.
My Mac is fine once it's up and ...
- 121
1
vote
1
answer
1k
views
How can I merge Notes from two Macbooks without using iCloud?
I have two laptops and both have different Notes that are useful to me.
Not wanting to share any such data with Apple, they are also not synced to iCloud.
So far, I found the path where they are ...
- 11
0
votes
1
answer
250
views
How to access iMessage library using Sequel Pro on macOS
I'd like to access my iMessages using Sequel Pro. I have been told that they are in a sqllite file.
- 157
5
votes
1
answer
5k
views
What format does the apple notes sqlite db date use?
I want to extract the note texts and modification dates from an sqlite notes database extracted from an iOS device backup. But I can't figure out how to convert the date format to a readable date ...
- 153
1
vote
1
answer
2k
views
"Segmentation fault: 11" when trying to vacuum Apple Mail index
Reading up on how to improve my suddenly-very-slow Mail app, I found the tip to rebuild the sqlite index:
sqlite3 ~/Library/Mail/V4/MailData/Envelope\ Index vacuum;
But I get an immediate "...
- 191
3
votes
1
answer
1k
views
Is there some way to automatically find and remove all the "broken referenced" in Apple's Photo App?
I like apple's Photo app but I am not willing to let it manage my photos library for many reasons (eg I want to manage and edit the same files from different applications such as Bridge but I also ...
- 397
7
votes
0
answers
519
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 ...
- 71
0
votes
2
answers
673
views
Force open a file with the UTF-8 encoding
I have a file that contains text. The file is not a text file, it is a SQL file.
I want to open this file with the UTF-8 encoding in order to copy and paste the texts. So far, I'm trying to do it ...
- 2,851
1
vote
1
answer
359
views
Contacts.app crashes on launch
My Contacts.app crashed on launch. In the crash report I found, among others, the following excerpt:
Application Specific Information:
*** Terminating app due to uncaught exception '...
- 3,268
3
votes
0
answers
2k
views
Using sqlite browser to extract OSX contacts [closed]
This is following up on this previous useful answer; I'd have left a comment there if i had the rep(: In case you have the same questions i did:
First, i had to rename AddressBook-v22.abcddb to end ...
- 137
1
vote
1
answer
4k
views
Resolving "There is a problem with your mailboxes." in El Capitan
I'm running into an identical problem with Mail on two separate systems, both starting immediately after upgrading from a long-working Yosemite to the new El Capitan and persisting through the latest ...
- 518
1
vote
1
answer
505
views
MacPorts not working after power outage during build (sqlite disk I/O error)
I was building packages in MacPorts on a Mac Mini when the power went out. Now anything I try to do in MacPorts (install, clean, selfupdate) results in the following error:
sqlite error: disk I/O ...
- 137
0
votes
1
answer
2k
views
Mac OS X Mavericks Contacts Database is a SQLite db, how can i open it with a SQLite App?
i have an Sqlite Browser App.
I would like to view and extract all Contacts of the Contacts App for further use in a FileMaker Pro file ...
How can i connect to this database and export its content ?
0
votes
1
answer
165
views
Show today’s anniversaries (if any) from contacts
I would like to be able to run a script which would look through my Contacts list and output the name (and, preferably, phone number) of anyone whose ‘Anniversary’ date matches today. (The script ...
- 20.5k
4
votes
1
answer
20k
views
Can I run an SQLite operation from Terminal?
When I download transactions in Quicken Essentials for Mac, my bank adds "DEBIT PURCHASE" and other junk to the Payee info.
Quicken has no ability to find and replace globally.
But I dug into the ...
- 3,872
3
votes
2
answers
8k
views
How to enable Sqlite on a Mac OS X Mavericks
I upgraded my Mac with OS X Mavericks last week. It appears to have taken away support for Sqlite -- not Sqlite3, but sqlite. I need that for a website I work on. I went to Sqlite's website, but ...
- 151
0
votes
1
answer
2k
views
SQLite Manager 4 : unable to open database file
I have recently purchased and installed the software SQLite Manager 4, now I am creating new SQLite3 database and whenever I try to create new table with 'xyz' name with any number of column, it gives ...
- 101
2
votes
2
answers
3k
views
Can the SQLite databases that store iOS mail be exploited to back up messages?
Being the technical dude of the family I'm confronted with the following problem:
An iPhone 3GS with iOS 3.1.2, the owner has a lot of old email messages stored on the device but has lost access to ...
- 21
1
vote
1
answer
446
views
Error while Compressing the Mail DB: file is encrypted or is not a database
I am trying to compress the Mail database by running the sqlite3 vacuum command. But I get the following error:
SQL Error: file is encrypted or is not a database
I was running Mac OS 10.6 and I ...
- 421
0
votes
4
answers
248
views
Mountain Lion - Does it allow different users to share database files using iCloud?
If a small business wanted to share a common database between all of its employees, is it possible to create a single iCloud account for a specific App rather than for all the iCloud related software ...
1
vote
2
answers
2k
views
editing a sqllite database from the command line within an iPad
I'm running a technical demo - it requires altering a SQLite database on an jailbroken iPad. At the moment I'm pulling the database off via SCP and altering it with a GUI I have lying around, (very ...
- 4,989
0
votes
1
answer
124
views
Apache module run under MacPorts gives SQLite error
I have an Apache module, compiled from source, which works just fine with the stock Apache 2.2 on Mac OS X 10.5 through 10.7. However, under the Apache 2.2.22 installed by MacPorts, running /opt/local/...
- 193
3
votes
2
answers
12k
views
How can I know whether MySQL, SQLite, PostgreSQL, etc. are installed on Mac OS X 10.7?
I'm running Mac OS X 10.7.
How can I know whether MySQL, SQLite, PostgreSQL, etc. are installed on the system?
- 183
1
vote
0
answers
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 ...
- 11
26
votes
10
answers
30k
views
SQLite frontend for OS X?
I am looking for a preferably free SQLite frontend to use under OS X.
Something similar to MySQL Workbench will do. Put separate suggestions in separate answers.
- 29.5k