QuestDB: My time series data’s new best friend? πŸ“ˆ

My first tests with QuestDB on 10 years of home automation data (1.4 billion rows) are promising.

πŸ‘‰ Fast ingestion of parquet files (~1 hour on an old Intel NUC i5)

I have stored my data in parquet files, one per month, and imported it with a simple Python script. The import on my really old Intel NUC i5 took only about one hour. I’ve never been able to do this so quickly with any other database.

πŸ€” Btw.: I think storing data in #parquet files, or any other open table format, like Apache Iceberg, is one of the best choices to keep data. Because it’s independent of a database engine.

πŸ‘‰ Familiar SQL syntax. I experienced that QuestDB has a powerful SQL engine. I converted some Postgres SQL statements to QuestDB without big issues or changes. And I love SQL πŸ’š

πŸ‘‰ Great query response times – see image. Not a representative query, but still impressive speed.

πŸ‘‰ By using ZFS with compression the used disk space can be reduced to a good value.

Do you want to log your OPCUA data to QuestDB? I have added this option to the seven days ago.