| import chdb | |
| # Get total rows | |
| total_rows = int(chdb.query(""" | |
| SELECT COUNT(*) | |
| FROM postgresql('192.168.3.135', 'sample_db', 'users', 'postgres', 'mysecretpassword') | |
| """).bytes().strip()) | |
| # Calculate rows per file | |
| rows_per_file = -(-total_rows // 10) # Ceiling division |
| payload: | |
| - DOMAIN-SUFFIX,tailscale.com | |
| - DOMAIN-KEYWORD,quickconnect | |
| - DOMAIN-SUFFIX,linrc.com | |
| - DOMAIN-SUFFIX,ts.net | |
| - PROCESS-NAME,tailscale | |
| - PROCESS-NAME,tailscaled | |
| - DOMAIN-KEYWORD,derp | |
| - DOMAIN-KEYWORD,tailscale | |
| - DOMAIN-SUFFIX,r2.cloudflarestorage.com |
| package main | |
| import ( | |
| "fmt" | |
| "os" | |
| "os/exec" | |
| "strings" | |
| ) | |
| func main() { |
This article show you the ultimate way to set up a transparent proxy on Linux using clash and iptables to bypass the GFW in China.
We use:
You can go to github gist to download all files mentioned in this article.
Based on ClickHouse Individual Contributor License Agreement v1.0
Thank you for your interest in chDB (https://github.com/chdb-io/chdb). In order to clarify the intellectual property license granted with Contributions from any person or entity, the author of chDB, Github User Name:[auxten] (https://github.com/auxten) ("Author")must have a Contributor License Agreement ("CLA") on file that has been signed, accepted or otherwise agreed to by each contributor, indicating agreement to the license terms below.
You accept and agree to the following terms and conditions for Your previous, present and future Contributions submitted to the Author. Except for the license granted herein to the Author and recipients of software distributed by the Author, You reserve all right, title, and interest in and to Your Contributions.
| #include <iostream> | |
| #include <fstream> | |
| #include <fcntl.h> | |
| #include <sys/stat.h> | |
| #include <unistd.h> | |
| #include <aws/core/Aws.h> | |
| #include <aws/s3/S3Client.h> | |
| #include <aws/s3/model/HeadObjectRequest.h> | |
| #include <aws/s3/model/GetObjectRequest.h> |
| import os | |
| import time | |
| import pandas as pd | |
| import pyarrow as pa | |
| import chdb | |
| import subprocess | |
| # file size 117MB | |
| data_path = '/home/Clickhouse/bench/hits_0.parquet' |
| import chdb | |
| data_path = "/home/Clickhouse/bench/uniswap_v2_trading_data/*.csv" | |
| small_data_path = "/home/Clickhouse/bench/uniswap_v2_trading_data/v2_trading_history_14025747.csv" | |
| print("Sample: ", | |
| chdb.query(f"select * from file('{data_path}', 'CSVWithNames') limit 10", "PrettyCompact").data()) | |
| print("Count: ", chdb.query(f"select count(*) from file('{data_path}', 'CSVWithNames')").data()) | |
| # ret = chdb.query( |
| [0.4361737529999914,0.05658163800001148,0.056433019999985845], | |
| [0.45631013700000267,0.06661815199998955,0.06499360399999432], | |
| [1.2878869360000067,0.12046150599996963,0.12141279399997984], | |
| [1.0351253719999818,0.19584039699998357,0.19377196099998173], | |
| [2.000329340999997,1.3100056389999963,1.3103087160000086], | |
| [1.8184413650000124,0.9605992319999928,0.9637660029999893], | |
| [0.4596347169999717,0.0655916599999955,0.06513699300001008], | |
| [0.45521096900000657,0.07589728199997126,0.07560694400001466], | |
| [1.4177663510000116,0.7329907230000003,0.7416720749999968], | |
| [3.5959058509999977,0.901890944999991,0.891994880000027], |
| alias ga='git add' | |
| alias gaa='git add --all' | |
| alias gap='git apply' | |
| alias gapa='git add --patch' | |
| alias gau='git add --update' | |
| alias gav='git add --verbose' | |
| alias gb='git branch' | |
| alias gbD='git branch -D' | |
| alias gba='git branch -a' | |
| alias gbd='git branch -d' |
