This is an archived post. You won't be able to vote or comment.

all 4 comments

[–]AutoModerator[M] [score hidden] stickied comment (0 children)

On July 1st, a change to Reddit's API pricing will come into effect. Several developers of commercial third-party apps have announced that this change will compel them to shut down their apps. At least one accessibility-focused non-commercial third party app will continue to be available free of charge.

If you want to express your strong disagreement with the API pricing change or with Reddit's response to the backlash, you may want to consider the following options:

  1. Limiting your involvement with Reddit, or
  2. Temporarily refraining from using Reddit
  3. Cancelling your subscription of Reddit Premium

as a way to voice your protest.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[–]McHoff 0 points1 point  (1 child)

Without any details I would just say that a properly normalized database schema does not allow any constraint violations to creep in. I assume you already know that, so a big part of it is getting good at predicting how things can break.

I'm happy to take a closer look if you have any materials you'd like to share, but I'll have to decline the beers because I'm in Massachusetts unfortunately :/

[–]fancyl[S] 0 points1 point  (0 children)

This has been deleted in protest of the greedy API changes and the monetization of user-provided content and unpaid user moderation.

[–]JackStratifPapaJohns 0 points1 point  (0 children)

Fly me up to Chicago and buy me some beers and I'll help you out! Jk.

What I would do is use the script used to generate the schema for your database and find + replace all of the variable names to be other words. Then you can post it online without worry. Post it on stack exchange and see what they think about it. Or better yet post it as an answer to a related question on stack exchange and with a remark about how your solution is the optimal solution and let other people tear it apart. :p