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.
Example: convert currency on the fly
Shows how to fetch up-to-date currency rates and use them to convert prices in result sets on the fly.
Example: hide some customers
Focuses on the different ways your logic can determine what to do.
Example: manipulating data
Shows ways of converting between data types.
Example: transparent encryption/decryption
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.
Example: writing metrics to an Excel file
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.