---
title: "Database Overview"
slug: "database-overview"
updated: 2024-09-17T10:34:23Z
published: 2024-09-17T10:34:23Z
canonical: "help.hyperscience.ai/database-overview"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.hyperscience.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Database Overview

## Database setup

Follow the instructions for the type of database you'll be connecting to the application:

- [Oracle](/deployment/docs/oracle)
- [PostgreSQL](/deployment/docs/postgresql)
- [MSSQL](/deployment/docs/mssql)

> [!NOTE]
> Note that PostgreSQL and MSSQL are the recommended database options. While we do support the use of Oracle, it is the least used option, and we may remove support for it in the future if usage decreases.

For a list of supported versions, see [Infrastructure Requirements (Production)](/deployment/docs/infrastructure-requirements).

## Database notifications configuration (optional)

Workers notify each other using a database provided notification mechanism. With big clusters, this can put unnecessary high load on the database.

To replace the notification mechanism with polling, add:

```bash
JOBQUEUE_POLLING_SEC=8
```

A positive value means the number of seconds to sleep between polls. A value of 0 means notifications through the database.

Recommended values:

1. For clusters up to 2 machines: 0
2. For clusters of 3 or more machines: the number of machines.

## Pooling database connections (optional)

In v28.3.3+ and v30.0.5 and later, you can pool database connections by adding the *FORMS_DB_CONN_MAX_AGE* variable to your ".env" file. The variable's value is the maximum number of seconds that database connections are kept and reused.

In the example below, database connections are retained and reused for up to 10 hours:

```bash
FORMS_DB_CONN_MAX_AGE=36000
```