Awesome ClickHouse › JavaScript/Typescript

apla/node-clickhouse

⭐ 215 JavaScript repository created 2016-07-23

The project "apla/node-clickhouse" is a Node.js driver for interacting with the ClickHouse database, a fast and scalable columnar database management system developed by Yandex. This driver provides a simple yet powerful interface to connect to ClickHouse servers, execute queries, and handle large datasets efficiently. It supports both streaming and promise-based query interfaces, although the promise interface is not recommended for large SELECT or INSERT operations due to memory and performance considerations. The driver allows users to configure connection options such as host, port, user credentials, protocol, and query-specific settings. It supports various data formats for input and output, including JSONCompact, CSV, and TSV, enabling flexible data handling and bulk data loading. The streaming interface is designed to handle large datasets by processing data row-by-row, which helps in managing memory usage effectively. Key features include the ability to send SQL queries, stream query results, insert large datasets efficiently, and customize query execution with options like readonly mode and query-specific settings. The driver also provides event-based handling for query execution, including error handling, metadata reception, and data streaming events. It supports advanced ClickHouse settings and permissions, making it suitable for complex query scenarios. The project includes comprehensive examples demonstrating how to select and insert large datasets, use streaming for data processing, and configure the driver for different use cases. It is designed to integrate seamlessly with Node.js applications, providing a robust tool for developers working with ClickHouse databases. Overall, "apla/node-clickhouse" is a well-documented and versatile Node.js client for ClickHouse, facilitating efficient database operations with a focus on performance and scalability.

https://github.com/apla/node-clickhouse

bulk-data-loadingclickhousecsvdatabase-driverevent-handlingjsoncompactnode.jsperformancequery-executionscalabilitysql-queriesstreamingtsv