ROWID AND label = ( SELECT ROWID FROM ABMultiValueLabel WHERE value = '_$!!$_' ) ) AS phone_mobile, ( SELECT value FROM ABMultiValue WHERE property = 3 AND record_id = ABPerson. ROWID AND label = ( SELECT ROWID FROM ABMultiValueLabel WHERE value = '_$!!$_' ) ) AS phone_work, ( SELECT value FROM ABMultiValue WHERE property = 3 AND record_id = ABPerson. ModificationDate + STRFTIME ( '%s', ' 00:00:00' ), 'unixepoch', 'localtime' ) AS Modified, ( SELECT value FROM ABMultiValue WHERE property = 3 AND record_id = ABPerson. CreationDate + STRFTIME ( '%s', ' 00:00:00' ), 'unixepoch', 'localtime' ) AS Created, DATETIME ( ABPerson. Birthday + STRFTIME ( '%s', ' 00:00:00' ), 'unixepoch', 'localtime' ) AS Birthday, ABPerson. Department AS department, DATETIME ( ABPerson. Choosing the 'Execute SQL' tab, paste this into the 'SQL string' field: How can I work with Apple's database files directly?Īs an example, to manually access contact data, users should extract Libray/AddressBook/AddressBook.sqllitedb, and then open the extracted file with a SQLite viewer.

Reincubate isn’t affiliated with any of these products, and doesn’t receive compensation for mentioning them. It's our recommended tool for Windows, and it's free. DB Browser used to be named the SQLite Database Browser.

DB Browser for SQLite (free, macOS & Windows).

Base is one of our second-favourite SQLite tools for macOS, and is available as a direct download and App Store app. SQLiteFlow is our macOS SQLite tool of choice. Users might want to try any of these three applications: However, users wishing to extract data from these files will need a SQLite database client. IPhone Backup Extractor includes a built-in Plist editor, and its users are able to automatically export their data to PDF, HTML, VCard, ICAL, VCF or CSV formats for easy access.

These are often comprised of SQLite database (.

Some users may wish to directly manipulate the raw files stored in their backups using expert mode.

Sqlite expert mac