pg_embedding has introduced the Hierarchical Navigable Small World (HNSW) index to Postgres, allowing vector search to scale in Postgres. But with the addition of HNSW to pgvector 0.5.0, we see little benefit to the community to have to choose between two vector search extensions for Postgres. After...

Vector embeddings have become an essential component of Generative AI applications. These embeddings encapsulate the meaning of the text, thus enabling AI models to understand which texts are semantically similar. The process of extracting the most similar texts from your database to a user’s reques...

In this post, I’d like to introduce Neon’s serverless driver which is suitable for use with Vercel Edge Functions. I’ll explain how to use it with Next.js and a free Neon serverless Postgres database Here’s a demo I created. I’ve called it Ping Thing.  What does Ping Thing do? When users click Ping,...

We’re excited to announce that Neon now supports Postgres 16. This latest release includes several performance improvements and developer experience enhancements. One of the most anticipated features is the expanded support for SQL/JSON syntax, including: In this article, we will cover these new fun...

In this guide, we’ll cover what read replicas are, how they work in Neon, and how to leverage them to scale your Prisma applications. What is a read replica? A read replica is a read-only synchronized copy of your primary database. It offloads read traffic from your primary database to improve perfo...

A few weeks back, we published an AI-powered app where you can submit an idea for a startup and get a list of similar companies YCombinator has invested in. The app got attention on HackerNews and Twitter, resulting in 5,000+ visitors and 2,500+ submissions. If you haven’t had a chance to try it out...

Back in 2010, my first production Postgres database used a couple of JSON columns to provide some flexibility around the main schema. From the point of view of the database, those columns were actually just text. But Postgres got a native JSON type soon after (with version 9.2 in 2012), and its JSON...

In this guide, you will learn how to create a Neon branch for every Qovery preview environment. What are preview environments? This enables developers to build new features in parallel without affecting each other. It also makes it possible to do frequent small releases, making it easier to revert c...

A few weeks back, we released pg_embedding, a new extension for Postgres and LangChain which introduced Hierarchical Navigable Small Worlds (HNSW) indexes for vector similarity search. This new indexing method resulted in 20x faster queries at a 99% accuracy compared to traditional IVFFlat indexing....

For anyone that has been paying attention, the 30M and now 46M funding rounds for Neon seems like an awful lot of money for a two year old company of just over 50 people. Funding is great and we are great believers in “raise it when you can not when you have to” but as […]

In this guide, you’ll learn how to leverage Neon branching to programmatically restore your data to a previous state. What’s Neon? Neon is a fully managed serverless Postgres. This means you do not have to pick a size for your database upfront, and it will automatically allocate resources to meet yo...

tl;dr> Over the past few months, a bunch of efforts by the engineeringteam have greatly reduced our “cold start time” for compute resourcesfor idle computes that become active. This post explores the problemand how the Neon team worked on this problem. Background: What’s a cold start and why does it...

We’re excited to share that we have completed the SOC2 Type 1 audit- a significant milestone in our commitment to security. This article will cover what SOC2 is, our journey, and our plans for the future. What’s SOC2? Service Organization Control 2 (SOC2) is an auditing standard developed by the Ame...

One of our goals during the past few months was to improve the developer experience when using Prisma with Neon. This article highlights all the improvements we shipped, including reducing cold starts, having a better experience working with Prisma Migrate, and improving connection pooling support. ...

Today, we are releasing Neon CLI, a command-line interface that enables developers to manage Neon resources directly from the terminal! With Neon CLI, you can handle authentication, and manage projects, branches, databases, roles, and much more without leaving your command line. Get started by insta...

We’re excited to announce the release of our pg_embedding extension for Postgres and LangChain! The new pg_embedding extension brings 20x the speed for 99% accuracy to graph-based approximate nearest neighbor search to your Postgres databases.  While the pgvector extension with IVFFlat indexing has ...

Faster is always better, especially when executing SQL queries.  We recently introduced SQL-over-HTTP to our driver, which previously only supported WebSockets. Why did we do that? And which approach is faster? Our journey developing the WebSockets serverless driver We first developed the Neon drive...

Today, we are excited to introduce same-region read replicas to Neon’s serverless architecture, an important milestone in achieving global replication.  To start using Neon’s read replicas, you’ll need to sign up for Neon’s Pro plan. You can create a read replica on the Neon console:  Or using the N...

Today, we are thrilled to announce the release of our enhanced driver for your Postgres queries at the Edge.  With this release, developers can observe a 40% reduction in query latencies from Vercel Serverless Functions and Edge Functions, bringing same-region queries down to single-digit millisecon...

We’re thrilled to announce the launch of our official Neon Partner Program, which makes it possible to integrate Neon into any application seamlessly. Keep reading to learn how you can become a partner and the types of integrations we offer. Neon’s OAuth integration The first type of integration we ...

According to the StackOverflow Survey 2023, nearly half of professional developers use Postgres. It’s natural then that the Postgres extension for vector similarity search, pgvector, is one of the most popular options for prototyping  AI-powered applications. But how to properly use pgvector? Is it ...

To use Neon to its full potential, it is important to understand its object hierarchy. Before diving in, we will first go over the experience of provisioning a managed Postgres instance and why it was necessary to introduce a new architecture to make Postgres cloud-native. Traditional managed Postgr...

I got a Slack message from colleagues at a major partner. They’d updated their dev environment to support WebSockets, so that Neon’s serverless driver could be used there, but then they’d run into a weird issue.  The nub of it was this: This hangs: This works Reproducibly, the query without an ORDER...

In this guide, you will learn how to build a serverless API using Cloudflare Workers, Hono, Drizzle ORM, and Neon.  What are Cloudflare Workers? Cloudflare Workers enable you to build and deploy serverless code instantly across the globe without worrying about managing and scaling infrastructure. Wh...

In this blog post, we’ll walk through creating a Githook script that automates the creation of Neon branches every time a new Git branch is created. This is possible because Neon provides an API to manage your projects, branches, and most other operations supported by the Neon Console. You can learn...

Neon is a serverless Postgres system that separates storage from compute, providing users with all the customary Postgres features and more, including usage-based billing, autoscaling, database branching, and point-in-time recovery. We previously provided a comprehensive overview of our storage engi...

A few months back, we had an internal AI hackathon at Neon where we could learn and experiment with OpenAI’s APIs. One of the ideas was to build an online AI SQL playground for Postgres. It would enable developers to connect to a Neon Postgres database and have an AI assistant generate SQL queries u...

Typed SQL libraries for Typescript are designed to provide a robust, maintainable, and developer-friendly interface between your code and the database. However, choosing the right library for your Typescript project can be difficult since they all offer similar functionalities.  This blog post will ...

SQL injection is one of the most well-known security vulnerabilities, allowing attackers to manipulate database queries and potentially gain unauthorized access to sensitive data. However, using our serverless driver, you can continue to write queries as you always have, but feel confident you’re no...

Neon, a leading provider of Serverless Postgres in the Cloud, has partnered with Vercel, a frontend cloud provider, to introduce Vercel Postgres, the first serverless Postgres database built for the frontend. This strategic partnership will provide developers with the ability to deploy high-performi...