A beta release of a new ADBC driver for SingleStore is now available via dbc. If you have dbc 0.2.0 or newer installed, run dbc install singlestore --pre to try it out today.
The driver supports query execution, bulk ingestion (create, append, and replace modes), catalog metadata retrieval, prepared statements, and transactions. Documentation can be found at docs.adbc-drivers.org. This is a beta release, and more features are actively being developed, so stay tuned.
The driver was developed by SingleStore, is implemented in Go, and uses the MySQL wire protocol to connect. To get started, provide a connection URI using the Go MySQL Driver DSN format with a singlestore:// scheme:
singlestore://user:password@tcp(host:3306)/database
Bulk ingestion uses LOAD DATA LOCAL INFILE under the hood. The driver includes comprehensive type mappings between SingleStore and Arrow types, covering integers, floating-point numbers, decimals, temporal types (DATE, DATETIME, TIME, TIMESTAMP), strings, binary data, and JSON.
The ADBC Quickstarts have runnable examples demonstrating the SingleStore driver in C++, Go, Java, Python, R, and Rust.
Please submit bug reports and feature requests directly to the singlestore-adbc-connector repository. You can also start a Discussion on GitHub or join the Columnar Community Slack.