- 11
- 11 126
QuestDB
United States
Registrace 14. 11. 2020
QuestDB is the fastest open source time series database. It implements SQL and exposes a Postgres wire protocol, a high-performance REST API and supports ingestion with InfluxDB line protocol.
Introduction to QuestDB
QuestDB is a high-speed, open-source database designed for time-series data. It offers superior ingestion and query speed combined with SQL.
QuestDB is well-suited for financial market data, as well as demanding IoT workloads with high cardinality data.
We achieve high performance by adopting a column-oriented storage model, parallelized vector execution, SIMD instructions, and low-latency techniques. The entire codebase is built from the ground up in Java (Zero-GC), C++ and Rust.
QuestDB is moving to open formats such as Parquet and Arrow. These formats decouple storage and compute. Moving the data to Parquet on object stores frees the data and ensures no vendor lock-in.
QuestDB is well-suited for financial market data, as well as demanding IoT workloads with high cardinality data.
We achieve high performance by adopting a column-oriented storage model, parallelized vector execution, SIMD instructions, and low-latency techniques. The entire codebase is built from the ground up in Java (Zero-GC), C++ and Rust.
QuestDB is moving to open formats such as Parquet and Arrow. These formats decouple storage and compute. Moving the data to Parquet on object stores frees the data and ensures no vendor lock-in.
zhlédnutí: 637
Video
SQL Window Functions for finance with QuestDB
zhlédnutí 172Před měsícem
Disclaimer: I use the terms "volume" and "total volume" incorrectly in this video. I should have said "traded value" and "total value" instead, but it is too late to change it now! The spirit still remains :) SQL Window Functions are a very powerful feature allowing you to aggregate results relative to the current row. In this video I show you how to use Window Functions in QuestDB to work with...
QuestDB Quickstart: Stream time-series data with real-time dashboards using Grafana
zhlédnutí 1,8KPřed rokem
We are introducing the QuestDB Quickstart, a public repository designed to start an end-to-end demo of the QuestDB time-series database. The Quickstart allows users to create a working instance of QuestDB, create tables, ingest batch and streaming data, and build a real-time dashboard that refresh every few seconds using Grafana. The repository can deploy in three different ways: Docker Compose...
Why your relational database sucks at time-series
zhlédnutí 1,9KPřed rokem
Relational databases are awesome, but they were not really designed to be used for low-latency and high volume ingestion of data where you keep track of changes over time. In this video, we'll tell you why your trustworthy relational database is probably not the best tool to use when you are dealing with time-series. I will also tell you a bit more about the use cases for time-series, and about...
QuestDB can ingest over a million events/second on a single instance. Come see us at Big Data London
zhlédnutí 189Před rokem
Part of the core team of QuestDB will be attending Big Data London. We welcome you to our booth at the expo area for any questions you might have. We will also be presenting about how QuestDB works, and how we are building it to make it perform at over 1 million records per second ingestion, while running sub second queries on the same instance. Registration is free. More info at bigdataldn.com...
Time Series with Python - QuestDB official Python client just released
zhlédnutí 1,2KPřed 2 lety
Time-series data is everywhere, and python is the choice of many developers and data scientist to deal with time-series analytics. You can use the Postgres wire protocol to query data using, for example, psycopg2. But when it comes to ingesting data, it is better to use the ILP protocol. Until now, using ILP from Python would imply dealing with sockets, which is not ideal. We are excited to ann...
QuestDB Code Contributions from 2019 to 2022
zhlédnutí 202Před 2 lety
QuestDB is an open-source SQL database designed to process time-series data, faster. Our approach comes from low-latency trading; QuestDB’s stack is engineered from scratch, is without garbage colletion, and dependency-free. QuestDB GitHub: github.com/questdb/questdb Tool for visualization: Gource
Real-time analytics and anomaly detection with Apache Kafka, Apache Flink, Grafana & QuestDB
zhlédnutí 2,4KPřed 2 lety
How does a time-series database fit into your real-time streaming analytics projects? How do you integrate it with the tools you are already using? In this video, we show you a demo in which we ingest temperature and status data from 100 sensors using Apache Kafka, then we detect anomalies in real-time with Apache Flink, and we store the results in QuestDB for further analytics and to power a r...
Time-series Database for Developers: QuestDB
zhlédnutí 1,8KPřed 2 lety
QuestDB is the fastest open-source time-series database. In this video, Javier Ramirez, our developer advocate, will tell you why developers and businesses should care about QuestDB. Get started with QuestDB at github.com/questdb/questdb, learn more at questdb.io/docs, play with our demo at demo.questdb.io, or follow us at questdb 00:00 Intro 00:31 SQL for analytics over time-series...
QuestDB Community Meetup with TQS Integrations
zhlédnutí 583Před 2 lety
QuestDB is a high-performance open-source database designed for time series data. github.com/questdb/questdb 03:18 Community Show&Tell by Holger Amort, Senior Data Scientist at TQS Integration 43:03 InfluxDB Line Protocol Performance Optimization Slides: drive.google.com/file/d/1akAk7-tsLuhFosohK_k8BlSY5GpYYeYI/view?usp=sharing
QuestDB Community Meetup with Yahoo and BIBA
zhlédnutí 305Před 2 lety
This webinar includes a presentation from Jon Bratseth (Yahoo) and Shan Desai (BIBA) about their use case with QuestDB. Then, CTO Vlad Ilyushchenko goes through clustering. QuestDB is an open-source SQL database designed to process time-series data, faster. Our approach comes from low-latency trading; QuestDB’s stack is engineered from scratch without garbage collection and is dependency-free. ...