How we store data (4393x1069)

[–] jobes 4 points (+4|-0)

IMHO you should change the NSFW field from a boolean to an integer field so you can have a sliding scale of NSFWishness. Like a 0 is safe and the old false option, a 1 is a girl in a bikini and a 10 is applied by default to any post @BUTTHOLE_EMPRESS makes. Then user settings can have a work safety slider.

[–] Polsaker [OP] 3 points (+3|-0)

So SDBH would be 65536?

[–] jobes 3 points (+3|-0)

You should probably make it a 64-bit field to cover up to 0xFFFFFFFFFFFFFFFF

[–] [Deleted] 1 points (+1|-0)

LOL

[–] moot 2 points (+2|-0)

Very interesting

[–] jobes 1 points (+1|-0)

The source is open, used on other sites actually. If you're glowing this information should have been known to you 4 years ago

[–] E-werd 1 points (+1|-0)

I should have paid more attention in SQL class. I took that damn class twice.

[–] Polsaker [OP] 0 points (+0|-0)

Rather than SQL you can imagine this as objects and their attributes/interactions

[–] E-werd 1 points (+1|-0)

Edited

I mean, I get it. I still understand how Foreign and Primary keys work for the most part. I'm just intimidated by the whole thing. Queries mostly.

EDIT: You're right, this is a lot like objects and properties/methods.

[–] Polsaker [OP] 0 points (+0|-0)

Oh yeah. Queries can get quite complicated. Even more when you join a lot of tables

[–] CDanger 0 points (+0|-0)

Is this webscale?

[–] Polsaker [OP] 0 points (+0|-0)

You probably have to open the image in another tab. It's too big to show well in the expando

How we store data (4393x1069)

12 comments

/s/phuksdev