Apache Arrow Flight SQL adapter for PostgreSQL 0.1.0

From: Apache Arrow via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: Apache Arrow Flight SQL adapter for PostgreSQL 0.1.0
Date: 2023-09-17 19:33:47
Message-ID: 169497922793.3727332.5417515785416848565@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

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/)

Browse pgsql-announce by date

  From Date Subject
Next Message fish's dotNET via PostgreSQL Announce 2023-09-18 05:57:56 dbMigration .NET v16.4 released
Previous Message Gilles Darold via PostgreSQL Announce 2023-09-17 19:33:35 Credcheck version 2.2 released