TODO - Githubissues

General

[x] Setup data models
[x] Setup Github auth
[x] Setup username/password auth
- https://lucia-auth.com/start-here/username-password
- [x] Fix login failure errors
- [ ] Add password reset
[ ] Setup Google auth
[ ] Figure out how to get github token for API access
- https://lucia-auth.com/oauth/providers/github
[ ] Setup roles and permissions
[ ] Setup passwordless (email) login
[ ] Add protected profile page
- [ ] Setup connecting another external provider
- [ ] Should also work if signing in with another provider that shares the same email
[ ] Investigate
- Magic links (passwordless auth)
- https://hackernoon.com/how-to-build-a-passwordless-authentication-with-email-and-jwt-o33w3311
- https://aws.amazon.com/blogs/mobile/implementing-passwordless-email-authentication-with-amazon-cognito/
- https://frontegg.com/blog/passwordless-authentication-for-saas
- https://postmarkapp.com/blog/magic-links
- Multi-factor authentication (MFA)
- Passkey / WebAuthN
- https://github.com/pilcrowOnPaper/lucia/issues/577
- https://web.dev/passkey-registration/
- OpenID
- https://github.com/pilcrowOnPaper/lucia/issues/555

[x] Setup Drizzle with Vercel Postgres
[x] Setup migrations
[x] Setup Superforms
[ ] Setup drizzle-zod
[ ] Consider row-level security
- https://imfeld.dev/notes/postgresql_row_level_security

[x] Setup Github project with Vercel integration
[x] Setup Vercel Postgres
[x] Move to Neon Database instead of Vercel Postgres
- 730 hrs vs 60 hrs compute hours
- 3GB vs 0.25GB free storage
- $0.12 vs $.30 per GB/month
[x] Run npm run dev instead of npm run dev:vercel (vercel dev)
[x] Setup Upstash (what should be cached)?
- Move page view tracking to Upstash instead of DB
[ ] Send emails
- https://vercel.com/guides/sending-emails-from-an-application-on-vercel
- SendGrid (100 emails/day free)
- Postmark (100 emails/month free)
- Amazon SES
[x] Storage