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