SQLite in Production for Small to Medium Sites

SQLite is often underestimated. For small to medium sites with read-heavy, write-light workloads on a single server, it performs very reliably.

Advantages

• Zero ops; a single file is the database
• Backup is just copying the file
• Great developer experience with EF Core

Notes

Enable WAL mode to significantly improve concurrent read/write; take regular file-level backups; keep the database file on persistent storage in production.