#database-entity

Chat Application Database Design: Schema, Queries, and Scale

A working chat application database design in PostgreSQL, with the tables, foreign keys, and indexes that hold up. Covers keyset pagination, Redis caching, read receipts, conversation titles, and the order to fix things when the message table gets large.