All geek questions in one place

Examples of complex real-world examples or situations resolved using stored procedures

I am currently working on acquiring various relevant skills to master the database. I just finished reading stored procedures and wondered how this can be applied to real world situations, if any.

Hope someone can list a number of complex problems in the real world / Internet that are resolved or require resolving with stored procedures. Any web books / list of resources with a lot of such problems in the real world or complex examples will be welcome.

+3
source share
2 answers

Above my head:

  • Advanced data operations (data analysis, unpacking binary data)
  • Moving charted data
  • Failure of the physical data model
  • Security (most databases have crude mechanisms for checking SELECT)
  • Flexible / extensible API design.

I will not say "performance" because typical examples in textbooks are equally fast with a prepared expression.

+1
source

Almost any batch procedure, where there is a lot of processed data, and you do not want a lot of "back and forth" between the application server or the client application and the database.

, , . , -, , .

0

Source: https://habr.com/ru/post/1782149/

More articles:


All Articles