RStudio

All integration guides. RStudio runs the R ADBC driver-manager example; it does not provide a separate Flight SQL database connector.

Install

Install R and RStudio Desktop. Follow the R package and shared driver installation for adbcdrivermanager, nanoarrow and a Flight SQL driver library matching R's OS and architecture. Start the server against a disposable backend.

Read, write and verify

Open this repository as the RStudio working directory. In the R Console, run:

source("examples/r/flight_sql.R")
main("grpc://localhost:8815", "/absolute/path/to/libadbc_driver_flightsql.so")

Replace the driver path with the library you installed. Sourcing defines the script's main function; calling it in the console runs the read/write checks.

The R script creates a unique table, inserts three rows through R ADBC, reads the values back (including NULL and an empty result), checks the aggregate and drops its fixture. Expect PASS R Flight SQL and printed session information. It uses autocommit and requires no shared sample table. Inspect the script for the complete statement and stream code.

Validation and limits

The November 3 RStudio transcript records native R Console execution of this harness, including writes and read-back. DBI/adbi and RStudio's Connections pane remain untested. The live run used the retained Enterprise-backed endpoint; it does not qualify a new public source fingerprint or test Flight client TLS/auth.