duckdb VS tsbs

Compare duckdb vs tsbs and see what are their differences.

duckdb

DuckDB is an in-process SQL OLAP Database Management System (by duckdb)

tsbs

Time Series Benchmark Suite, a tool for comparing and evaluating databases for time series data (by timescale)
Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
duckdb tsbs
51 76
15,710 1,198
10.4% 2.1%
10.0 1.9
4 days ago 7 days ago
C++ Go
MIT License MIT License
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

duckdb

Posts with mentions or reviews of duckdb. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-11-06.

tsbs

Posts with mentions or reviews of tsbs. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-08-17.
  • Fuzz Testing Is the Best Thing to Happen to Our Application Tests
    3 projects | news.ycombinator.com | 17 Aug 2023
    1. correctness: from small units tests to relatively complex integrations tests. they typically populate a test database and query it via various interfaces, such as REST or the Postgres protocol. we use Azure Pipelines to execute them - testing in MacoOS, Linux (both Intel and ARM) and Windows.

    2. performance: we tend to use the TSBS project for most of our performance testing and profiling. fun fact: we actually had to patch it as the vanilla TSBS was a bottleneck in some tests. Sadly, the PR with the improvements is still not merged: https://github.com/timescale/tsbs/pull/186

  • MongoDB Time Series Benchmark and Review
    2 projects | dev.to | 22 Mar 2023
    As usual, we use the industry standard Time Series Benchmark Suite (TSBS) as the benchmark tool. Unfortunately, TSBS upstream does not support MongoDB time series collections.
  • Show HN: QuestDB with Python, Pandas and SQL in a Jupyter notebook – no install
    3 projects | news.ycombinator.com | 21 Feb 2023
    yes correct - although Clickhouse is more of an OLAP database. Timescale is built on top of Postgres, while QuestDB is built from scratch with Postgres wire compatibility. You can run benchmarks on https://github.com/timescale/tsbs
    3 projects | news.ycombinator.com | 21 Feb 2023
  • Streaming data storage
    2 projects | /r/dataengineering | 24 Jan 2023
    According their benchmark it is really fast.
  • Ingesting with CrateDB
    2 projects | dev.to | 18 Jan 2023
    We used the nodeIngestBench for all the benchmarking. It is a multi-process Node.js script that runs high-performance ingest benchmarks on CrateDB. It uses a data model that was adapted from Timescale’s Time Series Benchmark Suite (TSBS). One thing that we want to make clear is that nodeIngestBench is a write benchmark. The data structure that it creates is unsuitable for any performance-indicative reading tests because of its high cardinality (due to random data) and no partitioning.
  • 4Bn rows/sec query benchmark: Clickhouse vs QuestDB vs Timescale
    2 projects | dev.to | 23 Jun 2022
    In order to make the benchmark easily reproducible, we're going to use TSBS benchmark utilities to generate the data. We'll be using so-called IoT use case:
  • DeWitt Clause, or Can You Benchmark %DATABASE% and Get Away With It
    21 projects | dev.to | 2 Jun 2022
    Also, some open-source vendors collaboratively maintain benchmarking suites such as Time Series Benchmark Suite to help choose the best tools for particular workloads.
  • 4Bn rows/SEC query benchmark: ClickHouse vs. QuestDB vs. Timescale
    2 projects | news.ycombinator.com | 1 Jun 2022
    Last year we released QuestDB 6.0 and achieved an ingestion rate of 1.4 million rows per second (per server). We compared those results to popular open source databases [1] and explained how we dealt with out of order ingestion under the hood while keeping the underlying storage model read-friendly. Since then, we focused our efforts on making queries faster, in particular filter queries with WHERE clauses. To do so, we once again decided to make things from scratch and built a JIT (Just-in-Time) compiler for SQL filters, with tons of low-level optimisations such as SIMD. We then parallelized the query execution to improve the execution time even further. In this blog post, we first look at some benchmarks against Clickhouse and TimescaleDB, before digging deeper in how this all works within QuestDB's storage model. Once again, we use the Time Series Benchmark Suite (TSBS) [2], developed by TimescaleDB,: it is an open source and reproducible benchmark.

    We'd love to get your feedback!

    [1]: https://news.ycombinator.com/item?id=27411307

    [2] https://github.com/timescale/tsbs

    2 projects | news.ycombinator.com | 1 Jun 2022
    This table schema: https://github.com/timescale/tsbs/blob/bcc00137d72d889e6059e...

    ...seems like a quite odd way to store time-series in ClickHouse. If I understood that code correctly (and I am really not sure), they partition their data by some tag value (the first one in a list?) instead of time, which is what timescaledb afaik partitions by. Of course that query filtering by timerange is going to be slower than usual. Whether that makes sense depends on your usecase.

What are some alternatives?

When comparing duckdb and tsbs you can also consider the following projects:

ClickHouse - ClickHouse® is a free analytics DBMS for big data

sqlite-worker - A simple, and persistent, SQLite database for Web and Workers.

datasette - An open source multi-tool for exploring and publishing data

octosql - OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

metabase-clickhouse-driver - ClickHouse database driver for the Metabase business intelligence front-end

QuestDB - An open source time-series database for fast ingest and SQL queries

arrow-datafusion - Apache Arrow DataFusion SQL Query Engine

LevelDB - LevelDB is a fast key-value storage library written at Google that provides an ordered mapping from string keys to string values.

duckdb-rs - Ergonomic bindings to duckdb for Rust

TimescaleDB - An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.

toydb - Distributed SQL database in Rust, written as a learning project