A Django migration to add PostgreSQL trigram search, aka pg_trgm

trigram_migration.py

# -*- coding: utf-8 -*-
# XXX this is actually useful for very special use cases, e.g. misspel suggestions:
#  https://www.postgresql.org/docs/9.6/static/pgtrgm.html#AEN180626
from __future__ import unicode_literals

from django.db import migrations
from django.contrib.postgres.operations import TrigramExtension

class Migration(migrations.Migration):
    operations = [
        TrigramExtension(),
        migrations.RunSQL(
            'create index trgm_idx on polls_poll '
            'using gin (text gin_trgm_ops);',
            reverse_sql='drop index trgm_idx;'
        ),
    ]