“Databases have always been such a pain in terms of the migration flow, backups, scaling, risk of breaking production… In Neon, everything feels easier and much safer to do” Julian Benegas, CEO of BaseHub ​​BaseHub is a new kind of headless CMS, designed to make content management fast, simple, and ...

Building high throughput, scalable embeddings indexing pipelines can be a daunting task, often requiring stitching together systems with code that needs to scale, handle failures and ensure delivery guarantees. However, with powerful tools like Redpanda and Neon, this process can be significantly si...

With the announcement that Neon’s autoscaling feature is GA, we wanted to take the opportunity to dive into the implementation of a recent improvement we made: Scaling to match your workload’s working set size. This can provide extraordinary speed-ups for real-world workloads, but it’s a complex pro...

One more year, Postgres is the most loved and trusted database in the world—and it’s about to get better with Postgres 17. This upcoming release comes with improvements both in developer experience and performance.  Top 3 features in Postgres 17  MERGE command with RETURNING support Why we like this...

Many Neon users aren’t just storing their own information, but host data on behalf of many clients or customers, commonly called tenants. Over the decades, approaches to these multi-tenant data architectures have evolved in three main directions: shared schema, schema-per-user, and database-per-user...

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...