#tech

Posts tagged with "tech"

Django Bulk Save - 2 Fast 2 Big

Django Bulk Save - 2 Fast 2 Big

· 2 min read

Continuing from Django Bulk Save, I wanted to test how would the copy_from function perform when I scale to over a million records. The copy_from scales incredibly well, it took 4 seconds to write 1.6 million rows. The rest of the article strays away from the actual topic. I decided to play around with different CSV libraries and figure out what would be the most efficient library to use when you have a file this large. You'd probably never encounter a scenario where you'd have to parse a mil
tech django
Streaming through millions of records trying to match an encrypted field : Java

Streaming through millions of records trying to match an encrypted field : Java

· 3 min read

A year ago I was working on a really tiny part of a large non-consumer facing product (idk what's the correct term). I can't divulge much, I have done a lot of illegal things like calling a politician an idiot on social media, so I don't want to add more to the list. Imagine you ran an ice cream subscription service, and you had a lot of people on the payroll tasked with managing renewals for subscribers. Let's call them agents. You had an online portal for customers to manage/renew their subsc
tech java spring batch
Connecting Django to RDS via pgbouncer using IAM auth

Connecting Django to RDS via pgbouncer using IAM auth

· 3 min read

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
devops tech django pgbouncer kubernetes aws