{"repo":"SteveSuv/remix-words-funny","free":true,"listed":false,"github":"https://github.com/SteveSuv/remix-words-funny","clone":"git clone https://github.com/SteveSuv/remix-words-funny.git","description":"a fullstack English words study website: remix (react-router v7) + trpc + drizzle + postgresql + heroui + jotai + docker","language":"TypeScript","stars":1257,"topics":["docker","drizzle-orm","jotai","jwt","lucide-icons","nodemailer","postgresql","react","react-query","react-router"],"license":null,"category":"deployment-docker-iac","readme_excerpt":"remix-words-funny A fullstack English words study website built with remix-t3-stack features - end-to-end type safe by trpc - get myUserInfo anywhere by useMyUserInfo - type safe form with zod by useZodForm - no need to export action in routes, just call trpcClient.action to mutate anywhere - request with permission control by trpc middlewares - deploy by docker or pm2 - support dark mode by useAppTheme - use drizzle to keep type safe with postgresql db - toast request error automatically - always use latest remix (react-router v7) features stack - remix (react-router v7) - vite - trpc - tailwindcss - heroUI - typescript - drizzle - postgresql - jwt - jotai - pnpm - react-hook-form - react-query - next-themes - lucide-icons - zod - docker how to dev 1. clone this repository 2. install packages 3. init database - install docker and start docker service - first run command below to create a local postgres container (you can replace the POSTGRES PASSWORD EXAMPLE ): - run command pnpm db:push to sync db structs and drizzle schema - download csv data file: https://mypikpak.com/s/VOEs95bTB0KGAg75t0Nrs-oOo1 - use your favorite db tool like TablePlus to connect the postgres db - insert db data by import csv files to tables. Notice! you should first import Book , then Word , then others, because tables have some relations - run pnpm db:task , if print total words count: 152543 means the postgres db is running ok 4. init email server (optional, if you don't want to send login verify co","default_branch":null,"files":null,"tree":[],"storefront":"/r/SteveSuv","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/SteveSuv/remix-words-funny/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}