Company
Date Published
Author
Nikola Chochkov
Word count
1256
Language
English
Hacker News points
None

Summary

The company, flowkey, is a leading app for learning to play the piano with over 10 million registered users in more than 100 countries. The company was launched in 2015 and has become one of the global leaders in its category. Flowkey's data analysts are well-versed in SQL and PostgreSQL, and they needed a scalable solution for categorical, time-series data analysis. They chose TimescaleDB, an open-source relational database that suits their needs perfectly. With TimescaleDB, they can analyze user behavioral data using Metabase or Jupyter/Rmarkedown Notebooks, drive rapid growth and experimentation, and improve their online piano lessons by understanding millions of user events daily. The company's deployment is self-hosted on machines, with automated data tiering that reduces disk space usage by 28%. They use compression to store JSONB fields, and have established a workflow for writing custom continuous aggregates for experiments. Flowkey recommends the Timescale documentation and Slack Community for advice and resources, and they are always keen to feature new community projects and stories on their blog.