v1.0 · Portfolio project
eduAssets records who took what, keeps stock up to date, tracks maintenance and breakage, and exports reports as CSV, Excel and PDF.
Opens in Guest Mode: read-only, no sign-up.
Portfolio project
A full-stack web system for managing school equipment inventory, loans, returns and incidents.
Schools often manage laptops, tablets and accessories through scattered spreadsheets, making it difficult to know what is available, borrowed, under maintenance or broken.
eduAssets centralizes inventory, loans, returns, incidents, permissions and report exports in a web application.
TypeScript, Vite and feature-first architecture.
Node.js, Express 5, Prisma and Zod.
Managed PostgreSQL on Neon.
JWT, session control and responsibility-based access levels.
Integration with Raspberry Pi or Arduino Nano.
CI/CD, application and API deployment, and operational documentation.
The Oracle VM has only 1 GB of RAM. Keeping PostgreSQL managed reduces memory usage, simplifies backups and separates database availability from the API machine.
The static frontend can be served globally by Cloudflare Pages, while the API remains on a VM with independent operational control.
To allow immediate evaluation and interaction without creating accounts or exposing administrator credentials.
The system remains useful with conventional login and can receive hardware when hosted locally or when operations justify the investment.
Loan workflow
Each step updates stock immediately, so available stock is always the real one.
Enter the requester, the person responsible, date and time, and items with quantities.
If available stock is not enough, the record is blocked.
From the open loans list, confirm the return with date and time. Items go back to stock.
Every loan stays on record with Open or Returned status.
Features
Register loans with several items and process returns from the list of open loans.
Total, available, on loan, in maintenance and broken items in summary cards. Stock is listed by category and the history shows every loan.
Record observations, maintenance and broken equipment. When you resolve a record, describe the fix and the item goes back to stock.
Stock changes with every action, with no manual editing.
Also included
Beyond the panels, what the system offers in daily use.
Anyone can explore the system in read-only mode, with no sign-up.
Access levels do not rely on the interface alone: every write route validates the token.
Atomic, transaction-scoped updates and a blocked record when stock is short.
Card login with a Raspberry Pi or Arduino Nano. Password login stays available.
Loan history and inventory as CSV, Excel or PDF.
Interface in both languages, with light, dark or system theme.
Access and security
Restrictions exist in the interface and are enforced by the backend too.
Enters without login. Views Dashboard, history and stock. Cannot create, edit or delete.
Registers loans, processes returns and creates or edits Control records.
Full access: Registers, record deletion, password change and RFID cards.
Optional hardware
Users tap their card on the reader and sign in without typing a password.
The administrator generates a token under Registers → Users and writes it to the card. The server stores only the hash.
A Python service on a Raspberry Pi or Arduino Nano reads the card and sends the token to the backend.
The backend validates the token and notifies open tabs over WebSocket. The session starts by itself.
The reader plays distinct tones for card detected, success and error. RFID is never required.
Technology
Documentation
Browse the user, architecture, API, development, deployment, hosting and operations guides.
Source repository:GitHub
Personal profile
Developer, IT technician and Computer Engineering student.
Developer · IT technician · Computer Engineering student
São Paulo, Brazil
Open eduAssets in Guest Mode and browse every panel, no sign-up.
