Using MySQL’s LOAD DATA with Django

Thursday, January 23, 2020

While attempting to improve performance of bulk inserting data into MySQL database my coworker came across the LOAD DATA SQL statement. It allows you to read data from a text file (in a comma separated variable-like format) and quickly insert it into a table. There’s two variations of it …

read more →

Adding Two-Factor Authentication to Django (with django-allauth)” Lightning Talk

Thursday, April 6, 2017

A bit late on this article, but better late than never! Back on October 27th, 2016 I gave a talk at Django Boston entitled “Adding Two-Factor Authentication to Django (with django-allauth)”. It was a ~20 minute talk on integrating the django-allauth-2fa package into a Django project. The package (which I …

read more →

Combining Disparate QuerySets in Django

Thursday, February 4, 2016

Note: This was originally posted on the Strongarm Blog.

While refactoring we ran into a problem: we had different database tables that we needed to query over as if they were a single database table. We use Django as an ORM and needed to stay within the ORM …

read more →