September 26, 2024: PostgreSQL 17 Released!

Apache Arrow Flight SQL adapter for PostgreSQL 0.1.0

Posted on 2023-09-17 by Apache Arrow
Related Open Source

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 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 endpoint to PostgreSQL.

Apache Arrow Flight SQL is a protocol to use Apache Arrow format to interact with SQL databases. You can use Apache Arrow Flight SQL instead of the PostgreSQL wire protocol 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.

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 for details.

Community

Please report any feedback to the GitHub issues or mailing lists: