Skip to content

Instantly share code, notes, and snippets.

@den-crane
den-crane / gist:6eff375752a236a456e1b3dc2ca7db62
Last active May 25, 2020
Clickhouse example AggregatingMergeTree, (max, min, avg ) State / Merge
View gist:6eff375752a236a456e1b3dc2ca7db62
DROP TABLE IF EXISTS requests;
CREATE TABLE requests (
request_date Date,
request_time DateTime,
response_time Int,
request_uri String)
ENGINE = MergeTree(request_date, (request_time, request_uri), 8192);
@inkrement
inkrement / clickhousedump
Created Aug 19, 2017
dump all clickhouse databases and tables
View clickhousedump
#!/bin/bash
OUTDIR=.
while read -r db ; do
while read -r table ; do
if [ "$db" == "system" ]; then
echo "skip system db"
continue 2;
@denji
denji / golang-tls.md
Last active Jul 8, 2020 — forked from spikebike/client.go
Simple Golang HTTPS/TLS Examples
View golang-tls.md

Moved to git repository: https://github.com/denji/golang-tls

Generate private key (.key)
# Key considerations for algorithm "RSA" ≥ 2048-bit
openssl genrsa -out server.key 2048

# Key considerations for algorithm "ECDSA" ≥ secp384r1
# List ECDSA the supported curves (openssl ecparam -list_curves)
You can’t perform that action at this time.