Overview
I designed and built Dr. Jihad Atassi's corporate platform end to end, from architecture to production. It is the digital presence of a consultant with over forty years in AI, IoT and smart infrastructure who also trains engineers. There is not a single hard-coded string on the site — headings, menu order, social links, even the wording of the e-mails are managed from the panel in both languages. The site is live at jihadatassi.net.
Architectural Decisions
- Backend: ASP.NET Core 10 with database-first EF Core. The schema was written by hand; business rules are guaranteed at the database level with CHECK constraints, partial unique indexes and deliberate foreign-key behaviour
- Database: PostgreSQL (Supabase) across 5 schemas — system, identity, content, catalogue and enquiries
- Frontend: Next.js 16 with SSR and bilingual routing. Full RTL for Arabic; even the list of languages comes from the database
- Infrastructure: the API serverless on Google Cloud Run, media on Cloud Storage, the frontend on Vercel, scheduled work triggered by Cloud Scheduler
The Admin Panel
This is where most of the work is. The goal was that the owner never needs me:
- Content: pages, profile, education, services, solutions, courses, certifications, organizations, lists and gallery — each in both languages, with a rich-text editor
- Catalogue: products, categories and pricing plans, each plan with its own enquiry form
- Enquiry inbox: submissions from the site, with status tracking and replies
- Media library: upload, derived sizes, reuse
- Access control: SuperAdmin, Admin and Editor roles, with an audit trail of who changed what
- System: settings, languages, users, the e-mail outbox and a system status screen
Course Registration and E-mail
- A registration form whose fields are defined per course — type, requirement, width, and options loaded from ready-made reference lists such as countries and nationalities
- Capacity, waiting list, duplicate prevention and CSV export
- An e-mail system built on a transactional outbox: session reminders, calendar invitations (.ics), bulk announcements, scheduled sending, delivery tracking and unsubscribe handling
- The subject and body of every e-mail the system sends are editable in both languages from the panel
Security and Data
- Argon2id password hashing, refresh-token rotation with reuse detection, session invalidation
- Two separate database roles: the application role cannot alter audit records or login attempts
- Retention is enforced by
functions in the database, not by application codeSECURITY DEFINER - Signature-based file type validation, EXIF stripping, SVG rejection
- Three layers of anti-spam, a strict CSP, verified trusted proxies
Testing
Over 800 automated tests across backend, frontend and end-to-end; Playwright scenarios running on four browsers and an accessibility gate with axe. The browser tests caught real bugs several times that neither the compiler nor the unit tests could see.
Takeaways
This was the project where I learned in practice what moving from a rented server to a fully serverless architecture means. Storing files where there is no persistent disk, the lifecycle of encryption keys, moving background work onto a scheduler, how a connection pool behaves behind a pooler. And one more thing: "the code no longer reads that column" is not the same as "the ORM no longer maps it" — I learned the difference through a fifteen-minute outage in production.
