Question:
There is a server program for Windows and Linux, a mandatory part of which is a database. How to make a distribution kit for such a program? For Windows OS, you can offer to install a DBMS during installation, for Linux – add a package with a DBMS as a dependency. How to add a user, configure authorization in the database (for example, PostgreSQL requires settings to access it by login and password), deploy the database itself?
Answer:
If you are using a non-embedded DBMS (such as SQLite), then the DBMS itself is a prerequisite. The application distribution kit should not be involved in installing the DBMS. It is the responsibility of the administrator / user. In the installer, you ask for the server address, authentication data and the name of the base. The database itself should be created and configured automatically using scripts.