@socialgouv/matomo-postgres

@socialgouv/matomo-postgres

Extract matomo data from Live.getLastVisitsDetails API and push events and visits informations to Postgres.

Use pg_partman to partition data by month.

Usage

Create the initial table database table then run the following job with correct environment variables.

npx @socialgouv/matomo-postgres

Environment variables Deployment

name	value
MATOMO_KEY*	matomo api token
MATOMO_SITE*	matomo site id
MATOMO_URL*	matomo url
PGDATABASE*	Postgres connection string
DESTINATION_TABLE	matomo
STARTDATE	default to today()
RESULTPERPAGE	matomo pagination : 100
OFFSET	default days to check in the past; default = 3

Dev

docker-compose up
export MATOMO_URL=
export MATOMO_SITE=
export MATOMO_KEY=
export DESTINATION_TABLE= # optional
export STARTDATE= # optional
export OFFSET= # optional
export PGDATABASE=postgres://postgres:postgres@127.0.0.1:5455/postgres
yarn start

Use yarn test -u to update the snapshots