Uploaded image for project: 'RAML Module Builder'
  1. RAML Module Builder
  2. RMB-425

Use computed columns, replace foreign key field triggers and basic columns

    XMLWordPrintable

Details

    • New Feature
    • Status: Blocked (View Workflow)
    • TBD
    • Resolution: Unresolved
    • None
    • None
    • CP: Roadmap backlog
    • Core: Platform

    Description

      Jon Miller writes on Slack #development:

      PostgreSQL 12 has some new features that could be useful for FOLIO. https://www.postgresql.org/about/news/1943/

      And it supports computed columns, which I'm thinking might be better than using triggers for things like the foreign key columns that are duplicated from the jsonb column.

      It would also be nice if computed columns were added that project some of the JSON properties. For example, it would be nice if the users table had computed columns for basic fields such as first, middle, last name, etc.

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                Unassigned Unassigned
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:

                  TestRail: Runs

                    TestRail: Cases