tofumatt/mozillians — comment on commit a13faefdf9e296cba88596a6c155cf1631d962b5
File: apps/locations/models.py line 58
By ozten:

Instead of migrating all of the MySQL data to Postgres, this seems like a good place to partition data and handle referential integrity at the application layer.

Building on that... there are several other possibilities to consider:
1) Create geo spacial data in a second MySQL database, one which supports spacial indexes
2) Create a location data web service backed by Postgres and have Mozillians consume that WS. Other mozillia web apps would gain the ability to also reuse that data.

Option 1 would require adding multi-db routing code to this patch.

Option 2 could be done during a later release (much like the postgres migration would be a later release).