TIL — RLS on Postgres VIEWs

Views are useful for encapsulating commonly executed queries into a…

TIL — Conditionally enable a Terraform module

We can conditionally enable or disable a Terraform module for different environments using the count meta-argument.

variable "ENABLE_DB" { 
  type = bool
  default = true 
}

module "database" {
  source =…

TIL — Postgres v15 features

All roles in Postgres inherit from the Public role and, therefore, can create objects on the public schema. This is no longer the case with Postgres v15.

It removes the default CREATE privilege, which is a good security measure. Now, we no longer have to…