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