Freika/dawarich 0.21.0 on GitHub

⚠️ This release introduces a breaking change. ⚠️

The dawarich_db service now uses a custom postgresql.conf file.

As @tabacha pointed out in #549, the default shm_size for the dawarich_db service is too small and it may lead to database performance issues. This release introduces a shm_size parameter to the dawarich_db service to increase the size of the shared memory for PostgreSQL. This should help database with peforming vacuum and other operations. Also, it introduces a custom postgresql.conf file to the dawarich_db service.

To mount a custom postgresql.conf file, you need to create a postgresql.conf file in the dawarich_db service directory and add the following line to it:

  dawarich_db:
    image: postgres:14.2-alpine
    shm_size: 1G
    container_name: dawarich_db
    volumes:
      - dawarich_db_data:/var/lib/postgresql/data
      - dawarich_shared:/var/shared
+     - ./postgresql.conf:/etc/postgresql/postgresql.conf # Provide path to custom config
  ...
    healthcheck:
      test: [ "CMD-SHELL", "pg_isready -U postgres -d dawarich_development" ]
      interval: 10s
      retries: 5
      start_period: 30s
      timeout: 10s
+   command: postgres -c config_file=/etc/postgresql/postgresql.conf # Use custom config

To ensure your database is using custom config, you can connect to the container (docker exec -it dawarich_db psql -U postgres) and run SHOW config_file; command. It should return the following path: /etc/postgresql/postgresql.conf.

An example of a custom postgresql.conf file is provided in the postgresql.conf.example file.

Added

A button on a year stats card to update stats for the whole year. #466
A button on a month stats card to update stats for a specific month. #466
A confirmation alert on the Notifications page before deleting all notifications.
A shm_size parameter to the dawarich_db service to increase the size of the shared memory for PostgreSQL. This should help database with peforming vacuum and other operations.

  ...
  dawarich_db:
    image: postgres:14.2-alpine
+   shm_size: 1G
  ...

In addition to api_key parameter, Authorization header is now being used to authenticate API requests. #543

Example:

Authorization: Bearer YOUR_API_KEY

Changed

The map borders were expanded to make it easier for New Zealanders to scroll around the map.
The dawarich_db service now uses a custom postgresql.conf file.
The popup over polylines now shows dates in the user's format, based on their browser settings.

🎄Christmas disclaimer: 🎄

The holidays are ahead of us, so please expect slower responses and fixes. Things should return to their normal pace by the end of January 2025. Meanwhile, give yourself a well-deserved rest and enjoy your time with significant people. Eat some salads, build a snowman if you have snow in your area, and feel that holiday spirit.

Happy holidays!

💙 This release is supported by Steven B., James Manolios, chenrik, aldumil and Arne Schwarck on Patreon 💙

What's Changed

Add buttons to recalculate month and year stats independently by @Freika in #567
Support API key in Authorization header by @Freika in #568
Add a custom postgresql.conf file to the dawarich_db service by @Freika in #569
Update map popup to format dates with the locale from the browser by @whimsical-c4lic0 in #564

Full Changelog: 0.20.2...0.21.0