Day 15 of Backend
Spent the day revising the last 14 days of learning.
• FastAPI: Pydantic, HTTP methods, validators, computed fields, serialization
• Docker: Dockerfile, images, containers, registry, Docker Hub
• PostgreSQL: CRUD, datatypes, constraints
#buildinpublic
Day 14 of Backend
• Done with PostgreSQL (enough to explain things).
• Worked with VIEWS.
• Worked with HAVING clause.
• Worked on few user defined functions.
• Worked with WINDOW function.
• Learnt about CTE (Common table expression) and Triggers.
#buildinpublic
Day 15 of Backend
Spent the day revising the last 14 days of learning.
• FastAPI: Pydantic, HTTP methods, validators, computed fields, serialization
• Docker: Dockerfile, images, containers, registry, Docker Hub
• PostgreSQL: CRUD, datatypes, constraints
#buildinpublic
Day 14 of Backend
• Done with PostgreSQL (enough to explain things).
• Worked with VIEWS.
• Worked with HAVING clause.
• Worked on few user defined functions.
• Worked with WINDOW function.
• Learnt about CTE (Common table expression) and Triggers.
#buildinpublic
@PhantomC0der Looks solid! One thing, consider adding an (updatedAt) to Holding too, useful for tracking when positions change. Also might want a TransactionHistory table separate from Orders for audit trail purposes.