Case Study
Motion uses QuestDB for high-performance API analytics
Learn how fast-growing startup Motion uses QuestDB to monitor and handle their rapidly growing API usage.
- Superfast analytics
- Real-time, intensive API tracking
- Worry-free reliability
- High availability, security and scale.
- QuestDB OSS
- Built from open source.
- Avg ingested rows/sec
- 3M+
- Write speed vs InfluxDB
- 10x
- Compression ratio
- 6x
- Cloud up-time
- 99.99999%
Empowering AI productivity
Motion relies on QuestDB
Motion leverages QuestDB to enhance their AI-infused productivity tools, ensuring high performance and reliability for millions of users worldwide.
- Real-Time Analytics
- QuestDB powers real-time analytics, for immediate insights into user interactions. Data is kept clean via native out-of-order indexing and deduplication.
"QuestDB made it 10x easier to build a real-time time-series graph visualizer for our users."
SELECTTimestamp AS hour,SUM(count) AS requests_per_hourFROMAPI_usageWHEREtimestamp >= dateadd('d', -1, timestamp('d', now()))SAMPLE BY1H ALIGN TO CALENDAR
Internal and customer dashboards
Powerful SQL for dashboards
Track massive numbers of API calls and downsample the results based on periods of time. With QuestDB time-series native SQL extensions, Motion manages and downsamples these events using "SAMPLE BY".
Faster time-to-market
Familiar syntax, unfamiliar performance
Motion leverages the Postgres Wire Protocol to do transactional inserts, which interacts with the front end of their application in NodeJS. For the Motion team, the Posgres Wire Protocol offered a familiar and straightforward option to get started.
“We use QuestDB to track API usage. For time-series data, QuestDB is a no-brainer, and the client libraries are very intuitive.”
