数据库 - iOS客户端如何设计用于存储聊天记录的表？

Question

除了表之外其他的存储方式也可以，现在没有思路不知道该如何设计。

Answer 1

The sqlite files of QQ and WeChat are unencrypted, you can open them to see the table structure reference. General historical data is archived in sqlite, and the recent contact list with the last message is simply stored in plist.

Answer 2

Use files, one file corresponds to one chat object

Answer 3

Coredata, sqlite, files are all fine, it depends on what you use

Answer 4

It is recommended that you take a look at the SQLight structure of WeChat. One session is one table, and pictures, sounds, expressions are stored in files. Each record must have at least ID, message type, message body, sending time, from, to, etc.