This 7zip archive has two SQLite3 databases, containing large parts of Ponibooru's metadata (not images, they're available elsewhere).

pb_archive.sqlite contains comments, faves, users and basic image information. It's biggest drawback is inaccurate timestamps. For some reason, the only timestamps in the HTML files were dates, but no times. This means it's impossible to fully know when a certain comment was posted. It was created by me back in 2014, using a C++11 program that performed basic HTML parsing (no, it didn't use regexps) to extract everything from the HTML files and insert them into an SQLite database.

meta.sqlite contains detailed information about each image, like width and height, MD5 hash and an exact timestamp (in unknown timezone; probably Pacific Time Zone because IIRC that's what Ponibooru used) when the image was uploaded. I do not know where this database comes from, I didn't create it (if I did create it, I cannot track down the source for the data, nor the program that created it). It contains data that isn't available in the HTML files. I have a hunch that a Derpibooru user called jspenguin created it; after all, he created the gigantic HTML archive ZIP I used to build pb_archive.sqlite3. I don't know why I didn't merge the full medata from meta.sqlite with pb_archive.sqlite.

A few words about image tags. They're not easily searchable in their current form. If someone wants to perform proper Derpibooru-style searches over them, you have to parse them into "tags" and "image_taggings" -style tables (see Derpibooru's database dump schemas), then load them into ElasticSearch (or similar) and add a some kind of a query parser/converter on top of it.

Have fun!

--------------------------------------------------------------------------------------------

pb_archive.sqlite3 contains four tables:

    comments
    faves
    images
    users

Their structure is as follows (forgive me any weird things in them, I had only basic SQL knowledge when I made them):

CREATE TABLE comments(
    id INTEGER PRIMARY KEY,
    image INTEGER,
    user INTEGER,
    date TEXT,
    comment TEXT,
    FOREIGN KEY(image) REFERENCES images(number),
    FOREIGN KEY(user) REFERENCES users(id)
);

CREATE TABLE faves(
    user INTEGER,
    image INTEGER,
    FOREIGN KEY(user) REFERENCES users(id),
    FOREIGN KEY(image) REFERENCES images(number)
);

CREATE TABLE images(
    number INTEGER PRIMARY KEY,
    uploader INTEGER,
    date TEXT,
    FOREIGN KEY(uploader) REFERENCES users(id)
);

CREATE TABLE users(
    id INTEGER PRIMARY KEY,
    name TEXT UNIQUE
);

--------------------------------------------------------------------------------------------

meta.sqlite contains only one table, "images":

CREATE TABLE images(
    id INTEGER PRIMARY KEY,
    md5sum TEXT,
    type TEXT,
    uploader TEXT,
    tags TEXT,
    source TEXT,
    rating TEXT,
    date TEXT,
    origfn TEXT,
    w INTEGER NOT NULL DEFAULT 0,
    h INTEGER NOT NULL DEFAULT 0,
    size INTEGER NOT NULL DEFAULT 0,
    filename TEXT, sel INTEGER
);

- END -
