🐘
PostgreSQL
Indexes, performance, UUIDs, ULID, and Postgres internals.
Benchmarking UUID v4 vs ULID
Benchmarking UUID against ULID.
UUID vs Serials
Benchmarking UUID and Serial Values in Postgres and Python.
Connecting Django to RDS via pgbouncer using IAM auth
Setting up the infra
We primarily use a django backend with RDS postgres in a kubernetes cluster for production environments. We were trying to setup an environment which would be HIPAA compliant and secure as well, as well as keep complexity to a minimum in the backend layer. We decided to go with IAM authentication to connect to RDS for the django application.
The tricky part was to figure out how we would add pgbouncer between RDS and django to manage connection pooling issues.
We setup a