Implementing messages cache in VK

Every day millions of people talk to each other through the VK social network.

How fast messages are uploaded and displayed is really important for us, and the local cache on SQLite helps us in that matter a lot.

From this talk, you'll learn:

• how we store every uploaded message for the longest possible amount of time;
• how such a complex entity as message is represented in database;
• how we quicken and optimize SQL queries.