Page History

Central storage for operational Forecast data. One instance per Master Controller. 

Minimum requirements

• Follow database vendor requirements for memory and CPU requirements.
• 4 GB RAM for the database server is required for a small FEWS instance with less than 5 users. 8 GB or more for larger systems.
• The database instance(s) can be hosted on an existing database server or cluster.
• See also Database connection count calculator

The Delft-FEWS client-server system is known to run with the following database versions:

Oracle

• Oracle 12c, 18c, 19c
• See (see https://support.oracle.com/knowledge/Oracle%20Database%20Products/742060_1.html)

PostgreSQL

• PostgreSQL 11, 12
• See (see https://endoflife.date/postgresql)
• The maximum size for PostgreSQL database fields in Delft-FEWS is 1 GB. As a result all big files such as Module config files and ColdStates must respect this limit. WarmStates exceeding this size can be stored externally on the file systemAt least enough memory to hold the largest uploaded moduleInstanceDataset twice.

SQLServer

• MS SQL Server 2012 / 2014 / 2016 / 2019.
• Managed instances are possible (, but In-Memory OLTP is required, see https://learn.microsoft.com/en-us/azure/azure-sql/in-memory-oltp-overview?view=azuresql.
• See https://endoflife.date/mssqlserver)
• The maximum size for SQLServer database fields in Delft-FEWS is 2 GB. As a result all big files such as Module config files and ColdStates must respect this limit. WarmStates exceeding this size can be stored externally on the file system.