SingleStoreDB is a distributed SQL database designed for real-time analytics, offering low latency streaming data ingestion, flexible indexing, strong analytical support for complex queries, separation of storage and compute, and stronger availability requirements than typical data warehouses. It has been used by large customers such as Uber, Pinterest, and Akamai, and has been rated as the top operational data warehouse in Gartner's survey of analytical databases since 2016. The database supports a rich set of indexing techniques to speed up different data access patterns, including shard keys, unique keys for deduplication, sort keys, full-text keys, geospatial keys, and zone maps. It also has strong high availability support to keep applications online in the face of hardware failures or management operations such as database upgrades and schema changes.