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...

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...

If 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 ...