USERDATA/data/com.google.android.apps.messaging/databases/bugle_db: RCS and Google messaging

right now, only the S21 is known¹. For Google Messages, com.google.android.apps.messaging/cache/image_manager_disk_cache/ folder may contain copies of pictures sent/received and/or available to the app in Photos that were merely “read” by the app (not sent or received).  Files are stored as .bin files. 

Query (Google Messages - bugle_db): 

SELECT 

datetime(parts.timestamp/1000,’unixepoch’) AS “Timestamp”, 

parts.content_type AS “Message Type”, 

conversations.name AS “Other Participant/Conversation Name”, 

participants.display_destination AS “Message Sender”, 

parts.text AS “Message”, 

CASE 

WHEN parts.file_size_bytes=-1 THEN ‘NA’ 

ELSE parts.file_size_bytes 

END AS “File Size (bytes)”, 

parts.local_cache_path AS “Path To Attachment” 

FROM 

parts 

JOIN messages ON messages._id=parts.message_id 

JOIN participants ON participants._id=messages.sender_id 

JOIN conversations ON conversations._id=parts.conversation_id 

ORDER BY “Timestamp” ASC 

Reference:

[1] https://for585.com/s21 - RCS Messages