This guide details the features available for managing relational databases on Infomaniak hosting.

Use of Views, Triggers, Stored Procedures, and Routines

Regarding the management of relational databases, the view feature ("views") is available by default, allowing users to create views to simplify data management and presentation.

However, some advanced features, such as…

• "triggers"
• stored procedures ("stored procedures")
• routines
• and the creation of functions

… are only available on Cloud Servers.

These features allow for more precise and complex data manipulation, but they are not allowed on shared servers. This restriction is mainly due to 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 in question but also the experience of all clients hosted on the same infrastructure.