Benchmark Fastest Timeseries alternatives: ClickHouse Vs. InfluxDB Vs. Postgresql Vs. Parquet Vs. MongoDB Vs. DuckDB Vs Kdb+
- Run:
mkdir data
pip install requirements.txt
- Rename the file "properties-model.ini" to "properties.ini"
- Fill with your own credentials
The proposal of this work is to compare the speed in read/writing a specific amount of data, in this case, a dataset with 9 columns and 1.000.000 lines) calculating medium ingestion time betwenn seven diferent databases:
- ClickHouse
- InfluxDB
- Postgresql
- Parquet (in a S3 Minio Storage)
- DuckDB
- MongoDB
- Kdb+