Hey, Jow Forums...

>150cm
>36H
>always squirts
well this thread was worth clicking

I know, its the one in the OP, I want to get opinions on how it could be better

SQLite + any SQLite CLI/GUI for management.
Write a script to automate the initial load.
Do not save videos as blobs in the database and preserve the directory structure, keep a (relative) path to the file in your schema.

>he doesn't know that they drink a shitload of water before shooting a scene, so it's actually just piss
not that its a bad thing, just saying

>36H
Absolutely disgusting. Ittie bitties are the best titties

>Only one that isn't pregnant or married is Hitomi

>She got so desperate for a relationship she's even started dating foreign men

>Broke down on Twitter wondering why she couldn't get a relationship or married like her friends.

Gotta stay hydrated

Big fat asian tats

i had figured as much but it's still hot

I remember reading somewhere that Hitomi wanted to get out of JAV years ago, but she was making the yakuza producers too much money, so they wouldn't let her

Making bridge tables for tags will be an pain in the ass to use. Just add 4 or 5 foreign key columns for tags. Same with actresses. You shouldn't need to store metadata about the files since you can just pull them from the file when needed

Source: unemployed wannabe dba

Christ you're pathetic

Fuck you for bringing this up again and making me wana do it. I have a fair bit more than you and wanted to get some sort of database for it all.

I gave up because I wanted something like deckbox for magic cards but for JAVs. The closest thing I found was javlibrary com but I havent had the time to really test it out.

Attached: nas.jpg (1325x909, 632K)

>not using randomly generated filenames, putting all files on the desktop and memorizing the meta data of each video

Attached: mastermind.jpg (236x233, 12K)

>18TB used
Is that all JAV?
Impressive.

I remember that. Then laster that year she released a video of her wearing a cow outfit and getting milked whiles getting fucked. She was told to moo like a cow. Was fucked up but I still came it it.

Only 8 TB?

Came to say this. You don't need a massive database in normal form. Just use Excel or LibreOffice Calc, and then use formulas to generate a rename script to put all standard filenames/paths on them.

MILKY MILKY WARM AND TASTY!

MOMMY! MILKY! PLEASE BE HASTY!

REFRESHING DRINK FROM MOMMY'S UDDERS!

I WANT MOMMY'S AND NO OTHER'S!

GIVE IT! GIVE IT! GIVE IT NOW!

GIVE ME MILKY, LAZY SOW!

UNTIL YOU DO I'LL SCREAM I'LL SHOUT!

I'LL CRY I'LL WHINE AND STOMP ABOUT!

UNTIL MY BELLY IS FULL AND HAPPY!

I REFUSE TO TAKE A NAPPY!

Attached: 1517848208412.jpg (250x164, 6K)

Tasty pasta.

>massive database
>sqlite
'no'

maybe Jow Forums should make a booru-like website just for jav stuff, and have multiple online archives with mirrors and backups. i'll pay for the servers, you make it happen.

As databases go I know it isn't at all huge, but what OP is outlining is already way more than is needed to catalog your porn.

sqlite does fine with size, it's multiple concurrent writers where it struggles

Is this a serious proposal? If so, I'd be happy to contribute resources

hello sir
i recommend mongodb for this
thank you

I think he meant that SQLite is small compared to something like Postgres

No shit but either is overkill and a waste of time for catalogging porn. Just toss it in an Excel sheet and rename files with tags.

use nosql database. they also have schemas but they are more flexible when you want to add something to it.

Is this the Home Server General?

Imagine being the girl on the left and having friends like the other two.

Attached: 1505762748995.jpg (400x400, 19K)

just create a torrent, we will sort everything for you.

Oh I'm planning on it, once everything is nice and organized.

no Sir

>being this retarded
Hitomi's tits are bigger Kaho's

>150cm
>36H
>Loli-sized but with boobs literally the size of her head
and they said anime is not realistic

why the fuck those chinks still pixelize the vaginas?

I was ready to cum a bunchload and I got a feeling like I'm watching porn for blind people.
dafaq

oh fuck, I did not recognize her. She looks modest in the pic

SPRD-860
:^)

I agree with this, I was thinking bridge tables for tags aren't necessary

Seriously who watch slant eyed hairy pussy blurred genitals porn.

media {
id:uuid,
type:str,
filename:str,
ext: str,
path: str,
metadata: obj,
vendor: str or vendorId,
actors: list,
tags: list,
rating: int
}

Because vaginas are ugly, user.

pussies are for pounding, not admiring

This reminds me; I need to do a bit of house cleaning myself. My modest 3.6TB collection of porn/hentai/doujins needs some re org work. The rest of my data needs some work to. I'll do it when a drive shits itself or I upgrade my main server's storage.

>he doesnt eat her out and suck up all the sweet pucci juice
remember, if your girl's pussy tastes bad, she isnt healthy

Attached: 1515638127631.jpg (540x350, 41K)

>8tb of porn.
>Can only fap to one video at a time.

Why do you even need 8tb? I bet even if you fapped to one single girl. You woudn't watch all the videos of this one girl.

its been forever since I gave a girl head. she's got to be something special to deserve that.
I think I'd be able to tell within 3 dates if I would be willing to give a girl head, finger banging is the more dignified way and hygienic way.

Left?

Hitomi Tanaka

Use postgresql

Stop using varchar or smallint use text or integer. Storing the videos in the DB would probably be overkill.

The reference tables will be terrible. An array of an enumeration would be a good alternative. In 9.1+ you can just update the enumeration as new actors, tags or vendors are found. Of course each of these would be their own enumeration.

So that would basically leave you with over table for the videos since your data is not that complex.

Similar to

Right side girl?

anri okita, shes retired (for now)

kys degenerates

this
kenzie reeves is best

> its been never
ftfy

what is degenerate about that

If you're a prude, anything beyond the most vanilla softcore porn is utterly degenerate.

>he doesn't fap to natural, plump, mature Japanese women but instead botoxed white women with various disfigurements such as tattoos and piercings

>a prude
*snap*

But... It's hard to find BLACKED® content featuring plump Japanese women.

How do you even get off to JAV? I had 1TB of it but I decided to delete most of it because their screech was annoyed, censorship was in the way, positions are bad and asians are ugly unless they've done plastic surgeries to look white

Either way, you want something like a music player right, but for porn?

>I don't like JAV because it isn't Jewish Brazzers garbage
ftfy

you need to use Hydrus Network.
Folder schemes will never work.

OHHHH MY GOD FUCK YEAAAAAHHHHH

Nice bro

Get out of here, Winbabby. Real men are talking.

Meh. Folders and symlinks work fine.

see

You're asking for advice?
Here's some

Delete it. All of it. The physical space of 8tb is nothing compared to the mental space of this rotten filth in your mind. It invariably causes habituation and increased frequency. Sexual frequency is contingent upon deltafosb induction; the more you do it, the more you will do it in the future.

There is no benefit to pornography. It corrupts your mind and reduces your potential. Rather than have bright ideas and dreams flowing through your subconscious, it is filled with sexual thoughts, directing chiefly when it is going to get off next. You become but an empty shell of the person you could have been.

>The greatest intellectual geniuses in both ancient and modern times led continent lives, and there is yet to be recorded one individual who freely expended seminal fluid who ever amounted to anything. In most cases, individuals who have achieved have been forced by necessity to abstain from sexual indulgence, as Cervantes, who wrote Don Quixote while in prison, or Dante who wrote his Divine Comedy while in exile. Milton wrote "Paradise Lost" when blind and when he did not indulge in sex. Sir Isaac Newton, active in intellect until the age of 80, led a continent life from birth, and so did Leonardo da Vinci and Michelangelo, both of whom retained their creative genius [until] an advanced age.

Even if true they were geniuses and I'm a fucking idiot. Why should I abstain from porn when, at best, it'd only make me average? Fuck off.

>There is no benefit to pornography.
It makes my wee feel good and satisfies urges.

Might as well inject heroin with that attitude.

A lot of your tags (e.g. "big tits") are really properties of the actress—anything with Hitomi Tanaka is going to be big tits. But, if you store tags on the actress, you're going to run into problems with those attributes changing over time—breast augmentation making an actress small-tits and big-tits at different points in time, or early Okita Anri not counting as a MILF.

You're going to want something like :
tag_list
-> tag_id
-> tag_text

actor_list
-> actor_id
-> actor_name

attributes
-> actor_id
-> date
-> tag_id

Storing the video blobs in a database is nuts, though. Files are meant for file systems.

k bud

Attached: 1520671219095.png (493x395, 115K)

No, that costs money. Porn is nearly free.

all it costs is dignity

GTFO with the Christfag pseudoscience.

Also the only reason why you exist is that your last million ancestors took every opportunity to live out their sexuality, chase skirts and fuck. Since we don't want the same birth rates but still are proper human, masturbation it is. No, there is no downgrade involved except in the minds of faggots (among them the generally filthy rich organized religion's leaders) that would have you live only for their wealth.

Not my dignity anyway

Based and redpilled, unironically

>satisfies urges
It satiates for a half hour at the expense of your focus and motivation for nearly the next 16 hours.
In reality, indulging reinforces these urges. Often, these urges arise from your own thoughts and exposure to erotic stimuli.

>Emission not Necessary to Health.—If it be argued that an occasional emission is necessary to relieve the overloaded seminal vesicles, we reply, the same argument has been used as an apology for unchastity; but it is equally worthless in both instances. It might be as well argued that vomiting is a necessary physiological and healthful act, and should occur with regularity, because a person may so overload his stomach as to make the act necessary as a remedial measure. Vomiting is a diseased action, a pathological process, and is occasioned by the voluntary transgression of the individual. Hence, it is as unnecessary as gluttony, and must be wasteful of vitality, even though rendered necessary under some circumstances. So with emissions. If a person allows his mind to dwell upon unchaste subjects, indulges in erotic dreams, and riots in mental lasciviousness, he may render an emission almost necessary as a remedial effort. Nevertheless, he will suffer from the loss of the vital fluid just the same as though he had not, by his own concupiscence, rendered it in some degree necessary. And as it would have been infinitely better for him to have retained and digested food in his stomach instead of ejecting it—provided it were wholesome food—so it would have been better for him to have retained in his system the seminal fluid, which would have been disposed of by the system and probably utilized to very great advantage in the repair of certain of the tissues.

Without spending a year doing data entry, I don't see how this is feasible.

>It might be as well argued that vomiting is a necessary physiological and healthful act, and should occur with regularity, because a person may so overload his stomach as to make the act necessary as a remedial measure.
If you don't vomit, it comes out your ass as normal poo. Cum does not.

Lel, Einstein was married twice and cheated with like 10 women, and there are many other important scientists or political leaders who fucked a lot or were known sexual deviants for their time.

As well as famous but not terribly important artfags akin to Leonardo or Michaelangelo or the equally importany people that draw naked anime waifus having sex. Or Mozart. Go read.

It's okay, I enjoy it
A couple hours a day and it will come together slowly and/or never because I download new JAVs daily

1. I did not make any appeal or claim to a deity. I clearly iterated that a pornography habit is self defeating behavior that brings along with it negative effects. You say it's a religious appeal so as to set up a straw man.
2. Your entire argument is a poor appeal to nature, not on any objective proof but your own habits. In reality, your sedentary lifestyle and presence of near limitless superstimuli, give rise to a sexual frequency that is far beyond what what have been observed in mammals. You also present a fallacious mutually exclusive choice of intercourse or masturbation, not realizing that abstinence can be practice not only without injury, but with great benefit. If procreation is not the intended goal of a sex act, especially if it's habitual, is of no benefit.

It does degrade a man. "No man is free who is not master of himself" - Pythagoras. You are a slave, not a man yielding autonomy and control over his own life.

Kellogg isn't saying not to vomit. He makes the case that both actions are a consequence of behaviors that preceded them.

Cowpers fluid has nowhere to go but seminal fluid in the vesicles and sperm within the testes are recycled hourly. If you avoid arousal, then abstinence can be maintained indefinitely without urges.

Einstein was an overrated hack.
Mozart was incredibly chaste during his early years. You must have watched the film, Amadeus which was grossly historically inaccurate. Beethoven was chaste for nearly all of his life. Stop justifying your sexual excesses.

Kellogg was a dumbass.

How hard are you tipping your fedora right now?

Attached: 1531601220549.png (480x480, 254K)

It’s piss you disgusting fucks.

This. I love Japanese women but anything that isn’t solo or amateur is intolerable.

>there is yet to be recorded one individual who freely expended seminal fluid who ever amounted to anything.

Attached: Nietzsche187a.jpg (1464x1986, 632K)