Howdy Logo
Glossary Hero image

The Howdy Glossary

Search terms in Glossary

Sql/psm

SQL/PSM, as a combination of SQL and PSM (Persistent Stored Modules), provides a standard for programming in SQL databases. This extension adds procedural programming features to the Structured Query Language, enabling developers to create complex applications directly within the database server environment. The concept was first introduced by the ISO as an addition to their SQL standardization effort with the intention of streamlining and simplifying how programs interact with databases. In essence, it allows users to create functions and triggers within an individual database schema using SQL statements. With these capabilities, complex logic can be encapsulated for reuse without having to extract data from a database into another language's runtime environment for processing.

Back
Hire Sql/psm Experts

Enter your email to get started.