Closed Bug 1571518 Opened 6 years ago Closed 6 years ago

[research] switch to Postgres

Categories

(Cloud Services :: Server: Location, task, P2)

Product:
Cloud Services
Component:
Server: Location
Type:
task

Tracking

(Not tracked)

Status:
RESOLVED INVALID

People

(Reporter: willkg, Assigned: ckolos)

Details

Ichnaea uses mysql 5.6 in stage/prod and 5.7 in local dev environment and CI. Further, it uses PyMySQL and mysql-connector-python. Further, early versions of MySQL have exciting support annoyances around TLS 1.0 and 1.1 support which have been tricky to work around.

Is Ichnaea doing anything that's unique to mysql? Can we switch to Postgres? If so, what's involved in switching? How does it affect SQLAlchemy models and existing alembic migrations?

This bug covers looking into switching to Postgres.

Making this a P2 to look into at some point.

Priority: -- → P2

Moving this to github. https://github.com/mozilla/ichnaea/issues/829

Status: NEW → RESOLVED
Closed: 6 years ago
Resolution: --- → INVALID
You need to log in before you can comment on or make changes to this bug.