August 2022 Summaries

A new release introduces an algorithm for the SQL COPY statement, enhancing the ability to perform fast and efficient CSV imports for large and unsorted data files, streamlining the process of migrating substantial datasets from other databases to QuestDB. Additionally, the update includes several enhancements and bug fixes for the Influx line protocol, Core, and SQL engine, contributing to overall performance improvements and stability.

QuestDB, an open-source time-series database designed for high-demand workloads, offers ultra-low latency and high ingestion throughput with support for Parquet and SQL to maintain data portability and prevent vendor lock-in. A tutorial by Kovid Rathee outlines how to enhance security through Nginx Basic Authentication for the QuestDB open source, despite this method now being obsolete with the release of QuestDB 8.0.3, which allows direct configuration of Basic Auth. The tutorial emphasizes the significance of data security, especially for sensitive time-series data, and provides a step-by-step guide to setting up Nginx Basic Authentication as a quick solution for securing QuestDB's web console. The process involves installing QuestDB and Nginx, creating a username and password, modifying the Nginx configuration file, and ensuring redirected access through Nginx while blocking direct access to enhance security. Although Nginx Basic Authentication is a temporary measure, the tutorial suggests considering more robust solutions like LDAP, OAuth, or QuestDB Enterprise for long-term security needs.