# Chdb for rust
Use clickhouse as library, based on `clickhouse local`
### Requirements:
You should have [libchdb](https://github.com/metrico/libchdb#package-installation)
### Install
```
cargo add chdb
```
or add to Cargo.toml
```
chdb = "0.1"
```
Powered by:
- ClickHouse - https://clickhouse.com/
- Chdb - https://github.com/chdb-io/chdb
- libchdb - https://github.com/metrico/libchdb
## Usage
```rust
use chdb::{flag, option, options::QueryOption, Query};
let result = Query::new("SELECT number FROM numbers(10)")
.option(option!("format", "TSVWithNames"))
.option(flag!("verbose"))
.exec()
.unwrap();
println!("Elapsed: {}", result.elapsed);
println!("Rows: {}", result.rows_read);
println!("Bytes: {}", result.bytes_read);
println!("Result:\n{}", result.to_string().unwrap());
```
Otputs:
```
SELECT number FROM numbers(10)
Elapsed: 0.007413874
Rows: 10
Bytes: 80
Result:
number
0
1
2
3
4
5
6
7
8
9
```
## Options and flags
List of available options [here](OPTIONS.md)