PostgreSQL Interface for Google Spanner

#1

Post by brunoluiz » Sat, Jul 02, 2022, 7:00 AM UTC

PostgreSQL Interface for Google Spanner
cloud.google.com

Re: PostgreSQL Interface for Google Spanner

#2

Post by londons_explore » Sun, Jul 03, 2022, 7:18 AM UTC

It's disappointing that each database can only talk one SQL dialect.

That means every application that accessed the database will have to use the same, and any migration will be a lot of work.

Re: PostgreSQL Interface for Google Spanner

#3

Post by ranguna » Sun, Jul 03, 2022, 10:12 AM UTC

If you want to know the actual compatibility list first, instead of marketing speak, check out this link: https://cloud.google.com/spanner/docs/reference/postgresql/o...

Spoiler: no stored procedures or triggers, amongst other stuff.

Re: PostgreSQL Interface for Google Spanner

#4

Post by paulryanrogers » Sun, Jul 03, 2022, 4:43 PM UTC

londons_explore wrote: post #2

It's disappointing that each database can only talk one SQL dialect. That means every application that accessed the database will have to use the same, and any migration will be a lot of work.

Sad there are so many dialects. Ideally each would converge on standard SQL and the standard would adopt enhancements as they become widespread. Much like vender prefixing in CSS.

Then one wouldn't need bespoke features except temporarily or where they are truly necessary for the business.

Re: PostgreSQL Interface for Google Spanner

#5

Post by Tostino » Wed, Jul 06, 2022, 4:51 AM UTC

londons_explore wrote: post #2

It's disappointing that each database can only talk one SQL dialect. That means every application that accessed the database will have to use the same, and any migration will be a lot of work.

One potential way forward is what AWS is trying with their Babblefish project: https://babelfishpg.org/

If this proves successful, there could be other implementations for other vendor dbms dialects.