Databases and Support Services

These are the foundational services that support the entire platform.

DB AClimate v3 (PostgreSQL)

The main database of the platform, storing all climate and agroclimatic data including catalogs, observations, indicators, and configuration.

Responsibilities

• Store catalog entities (countries, crops, soils, indicators)
• Store climate observations and aggregated data
• Store indicator results and system configuration

Key functionalities detailed:

1. Main storage — Contains catalog information (countries, crops, soils, indicators).
2. Observations — Stores daily, monthly, and climatological climate data.
3. Indicators and configuration — Keeps indicator results and system parameters.

DB AClimate v3 Users (PostgreSQL)

Separate database for user information and access control, keeping user data isolated from the main climate data.

Responsibilities

• Store user information
• Store access control data
• Keep user data isolated from climate data

Key functionalities detailed:

1. User storage — Manages user accounts and profiles separately.
2. Access control — Stores permissions and access levels.