/* Code Comments */4 posts tagged with "constraint"
typescript: constraining allowed keys in an object with string literals
2022-11-28
|~2 min read
|242 words
I was working on a project recently where I wanted to check incoming data to see if it conformed to my allow list. To do this, I had an…
adding a unique constraint to postgres tables after creation
2022-11-28
|~3 min read
|409 words
How do you add a unique constraint to a table in Postgres if it’s already been created? Most of the time, we add unique constraints to a…
postgres constraints and arrays
2022-11-28
|~2 min read
|277 words
I wrote in the past about using constraints in the context of array operators in Postgres. Today, however, I didn’t have a pre-defined array…
array intersection in postgres
2022-11-28
|~2 min read
|322 words
Recently, I was building an API to modify the data in a database. The field I was modifying happened to be an array, and I wanted to make…