• Already Done

To-Do

• [ ] server refactoring
  • [x] routes
    • [x] account
    • [x] bookmark
    • [x] feed
    • [x] auth
    • [x] post
    • [x] user
  • [x] search for anything related to “xata” in codebase and delete
  • [x] add delete rules to schema
  • [x] delete /server/utils/*.ts (not v2)
  • [x] check if updatedAt update works
  • [x] bug: exclude comments in most basePost lists.
  • [x] bug: _count_postComments ist falsch
  • [x] migrate old data to new db (lookup what seed could mean, maybe helpful)
  • [x] check on “computed fields”
  • [ ] make edgedb -I digitalocean ui work.
  • [ ] maybe add access policies https://www.edgedb.com/docs/datamodel/access_policies#ref-datamodel-access-policies
  • [x] prepare for production & host the db somewhere https://www.edgedb.com/docs/guides/tutorials/nextjs#deploying-to-vercel
• [ ] Try out Prisma + Supabase Postgres
  • [ ] Example Apps & Useful links
    • [ ] Prisma Client Docs: https://www.prisma.io/docs/concepts/components/prisma-client
    • [ ] https://github.com/xlanex6/nuxt3-prisma-demo
    • [ ] https://github.com/visualjerk/karteikasten
    • [ ] https://www.reddit.com/r/Supabase/comments/p6mueg/why_would_you_use_prisma_with_supabase/
    • [ ] https://github.com/supabase/supabase/discussions/7659 https://community.redwoodjs.com/t/guide-migrations-connection-pool-urls-supabase/2505
  • [ ] before push to vercel, complete
    • [ ] https://community.redwoodjs.com/t/guide-migrations-connection-pool-urls-supabase/2505
• [ ] Richtext
  • [ ] in user.description, in post.content, etc.
  • [ ] #hashtag parsing
  • [ ] @username parsing
• [ ] Image/asset upload
• [ ] create “interest groups”, so people filling up what they’re interested about in the account-signup. Then also built this into the “Discover people” page.
• [ ] paginated post list requests + add order_by to all
  • [x] profile page
  • [ ] feed
  • [ ] bookmark folder
• [ ] user profiles
  • [ ] ability to add profile pic (maybe with image editor, pintura)
  • [ ] amount of
    • [ ] followers
    • [ ] following
  • [ ] header image
  • [x] bio
  • [ ] links
• [ ] notifications
  • [ ] likes
  • [ ] follows
  • [ ] answers on your post
• [ ] restructure names of api endpoints
• [ ] implement search
• [ ] Communities
• [ ] Searching
• [ ] Exploring hashtags

Backlog