Abandon (experimental) Postgres Support

1 Reasons to Abandon Feature

Since the introduction of Postgres support, it has been classified as experimental. Unfortunately, the feature has never left this state. For a certain period of time, a person from the community had taken care of the support of Postgres, but unfortunately the Technical Board can no longer reach this person. In addition, we want to orient the use of the database in ILIAS towards future requirements and conversions and see an advantage in only supporting MySQl/MariaDB.
I propose this request as maintainer but also in consultation with the Technical Board.

2 Technical Information

Practically no cosumer code is affected by the abstraction layer. The following classes and their use are removed:

• Services/Database/classes/QueryUtils/class.ilPostgresQueryUtils.php
• Services/Database/classes/PDO/class.ilDBPdoPostgreSQL.php
• Services/Database/classes/PDO/FieldDefinition/class.ilDBPdoPostgresFieldDefinition.php
• Services/Database/classes/PDO/Manager/class.ilDBPdoManagerPostgres.php
• Services/Database/classes/PDO/Reverse/class.ilDBPdoReversePostgres.php

3 Contact

• Author of the Request: Schmid, Fabian [fschmid]
• Maintainer: none (Coordinator Schmid, Fabian [fschmid])
• Implementation of the feature is done by: Schmid, Fabian [fschmid]

4 Funding

Removing the feature from the ILIAS code base might need funding. If you are interest in funding this request, please add your name and institution to this list.

• ...

5 Discussion

Use the following discussion section to express your objections against this request or your consent to get rid of this feature.

JourFixe, ILIAS [jourfixe], 07 FEB 2022 : We accept to discuss the feature request Abandon (experimental) Postgres Support already for version 8 and to remove - if accepted - related code from ILIAS with the next ILIAS version. FR shall be discussed on one of the next JF to give Fabian enough time to remove code until coding completed.

JourFixe, ILIAS [jourfixe], 21 FEB 2022 : We accept to abandon PostgreS support with ILIAS 8.

JourFixe, ILIAS [jourfixe], 21 FEB 2022 : We accept to abandon PostgreS support with ILIAS 8.

6 Implementation

The relevant Code in ILIAS 8 has been removed, Installations with Postgre-SQL won't be able to update to ILIAS 8. There is a configuration-check in ilDatabaseConfigStoredObjective which will abort the update with a NotExecutableException.

Removal of code in: https://github.com/ILIAS-eLearning/ILIAS/commit/ca387f258889e2c94387ae601affdb7d5af4c024

Removed Testcases

The following testcases have been removed from Testrail or modified because the feature is no longer part of the ILIAS core.

• No Testcases for Postgres were available in Testrail

Approval

Approved at 27.05.2022 by Schmid, Fabian [fschmid].