Database

7 Articles

Database Overview

Published on Sep 17, 2024

Database setup
Follow the instructions for the type of database you'll be connecting to the application:
Oracle
PostgreSQL
MSSQL
Note that PostgreSQL and MSSQL are the recommended database options. While we do support the use of...

MSSQL

Updated on Mar 26, 2026
Published on Sep 17, 2024

Hyperscience supports the following implementations of MSSQL:
On premise
For a list of supported MSSQL versions, see Infrastructure Requirements (Production).
Azure SQL Managed Instance
Supported in Hyperscience v28 and ...

MSSQL Server - Windows Authentication

Updated on Feb 25, 2026
Published on Oct 29, 2025

This feature is supported for Docker and Podman deployments running v42 or later. It is not supported for Kubernetes deployments.
Microsoft offers two authentication methods for MSSQL databases: SQL Server authentication and Windows authentication.

PostgreSQL

Published on Sep 17, 2024

Configuring Hyperscience for PostgreSQL
For a list of supported versions, see Infrastructure Requirements (Production).
Add the following variables to your ".env" file:
FORMS_DB_TYPE=postgres
FORMS_DB_HOST=

Oracle

Updated on Oct 21, 2025
Published on Sep 17, 2024

For a list of supported versions, see Infrastructure Requirements.
Note that the standard convention for Oracle DB names includes the host in front of it so you must include that in the ".env" file:
FORMS_DB_TYPE=oracle
FORMS_DB_HOST=

Retrieving Data From a Replica Database

Updated on Oct 7, 2025
Published on Sep 26, 2025

This feature is available in v42 and later.
In v42 and later, you can set up a replica database to read reporting and audit-log data in on-premise instances.
Doing so prevents system latency and timeouts when attempting to retrieve these kinds of...

Checking Database Connectivity

Published on Mar 25, 2026

This feature is available in v42.3 and later.
If your instance's database connection is unstable, you can configure the system to check the status of the database connection at the beginning of each HTTP request.
If the connection is broken, the ...