Setting default values for fields

Let’s say you want certain fields to have their values set automatically when not explicitly passed. You can do this in the following ways:

  • Postgres defaults: configure default values, using fixed values or simple SQL functions, for columns in the table definition. e.g. an auto-incrementing id, a created_at timestamp, etc.
  • Custom SQL functions: set up Postgres triggers which run custom SQL functions/stored procedures to set the values of certain columns on inserts/updates on the table. This is useful to set values of fields which depend on other fields passed in the input. e.g. set submission_time of an online quiz as 1 hour from the start_time.
  • Role based column presets: set up presets, using session variables or fixed values, that are applied when a new row is created with a particular user role. e.g. set a user_id field automatically from a session variable/Authorization header.