Description
Describe the enhancement requested
There are plenty of ways to learn about FlightSQL [1] [2] [3] but it's harder to find out which databases support FlightSQL and how. We have the Powered By page for more general Arrow adoption but I wonder if it would be helpful if there was something specifically for FlightSQL. I think the same question could be asked for ADBC but that can be done in another ticket.
Here's a rough categorization and list I came up with after a bit of research:
via demo wrappers
- SQLite: https://github.com/apache/arrow/blob/release-7.0.0/cpp/src/arrow/flight/sql/example/sqlite_server.h, GitHub - voltrondata/sqlflite: An example Flight SQL Server implementation - with DuckDB and SQLite back-ends.
- DuckDB: GitHub - voltrondata/sqlflite: An example Flight SQL Server implementation - with DuckDB and SQLite back-ends.
- Apache Derby: arrow/java/flight/flight-sql/src/test/java/org/apache/arrow/flight/sql/example/FlightSqlExample.java at release-7.0.0 · apache/arrow · GitHub
via experimental extensions
Natively:
- Apache Doris: Connecting by Arrow Flight SQL Protocol - Apache Doris
- CnosBD: Arrow Flight SQL | CnosDB
- DataFusion: GitHub - datafusion-contrib/datafusion-flight-sql-server: DataFusion FlightSQL Server
- Deephaven: Connecting to a Deephaven Flight SQL server | Deephaven
- Denodo: Access using Flight SQL — Virtual DataPort Developer Guide 9.1
- Dremio: Develop Applications with Arrow Flight SQL | Dremio Documentation
- InfluxDB: Querying InfluxDB IOx Using the New Flight SQL Plugin for Grafana | InfluxData
- SpiceAI: FlightSQL | Spice.ai Cloud Documentation
- Theseus: Theseus Data Processing Engine | Voltron Data
Is this categorization fair and useful and is the list accurate/complete?
If there's agreement, I think the list could be maintained at https://arrow.apache.org/docs/format/FlightSql.html#arrow-flight-sql and pages like https://arrow.apache.org/adbc/current/driver/flight_sql.html could link to this list.
cc @lidavidm @zeroshade @ianmcook
PS: Do we need/want a FlightSQL label on GitHub?
Component(s)
Documentation, FlightRPC