Introduction I spend a lot of time interacting with developers on Neon’s Discord Server—if you’re not already a member, you should join us! One recurring issue that I’ve seen developers ask for assistance with is identifying a reason for suboptimal response times from their application’s API endpoin...

Foreign keys are a concept embedded in almost every relational database. If you are normalizing your database, you will expect to use foreign keys throughout. And they seem simple. But simplicity often belies the subtle differences that can trip you up when switching between database systems. One si...

“Database branching is the best quality-of-life improvement to my tech stack that I can think of in recent years. Second to maybe only Copilot” Miguel Hernandez, Backend Tech Lead at Neo.Tax Neo.Tax specializes in automating the calculation of tax credits for startups, enterprises, and mid-market co...

We love Postgres, and for us, being able to use Postgres database branches that can be integrated with our CI/CD pipeline is a killer feature. The ability to spawn databases that can scale down to zero is also incredibly helpful. This model fits well with our one database per customer architecture. ...

Database branching makes it easy to create database copies for your non-prod environments, but some companies face the obstacle of how to anonymize PII to ensure privacy. This can be solved with Neosync, an open-source tool that allows developers to anonymize data across branches. Try it with Neon. ...

Introduction Is it possible to safely reduce the number of SCRAM password hashing iterations from 4096 to just one? An engineer recently raised this question about our password generation to optimise CPU usage. Why? In Neon, every database is secured via a password. Verifying the password takes a ce...

“As soon as we found out about Neon’s branching model with copy-on-write, we knew it was exactly what we were looking for” Julien Goux, Software Engineer at Snaplet Snaplet uses Neon to power its Snapshot feature. Neon’s partnership plans make it possible to manage thousands of databases without cos...

After spending a bit of time with Neon’s SQL Editor making \d and friends work, there were a couple of other things I wanted to bring to it, both related to the query results. The first was a simple expand-to-window control for the results pane, to get a better and less cramped look at query result ...

If you are setting up a new table in Postgres, the first line is probably going to look like this: You’re going to have an id of type INTEGER, and you’re setting it as the PRIMARY KEY. If this is you, congrats, you can stop reading right here. However, if this is you: Then, read […]

At Neon, we are committed to listening to our customers and partners, and constantly striving to improve our services based on your feedback. That’s why we’re excited to announce a significant improvement to our partnership program: partners can now create up to 1,000 projects without cost as part o...

Modern development demands speed and flexibility, but this is nowhere to be found in database development. Even when using managed databases, database workflows are still slow and prone to errors: setting up new instances takes time, undoing changes is risky, keeping data consistent across environme...

Starting today, Encore now supports using Neon Postgres for all Encore environments, including those in the cloud on Amazon Web Services (AWS) and Google Cloud Platform (GCP). “This means you can connect your Neon account to use highly scalable serverless Postgres for all your Encore managed environ...

YC startups: we know the grind (customer obsession, rapid iterations, the need to scale with tight budgets) so we’re rolling out a special deal for you. If you’re in Y Combinator, you can claim $100k worth of Neon credits for your first year. And if you stumble upon a better deal somewhere else, let...

There are two ways to think about a relational database. The first is data-centric. Data is organized into tables with rows and columns, each representing a specific entity or concept. In this mental model of a database, the primary focus is on storing and retrieving data. This makes a lot of sense....

Reducing cloud costs is on everyone’s mind. While storage prices continue to drop, fewer innovations have been made to reduce compute costs, even though compute typically consumes a larger chunk of the bill. That’s why we’ve built Neon with scale to zero and autoscaling, so that teams only pay for t...

Increasing the velocity at which teams can develop, test, and deploy is a key goal for us at Neon. Our branchable Postgres enables teams to create development and preview environments instantaneously, and autoscaling gives you the confidence that your production environments can scale up to meet dem...

Different database systems provide different ways to list or describe the things they hold. For instance, to find a particular table and column in MySQL, you run SHOW TABLES followed by SHOW COLUMNS FROM my_table. In SQLite, you do .tables and then .schema my_table. And in Postgres, the commands are...

We’re excited to announce the release of Neon’s Serverless Driver 0.9.0 on Deno’s JavaScript Registry JSR. Deno is an open-source JavaScript, TypeScript, and WebAssembly runtime built on V8, Rust, and Tokio.  Although compatible with npm, Deno built JSR to address several changes and evolutions in t...

Neon’s serverless Postgres improves developer velocity and allows organizations to ship faster. When using a database for your app, monitoring its performance is crucial. You can do that using Postgres extensions such as pg_stat_statements. However, if you’d rather do it from the UI, we’re happy to ...

Neon helps teams ship with confidence without compromising development velocity. One of its features that contributes to that is database branching. In this post, we will explore two new features related to database branching: schema diff and protected branches. Database branches in Neon are copy-on...

Neon simplifies the use of scalable Postgres, changing how you handle your database infrastructure from development through production. This is a fundamental shift in how to leverage your Postgres infrastructure. Instead of spending time on Infrastructure as code (IaC) and cloud-specific configurati...

Neon introduced autoscaling for serverless Postgres to the world over a year ago, enabling your applications to handle peak demand without incurring peak infrastructure costs 24/7. Our autoscaling feature performs zero-downtime vertical scaling of your Postgres instance, provisioning extra CPU and m...

We separated storage and compute with the vision of scaling Postgres in the cloud. The compute part runs on VMs and pods, autoscales on-demand and streams Postgres Write-Ahead-Log (WAL) records to the storage engine. The storage part saves the database’s historical data in a Rust-based, multi-tenant...

Neon is now Generally Available. We’ve shipped major improvements to Neon internals that, combined with our operating experience scaling up to 700,000+ databases over the past year, give us the confidence that Neon is ready to support your business-critical workloads. If you’re building or scaling a...

This guide covers the step-by-step process of building user authentication APIs and HTML pages in Astro application with Lucia Auth and Postgres, powered by Neon. User authentication provides a way to manage user identities and access control in your application. Upon completing the guide, you would...

This guide covers the step-by-step process of building an e-commerce store UI powered by Neon in Astro and Postgres. Upon completing the guide, you will understand how to build dynamic pages in Astro by querying your Postgres database over HTTP requests and automating deployments on Git commits usin...

Introduction In this post, we’ll create and deploy a Nuxt fullstack application on Cloudflare Pages that uses server routes (API endpoints) to access Neon Serverless Postgres with Cloudflare Hyperdrive. Cloudflare Hyperdrive, now Generally Available, is a serverless application that proxies and acce...

Scale to zero is the Neon feature where you can say: “When my database is idle for X seconds, shut it off so I’m not paying for it, but wake it up when I need it again.” This is possible because Neon separates compute and storage: we shut off compute, storage stays safe and sound […]

Neon is serverless Postgres. Neon databases elastically scale up and down according to load—including scaling to zero—and database operations are greatly simplified via robust API support and database branching capabilities. But just like every Postgres, to get the most out of Neon’s performance, it...

Building an effective authentication and authorization system into your application is as equally fraught with challenges as managing database infrastructure. As the old wisdom says, never “roll your own” regarding authentication and authorization.  In addition to the effort required to develop the ...