Fikr Coworking: Desktop ERP
Full-featured desktop ERP system for a coworking space in Algeria with 12 SQLite entities, RBAC, audit trails, and PDF receipts.
Overview
A comprehensive desktop ERP application for Fikr Coworking in Algeria. Built with Electron and packaged as Windows installer. Features 12 versioned SQLite entities, granular per-user per-page RBAC, soft delete with complete audit trails, and PDF receipt generation.
What I Did
- →Architected full desktop application using Electron with Node.js backend and React frontend
- →Designed and implemented 12 SQLite entities with versioned migrations: members, services, subscriptions, sessions, rooms, reservations, receipts, payments, discounts, expenses, incomes, cash register
- →Implemented granular RBAC with per-user per-page permissions: view, edit, delete
- →Built soft delete system with comprehensive audit trail across all entity tables
- →Created PDF receipt generation engine using PDFKit with dynamic templating
- →Implemented bcrypt password hashing for secure user authentication
- →Integrated Google APIs for calendar and contact synchronization
- →Built super-admin role with full visibility and admin password management
- →Configured Electron Builder for NSIS Windows installer packaging
- →Implemented automatic database migrations on application startup
Challenges
- •Managing complex relational data across 12 interdependent entities
- •Ensuring data integrity with soft deletes across all tables
- •Implementing granular RBAC that scales as business operations grow
- •Handling PDF generation performance with large transaction volumes
- •Packaging and distributing desktop application to non-technical users
Results
- ✓Replaced spreadsheet-based booking and billing with a single desktop system
- ✓Soft deletes and a full audit trail give complete history for disputes and compliance
- ✓Automated PDF receipts remove hand-written billing errors
- ✓Per-user, per-page permissions keep staff scoped to exactly what they need
- ✓Admin dashboard gives owners full financial visibility and reporting
Tech Stack
Electron
Cross-platform desktop application with native Windows installer capability
SQLite
Lightweight embedded database perfect for desktop application with versioned migrations
React
Component-based UI for complex data management interfaces
Node.js
Server-side business logic and database operations
PDFKit
Dynamic PDF generation for receipts and financial reports
bcrypt
Industry-standard password hashing for security