Is Babelfish for PostgreSQL Possible on Google Cloud SQL?

[jfbaro]

Hi everyone,

Has anyone tried using Babelfish for PostgreSQL on Cloud SQL? From what I understand, it probably wouldn’t work since Babelfish requires some changes to PostgreSQL’s source code, which managed services like Cloud SQL don’t usually allow. But I’m curious, has anyone found a way to make it work or come across a Cloud SQL version that supports it?

We’re thinking it could help us migrate SQL Server-based applications more gradually. The idea would be to use Babelfish to get things running on PostgreSQL, then slowly update SQL Server-specific queries and procedures to ANSI SQL or PostgreSQL-native ones, eventually phasing out Babelfish completely.

Would love to hear if anyone has explored this or has thoughts on whether it’s possible. 😍

Thanks!

[mcbsalceda · Accepted solution]

Hi @jfbaro,

Babelfish requires custom changes to PostgreSQL's source code, which can be tricky with managed services like Cloud SQL, as they typically don’t allow that level of customization. There isn't currently a Cloud SQL version that supports Babelfish directly.

You can submit a feature request for Cloud SQL to support Babelfish, but keep in mind that there’s no guaranteed timeline or assurance that it will be implemented. 

Hope this helps.