search

bsiegert / BulkTracker

Track bulk build status in pkgsrc
Other
8 stars 1 forks source link

SQL queries? #54

Open riastradh opened 2 months ago

riastradh commented 2 months ago

Can I do SQL queries against the bulktracker database, or can I download a snapshot to load into sqlite3 for my own queries?

bsiegert commented 2 months ago

The database is on mollari at /home/bulktrack/BulkTracker.db. You can try accessing it with a local SQLite binary.

riastradh commented 2 months ago

Thanks! Might be handy to expose a periodic compressed dump of the database somewhere/somehow. I fed sqlite3 BulkTracker.db .dump output through xz -c and the result is 57 MB (not counting any back doors I could stuff in the xz payload, of course!).