Show newer

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.

@beardalaxy Users can filter based on any tag they want. It's just that those tags will appear by default or if you are not logged in.

Show older
Game Liberty Mastodon

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