Questions tagged [sqlite]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
23 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 ...
user avatar
  • 1,557
0 votes
0 answers
20 views

How to correlate Safari’s favicon in cache with URL

I’m trying to get the favicons for the websites I have visited in Safari. If we switch directories to ~/Library/Safari/Favicon Cache we can find a favicons.db SQLite database and a favicons directory ...
user avatar
  • 1,425
0 votes
0 answers
85 views

How do I link attachments up to messages in the Apple Messages chat.db?

I'm trying to export an entire chat conversation with one friend from a backup of my chat.db SQLite database. I deleted the thread, but realized that I had a backup that is a few months old. I do not ...
user avatar
0 votes
0 answers
47 views

Trying to restore deleted iMessage messages to the application

So I’ve spoken with apple support and it seems that the MacBooks get forwarded copies of the iMessages to the device. As such it stores them locally in the library messages and archive folder. All the ...
user avatar
0 votes
0 answers
29 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 ...
user avatar
0 votes
0 answers
69 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 ...
user avatar
  • 1
8 votes
1 answer
8k 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 ...
user avatar
  • 193
1 vote
1 answer
109 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 ...
user avatar
  • 193
0 votes
0 answers
25 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 ...
user avatar
1 vote
0 answers
191 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 ...
user avatar
  • 11
0 votes
0 answers
93 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 (...
user avatar
  • 1
0 votes
1 answer
738 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 ...
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 ...
user avatar
  • 101
2 votes
1 answer
985 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 ...
user avatar
1 vote
1 answer
262 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....
user avatar
  • 623
2 votes
2 answers
2k 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 ...
user avatar
  • 31
0 votes
3 answers
426 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 \"...
user avatar
2 votes
0 answers
48 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 ...
user avatar
0 votes
0 answers
54 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 ...
user avatar
3 votes
0 answers
307 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 ...
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 ...
user avatar
2 votes
1 answer
259 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 ...
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 ...
user avatar
  • 11
0 votes
1 answer
192 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.
user avatar
  • 147
5 votes
1 answer
4k 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 ...
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 "...
user avatar
3 votes
1 answer
967 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 ...
user avatar
  • 387
7 votes
0 answers
470 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 ...
user avatar
  • 71
0 votes
2 answers
570 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 ...
user avatar
  • 2,519
0 votes
1 answer
354 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 '...
user avatar
  • 1
3 votes
0 answers
1k 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 ...
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 ...
user avatar
1 vote
1 answer
490 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 ...
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 ?
user avatar
0 votes
1 answer
148 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 ...
user avatar
  • 19.3k
3 votes
1 answer
18k 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 ...
user avatar
  • 3,642
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 ...
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 ...
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 ...
user avatar
  • 21
1 vote
1 answer
443 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 ...
user avatar
  • 411
0 votes
4 answers
241 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 ...
user avatar
1 vote
2 answers
1k 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 ...
user avatar
  • 4,819
0 votes
1 answer
117 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/...
user avatar
  • 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?
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 ...
user avatar
25 votes
10 answers
27k 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.
user avatar
  • 26.9k