flight-sql-client 0.1.0

A Rust client library for Arrow Flight SQL servers
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47

# flight-sql-client

A Rust client library for connecting to Arrow Flight SQL servers, built on top of ADBC drivers. Designed for use with [SwanLake](https://github.com/swanlake-io/swanlake), an Arrow Flight SQL server backed by DuckDB.

## Installation

Add this to your `Cargo.toml`:

```toml
[dependencies]
flight-sql-client = "0.1.0"
```

## Usage

Connect to a SwanLake server and execute a query:

```rust
use flight_sql_client::FlightSQLClient;

fn main() -> Result<(), Box<dyn std::error::Error>> {
    // Connect to the server
    let mut client = FlightSQLClient::connect("grpc://localhost:4214")?;

    // Execute a query
    let result = client.execute("SELECT 1 as col")?;
    println!("Total rows: {}", result.total_rows);

    // Execute an update
    let update_result = client.execute_update("CREATE TABLE test (id INTEGER)")?;
    println!("Rows affected: {:?}", update_result.rows_affected);

    Ok(())
}
```

## API Overview

- `FlightSQLClient`: Main client for executing queries and updates.
- `QueryResult`: Holds query results with record batches.
- `UpdateResult`: Holds update results with affected rows.

See the [SwanLake repository](https://github.com/swanlake-io/swanlake) for more examples and server setup.

## License

Licensed under the MIT License.