The Apache Arrow team is pleased to announce the 0.1.0 release of the Apache Arrow Flight SQL adapter for PostgreSQL.
Read [the blog post of this release](https://arrow.apache.org/blog/2023/09/13/flight-sql-postgresql-0.1.0-release/) about what's new in the release. ## What is Apache Arrow Flight SQL adapter for PostgreSQL? Apache Arrow Flight SQL adapter for PostgreSQL is a PostgreSQL extension that adds an [Apache Arrow Flight SQL](https://arrow.apache.org/docs/format/FlightSql.html) endpoint to PostgreSQL. Apache Arrow Flight SQL is a protocol to use [Apache Arrow format](https://arrow.apache.org/docs/format/Columnar.html) to interact with SQL databases. You can use Apache Arrow Flight SQL instead of [the PostgreSQL wire protocol](https://www.postgresql.org/docs/current/protocol.html) to interact with PostgreSQL by Apache Arrow Flight SQL adapter for PostgreSQL. Apache Arrow format is designed for fast typed table data exchange. If you want to get large data by `SELECT` or `INSERT`/`UPDATE` large data, Apache Arrow Flight SQL will be faster than the PostgreSQL wire protocol. See also [the overview document](https://arrow.apache.org/flight-sql-postgresql/0.1.0/overview.html). ## Release note The initial release! ### Improvements - Added support for literal `SELECT`/`INSERT`/`UPDATE`/`DELETE`. - Added support for prepared `SELECT`/`INSERT`/`UPDATE`/`DELETE`. - Added support for customizing the max number of record per record batch. - Added support for concurrent session. - Added support for session timeout. - Added support for `password`/`trust` authentications. - Added support for TLS. - Added support for `Int8`. - Added support for `Int16`/`smallint`. - Added support for `Int32`/`intger`. - Added support for `Int64`/`bigint`. - Added support for `UInt8`. - Added support for `UInt16`. - Added support for `UInt32`. - Added support for `UInt64`. - Added support for `Float`/`real`. - Added support for `Double`/`double precision`. - Added support for `String`/`text`/`varchar`. - Added support for `Binary`/`bytea`. - Added support for `Timestamp`/`timestamp without time zone`. - Added support for package of Debian GNU/Linux bookworm. - Added support for package of Ubuntu jammy. ## Install See [the install document](https://arrow.apache.org/flight-sql-postgresql/0.1.0/install.html) for details. ## Community Please report any feedback to the GitHub issues or mailing lists: * [GitHub](https://github.com/apache/arrow-flight-sql-postgresql/issues) * [Mailing list](https://arrow.apache.org/community/)
