How do I add a record with this?

[SamuelBucher]

There doesn't seem to be any documentation on how one is supposed to work with this library. I can't figure out how to even create a record in my database with it.

[janKir]

This is a storage adapter for boardgame.io
If you set it up as documented, boardgame.io will take care of everything. This library is not designed to add any records by yourself.

[sridharraman]

Is there documentation on what are the tables and the structure? I was hoping to use this to add a Facilitator/Observer Dashboard to the game. It would be useful to know what information is stored in the tables.

[janKir]

Have a look here for the structure of the database: https://github.com/janKir/bgio-postgres/blob/main/src/entities/match.ts

For an example how to extend the database functionality, you can have a look here: https://github.com/wizard-online/wizard-online/blob/develop/src/server/index.ts

The PostgresStore from this package is wrapped by a custom ServerPostgres class that also implements the Async interface by bgio and adds custom tables to the database.

let db: StorageCache | undefined;
if (process.env.DATABASE_URL) {
  const postgres = new PostgresStore(process.env.DATABASE_URL!, {
    // fix SSL error https://stackoverflow.com/a/64960461
    dialectOptions: {
      ssl: {
        require: true,
        rejectUnauthorized: false,
      },
    },
  });
  const serverPostgres = new ServerPostgres(postgres);
  db = new StorageCache(serverPostgres);
  console.log("using postgresql storage");
}