Home / Companies / QuestDB / Blog / Post Details
Content Deep Dive

Realtime crypto tracker with QuestDB Kafka Connector

Blog post from QuestDB

Post Details
Company
Date Published
Author
Yitaek Hwang
Word Count
825
Language
English
Hacker News Points
-
Summary

QuestDB is a cutting-edge, open-source time-series database optimized for financial market data, offering robust ingestion throughput and SQL analytics. It is particularly well-suited for handling tick data and can be integrated with Kafka to analyze live trading activity for cryptocurrencies. A project was developed to track the prices of Bitcoin, Ethereum, and Chainlink using the public Coinbase API, with data being published to Kafka topics and stored in QuestDB via a Kafka Connect setup. The QuestDB Kafka connector utilizes the InfluxDB line protocol for efficient data ingestion and schema management. The project setup involves Docker for container management and Python scripts for data handling, allowing users to visualize data using QuestDB's UI or a REST API. The setup demonstrates how to leverage QuestDB and Kafka for real-time financial data analysis and historical trend evaluation, with further resources available for advanced visualization and configuration.