Dependencies

• shadcn-ui - UI library
• clerk - Auth library
• hono - API library
• zod - Schema Validation
• neon - Database
• drizze - ORM to connect to neon
• [react-query]
• [cuid2]
• [zustand]

To-do

(V) Project Setup; (V) Authentication; (V) Hono.js setup; (V) Header Component; (V) Drizzle ORM & Neon Database; (V) Accounts GET API; (V) Accounts POST API; (V) Data table component; (V) Accounts bulk delete; (V) Accounts edit; (V) Categories API + UI; (V) Transactions API; (V) Transactions hooks; (V) Transactions form; (V) Transactions page; (V) Transactions CSV import; (V) Transactions account select (V) Summary API; (V) Dashboard cards; (V) Dashboard charts; (V) Dashboard pie; (!) Date & account filters; ( ) Deployment;

Issues

[FIXED] Column transactions.date does not exist; [NOT_FIXED]Wrong round amount (Ex: $10,50 === 11000);

Commands

db:generate - Generate Schema; db:migrate - Make migration; db:studio - Open DB;

To study

• Difference between inner join and left join;
• [[...name]] in folder structure;
• RPC (Sharing API specifications between server and client);

Refs

• https://www.youtube.com/watch?v=N_uNKAus0II&t=3274s