Neptune DXP Documentation
Neptune DXP - Open Edition · 24.14 LTS

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:

  1. Configure your database in System Settings → Database.

  2. Restart Neptune DXP - Open Edition.

  3. Continue with further configurations.

Microsoft SQL Server

See Microsoft SQL setup for Neptune DXP - Open Edition

PostgreSQL

  1. Create a new database.

  2. 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.