> How sensible is the data stored in the DB? Too much to be made public?

Yeah, I wondered the same. Could we sanatize any user auth/account data
and just make the raw posts of all the public lists available?

Hmm, There's the issue of people's email addresses, it could become a gold mine for spammers.
The export could replace those with the UUID that Mailman generates for each user though, but that won't work for the email that was imported from Mailman2 (unless the sender sent a mail though Mailman3 later).

I know HyperKitty's REST API should be improved anyway, though :-)

 
> Otherwise if it's for a one-off we could see to either let one of
> sysadmin-main run the script or provide a DB dump to one person but I
> guess this isn't quite sustainable if it's a regular script to run.
> IIRC, so far I think somone in sysadmin-main ran the script when
> needed.

We do have a process for database dumps... they have to get 2 +1's from
sysadmin-main folks and get dumped out by one of them and given to the
person. So we could do that short term.

My understanding is that Matt wants to do this analysis periodically to get usage statistics and tendencies.

A.