977354 - Move areweslimyet.com to PostgreSQL

Status: NEW

(Testing :: General, defect)

Description

[John Schoenick [:johns]]

[ Filing this in bugzilla since its relevant to other B2G awsy work tracked here. ]

AWSY's backend uses sqlite to store data. When I wrote it, we were getting maybe hundreds of lines per build, run once per m-c push. Now we run two, soon to be three, tests on every m-i push and the return tens of thousands of lines. The AWSY tester is soon going to be bottlenecked on inserting results into the DB.

We don't run any complicated queries, so changing to PgSQL should just be a matter of setting it up and changing the connect-to-db scripts. The partition-sqlite-by-month maintenance script would also need to be changed.