Shows how to easily modify specific data items without changing the database or the database clients. In this scenario, we have a number of applications retrieving data from the database, and we need to change a country name to comply with unexpected political changes.

Shows how to fetch up-to-date currency rates and use them to convert prices in result sets on the fly.

Focuses on the different ways your logic can determine what to do.

Shows ways of converting between data types.

Shows how to encrypt an attribute for certain objects and decrypt it whenever it gets accessed. This is an advanced example which requires some familiarity with Java.

Shows how to use a Java library to create an Excel file with metrics collected by the metrics code filter for Postgres.

Shows how to detect that a query is returning an empty result set, and how to add objects to that result set.

Example: using secrets

Shows how to retrieve secrets such as keys and passwords from an external service such as Kubernetes Secrets, Azure Key Vault or AWS Secret Manager.

Shows how to build a regular expression to match a variety of SQL queries.