Svelte User Manager — Authenticated CRUD API
This project serves as an architectural bridge. After years of managing complex IdentityServer configurations in the .NET ecosystem, I implemented this lean JWT-based authentication flow from scratch to explore modern Node.js middleware patterns.
The backend focuses on Parameterised SQL safety to prevent injection attacks while maintaining clean state synchronisation between a Svelte frontend and a PostgreSQL (NeonDB) persistence layer.
It demonstrates a production-ready approach to full CRUD operations, secure login/registration flows, and protected route orchestration via custom Express authentication middleware.
The Forge Specs
- ✦ Security: JWT Authentication with protected route middleware
- ✦ Data Integrity: Parameterised SQL via pg-library (No ORM overhead)
- ✦ Persistence: PostgreSQL on NeonDB with relational CRUD logic
- ✦ Middleware: Custom Express handlers for JSON parsing and Auth-verification
- ✦ Frontend: Svelte-driven UI with reactive state synchronisation
- ✦ Deployment: Netlify (Frontend) | Leapcell (Service) | Neon (Database)