Generate migration file
npm run db:generate
Setup db (run migration)
wrangler d1 execute life-tracker --file=./drizzle/<migration filename>.sql
Run sql
wrangler d1 execute life-tracker --command='SELECT * FROM score'
Deploy
npm run deploy
- put drizzle into middleware?
- filter by day of the week
- auth + login
- validation for create entry and edit entry
- zod validation
- uuid for db primary key
- use oob swap for deleting items?
- migrate to async hono v3
- e2e testing - playwright?
- settings to add activities
- local vars to switch variables
- loading states
- animate delete
- colors for mood
- save food
- edit existing entry
- delete entry
- sort activities by category on entry card
- add fitness tracking
- social activities, lunch, dinner, drinking, calling, hangout
- hard 75
- icons for activities