What if we treated Postgres like SQLite?

PostgreSQL could be used like SQLite - installed locally on a single server without network access, communicating via Unix socket for speed. This approach offers PostgreSQL's mature ecosystem and extensions (like pgvector) without SQLite's extension compilation challenges, while maintaining simplicity. Though PostgreSQL requires server configuration, it might be worth experimenting with for projects that need advanced database features with SQLite-like operational simplicity.