======== Database ======== .. image:: /admin/_images/database.png :align: center :alt: Database dialog In this dialog project database parameters are displayed. When they have been changed and OK button is clicked, the Application builder will check connection to the database and if it failed to connect an error will be displayed. .. note:: When any **Database** parameter is changed, except **DB manual update**, the server application must be restarted for changes to take effect. If **DB manual update** checkbox is unchecked (default), then when changes to an item, that have an associated database table, are saved, this database table is automatically modified. For example, if we add a new field to some item in the :doc:`Item Editor Dialog ` , the new field will be added to the associated database table. If this checkbox is checked, no modifications to the database tables are made. The **DB manual update** was renamed to **DB manual mode** in more recent version. .. note:: Please be very careful when using this option. Examples of database setups =========================== SQLite ------ .. image:: /admin/_images/SQLite_setup.png :align: center :alt: SQLite setup PostgreSQL ---------- .. image:: /admin/_images/postgres_setup.png :align: center :alt: PostgreSQL setup MySql ----- .. image:: /admin/_images/MySql_setup.png :align: center :alt: MySql setup FireBird -------- .. image:: /admin/_images/firebird_setup.png :align: center :alt: FireBird setup MSSQL ----- .. image:: /admin/_images/mssql_setup.png :align: center :alt: MSSQL setup Oracle ------ .. image:: /admin/_images/oracle_setup.png :align: center :alt: Oracle setup