Skip to main content

Questions tagged [sqlite]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
39 views

Spotlights Store.db File

Long story short... We have a user whose Notes app bit the dust and they lost everything. Years of work and personal information. No backup either. When we do a search for the notes in Spotlight, ...
monaronyc's user avatar
1 vote
0 answers
61 views

iOS SQLite database name no longer 3d0d7e5fb2ce288813306e4d4636395e047a3d28?

Trying to extract the SQLite db from my iOS phone. Used IExplorer to download the directory Media/Library/SMS but could not find the expected file name 3d0d7e5fb2ce288813306e4d4636395e047a3d28. Has it ...
bezbiker's user avatar
1 vote
0 answers
131 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 ...
nostromo's user avatar
  • 197
4 votes
1 answer
1k 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? ...
Alexander's user avatar
  • 8,353
3 votes
2 answers
2k 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 ...
luckman212's user avatar
  • 3,243
0 votes
0 answers
262 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 ...
yeet_thiswheat's user avatar
0 votes
0 answers
177 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 ...
text's user avatar
  • 1
18 votes
4 answers
37k 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 ...
hrokr's user avatar
  • 293
1 vote
1 answer
239 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 ...
hrokr's user avatar
  • 293
0 votes
0 answers
94 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 ...
Becca's user avatar
  • 259
1 vote
0 answers
494 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 ...
SMc's user avatar
  • 11
0 votes
0 answers
225 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 (...
George's user avatar
  • 1
0 votes
1 answer
1k 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 ...
jaleya.quinne's user avatar
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 ...
LBogaardt's user avatar
  • 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 ...
user1197457's user avatar
1 vote
1 answer
414 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....
John D.'s user avatar
  • 715
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 ...
buzlink's user avatar
  • 31
0 votes
3 answers
518 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 \"...
Ben Robinson's user avatar
5 votes
1 answer
6k views

Error: unable to open database from Terminal

sqlite3 ~/Library/Mail/V6/MailData/Envelope\ Index vacuum; Error: unable to open database "/Users/Me/Library/Mail/V6/MailData/Envelope Index": unable to open database file This happened ...
Dylan_Larkin's user avatar
2 votes
0 answers
58 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 ...
user300961's user avatar
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 ...
a paid nerd's user avatar
3 votes
0 answers
383 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 ...
Andrew Lauer Barinov's user avatar
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 ...
Mohamed Shibo's user avatar
2 votes
1 answer
281 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 ...
David's user avatar
  • 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 ...
Mihai's user avatar
  • 11
0 votes
1 answer
260 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.
FooBar's user avatar
  • 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 ...
Ryan1729's user avatar
  • 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 "...
CaymanCarver's user avatar
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 ...
FotisK's user avatar
  • 397
7 votes
0 answers
547 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 ...
Markus's user avatar
  • 71
0 votes
2 answers
686 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 ...
Colas's user avatar
  • 2,971
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 '...
d-b's user avatar
  • 3,408
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 ...
rikb's user avatar
  • 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 ...
Walt Stoneburner's user avatar
1 vote
1 answer
511 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 ...
Brian McCutchon's user avatar
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 ?
Stanyslasse's user avatar
0 votes
1 answer
168 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 ...
TJ Luoma's user avatar
  • 20.7k
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 ...
d0g's user avatar
  • 4,002
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 ...
sehummel's user avatar
  • 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 ...
Yama's user avatar
  • 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 ...
Alex G.'s user avatar
  • 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 ...
Helium's user avatar
  • 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 ...
Douglas Michael's user avatar
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 ...
Joe's user avatar
  • 5,079
0 votes
1 answer
127 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/...
Eric3's user avatar
  • 203
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?
ignis's user avatar
  • 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 ...
alexpelan's user avatar
27 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.
sorin's user avatar
  • 30.2k