Thread #1383946 | Image & Video Expansion | Click to Play
File: 8d21738b589503a2e8c9892f1ba1e374.png (1.5 MB)
1.5 MB PNG
magnet:?xt=urn:btmh:1220b45acddd6ac1a3685184174e80f3496cb6c8bb2e314bea ea1d78d4fc24ee5d05
date: 2025-10-26
by: Avery
May contain deleted posts.
Negative IDs on the tags table mean the tag was listed in the post response, but its details aren't available through the gelbooru tags api.
Count of posts by Rating:
rating_name |post_count|
------------+----------+
Sensitive | 5595742|
General | 2682397|
Explicit | 2377926|
Questionable| 1571064|
Safe | 29|
Count of tags by type:
tag_type |total_tags|total_tag_usage|
----------+----------+---------------+
Artist | 506011| 11207081|
General | 323206| 351580251|
Character | 226270| 18247000|
Copyright | 49205| 18156724|
Deprecated| 2990| 33548549|
Metadata | 501| 20854199|
Explicit/Questionable to General ratio:
explicit_like_posts|general_posts|explicit_like_to_general_ratio|
-------------------+-------------+------------------------------+
3948990| 2682397| 1.47|
Schema:
CREATE TABLE posts (
id BIGSERIAL PRIMARY KEY,
...
);
CREATE TABLE tags (
id BIGSERIAL PRIMARY KEY,
name VARCHAR(255) NOT NULL,
count BIGINT NOT NULL DEFAULT 0,
type BIGINT NOT NULL DEFAULT 0,
ambiguous BIGINT NOT NULL DEFAULT 0,
CONSTRAINT unique_tag_name UNIQUE (name)
);
CREATE TABLE post_tags (
post_id BIGINT NOT NULL,
tag_id BIGINT NOT NULL,
);
Tag types:
General = 0
Artist = 1
Unknown = 2
Copyright = 3
Character = 4
Metadata = 5
Deprecated = 6
Tag rating:
Explicit = 0
General = 1
Questionable = 2
Safe = 3
Sensitive = 4
15 RepliesView Thread
Showing all 15 replies.>>
>>
>>
>>
>>
>>
>>
>>
>>
File: G7qk1hVW0AA2h2c.jpg (159.2 KB)
159.2 KB JPG
>>1387793
>>1388224
This is the metadata to go along with the media, so if you roll your own booru or whatever all the tags etc can be mass imported. It's a shame nothing worth a damn has mass import functionality and it's a shame people who make torrents either provide the media or the metadata but never both.
>>
>>
File: 1750856146820619.jpg (39.3 KB)
39.3 KB JPG
>>1389016
The OP has a description of the tag types. I haven't gone through the SQL file to say if it's a complete description or if there is other metadata like the source URL or the uploader's username.
This torrent is worth it if you combine it with torrents/scrapes of the media unless you want to manually tag everything. And this torrent's value increases as moralfag politicians keep cucking the internet and the pressure on Gelbooru's future slowly increases.
>>
What did people even do before Gelbooru? Were there other sites? Surely the cavemen drawing on stone walls in neolithic France one day dreamed of a repository such as Gelbooru, where they could gaze upon any beauty at any time. This torrent serves to fufill the wishes of our ancestors, archiving all things good to protect them from the moral police that threaten it.
>>