Database dump

This is a subset of the Danbooru PostgreSQL database.

THERE ARE NO IMAGES IN THIS DUMP.

Several tables and columns were dropped so you can't just restore this into a local copy of Danbooru and expect it to work.

It's 450MB. You'll have to restore it using pg_restore.

http://sonohara.donmai.us/danbooru-mini.dump

Thanks a lot, this should be very useful.

Is this intended to be updated periodically? If so what sort of cycle were you thinking of?

I've found that just dropping tables/columns is much faster than updating them so I can probably do this semi-regularly. But if you want to just profile different queries then this dump should be adequate for awhile because the distributions don't change much over the months.

Awesome, thanks. Could you sum up what has been dropped?

Also, it'd seem beneficial to have it content-encoded with gzip; right now it's going uncompressed, which is a silly waste of bandwidth and time.

@albert

Yeah I agree that the distributions don't change quickly enough to matter for most things. If the update cycle was once a month or two, that'd probably be sufficent for everything I have in mind right now.

If I really needed newer post data for the most recent month or so, the API should be able to handle that just fine.

@hazuki

If you try compressing the dump, it actually doesn't compress well at all. It looks like compression is already baked into Postgre's pg_dump and it looks like Albert has used it here.

Ah, right, my bad about confusing the formats.

Is it possible to get a new version of this?

Edit:
Actually... it doesn't look like I'll need it. So don't bother if it is a pain in the arse.

It's gone... Any chance we could get another dump? Or, does anyone happen to have the old one handy, at least?