a mini social media app for small communities
emmeline.girlkisser.top
1# todo
2
3> i use `:` to denote categories
4
5## in-progress
6
7- [x] post:search for posts
8 - [ ] filters:
9 ```
10 created-at:<date>
11 created-after:<date>
12 created-before:<date>
13 is:pinned
14 has-tag:<tag>
15 posted-by:<user>
16 !excluded-query
17 ```
18- [x] user:search for users
19 - [ ] filters:
20 ```
21 created-at:<date>
22 created-after:<date>
23 created-before:<date>
24 is:admin
25 ```
26
27## planing
28
29> p.s. when initially writing "planing," i made a typo. it should be "planning."
30> however, i will not be fixing it, because it is funny.
31
32- [ ] post:add more embedded link handling! (discord, github, gitlab, codeberg, etc)
33- [ ] user:follow other users (send notifications on new posts)
34- [ ] site:log new accounts, account deletions, etc etc in an admin-accessible site log
35 - 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
36- [ ] site:implement a database keep-alive system
37 - i may also just need to change a setting in the database server to keep it alive, i am not sure yet.
38- [ ] site:overhaul security
39 - i am not a database security specialist, and some of the methods below may be bad.
40 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.
41 - [ ] row level security?
42 - [ ] roles/user groups?
43 - [ ] whitelist maps where possible?
44 - [ ] database firewall?
45
46## ideas
47
48- [ ] user:per-user post pins
49 - could be used as an alternative for a bio to include more information perhaps
50- [ ] site:rss feed?
51
52## done
53
54- [x] user:nicknames
55- [x] user:bio/about me
56- [x] user:listed pronouns
57- [x] user:notifications
58- [x] user:deletion
59- [x] user:change password
60- [x] user:change username
61- [x] post:likes/dislikes
62- [x] post:mentioning ('tagging') other users in posts
63 - [x] post:mentioning:who mentioned you (send notifications when a user mentions you)
64- [x] post:editing
65- [x] post:replies
66- [x] post:tags ('hashtags')
67- [x] post:embedded links (links added to a post will be embedded into the post
68as images, music links, etc)
69 - should have special handling for spotify, apple music, youtube,
70 discord, and other common links. we want those ones to look fancy!
71- [x] post:saving (add the post to a list of saved posts that a user can view later)
72- [x] site:message of the day (admins can add a welcome message displayed on index.html)
73- [x] misc:replace `SELECT *` with `SELECT <column>`
74
75## graveyard
76
77- [ ] ~~post:images (should have a config.maple toggle to enable/disable)~~
78 - replaced with post:embedded links
79- [ ] ~~site:stylesheet (and a toggle for html-only mode)~~
80 - replaced with per-user optional stylesheets