you are viewing a single comment's thread.

view the rest of the comments →

[–]wizzwizz4 2 insightful - 1 fun2 insightful - 0 fun3 insightful - 1 fun -  (3 children)

Subs are easy; you just cache basic data for the listings and then request it from the external site when you need to view it. Any content on there is stored on the external site, and maybe a copy's kept for convenience on user pages but that's non-canonical.

Does SQLAlchemy let you add a new attribute to the magic Table object, run the code in prod and automatically update the database? Or do you have to run SQL commands to add the column manually?

Hadn't seen Lemmy; that's cool. Also, it reminds me of one other issue:

Other sites have different voting systems. If we're going to federate with them, we need to genericise the way we represent votes or everything will fall over when we try to pass content to and from somewhere with only one vote, or with upvote and downvote, or even with three types of vote.

Here's one possible way of doing that: we have a votes table, where each vote has an id. Then we— wait, that won't work.

[–]d3rr 3 insightful - 1 fun3 insightful - 0 fun4 insightful - 1 fun -  (2 children)

Does SQLAlchemy let you add a new attribute to the magic Table object, run the code in prod and automatically update the database?

Yes, new db columns/rows are happening automatically based on changes in code.

genericise the way we represent votes

we can just call our points whatever the protocol wants to call them, upvotes or likes or whatever.

[–]wizzwizz4 2 insightful - 2 fun2 insightful - 1 fun3 insightful - 2 fun -  (1 child)

No, I mean…

Let's say (and this wouldn't ever happen) that we convinced Reddit to add federation support identical to our own. When you're viewing Reddit posts from Saidit, and find something funny, and click the fun button… they get a downvote. And conversely, if you don't like something on Saidit-from-Reddit, you want to downvote it, but accidentally mark it "fun".

What do we do about that?


Incidentally, /s/CringeAnarchy has CSS'd in up and down arrows, which isn't such a smart move as the mod probably thought it was. Do you want to try to explain, or just leave it?

[–]d3rr 3 insightful - 1 fun3 insightful - 0 fun4 insightful - 1 fun -  (0 children)

What do we do about that?

Well since only SaidIt clones will have the same voting model, the best we can do is work around it. If a downvote comes in, it's discarded (edit: or subtract downvotes from the upvotes if both are present). For a fun vote to go out, it either counts as another upvote or it's discarded. Etc. etc.

Do you want to try to explain, or just leave it?

I'm just gonna live and let live. Maybe they like it because it ups the cringe factor. Surely they will notice the score in the sidebar not subtracting points on "downvotes" sooner or later. Edit: they have already changed them anyway.