Smokes your problems, coughs fresh air.

pg_role_fkey_trigger_functions: establishing and maintaining foreign key-like relationships to database ROLEs

Another release from the long list of PostgreSQL extensions that I’m splitting off from the database schemas that make up our rock-solid MQTT hosting platform issss: pg_role_fkey_trigger_functions. That extension name is quite the mouthful. From its readme (again courtesy of pg_readme):

The pg_role_fkey_trigger_functions PostgreSQL extension offers a bunch of trigger functions to help establish and/or maintain referential integrity for columns that reference PostgreSQL ROLE NAMEs.

Many extensions are yet to come, because I’ve found that dependencies in themselves aren’t bad, as long as they are used side by side, and not needlessly stacked on top of each other. That they are no longer 100% internal to the migrations belonging to the app doesn’t worry my, because:

  1. I still maintain them myself anyway, and
  2. the migrations can (and will) use specific extension versions, so that, in fact, no control and cohesion is lost, even while some decoupling and modularity is being won.

1 Comment

  1. Rowan Rodrik

    Version 0.9.2 of pg_role_fkey_trigger_functions is now also on PGXN: https://pgxn.org/dist/pg_role_fkey_trigger_functions/

    Most of the changes compared to version 0.9.1 are documentation improvements and changes related to the packaging for PGXN.

    I’m getting closer and closer to being done with refactoring a lot of the migration-managed structures that underlie our scalable MQTT hosting service into PostgreSQL extensions.

© 2024 BigSmoke

Theme by Anders NorenUp ↑