Closed Bug 551571 Opened 15 years ago Closed 14 years ago

Store uploads in database instead of flat files on server

Categories

(Mozilla Labs Graveyard :: Test Pilot, defect, P1)

Product:
Mozilla Labs Graveyard
Component:
Test Pilot
Type:
defect

Tracking

(Not tracked)

Status:
RESOLVED DUPLICATE of bug 565379

People

(Reporter: jono, Assigned: jono)

Details

(Whiteboard: data, server, analysis)

It will be easier for the Metrics team to do analysis if we put the uploads into a SQL database instead of individual csv files in a directory (R can import directly from SQL for analysis). There is already a MySQL 5 server on testpilot.mozillalabs.com, so we just need to alter upload/index.php to parse the CSV and do an INSERT. There will have to be a table for each experiment (mimicing the schema of the firefox SQLite table that stores the data before upload); there will also have to be another table for metadata and survey answers. Because we don't have user IDs, we can just invent some kind of meaningless serial number used to do JOINs between these two tables.
Priority: -- → P1
Whiteboard: data, server, analysis
Target Milestone: 0.1 → --
We now have a tracking bug for the "new backend" project, which is 565379 , so I'm closing this bug as a duplicate.
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → DUPLICATE
Product: Mozilla Labs → Mozilla Labs Graveyard
You need to log in before you can comment on or make changes to this bug.