In Neon, we’re always trying to strike a balance between out of the box configurations that work for most people and the flexibility to accommodate a wide range of use cases. By tweaking features like autoscaling, branching, and scale to zero, you can optimize Neon for many diffe...

Branching is one of the most powerful features in Neon. It lets teams spin up isolated environments instantly and automate workflows through the API, and as a result, developers and agents create many branches at scale – hundreds or even thousands of them. To make managing short ...

Developers love using Neon branches for a local development, due to the agility they provide (e.g. fast resets, isolated environments, and the ability to test without polluting production data). But using Neon branches still requires you to manage separate connection strings for ...

Over the last decade, nearly every part of the software development stack has evolved to support faster iteration, better automation, and less oversight. But one layer has stubbornly resisted this evolution – the relational database. The stack evolved, the database stayed behind ...

Postgres Event Triggers via the neon_superuser role. This unlocks many use cases around schema change detection, automation, and unlock sync engines like Zero. Event triggers in Neon work exactly as they do in vanilla Postgres." > Postgres event triggers are a powerful (although ...

Implementing text search in Postgres is trivial. You can do it as simply as this But like most simple things in SQL, it’s only simple when your data is simple—when you hit anything approaching scale, the simple things become hard. Full text search is precisely one of these cases....

You’re building a healthtech app. Maybe you’ve decided to take on the insane complexity of electronic health records, or maybe you’re building an app for doctors to communicate with patients, or perhaps you’re creating a platform for managing clinical trials. Whatever your specif...

Microsoft recently introduced a Visual Studio Code extension for Postgres database management. Similar in functionality to tools like PgAdmin or DBeaver, this extension embeds Postgres management directly into VSCode and comes fully integrated with GitHub Copilot, allowing it to ...

If you’re building a dev tool, template, or platform where users need a database, you’re probably familiar with the pain you can either ask them to bring their own, or build a full provisioning flow yourself. Beyond just provisioning it, your users will need to set up their schem...

Moving a Postgres database from one provider to another it’s tedious, even for simple migrations. You have to export and import dumps, match versions, check extension support… To take that friction out of this equation, we’ve built a tool the Import Data Assistant. Migrate Your D...