1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Using Views, Triggers, Stored Procedures and Routines
This guide details the features available for managing relational databases on hosting.
Use of Views, Triggers, Stored Procedures and Routines
Regarding the management of relational databases, the views ("views") feature is available by default, allowing users to create views to simplify data management and presentation.
However, some advanced features, such as…
- “triggers”
- 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.