@socialgouv/matomo-postgres
Advanced tools
Extract matomo data from Live.getLastVisitsDetails API and push events and visits informations to Postgres.
Create the initial table database table then run the following job with correct environment variables.
npx @socialgouv/matomo-postgres
| 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 (defaults to 500) |
| INITIAL_OFFSET | How many days to fetch on initialisation (defaults to 3) |
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
yarn migrate is run on each yarn start with Kysely migrations at ./src/migrations
FAQs
Extract visitor events from Matomo API and push to Postgres
The npm package @socialgouv/matomo-postgres receives a total of 1,523 weekly downloads. As such, @socialgouv/matomo-postgres popularity was classified as popular.
We found that @socialgouv/matomo-postgres demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 2 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Deno 2.2 enhances Node.js compatibility, improves dependency management, adds OpenTelemetry support, and expands linting and task automation for developers.
Security News
React's CRA deprecation announcement sparked community criticism over framework recommendations, leading to quick updates acknowledging build tools like Vite as valid alternatives.
Security News
Ransomware payment rates hit an all-time low in 2024 as law enforcement crackdowns, stronger defenses, and shifting policies make attacks riskier and less profitable.