[MM3-users] Re: What database to choose for production deployment: Postgres or MySql

Brian Carpenter writes:

We came across a bug using MySQL with Mailman 3

I recall a problem reported that MySQL does not apply ordering to subqueries (this is conformant to the SQL standard, but other SQL databases, specifically Postgres and SQLite3 *do* apply ordering), and this resulted in subscriber lists that weren't alphabetized. Maybe that was your developer for Affinity who reported it?

I'm not sure if we fixed this in Mailman, and I don't think it's a problem for Postorius, only for direct access to the REST API.