Database configuration for Neptune DXP - Open Edition

All data, ranging from your configuration, apps, and application data, is kept in the Neptune DXP - Open Edition database.

Neptune DXP - Open Edition supports the following databases:

Microsoft SQL Server
PostgreSQL
SQLite

By default, the embedded SQLite database is configured and used. SQLite is suited to evaluation and development. For a production setup, use Microsoft SQL Server or PostgreSQL.

Neptune does not recommend SQLite for production.

The data from your previously installed Neptune DXP - Open Edition database is deleted during the installation process of the new Neptune DXP - Open Edition version. Perform the following steps to avoid deletion of your data:

Configure your database in System Settings → Database.
Restart Neptune DXP - Open Edition.
Continue with further configurations.

PostgreSQL

Create a new database.
Create the planet9 schema.

CREATE DATABASE planet9;

CREATE SCHEMA planet9;

On initialization, Neptune DXP - Open Edition creates all the needed tables under this schema.

SQLite

There are no further preconditions for using the SQLite database.