I have a large collection of porn (~6TB) I'd like to organize

Thread replies: 7
Thread images: 1

Anonymous
2016-10-09 17:33:15 Post No.
[Report]

File: timthumb_php.jpg (310KB, 1500x1500px)

Anonymous 2016-10-09 17:33:15 Post No. [Report]

I have a large collection of porn (~6TB) I'd like to organize in a database.

What would be the best way to go about doing this? I have the following outline (that’s probably extremely erroneous), and I want to make sure that I don't have conflicting data. Yes, I'm a n00b at databases.

Tags
    Tables:
        [Tags]
        tag_id      SMALLINT[3] U, PK
        tagname     VARCHAR[64]

JAV
    Tables: [Vendor]
        id_num        VARCHAR[8] PK
        actresses     VARCHAR[64]
        genre         VARCHAR[16]
        resolution    SMALLINT[4] U
        path          VARCHAR[256] NN
        description   MEDIUMTEXT

Western
    Tables: [Video]
        title          VARCHAR[64] PK
        studio         VARCHAR[64]
        actresses      VARCHAR[64]
        genre          VARCHAR[16]
        resolution     SMALLINT[4] U
        path           VARCHAR[256] NN
        description    MEDIUMTEXT

        [Imagesets]
        title         VARCHAR[64] PK
        num_of_images SMALLINT[4] U
        actresses     VARCHAR[128]
        resolution    SMALLINT[4] U
        path          VARCHAR[256] NN
        description   MEDIUMTEXT

Hentai
    Tables: [Animated]
        title          VARCHAR[64] PK
        studio         VARCHAR[64]
        genre          VARCHAR[16]
        resolution     SMALLINT[4] U
        path           VARCHAR[256] NN
        description    MEDIUMTEXT  
        
        [Drawn]
        title          VARCHAR[64] PK
        artist         VARCHAR[64]
        genre          VARCHAR[16]
        resolution     SMALLINT[4] U
        path           VARCHAR[256] NN
        description    MEDIUMTEXT

Anonymous 2016-10-09 17:35:51 Post No.56998547
[Report]

Anonymous 2016-10-09 17:35:51 Post No.56998547 [Report]

>>56998512
https://en.wikipedia.org/wiki/Database_normalization

Read it.

Anonymous 2016-10-09 17:41:27 Post No.56998627
[Report]

Anonymous 2016-10-09 17:41:27 Post No.56998627 [Report]

>>56998512
I want to be that guy

Anonymous 2016-10-09 17:42:00 Post No.56998635
[Report]

Anonymous 2016-10-09 17:42:00 Post No.56998635 [Report]

You don't need different tables for Hentai, Western, and JAV. Those should be tags. If a field doesn't apply to one of them then just don't use it. You don't need seperat tables just to add acctresses/studio/author. Just use Tags and a general Media table, then add a thrid table that maps Tags to Media and use that for querying.

Anonymous 2016-10-09 17:42:40 Post No.56998645
[Report]

Anonymous 2016-10-09 17:42:40 Post No.56998645 [Report]

>>56998627
ikr

Anonymous 2016-10-09 17:51:09 Post No.56998766
[Report]

Anonymous 2016-10-09 17:51:09 Post No.56998766 [Report]

>>56998512
Sauce?

Anonymous 2016-10-09 17:53:51 Post No.56998812
[Report]

Anonymous 2016-10-09 17:53:51 Post No.56998812 [Report]

>>56998512
you could just put it all in the right folders since your database does nothing

I'm aware that Imgur.com will stop allowing adult images since 15th of May. I'm taking actions to backup as much data as possible. Read more on this topic here - https://archived.moe/talk/thread/1694/

I'm aware that Imgur.com will stop allowing adult images since 15th of May. I'm taking actions to backup as much data as possible.
Read more on this topic here - https://archived.moe/talk/thread/1694/