Domain-Specific Databases and Aviasales Mailings
summary
Describes building a domain-specific datastore and delivery pipeline for Aviasales email/SMS notifications: users subscribe with multi-predicate filters, search results enqueue as large (200–800 KB) JSON documents containing thousands of tickets, and SQL databases couldn’t handle the matching at scale. Presents a pragmatic, production-ready non‑SQL solution implemented in a few months to match subscriptions against incoming result queues and send notifications without over‑engineering.
AI-written summary · about
chapters (6)
- 0:00Introduction
- 10:11Problem and requirements
- 15:28Algorithms and data structures
- 26:50Optimizations and implementation
- 33:10Results and business impact
- 35:46Q&A
related talks
01h 05mDatabases: Bespoke Tailoring and Perfect Fit
26mPersonalizing User Content - The Power of a Vector & Search DB
43mDatabase in a SaaS application
47mExtendable by Design: Building Generative AI Apps with Postgres and Vector Storage and Azure AI
14mJourney of Building a Scalable, Domain-Agnostic Order Management System
47mState machines for product data from YDB and queues
41mHow to choose the right database for your application
51mEvolution of the PostgreSQL Storage for Listings at Avito