Get the latest tech news
What if we treated Postgres like SQLite?
What happens if we just treat a local Postgres like SQLite? What does that mean? In this article, I’d like to expand on that idea.
But when you need to copy a SQLite production database file to your laptop to debug something, because there isn’t remote access, and you’ve forgotten how to compile the extension in the right version on your local system, and the production system architecture is different than your local one, and you are in a hurry, things can get frustrating quickly. Common wisdom tells you to have a cluster of Postgres instances replicating each other in some configuration or other, for operational robustness and fault tolerance. I guess Postgres could even run in a Docker container without taking a big performance hit, when everything is configured correctly.
Or read this on Hacker News