Examples

Example: parsing SQL commands

Shows how to use a Java library to parse SQL commands and modify them on the fly if needed.

Example: change data in credit card applications

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.

Example: insert data into empty Mongo result set

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 and AWS Secret Manager.

Example: matching queries with a regular expression

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

Example: writing directly to a file

Shows how to open a file in the file system and write to it. Includes how to have rolling log file.

Example: watermarking bitmaps

Shows how to dynamically edit a bitmap when it is retrieved from the database.

Example: modifying PDF documents

Shows how to dynamically change the metadata in a PDF document stored in the database, and how to add a watermark to all pages.