Use Views, Triggers, Stored Procedures and Routines

This guide details the features available in relational database management on accommodation Infomaniak.

Using Views, Triggers, Stored Procedures and Routines

With regard to the management of relational databases, the functionality of the views (VIEWS) is available by default, allowing users to create views to simplify data management and presentation.

However, some advanced features, such as triggers, procédures stockées, routines and the création de fonctions, are only available on Cloud Servers These features allow for finer and more complex manipulation of data, but they are not allowed on shared servers.

This restriction is mainly due to the potential risks to the stability of the infrastructure. Poor configuration or excessive use of these features could create infinite loops or significant overloads, affecting not only the performance of the server concerned, but also the experience of all clients hosted on the same infrastructure.