September 2025I love SQLite. It just works. It is extremely fast, because it’s just a local file access. It is very operationally and mentally simple, and it is extremely stable and well-tested. However, over my years of using it, there are just some things that I miss from the world of Postgres. So 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. I’ve talked and written extensively about the virtues of SQLite. I’v...