Yet another PostgreSQL extension that emerged from the FlashMQ PostgreSQL backend is: pg_safer_settings. pg_safer_settings offers some functions and a mechanisms to make working with settings in PostgreSQL a bit safer. Its defining features are:
- easy access to database and role-level settings, bypassing session-local and transaction-local settings; and
- a type-safe configuration table pattern that allows for IMMUTABLE access to configuration values, and fine-grained access control.
pg_safer_settings is now also available as a PGXN package: https://pgxn.org/dist/pg_safer_settings/