search

mozilla / ssh_scan_api

An API for ssh_scan (https://github.com/mozilla/ssh_scan) and the backend API service for the Mozilla SSH Observatory (https://observatory.mozilla.org/)
31 stars 8 forks source link

make job queue db aware #2 #49

Closed hvardhanx closed 7 years ago

claudijd commented 7 years ago

Is there a specific reason we cannot create a schema that supports the queue and results in the same table?

Crude Example (just for example sake):

target, uuid, status (queued, running, complete), results, error, etc.

I'm suggesting this because it makes DB querying, status, and metrics a one-stop-shop.

hvardhanx commented 7 years ago

I haven't started working on it yet. I have just fixed the conflicts from @rishabhs95's pull request. I was also thinking to create a schema that supports the queue and results in the same table. I will fix this.

claudijd commented 7 years ago

FYI: I just killed the sqlite option for DB support, it's proving to be more of a burden than a help. We're structured well to add more DBs in the future or swap them out, but for now I just want to maintain one DB tech to reduce overhead. https://github.com/mozilla/ssh_scan_api/pull/57

claudijd commented 7 years ago

Superceded by #58