>Decide to restart Indie Storefront Project after the Steam and Itch controversies
>Decide to use a NoSQL DB this time because nested SQL statements make my brain hurt
>Both MongoDB and CouchDB have repositories that lack release files which makes them insecure and disabled by default on apt
>The only other solution I can think of is Elasticsearch which isn't intended to be used as a DB.
BDSM
You don't need nested SQL statements, you can just run multiple queries and join in the app.
@cjd True, but document oriented databases just make more sense to me, especially since I'm used to OOP.
NoSQL goes from being The Easiest Thing Ever to Gouge Your Fucking Eyes Out With A Rusty Spoon complexity depending on what you need it to do.
@cjd I just want to create a simple site where people can upload their indie games and mods. Last time I tried to do that, I gave up on it after implementing comments because you are supposed to have two tables: comment and comment_link (at least this is standard practice). It just became to tedious.
@vokainen099 @cjd Also, I wanted people to be able to upload an unfixed amount of screenshots for each game/mod. It got way to complex and I underestimated myself.
Do not push yourself too hard, mister. Priority here is a solution to the payment processor issue. Websites can wait
@vokainen099 @cjd The solution to the payment processor issue is a crypto-only store front (though crypto payments would have to be added later). Don't put too much faith in MasterCard reversing their decision or the government stepping in.
@xianc78 @vokainen099 @cjd Postgres has arrays you know
As it turns out, the latest version of MySQL has support for JSON, bringing the best of both relational databases and document-oriented databases, and I can run this all on a simple LAMP server. That's good to know.
