Show newer

@applejack >You wouldn't want to store tag data on posts themselves

I was thinking about going with a two table solution. Not the three table one.

This is why a fucking hate SQL so much. I need to create THREE TABLES just to implement tagging. At least, that's the "proper way". Not to mention all the JOINS and nested queries I have to do.

I should've used MongoDB for this project, but I feel like it's too late to turn things around.

@LukeAlmighty Also, if you kill yourself while wearing a skirt, you are a victim of murder and not suicide.

xianc78 boosted

@gabriel I hope it will be an open standard like VHS or CD.

xianc78 boosted

@PurpCat @sallymayweather He's not a fedi user. bird.makeup is a one-way Twitter bridge.

xianc78 boosted

@beardalaxy Speaking of tags. I have to redo the tag system because I just realized that MySQL doesn't support the STRING_SPLIT function that other forms of SQL support. So I have to store tags in a separate table.

xianc78 boosted

@freddie_the_fed @Tadano Too be fair, Running With Scissors DID have an official board on 8chan. I'm not even joking.

@privacydingus I would be on-board ONLY if it is an open format like VHS or CDs.

xianc78 boosted
xianc78 boosted

@beardalaxy But despite, not currently supporting commercial games due to my lack of knowledge with online payment processing (both fiat and crypto) I do plan on having creators being able to link to their PayPal, Patreon, LibrePay, various crypto wallets etc on their profile page.

@beardalaxy
>also, as far as a name for the site goes, this is a little cheesy but how about "yourgame?"

It seems way to cheesy. Also, YouTube had strict rules, even back then. I remember people uploading shirtless videos and YouTube flagging them as "porn". The name meant "Broadcast Yourself". It gave people a chance to do just that. It didn't mean that there were no rules. Before that, you either had to create your own website or submit your pitch to a local public access station (assuming your area even had one).

I thought about "Indie Depot" or "IndieDepot". The only person who seems to already be using that name is some Instagram account. Though given that a lot of indie games are commercial and we currently don't support commercial games, it might be confusing. (I also place "hobbyist games" as a separate category from indie games)

@beardalaxy @graf Profiles now have bios. This bio is just taken from a random MobyGames page.

(Ian Fisch, if you are reading this, I hope you don't mind.)

xianc78 boosted

@beardalaxy I just know there are going to be those who say "all media is political" and bitch about the "Activism" tag.

Show older
Game Liberty Mastodon

Mainly gaming/nerd instance for people who value free speech. Everyone is welcome.