PostgresFeb 24, 2025Beyond Docker Compose: An Alternative for Deploying Postgres for TestingTesting 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...Jeff Christoffersen
PostgresFeb 18, 2025I Dropped a Table in Production—Now What?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...Carlota Soto
PostgresFeb 17, 2025The Dangers of Testing in SQLite as a Postgres UserSQLite 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...Brian Holt
PostgresJan 23, 2025Launch Postgres in Your Browser, Keep It On NeonSometimes 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...Guillaume Rivals
PostgresJan 15, 2025Test Your Database Without MocksMocks 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...Andrew Tate
PostgresJan 09, 2025An API to Track Database Schema ChangesWe 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...Luis Tavares
PostgresDec 23, 2024Three Signs It’s Time To Move Away From AWS RDS Amazon RDS has long been the default choice for hosting Postgres in AWS. Its reliability makes it a solid pick for many teams—but as workloads evolve, RDS can start becoming a serious bottleneck. Spotting the signs early can save your team time, money, and headaches. Signs of dan...Carlota Soto
PostgresDec 11, 2024psql from the browserIf you’ve ever worked with Postgres, you’ve probably launched psql at least once. It’s the default database client packaged with the Postgres server. This is a command line application, written in C, and it’s packed with many features such as autocompletion, command history, and ...Eduard Dyckman
PostgresDec 10, 2024What To Know About Postgres if You’re Coming From SQL Server1989. The year the Berners Lee proposed the World Wide Web, The Simpsons first premiered, and Taylor Swift was born. Another worldwide phenom was born that year Microsoft SQL Server 1.0. We’ve had 35 years of SQL Server (Microsoft’s version), and if you’ve been invested in the MS...Brian Holt
PostgresDec 02, 2024Let Your AWS Lambdas Survive Thousands of Connectionsneon.tech/aurora." > AWS Lambda is pretty awesome. Serverless “Functions as a Service” where you can deploy code without worrying about servers, scaling, or infra. Well, that’s the dream. The reality can be a bit nearer earth, especially when Lambda bumps up against other service...Andrew Tate