Snapshots are a critical safety net for any team running Postgres in production. If you’re using AWS RDS, you’re probably relying on them mostly as protection against accidental changes. But if your database grows to many terabytes, the experience of actually using those snapshot...

When a Postgres failure happens, the time it takes to recover can mean the difference between a relatively minor hiccup and a major business crisis. We regularly hear anecdotes from our customers on this topic, but we also wanted to gather some data—so we surveyed 50 developers m...

Reddit’s answer for solving noisy neighbors is simple Have a talk with them, if you can stay calm, be as straight forward as possible. Don’t bend on your position. At least find out what the other neighbors think. Good advice, but it can be difficult to talk to CPUs; they tend no...

We just announced that pg_search is available on Neon, making it easier than ever to build fast, full text search experiences with Postgres. To demonstrate its performance, we forked Vercel’s Book Inventory template and replaced the AI powered search with native PostgreSQL full t...

Testing applications with Postgres presents a common challenge how do you provide each developer and CI pipeline with isolated, consistent databases to test against? Docker Compose has emerged as the standard solution, offering containerized Postgres instances that can be spun up...

Imagine you’re running a multi terabyte production database in Neon when you accidentally drop a critical table. Ouch. You notice the mistake a few minutes later, during which your high ingestion workload continues pumping new data into the database. How can you recover that drop...

SQLite is genuinely an incredible piece of technology. Instead of having a list of which companies used the database, the SQLite site simply tells you its on every Android phone, every iPhone, in every browser, in every Mac, in every Windows machine. “Billions and billions of cop...

Sometimes you need a Postgres database right now, and you’d like to have it without setting up containers, deploying infra, or creating an account anywhere. Maybe you’re following a tutorial online or testing a quick idea. Enter Instagres—a tool that lets you spin up a fully func...

Mocks for databases are extremely brittle and complicated. – javcasas Mocks in general are rarely worth it, the DB ones 10x so. – pdimitar Was dealing with mocking voodoo garbage this morning as a result of fixing a bug. What a horrible mess just to claim a few lines of “test cov...

We keep expanding our Schema Diff feature, this time adding an API endpoint compare_schema. You can use it in all your Neon projects, including the Free Plan. Schema Diff allows you to easily compare schemas between Neon databases. It was first made available via the Neon Console...