October 2022 Summaries

PostgreSQL 15 introduces several improvements, including enhanced sort performance and write-ahead log file compression. The SQL MERGE query can now update, insert, or delete rows with a single statement, handling concurrent insertions differently than the INSERT ON CONFLICT statement. PostgreSQL 15 also removes the global write privilege from the public schema to limit potential security issues, allowing users to grant specific permissions to trusted individuals. Additionally, the database treats NULL values as not distinct in unique constraints and indexes, preventing duplicate key value violations. Users can try out these features by creating a PostgresSQL 15 project with Neon's SQL Editor at https://neon.tech.

PostgreSQL 15 introduces several enhancements, including improved sort performance and write-ahead log (WAL) file compression, and is now supported by Neon. One notable feature is the SQL MERGE command, which allows for the updating, inserting, or deleting of rows in a single statement, offering an alternative to the INSERT ON CONFLICT statement that has existed since version 9.5, with differences in handling concurrent insertions. Additionally, PostgreSQL 15 has removed the global CREATE privilege from the public schema to enhance security, requiring explicit permission grants for trusted users. Another enhancement is the ability of unique constraints and indexes to treat NULL values as not distinct, allowing only one NULL in a column specified as UNIQUE. Users are encouraged to explore these features on Neon and consider migrating their projects to PostgreSQL 15.

Neon has partnered with Hasura to provide developers with instant GraphQL APIs with Serverless Postgres, allowing users to create a Neon project in 1 click from the Hasura console. The partnership aims to enhance the developer experience, with future milestones including deeper integration between Neon and Hasura, enabling seamless connection to existing Neon databases and addition of a Hasura GraphQL API from the Neon console. This collaboration will enable developers to build real-time GraphQL APIs for their Postgres databases using Hasura's GraphQL Engine.

Neon and Hasura have collaborated to offer developers a seamless integration that enables the creation of a Neon Serverless Postgres project with a single click from the Hasura console, marking the first milestone in their partnership aimed at enhancing the developer experience. This integration allows users to instantly set up a GraphQL API with the Hasura GraphQL Engine, providing real-time access to Postgres databases. Future plans for the partnership include deeper integration features, such as the ability for Neon users to connect to existing databases from the Hasura console and add a Hasura GraphQL API directly from the Neon console. Developers are encouraged to explore the documentation for more details on utilizing these tools, and further enhancements are anticipated in the coming weeks and months.