On 6/10/25 02:33, ad...@bclug.ca wrote:
I've been asked to give a presentation on a recent migration from MMv2 to MMv3 
and one of the items in my notes is the question about why Haystack is used for 
full-text searching instead of PostgreSQL?

Can someone shed some light on that decision?

The people who developed HyperKitty are no longer actively involved with Mailman and I can't speak with any authority about their design decisions.

That said, both Django and Mailman core support multiple databases including PostgreSQL, MariaDB, MySQL, Oracle and SQLite whereas Django's full text search relies on PostgreSQL specific features and without some custom implementation, which may not even be possible, would not allow other DBMs.

Haystack on the other hand provides a unified API that works with multiple backends. As far as I know, no one has developed a Haystack backend for PostgreSQL full text search, but as Sam notes in another reply, there are supported backends for Solr, ElasticSearch, Whoosh and Xapian.


--
Mark Sapiro <m...@msapiro.net>        The highway is for gamblers,
San Francisco Bay Area, California    better use your sense - B. Dylan

_______________________________________________
Mailman-users mailing list -- mailman-users@mailman3.org
To unsubscribe send an email to mailman-users-le...@mailman3.org
https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
Archived at: 
https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/message/NRH22I5C3RMHPSQHSU5DHGQFL6VK5KSG/

This message sent to arch...@mail-archive.com

Reply via email to