Time-Series Data Visualization with Apache Superset and QuestDB
Blog post from QuestDB
QuestDB is an open-source time-series database designed for high-performance workloads, offering features like ultra-low latency, high ingestion throughput, and a multi-tier storage engine, while supporting Parquet and SQL for portability and AI readiness. A common application of time-series databases is in data visualization for business decisions, and this tutorial demonstrates how to connect QuestDB with Apache Superset, an open-source data exploration and visualization platform, to create dashboards. The process involves setting up QuestDB and Apache Superset using Docker, importing datasets on New York taxi rides and European energy consumption into QuestDB, and configuring the connection in Superset. Users can create datasets, construct charts, and build dashboards by selecting visualization types and defining data parameters. The tutorial further explores creating datasets from SQL statements and using the Mixed Chart type in Superset to visualize energy consumption data, encouraging users to explore Superset's capabilities and contribute to open-source projects.