Closed Bug 1361394 Opened 5 years ago Closed 4 years ago

[tracker] Simplify and clean up postgresql schema


(Socorro :: Database, task)

Not set


(Not tracked)



(Reporter: adrian, Unassigned)



Our current database schema is huge and has a lot of obsolete data. The deprecation rampage removed the need for many tables, stored procedures and matviews. 

We want to audit our database to figure out exactly which elements we actually use at the moment, remove the rest, and then see if it's possible to simplify it even further.
Depends on: 764672
Depends on: 1375421
Depends on: 1375422
Depends on: 1375426
Depends on: 1375431
Depends on: 1375434
Depends on: 1257531
No longer blocks: 1314814
Assignee: adrian → nobody
Depends on: 794524
Depends on: 828711, 1133779
Depends on: 137, 5421, 839530
No longer depends on: 1375421
Depends on: 1390847
Depends on: 1231672
Depends on: 1394800
Depends on: 1394909
No longer depends on: 1439019
No longer depends on: 1435071
Update on this project--we still want to do the following things:

1. Drop ADI and all the related things from Socorro. This covers some stored procedures, a bunch of tables, and some crontabber jobs.

2. Write a new product/version/build info acquiring system that's based on Buildhub and retire ftpscraper. This will let us remove a swatch of stored procedures and tables.

3. Move whatever's left from alembic/sqlalchemy land to Django land.

At that point, the webapp owns the database and we can use Django's tools to manage it. This will let us drop a ton of code. We'll be in a much better spot going forward.
Depends on: 1369498, 1366301
Summary: [tracker] Simplify postgresql database schema → [tracker] Simplify and clean up postgresql schema
No longer depends on: 5421
No longer depends on: 137
We should still rewrite crontabber, but otherwise this is done. Marking as FIXED.
Closed: 4 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.