SQLite vs PostgreSQL for AI Agent Memory: What Are Your Thoughts?

In a recent project, I benchmarked SQLite against PostgreSQL for an AI agent memory SDK. Surprisingly, SQLite outperformed PostgreSQL in local-first and single-node setups, simplifying the architecture significantly. What are your experiences with choosing databases for AI applications? Have you faced similar trade-offs? Let's discuss the pros and cons of different database choices in AI development.