4 ms·
sqlite is not a proper choice for a service like this, something like Postgres could actually provide a proper DBE that could net some performance benefits.
by Avamander 7y ago
sqlite is not a proper choice for a service like this, something like Postgres could actually provide a proper DBE that could net some performance benefits.
- velcrovan 7y agoPeople running their own email servers probably don't need higher performance than what SQLite can offer. Meanwhile the maintenance overhead of an SQLite-based setup is almost nil, and migrations & backups are trivial — two big benefits for people running their own email servers.-
- Avamander 7y agoMigrations and backups are trivial with Postgres as well.
- pjc50 7y agoTo me this seems ideal - you can already get IMAP-in-Postgres through lots of mail servers, it just takes more work to set up. Whereas sqlite is a strict upgrade compared to using mbox or maildir for people using a local filesystem (not NFS) while still requiring no setup.
- Avamander 7y agoYou shouldn't run your own mail if you can't install postgres.