To make it easier for developers and analysts to access the information they want from the site, we are planning to offer database dumps for our public-facing data.1
Though this could change in the future, currently the plan is to offer nightly dumps in the PostgreSQL custom dump format. This will make it easy for anyone who wants to use the data to simply restore the dump and have a fully operational schema with indices and foreign key constraints. In addition, these dumps will be consistent and represent a perfect snapshot of the database at the time they are taken.
We would like to know from the community what data would be most useful to include in these dumps. Please comment below with the data you would like and your usecase for it, or any questions you may have.
1: We will not be offering any data that may deanonymize background ponies, or that would otherwise be considered personally identifying information. |
Help fund the $15 daily operational cost of Derpibooru - support us financially!