Open in app
Home
Notifications
Lists
Stories

Write
Bear Giles
Bear Giles

Home

Oct 26, 2021

Type-Safe PostgreSQL Functions Using User-Defined Composite Types

In the last article I discussed using user-defined ENUM types. In this article I’ll discuss using user-defined composite types to simplify the pgcrypto encrypt and decrypt functions. Installing the PGCrypto extension Before we proceed further we must install the pgcrypto extension since it contains the cryptographic functions we’ll be wrapping. …

Postgresql

5 min read

Type-Safe PostgreSQL Functions Using User-Defined Composite Types
Type-Safe PostgreSQL Functions Using User-Defined Composite Types

Oct 26, 2021

Type-Safe PostgreSQL Functions Using User-Defined Enum Types

There are ten types of people in the world. People who think in binary terms and everyone else. No, wait, I meant there are two types of developers. Those who love strong-typed languages and those who hate them. I’m definitely in the former group — it can be a pain…

Postgresql Tutorials

3 min read

Type-Safe PostgreSQL Functions Using User-Defined Enum Types
Type-Safe PostgreSQL Functions Using User-Defined Enum Types

Oct 25, 2021

Slightly Saner Server-Side Symmetric Encryption in PostgreSQL

This is the first of a series of articles on using advanced database techniques to hide the complexity of database encryption and improve its security. The focus is conceptual, not operational, with the hope that readers can apply some of these techniques to their databases. …

Postgresql

5 min read

Bear Giles

Bear Giles

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Knowable