Since its launch last year, hundreds of thousands of developers have built apps and sites using Vercel Postgres, the serverless database powered by Neon. This has been a great partnership, helping Neon scale up to millions of databases and helping Vercel deliver on their vision of the frontend cloud...

Neon’s autoscaling, now GA and available in all pricing plans, enables Postgres instances to dynamically scale up for the high memory and CPU demands of HNSW index builds, avoiding constant overprovisioning. With memory extension through disk swaps, Neon efficiently handles large index builds even w...

Neon autoscaling has officially graduated out of beta and is now available for all Neon databases, including the Free plan. With autoscaling enabled, your Neon Postgres databases automatically adjust CPU and memory based on workload, ensuring optimal performance and cost efficiency. This removes the...

“We absolutely love Postgres, but we prefer not using AWS or GCP because they are not developer-first. We use PlanetScale for MySQL projects, but for Postgres, we didn’t have an equivalent where we could get the same level of developer experience… Until we found Neon” Sarim Malik, CEO at Rubric Labs...

On 2024-08-14, about 0.4% of customer projects in us-east-1 experienced an outage for up to 2 hours, after an EC2 instance hosting one of our services failed. We understand that these incidents have a significant impact on our customers, and we take them seriously. This post explains what went wrong...

“Wordware is all about building and iterating quickly, so there’s alignment with Neon. ​​With Neon’s preview branches, we can catch issues early (like a migration breaking on a copy of the main database) and fix them before they hit production. By spotting and fixing problems early, we can move fast...

In previous articles, we discussed the advantages of using Neon as a development database while keeping your production workloads on AWS RDS. We covered how to set up nightly dump/restore jobs using GitHub Actions to create a synchronized Neon Twin of your production database and how to implement Sl...

One of the things that got me really excited and curious about Neon, long before I joined the company, was the psql -h pg.neon.tech command. I’ve recently come to find out that other employees here went through the same “wow” experience even before they joined the company. So, I’ve decided to write ...

Every once in a while, a revolutionary product comes along and changes everything. And today, we’re talking about three of these phenomenal products. The first one is a document store. The second is a vector database. And the third is a graph database. So, three things: document storage, vector oper...

Outbound logical replication is available in beta for all Neon projects (outbound = from Neon to other sources). Inbound logical replication (from other sources to Neon) will be available soon. If you want to try it early, tell us here or join our Early Access list. Logical replication allows you to...

Have you ever stared at a complex database and thought, “What the F#!% did I get myself into?” If so, you’re not alone. Tables multiply, relationships tangle, and before you know it, you are lost in a monster of your own making, or worse, somebody else’s. This is where something like an Entity-Relat...

It’s official: Neon is coming to Azure. This expansion is backed by a $25M strategic investment led by M12, Microsoft’s Venture Fund. Multi-cloud has always been a part of our vision at Neon. We want to help developers ship faster with Postgres on Neon, regardless of which cloud provider they use. W...

“With Neon, we can start small and scale up. We don’t have to think about some level of operational stuff. That’s awesome.”  Paul Dlug, CTO of Comigo.ai Comigo.ai is a digital companion and coach for individuals with ADHD. The app leverages LLMs to offer support traditionally given by a body double—...

📚 This article is part of a series on setting up Neon for dev, test, and staging environments while keeping your prod database in RDS. Find out what we’re talking about.  In a previous blog post, we showed you how to create a Neon Twin using a GitHub Action that automatically runs a pg_dump of […]

pgvector’s latest release includes quantization features that help reduce your vector and index footprint while speeding up index builds and prewarming times for RAG applications. All Neon Postgres databases come with pgvector—spin up a free database here. In this blog post, we will test how scalar ...

The AI wars have begun. Not the one where the machines enslave us and use our body heat to power their compute–that’s at least 18 months off. 🙂 No, this AI war is between the tech giants and between closed, proprietary models and open source.  In one corner, we have OpenAI, supported by Microsoft, b...

Via database branching workflows, developers can quickly experiment and ship updates—this is why we often hear how Neon accelerates development for teams. But it can be nerve-wracking to think that you might accidentally delete the production branch or project. To give you peace of mind, we’ve imple...

As we discussed in Part I of this series, AWS RDS is great for production, but unwieldy for dev, stage, and test databases. Businesses of all kinds ship faster with their entire DB load on Neon: Instant provisioning saves time, development is smoother with branching, and scale to zero reduces non-pr...

Interacting with SQL databases can be challenging for non-technical team members, often requiring custom-built GUI tools. If you’re not an expert, writing SQL queries can become a barrier to accessing data—this is where AI can help.  What is AskYourDatabase? AskYourDatabase is an AI-powered tool tha...

We often get questions about Postgres indexing strategies, and read-only (or read-heavy) tables are especially interesting. This post was actually inspired by this question on Reddit:  “I have a table with about 20 columns that each have Boolean values indicating whether the row has a specific chara...

AWS RDS for PostgreSQL is the most widely-used hosted Postgres solution there is, so naturally we hear a lot from developers that use it. While it can be a solid offering, it’s quite lacking when it comes to developer experience, and doesn’t support modern developer workflows. We often hear of devel...

You’re building your app on top of Postgres. Stellar idea. You’ve created a Postgres database, the initial tables, and even seeded the initial data.  Nothing is going to stop you n… Roles. Roles will stop you now. Roles in Postgres are one of those things that look oh-so-simple from the outside (aft...

“Branching saves us both money and developer time. We no longer have to set up an actual testing database instance and make sure the data is always synced with production. We now spin up an ephemeral branch when we need to and then tear it down via the create/delete Github Actions” Angelina Quach, S...

The right indexes make big SQL queries fast. If you’ve been using Postgres for more than 5 minutes, you’re almost certainly familiar with the everyday B-Tree index. This can deal with data that has a one-dimensional ordering: numbers, timestamps, text, and so on. And if you’ve had anything to do wit...

To test a new database, you need data, and not just any data. You need consistent, reliable data that behaves the same way every time you run your tests. Otherwise, how can you trust that your database and code is working correctly? This is where the twin concepts of seeding and fixtures come into p...

Read replicas in Neon are different from what you’re used to – they’re lightweight, affordable, and fast to provision. You can rely on them to scale your performance horizontally when you need a boost. We’ve been working hard on our read replicas lately, improving their stability via numerous fixes....

“Our database traffic peaks at nights and on weekends when thousands of our members are attending experiences. Building on a database that preemptively autoscales allows us to regularly handle these traffic spikes.” Lex Nasser, Founding Engineer at 222 Life in a tech-enabled world has become perfect...

As you’re building your architecture, much thought goes into making database systems resilient to failures. But shhh… stuff happens; misconfigurations, human errors, or accidentally signing up little Bobby Tables to your service—sometimes, databases fall over. If you don’t have a data recovery strat...

A few weeks ago, we shipped a cool new feature in our console. In the past, the only way for Neon users to work with their data was via SQL queries; now, you can modify your data in an intuitive and visual way directly from the Tables page, powered by Drizzle Studio.  You can now […]

We are beyond excited to announce that the Outerbase integration for Neon is now publicly available. This integration enables you to instantly connect your Neon Postgres database to Outerbase’s Data Studio and invite your team to view, edit, query, and visualize your data with you. To learn how to c...