Re: [Mailman-Developers] mailman 3 and mysql

On May 27, 2015, at 03:39 PM, Danil Smirnov wrote:
As I see on page https://pythonhosted.org/mailman/src/mailman/docs/DATABASE.html
Mailman 3 should work with MySQL/MariaDB database.
Well, that page is careful to say that SQLAlchemy, the ORM layer we use, is compatible with MySQL, but it doesn't claim that Mailman 3 actually is. Currently we only officially support SQLite and PostgreSQL. We test all the time with the former, and try to keep the latter functional (that will actually get better once our gitlab CI integration is working).
TL;DR: We want to be able to support any FLOSS database backend that SQLAlchemy supports, but we need contributions and testing for databases other than SQLite and PostgreSQL.
Cheers, -Barry

Hi Barry!
Thank you for your answer. I have another 2 questions. :)
Does this also relate to Postorius and HyperKitty db configuration set in file production.py? Can I use MySQL for them?..
What is better for production - to keep SQLite use or install PostgreSQL? The manual told me that I have to use 'full-blown database server' which is not true for SQLite I think?...
Danil
2015-05-27 16:28 GMT+03:00 Barry Warsaw <barry@list.org>:
On May 27, 2015, at 03:39 PM, Danil Smirnov wrote:
As I see on page https://pythonhosted.org/mailman/src/mailman/docs/DATABASE.html
Mailman 3 should work with MySQL/MariaDB database.
Well, that page is careful to say that SQLAlchemy, the ORM layer we use, is compatible with MySQL, but it doesn't claim that Mailman 3 actually is. Currently we only officially support SQLite and PostgreSQL. We test all the time with the former, and try to keep the latter functional (that will actually get better once our gitlab CI integration is working).
TL;DR: We want to be able to support any FLOSS database backend that SQLAlchemy supports, but we need contributions and testing for databases other than SQLite and PostgreSQL.
Cheers, -Barry
Mailman-Developers mailing list Mailman-Developers@python.org https://mail.python.org/mailman/listinfo/mailman-developers Mailman FAQ: http://wiki.list.org/x/AgA3 Searchable Archives: http://www.mail-archive.com/mailman-developers%40python.org/ Unsubscribe: https://mail.python.org/mailman/options/mailman-developers/danil%40smirnov.l...
Security Policy: http://wiki.list.org/x/QIA9
participants (2)
-
Barry Warsaw
-
Danil Smirnov