SQL queries?

[riastradh]

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

[bsiegert]

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

[riastradh]

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!).