--- title: "Google on Postgres as a database API standard." publication: "Postgres Weekly" issue: 461 published_at: "2022-06-29" canonical_url: "https://postgresweekly.com/issues/461" --- Plus a lot of other Postgres tools that aren't spanners. | #​461 — June 29, 2022 [Web Version](https://postgresweekly.com/issues/461) 🔧 If you're more into tools and extensions than news or tutorials, this is the issue for you. There have been a lot of interesting releases in the past couple of weeks, so head down to the bumper-sized **Code & Tools** section at the bottom of this issue.. :-) __ _Peter Cooper, your editor_ Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/ttj3vztwmqphfjdt0qkk.jpg)](https://cloud.google.com/blog/products/databases/postgresql-interface-for-spanner-now-ga) [Google Cloud Spanner's Postgres Interface Goes GA](https://cloud.google.com/blog/products/databases/postgresql-interface-for-spanner-now-ga) — It’s unusual to see a lot of smart people sing the praises of a proprietary cloud database but Google’s _Cloud Spanner_ has many such fans with its promises of high availability, scalability, and ACID compliance — and slotting into the _Postgres_ ecosystem is seen as an increasingly important factor. Notably, the author says: _“PostgreSQL is the new 'API' for operational databases,”_ – maybe we can expect more Postgres love from Google in future? Justin Makeig (Google Cloud) [Amazon Aurora Adds Postgres 14 Support](https://aws.amazon.com/about-aws/whats-new/2022/06/amazon-aurora-supports-postgresql-14/) — Amazon’s highly scalable, managed _Postgres-a-like-but-not-quite_ service gets bumped up to Postgres 14 standard with improved parallel querying, partitioned tables, logical replication, and vacuuming, as well as new features like multirange types. Here's a full [laundry list of what’s new](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraPostgreSQL.Updates.html#AuroraPostgreSQL.Updates.20180305.143X). Amazon Web Services [![\](https://copm.s3.amazonaws.com/34e0281d.png)](https://goteleport.com/how-it-works/?utm_campaign=eg&utm_medium=partner&utm_source=postgresweekly) [How Teleport Works: Basic Concepts](https://goteleport.com/how-it-works/?utm_campaign=eg&utm_medium=partner&utm_source=postgresweekly) — Teleport is the easiest, most secure way to access all your infrastructure. Teleport provides secure access to SSH or Windows servers, Windows desktops, Kubernetes clusters, databases (PostgreSQL, MongoDB, Redis and others) and web applications. [Learn more](https://goteleport.com/how-it-works/?utm_campaign=eg&utm_medium=partner&utm_source=postgresweekly). Teleport sponsor **QUICK BITS:** - **The** [State of PostgreSQL 2022 survey](https://timescale.typeform.com/state-of-pg-22) **closes this Thursday,** so if you haven't taken it yet, now's the time. - One of our favorite bloggers, Haki Benita, was [interviewed about his experiences with SQL](https://www.timescale.com/blog/sql-isnt-that-hard-if-you-have-the-freedom-to-experiment/) and even mentioned us – thank you, sir! [Debugging Deadlocks in Postgres](https://www.cybertec-postgresql.com/en/debugging-deadlocks-in-postgresql/) — Locks provide a fantastic way to protect data integrity until.. you run into a deadlock. Laurenz sets up a simple deadlock in order to show off some techniques for debugging them. Laurenz Albe [Postgres Indexes, Selectivity, and Statistics](https://www.crunchydata.com/blog/indexes-selectivity-and-statistics) — A look under the covers at some ways to tweak things when Postgres’s query planning isn’t quite up to par. Paul Ramsey [Postgres Upgrades Are Hard](https://andreas.scherbaum.la/blog/archives/1116-PostgreSQL-Upgrades-are-hard!.html) — If you, like some people [on Hacker News](https://news.ycombinator.com/item?id=31873063), are tempted to say _“upgrading is easy, just use [pg_upgrade](https://www.postgresql.org/docs/current/pgupgrade.html)”_, be sure to read these notes as surprises and edge cases abound. Andreas 'ads' Scherbaum [Using Cloudflare Tunnel and Access with Postgres](https://blog.cloudflare.com/cloudflare-tunnel-for-postgres/) — Cloudflare’s database team explains how they use Cloudflare’s _Tunnels_ service internally to improve the security of employee access to databases. McNeil and Ravichandran (Cloudflare) **🔧 Code and Tools:** [pg_squeeze: An Extension to Fix Table Bloat](https://www.cybertec-postgresql.com/en/products/pg_squeeze/) — While it’s not a replacement for vacuuming, it boasts being a handy extension to go a few steps further to gain even more space improvements on a table. CYBERTEC [Barman 3.0: Backup and Recovery Manager for Postgres](https://github.com/EnterpriseDB/barman/releases/tag/release%2F3.0.0) — An admin tool for performing remote (hot) backups and disaster recovery of Postgres servers. [Homepage.](https://pgbarman.org/) EDB [Check Out Our Free Postgres eBooks in the pganalyze Resources Library](https://pganalyze.com/resources/ebooks?utm_source=PostgresWeeklySecondary06292022) pganalyze sponsor [pgenv 1.3: Postgres Binary Manger](https://github.com/theory/pgenv) — Aims to make it simple to build and run different releases of Postgres, particularly for switching between them to test, etc. David E. Wheeler and Contributors [pg_ivm 1.1: IVM (Incremental View Maintenance) Extension](https://github.com/sraoss/pg_ivm/releases/tag/v1.1) — Incremental View Maintenance keeps materialized views up to date in a way where incremental changes are computed and applied rather than recomputing everything. pg_ivm provides a kind of ‘immediate maintenance’ where materialized views are updated immediately after a base table is modified. v1.1 adds Postgres 13 and aggregates support. SRA OSS, Inc. Japan [PGSpider 1.0: A Data Virtualization Engine for Distributed Big Data](https://github.com/pgspider/pgspider_ext) — Think clustering meets FDW at scale. Toshiba Corporation **OTHER RELEASES:** [Good Job 3.0](https://github.com/bensheldon/good_job) – Postgres-based, ActiveJob backend for Ruby on Rails. [InfluxDB FDW 1.2](https://github.com/pgspider/influxdb_fdw) – A foreign data wrapper to InfluxDB. [FerretDB 0.4](https://github.com/FerretDB/FerretDB) – A MongoDB-a-like but with a Postgres backend. [Magic 14.0](https://github.com/polterguy/magic) – Create a CRUD API wrapping your database 'in seconds.' [OnlineMigrations 0.5](https://github.com/fatkodima/online_migrations) – Catch unsafe Postgres migrations in development. [PGLoader 3.6.6](https://github.com/dimitri/pgloader) – `COPY`-powered data migration tool. [data-diff 0.2.1](https://github.com/datafold/data-diff) – Efficiently diff rows across two different databases. [rel 0.36](https://github.com/go-rel/rel) – Modern ORM-ish for Go(lang). [postgres-meta 0.39](https://github.com/supabase/postgres-meta) – RESTful API for managing Postgres. **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. Thanks! --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter.](https://postgresweekly.com/leave/*|UID|*)