maevsi / sqitch

maevsi's database migrations.
https://maev.si
1 stars 3 forks source link

feat(recommendations): create database interface #29

Open azolus opened 1 year ago

azolus commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

@azolus, I can help you getting the database data