- Published on
使用 ExcelJS 实现 Excel 文件的规范化导入流程。包括文件格式校验、工作表和表头结构验证，将数据行解析为 JSON 格式并映射为业务对象，结合 Zod 进行字段级数据验证，并支持重复数据校验，确保导入数据的完整性与规范性。
All Posts
All Posts
- nextjs (18)
- best-practices (12)
- express (12)
- ai-companion (11)
- react (10)
- mongodb (9)
- web-scraping (8)
- git (7)
- leetcode (7)
- hono (6)
- gotcha (6)
- elasticsearch (6)
- scrapy (5)
- interview (5)
- supabase (4)
- aws (4)
- websocket (4)
- authjs (4)
- k8s (4)
- cloudflare (3)
- undetected-chromedriver (3)
- vercel (3)
- react-query (3)
- prisma (3)
- protobuf (3)
- shadcn (3)
- mongoose (3)
- curl_cffi (2)
- clerk (2)
- authentication (2)
- deployment (2)
- docker (2)
- drizzle (2)
- neon (2)
- redis (2)
- tailwind-css (2)
- tiptap (2)
- vscode (2)
- zod (2)
- zustand (2)
- pino (2)
- fastify (2)
- trpc (2)
- github (2)
- fabric (2)
- browser-automation (1)
- cache-control (1)
- blog (1)
- crontab (1)
- free-tier (1)
- cloud-databases (1)
- sql (1)
- nosql (1)
- planetscale (1)
- postgresql (1)
- exceljs (1)
- flyio (1)
- giscus (1)
- isr (1)
- jotai (1)
- newsletter (1)
- mailerlite (1)
- reddit (1)
- praw (1)
- redux (1)
- reford (1)
- english (1)
- ai-integration (1)
- sonner (1)
- swr (1)
- s3 (1)
- test (1)
- tsc (1)
- trie-树 (1)
- token (1)
- tts (1)
- airflow (1)
- oauth (1)
- credential (1)
- eks (1)
- cicd (1)
- apidoc (1)
- pm2 (1)
- cluster (1)
- kafka (1)
- feishu (1)
- streaming (1)
- superjson (1)
- leetcode_javascript (1)
- lib (1)
- malaysia (1)
- p-limit (1)
- next-intl (1)
- i18n (1)
- notion (1)
- eslint (1)
- prettier (1)
- swagger (1)
- Published on
MongoDB 在优化时, 考虑并发查询提升接口响应速度- Published on
记一次mongodb数据库跨版本迁移- Published on
- Published on
由于字段 isActive 是后续添加, 即便默认为 true , 数据库中已有记录并没有改字段, 如果使用 query={isActive: true} , mongodb将会显式比较 isActive: true 的数据