Re: Babelfish for PostgreSQL

>
>
> There is a method of simulating SQL Server by using PostgreSQL. The
> extension is called "Babelfish": https://babelfishpg.org/
>
> However, this extension requires modifications to the PostgreSQL source
> and building the PostgreSQL with Babelfish modifications from source. While
> it is a rather seamless process and goes on without much trouble, it is
> still much more complicated than installing the RPM or DEB packages,
> depending on your Linux distro of choice. Is there any chance that the
> Babelfish modifications will be adopted in the PostgreSQL source proper?
> From my DBA point of view, I didn't find any differences in the
> functionality of the PostgreSQL database itself. Amazon RDS incorporates
> that modification and allows creating Aurora PostgreSQL database with the
> Babelfish extension from the menu.
>

Hi there, I'm currently part of the Babelfish Open Source team.

Regarding the installation process it works, but is far from being smooth
or ready to get OS packages
(there is, although, an ongoing work to get Docker images support in the
upcoming months).

But most importantly, we won't see this into core anytime soon -- or maybe,
we just won't see it as it is.
There is a patch for supporting protocol extensibility, but that requires
considerable rework on the Babelfish
tds and tsql extensions if moving forward.

There is a long thread discussing about this in the pgsql-hackers list:
https://www.postgresql.org/message-id/flat/CAGBW59d5SjLyJLt-jwNv%2BoP6esbD8SCB%3D%3D%3D11WVe5%3DdOHLQ5wQ%40mail.gmail.com

Even though there is intensive work from the AWS team to support and build
distributions for Babelfish, it is
still a great solution for migrating from SQL Server while keeping legacy
applications working.

Regards,

--
--
Emanuel Calvo -- 3manuek.com
OnGres Data Engineer / ViaDB Founder
CanalDBA BDFL -- Sumate al Slack canaldba.com!
curl -s https://keybase.io/3manuek/key.asc