Neon Postgres

You can read the full engineering post here neon.com/blog/prewarming

Compute prewarming on Neon and Lakebase starts a new compute instance and pre-warms the cache from the storage layer before terminating the old compute.

Now active for all databases: 𝐂𝐨𝐦𝐩𝐮𝐭𝐞 𝐩𝐫𝐞𝐰𝐚𝐫𝐦𝐢𝐧𝐠 is the first of several features that make compute restarts invisible. Context: We auto-upgrade Postgres minor versions and ship security patches for millions of databases/month. For always-on databases, this requires a compute restart that has 1sec P99. But the compute cache still needs to warm up. Compute prewarming dramatically improves post-restart performance.

i built a thing with the @paper npm package

Agents can write your code. Now they can provision your database too. 𝚜𝚝𝚛𝚒𝚙𝚎 𝚙𝚛𝚘𝚓𝚎𝚌𝚝𝚜 𝚊𝚍𝚍 𝚗𝚎𝚘𝚗 One CLI command to get a Neon account, database, and credentials. We're excited to participate in Stripe Projects as a co-design partner!

Install the neon-postgres-egress-optimizer skill and ask your friendly coding agent to “reduce my Postgres public network transfer” ✨

What is Neon? What makes it serverless Postgres? @ant_giuliano has all the answers here 👇

Changelog for details neon.com/changelog

Lots of account upgrades on Neon: - Create organizations and invite members on Free Accounts - 2FA available on all accounts - Verify your domain to auto-add your entire team to a single Neon organization

We interviewed their co-founders about what they're building and how they're using Neon - check it out here neon.com/blog/how-speci…

Agents are great at writing code, but too much of the other work like configuration of local dev environment and provisioning infrastructure, is still on the developer. Specific.dev solves this with an agent-first cloud. Agents get automatic local dev environments and a Terraform-style IaC layer that gives them the infrastructure context they need to develop, deploy, and maintain apps safely. Also the database layer runs on Neon!

Big news: You can now add unlimited team members and create multiple organizations on the free plan. 🚀 This helps you isolate your projects, collaborate with ease, and never worry about "per-seat" pricing. Check out what’s new in the console! 👇

George MacKerron is back with another deep dive into one of Postgres’s strangest corners: what actually happens when you press CTRL+C in psql. neon.com/blog/ctrl-c-in…

The answer... a second connection attempt with a magic protocol number is made to your database over plaintext with a four-byte process id and secret key.

If you know how cancelling a query with CTRL-C in psql works, you've seen some things. If you don't know, you probably shouldn't look.

@QwikBuild Decoupled compute + storage with scale-to-zero → affordable to run large fleets where many apps sit idle One Neon project per app, provisioned instantly via API → no engineers babysitting databases Full story: neon.com/blog/inside-qw…

How @QwikBuild ships thousands of apps over WhatsApp - each with its own isolated Postgres database - without a huge team or budget? They lean into Neon’s architecture

Page is here neon.com/postgresql/pos…

Thanks @karlhorky for contributing much more intuitive Teams and Players SQL examples to our Postgres JOIN docs. All Neon docs, guides and Postgres pages are open source. We meet some of the best people via contributions.