a mini social media app for small communities
todo#
i use
:to denote categories
in-progress#
- post:search for posts
- filters:
created-at:<date> created-after:<date> created-before:<date> is:pinned has-tag:<tag> posted-by:<user> !excluded-query
- filters:
- user:search for users
- filters:
created-at:<date> created-after:<date> created-before:<date> is:admin
- filters:
planing#
p.s. when initially writing "planing," i made a typo. it should be "planning." however, i will not be fixing it, because it is funny.
- post:add more embedded link handling! (discord, github, gitlab, codeberg, etc)
- user:follow other users (send notifications on new posts)
- site:log new accounts, account deletions, etc etc in an admin-accessible site log
- this should be set up to only log things when an admin enables it in the site config, so as to only log when necessary
- site:implement a database keep-alive system
- i may also just need to change a setting in the database server to keep it alive, i am not sure yet.
- site:overhaul security
- i am not a database security specialist, and some of the methods below may be bad. before approaching which security features i want implemented, i will be consulting some other people to be sure of which ones need to be and do not need to be implemented.
- row level security?
- roles/user groups?
- whitelist maps where possible?
- database firewall?
ideas#
- user:per-user post pins
- could be used as an alternative for a bio to include more information perhaps
- site:rss feed?
done#
- user:nicknames
- user:bio/about me
- user:listed pronouns
- user:notifications
- user:deletion
- user:change password
- user:change username
- post:likes/dislikes
- post:mentioning ('tagging') other users in posts
- post:mentioning:who mentioned you (send notifications when a user mentions you)
- post:editing
- post:replies
- post:tags ('hashtags')
- post:embedded links (links added to a post will be embedded into the post
as images, music links, etc)
- should have special handling for spotify, apple music, youtube, discord, and other common links. we want those ones to look fancy!
- post:saving (add the post to a list of saved posts that a user can view later)
- site:message of the day (admins can add a welcome message displayed on index.html)
- misc:replace
SELECT *withSELECT <column>
graveyard#
-
post:images (should have a config.maple toggle to enable/disable)- replaced with post:embedded links
-
site:stylesheet (and a toggle for html-only mode)- replaced with per-user optional stylesheets