Smokes your problems, coughs fresh air.

pg_safer_settings: dealing with PostgreSQL settings more … safely

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.

1 Comment

  1. Rowan Rodrik

    pg_safer_settings is now also available as a PGXN package: https://pgxn.org/dist/pg_safer_settings/

© 2024 BigSmoke

Theme by Anders NorenUp ↑