← all work
● live
library-management-system-dbms
Full-stack DBMS on MySQL (TiDB Cloud) with a five-agent LangGraph concierge that streams replies token by token over SSE.
12
tables
5
agents
SSE
transport
engineering decisions
- ›Referential integrity enforced by FKs — the DB rejects orphaned writes
- ›Sales run as transactions: sale + payment commit or roll back together
- ›scrypt hashed passwords, per-session CSRF tokens, audit-logged logins
- ›v1 ran CRUD on Google Sheets (Vercel serverless) — rebuilt on MySQL for FK integrity, transactions, and real auth
- ›Intent classifier routes to specialist agents instead of one god-prompt
stack
FlaskLangGraphMySQLTiDBpgvectorRender