AUTOGENERATING A BOOK SERIES FROM THREE YEARS OF IMESSAGES

Summary from the TLDR Web Dev newsletter

This author wanted to physically browse their iMessage history, which is difficult with Apple's interface. They found that iPhone backups contain an 'sms.db' SQLite database with messages. Using SQL queries, they were able to retrieve their messages. They then generated LaTeX code to create a paperback book from their messages.