1.0.0 • Published 5 years ago
clickhouse-ssh v1.0.0
clickhouse-ssh
connect clickhouse server over ssh tunnel.
API
.connect(sshConfig, chConfig)
sshConfig
should be an object according to thessh2
package. see options.chConfig
should be an object according to theclickhouse
package. see options- Returns a Object, containing a
client
from theclickhouse
package andclose
function.
Usage
Don't forget to close()
the tunnel connection when you're done with clickhouse.
(async () => {
const { client, close } = await require('clickhouse-ssh').connect({
host: '127.0.0.1',
port: 22,
username: 'user',
password: 'pass',
}, {
host: '127.0.0.1',
port: 8123,
auth: 'user:pass'
});
try {
const result = await client.querying('select 1 as c');
console.log(result);
} catch (e) {
console.log(e);
} finally {
close();
}
})();
REF
1.0.0
5 years ago