Closed Bug 897527 Opened 12 years ago Closed 12 years ago

Switch Air Mozilla from MySQL to PostgreSQL

Categories

(Webtools Graveyard :: Air Mozilla, defect, P1)

Product:
Webtools Graveyard
Component:
Air Mozilla
Platform:
x86
macOS
Type:
defect

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: peterbe, Assigned: peterbe)

References

Details

(Whiteboard: cm2)

To be able to use postgres's fulltext indices for search, we need to switch over to postgres.
Blocks: 897531
Priority: -- → P1
Whiteboard: cm2
Selena, It works! I'm able to run it locally and all 228 tests pass. (by the way, doing this work I learned that mysql doesn't support neither microseconds or timezone aware dates!) Here's why I need your help. Please see https://github.com/mozilla/airmozilla/pull/61 You don't need to merge it. Let's just discuss. The last three files are non-boring-django-stuff. https://github.com/mozilla/airmozilla/pull/61/files#diff-30 Does the README make sense? Is it correct the way I created all those `alter table ...` commands for converting every 'timestamp without time zone' column? If you're ok with this, I'm going to merge this to master, rope in some help from IT and proceed with this on dev.
Blocks: 895126
Depends on: 899267
Blocks: 905662
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
Assignee: nobody → peterbe
Product: Webtools → Webtools Graveyard
You need to log in before you can comment on or make changes to this bug.