@pezzo/knex-clickhouse-dialect v1.3.0

Knex ClickHouse dialect

ClickHouse dialect for Knex.js

Install

npm install @march_ts/knex-clickhouse-dialect

Usage

import knex from 'knex';
import clickhouse from '@march_ts/knex-clickhouse-dialect';

export default knex({
    client: clickhouse,
    connection: () => {
        return 'clickhouse://login:password@localhost:8123/db_name';
    },
    // optional migrations config
    migrations: {
        directory: 'migrations_clickhouse',
        disableTransactions: true,
        disableMigrationsListValidation: true,
    },
});

Migration

Currently the migration default enging is MergeTree. If you want to use other enging, you can use the table.engine function to change the enging.

Testing Compatibility

Enging Migration

MergeTree

• MergeTree
• ReplacingMergeTree,
• SummingMergeTree
• AggregatingMergeTree
• VersionedCollapsingMergeTree
• CollapsingMergeTree

Log

• TinyLog
• StripeLog
• Log

Others Enging

• Memory
• Distributed
• View, MaterializedView
• Dictionary
• File, URL
• Buffer
• Kafka, RabbitMQ
• ODBC, JDBC, MySQL, PostgreSQL, HDFS