Redshift for instance is still using Postgres 8 wire protocol

psanford · on Dec 15, 2020

Redshift is definitely not abandoned. AWS just announced a bunch of improvements and new features at re:invent in the last 2 weeks[0].

Its not obvious to me why supporting a newer wire format would be a high priority for AWS. I think I would rather they work on things like native JSON/semi-structured data support[1] than a new wire format.

[0]: https://aws.amazon.com/redshift/whats-new/ [1]: https://aws.amazon.com/about-aws/whats-new/2020/12/amazon-re...

Androider · on Dec 16, 2020

Amazon didn't touch Redshift for years and years, until suddenly Snowflake became a thing and then they remembered they had Redshift.

scarface74 · on Dec 16, 2020

Redshift has constantly been improved. One of Amazon’s major initiatives was to get off of Oracle and improving Redshift was a major part of that initiative.

Tostino · on Dec 15, 2020

You will eventually run into issues when client interfaces start to drop support for old versions of the wire format to simplify their codebase.

trumpeta · on Dec 16, 2020

This is already the case, sqlx has to now add specific support for Redshift, its not enough ti use the postgres driver as is