On Jan 16, 2021, at 7:31 PM, Mark Sapiro <mark@msapiro.net> wrote:
On 1/16/21 6:06 PM, bruce.dubbs@gmail.com wrote:
I do have sqlite installed, but the documentation discusses mysql/mariadb and postresql. What are the considerations as to why I would need one of these other DBs?
You can use sqlite, but if you don't already have a mysql/mariadb database on the server, we recommend postgresql for performance and robustness. I personally have had issues with mysql and use postgresql on one production server that uses mysql for other applications.
I’ll word this a little more strongly: do not use sqlite for a production server.
Do not "just start with sqlite to get it running and then I’ll migrate it to something else down the road.” There is currently no validated way to migrate a mailman3 instance from sqlite to something else, and by “no validated way” what I actually mean is “no one has managed to get this to work, me included.”
Put in the extra effort to start with posgresql or mysql/mariadb up front. You’ll regret it if you don’t.
Ask me how I know. 😁
- Mark
mark@pdc-racing.net | 408-348-2878