--- title: "Postgres 18 features to take note of" publication: "Postgres Weekly" issue: 600 published_at: "2025-05-15" canonical_url: "https://postgresweekly.com/issues/600" --- Plus Neon gets acquired. | #​600 — May 15, 2025 [Web Version](https://postgresweekly.com/issues/600) Together with [![Microsoft logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_280,h_60/e_make_transparent/co_white,e_outline:7/om9hjsmudy5lsvba59eb.png)](https://posetteconf.com/2025/) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/dfj5uleaimiufr8dpzej.jpg)](https://docs.postgrest.org/en/v13/) [PostgREST 13: A RESTful API for Postgres Databases](https://docs.postgrest.org/en/v13/) — A standalone web server that turns your Postgres database directly into a RESTful HTTP API. [v13.0](https://github.com/PostgREST/postgrest/releases/tag/v13.0.0) adds support for [spread to-many relationships](https://docs.postgrest.org/en/v13/references/api/resource_embedding.html#spread-to-many-relationships) and [automatic `tsvector` conversion](https://docs.postgrest.org/en/v13/references/api/tables_views.html#automatic-tsvector-conversion) allowing the use of `fts` on `text` and `json` types out of the box. Joe Nelson and Steve Chavez [Postgres 18 Beta is Out: 7 Features You Should Know About](https://neon.tech/blog/postgres-18-beta-is-out) — Last week’s big news was [the release of Postgres 18 Beta 1.](https://www.postgresql.org/about/news/postgresql-18-beta-1-released-3070/) Neon has put together a quick roundup of seven features to be aware of. Heikki Linnakangas (Neon) [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/049732f6.png)](https://posetteconf.com/2025/) [POSETTE 2025: Save the Date!](https://posetteconf.com/2025/) — POSETTE: An Event for Postgres, a free & virtual developer event, is less than a month away -- **June 10-12**. Learn from 45 experts from the PostgreSQL ecosystem. Choose from 42 unique talks via 4 livestreams with live chat on Discord. [Save the date](https://posetteconf.com/2025/). Microsoft sponsor **IN BRIEF:** - The [Neon](https://neon.tech/) serverless Postgres platform has [announced it's being acquired by Databricks.](https://neon.tech/blog/neon-and-databricks) Nothing is set to change for users in the near-term, however. - In other Postgres platform news, [Xata is 'relaunching'](https://xata.io/blog/xata-postgres-with-data-branching-and-pii-anonymization) as a new cloud-agnostic scaling-focused Postgres service boasting instant copy-on-write branches, and data anonymization. - 🎤 The [Postgres FM](https://postgres.fm/) podcast's latest episode tackles [▶️ the top ten dangerous Postgres related issues](https://postgres.fm/episodes/top-ten-dangerous-issues). - 📱 [Schema](https://tryschema.com/) is a new Postgres and MySQL database client for iOS. I think I'd struggle to work on a database on my phone, but it does look well designed. - 🇩🇪 PGConf.DE took place in Berlin last week and there are [a couple of](https://www.credativ.de/en/blog/events-en/postgresql-conference-germany-2025/) trip reports covering [what happened there.](https://www.cybertec-postgresql.com/en/vacuum-talk-at-pgconf-de-2025/) 📄 [Good Enough Ten-Second Sum Types for Postgres](https://duckrabbit.tech/articles/pg-epoch.html) Evan Silberman 📄 [Implementing Event Triggers Without Superuser Access](https://supabase.com/blog/event-triggers-wo-superuser) – This relates to Supabase’s [Supautils extension.](https://github.com/supabase/supautils) Steve Chavez 📄 [A Tale of Migrating from CockroachDB to Postgres](https://engineering.usemotion.com/migrating-to-postgres-3c93dff9c65d) Sean Callahan 📄 [Managing Bloat Using `pgstattuple` on _Azure Database for PostgreSQL Flexible Server_](https://techcommunity.microsoft.com/blog/adforpostgresql/managing-bloat-in-postgresql-using-pgstattuple-on-azure-database-for-postgresql-/4410449) Gayathri Paderla (Microsoft) 📄 [How to Upgrade Postgres 16 to 17 on Ubuntu 25.04](https://www.paulox.net/2025/05/07/upgrading-postgresql-from-version-16-to-17-on-ubuntu-25-04-plucky-puffin/) Paolo Melchiorre 📄 [How LLMs Are Revolutionizing Database Queries Through Natural Language](https://www.queryhub.ai/blog/natural-language-to-sql-llm) Joe Harwood (QueryHub) 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/sixqwtolv7o1l6qnjdq5.jpg)](https://pgmodeler.io/) [pgModeler 1.2: A Postgres Database Modelling Tool](https://pgmodeler.io/) — An easy way to create and edit database models in a more visual way. It’s packaged up as a paid product but is also open source (GPLv3 – [repo here](https://github.com/pgmodeler/pgmodeler)) so you can build it yourself. [v1.2](https://github.com/pgmodeler/pgmodeler/releases/tag/v1.2.0) is a significant update. Raphael Araújo e Silva [pgwatch 3.3: A Postgres Monitoring Solution](https://pgwatch.com/) — A self-contained metrics monitoring dashboard tool for Postgres servers. Can be easily deployed with Docker in a non-invasive way (no extensions needed). [GitHub repo.](https://github.com/cybertec-postgresql/pgwatch) CYBERTEC [Vircadia: A Postgres-Powered Reactivity Layer for Games](https://vircadia.com/) — It seems to be early days, but the idea is you can use Vircadia to simulate agentic worlds and manage in-game entities through SQL. Vircadia - [FerretDB 2.2](https://github.com/FerretDB/FerretDB/releases/tag/v2.2.0) – A database that acts like MongoDB but uses Postgres for storage. (As an aside, [the co-founder of FerretDB recently joined Claire Giordano on the _Talking Postgres_ podcast](https://talkingpostgres.com/episodes/how-i-got-started-with-ferretdb-why-we-chose-postgres-with-peter-farkas) to talk about FerretDB and why they chose Postgres to be its backend.) - [River 0.22](https://riverqueue.com/) – Robust job processing system for Go and Postgres. - [pgroll 0.12](https://github.com/xataio/pgroll) – Zero-downtime, reversible, schema migrations. **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|*).