Tag: pg_safer_settings

Since my initial announcement here of pg_safer_settings, my extensions for safe (through per-column GRANTs), fast (through IMMUTABLE, auto-(re)generated accessor functions) settings has matured quite a bit, and is now at version 0.8.12.

Soon, later this month, still in the first quarter of 2024, I expect to release the first officially stable 1.0 version…

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:

1. easy access to database and role-level settings, bypassing session-local and transaction-local settings; and
2. a type-safe configuration table pattern that allows for IMMUTABLE access to configuration values, and fine-grained access control.