Memes and Reviews over Votables

[Vandivier]

MAJOR BENEFIT I HOPE: It has never been easier to contribute to open source: Just PR a meme!!!

---

i want memes for my content creation whether or not people view them

but, maybe people will like them so we can try it out

erm Reviewables not Rateables

use a clapping feature like medium - a UserRating references a user and a Ratable and it can rate smth up to +10 or -10. When the UserRating is updated the the Ratable's total score will be updated. VotableType should become RatableType and we can rm the more complex Votable entity. we don't want VotableHierarchy VotableSnapshot authors etc

a Reviewables will have:

id Int @id @default(autoincrement())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
type VotableType
displayName String? // also, the title for questions and blog posts
foreignKey String @unique // could be a course ID, a mentor ID, or a filename or URL; whatever the thing is
tags String[]
reviews Review[]
rating Int @default(0) // cached sum(reviews.rating)
ratingCount Int @default(0) // cached len(reviews)

---

blog articles and /memes will now be sortable by:

1. Published Date (updatedAt)
2. Count of Ratings
3. Average Rating
4. Total Rating
5. Random

each page can then nav next/prev (by published date), or random next, or back to list
this is for articles and memes for now

---

MAJOR BENEFIT I HOPE: It has never been easier to contribute to open source: Just PR a meme!!!

[Vandivier]

i can do similarly w shorts for 4pm-videos-and-images

later on we can review long vids, courses, services offered by individuals, checklists