Mentat

• thresholded events - Currently, the thresholding table in the database uses group name. Instead of that, a group ID could be used. The existing records in the database could be migrated by looking up an ID for a given group name.
• not reported events - The events to be reported are searched in the database by group name. The ID could be used instead of that, but that would make _Mentat/ResolvedAbuses much more difficult to comprehend. The idea I had was to store the list of the previous names of a group in the database and then search by this list as well. The previous names of a group are already kind of stored by changelogs_items table in the database, but this seems pretty annoying to parse.

Actually, I will look at the possibility of parsing the previous names from the changelogs_items table.

Rajmund Hruska wrote in #note-2:

Actually, I will look at the possibility of parsing the previous names from the changelogs_items table.

I found out that it's actually pretty easy to parse the name from the changelogs_items table.

Rajmund Hruska wrote in #note-2:

Actually, I will look at the possibility of parsing the previous names from the changelogs_items table.

I managed to write a function for searching the not reported events with old names of the groups.

So, what needs to be done next is to migrate events_thresholded table of mentat_events so it will use groupid instead of groupname. However, groups are stored in the mentat_main database, so cross-database query should be executed. I don't have any experience in cross-database querying but I found on the internet that postgres_fdw is the way to go. Radko Krkoš would you also recommend this approach or another one?