During the AWS re:Invent keynote, AWS announced the new database service Babelfish for Aurora PostgreSQL in Preview. The service is a fully-managed, PostgreSQL-compatible and ACID-compliant relational database engine that runs in the Amazon cloud and is open-source.

Babelfish for Aurora PostgreSQL is an SQL Server-compatible end-point for PostgreSQL, making the service PostgreSQL fluent in understanding communication from SQL Server applications (i.e., including understanding T-SQL and TDS communication protocol).

Matt Asay wrote in an AWS open-source blog post about Babelfish:

Babelfish enables PostgreSQL to understand database requests—both the command and the protocol—from applications written for Microsoft SQL Server without changing libraries, database schema, or SQL statements.

Thus with Babelfish for Aurora PostgreSQL, the company provides customers with an option to shift from SQL Server on-premise to Aurora PostgreSQL without switching database drivers or re-write application queries.

#devops