feat(recommendations): create database interface

[azolus]

To realize user-personalized event recommendations, maevsi needs to provide a simple interface to get the relevant data for computations:

table 1:
event id, event name, event type (optional)

table 2:
user id, event id, rating

It would be desirable if i could dump all the available data simultaneously to set things up. incremental updates would also be useful for later

[dargmuesli]

Sure thing! You can already get event ids and names at https://postgraphile.maev.si/graphiql using the following query:

query allEvents {
  allEvents {
    nodes {
      name
      id
    }
  }
}

A similar query for "all contacts" is currently not possible as accounts are not part of the public database schema. So let's turn this issue into a task to make that data public!

[myyxl]

@azolus, I can help you getting the database data