Enabling the fuzzystrmatch extension in PostgreSQL with a Django migration#

The PostgreSQL fuzzystrmatch extension enables several functions for fuzzy string matching: soundex(), difference(), levenshtein(), levenshtein_less_equal(), metaphone(), dmetaphone() and dmetaphone_alt().

Enabling them for use with Django turns out to be really easy - it just takes a migration that looks something like this:

1
from django.contrib.postgres.operations import CreateExtension
2
from django.db import migrations
3

4

5
class Migration(migrations.Migration):
6

7
    dependencies = [
8
        ("core", "0089_importrun_sourcelocation"),
9
    ]
10

11
    operations = [
12
        CreateExtension(name="fuzzystrmatch"),
13
    ]