SQL Web App
Description
In this web application, I created it for my database class to demonstrate our skills and knowledge. In this application, the user can create/delete workers in a fictional company.
My Role:
As a full-stack developer, I created and implemented core server-side functionalities using Node.JS, Express.JS, and various node modules. My primary responsibilities included:
- Designing and implementing the database schema
- Creating RESTful APIs for data operations
- Implementing CRUD functionality for employee and department management
- Building a responsive frontend interface
- Ensuring data integrity and validation
- Documentation of API endpoints and database structure
Technical Details:
The backend infrastructure leverages several key technologies:
- SQLite3 for data management:
- Employee record storage and retrieval
- Department management
- Data relationships and constraints
- Transaction management
- Express.js for server operations:
- RESTful API endpoints
- Request validation
- Error handling
- Route management
The frontend infrastructure implements:
- Bulma CSS Framework:
- Mobile-first responsive design
- Component styling
- Grid system
- Form layouts and validation
- JavaScript functionalities:
- Dynamic data updates
- Form handling
- API interactions
- Error message display
Challenges and Solutions:
-
Database Relationships
- Challenge: Implementing proper relationships between employees and departments
- Solution: Designed a schema with foreign key constraints and cascading updates/deletes to maintain data integrity
-
Data Validation
- Challenge: Ensuring data consistency and validity across all operations
- Solution: Implemented server-side validation and database constraints to maintain data quality
-
User Interface
- Challenge: Creating an intuitive interface for database operations
- Solution: Utilized Bulma CSS components and custom JavaScript to create a user-friendly experience
Results and Impact:
The platform successfully demonstrates several key achievements:
- Complete employee and department management system
- Intuitive user interface for database operations
- Robust data validation and error handling
- Responsive design for various device sizes
- Efficient database querying and management The project received full marks and demonstrated practical implementation of database concepts.
Skills Learned and Demonstrated:
- Database design and implementation
- RESTful API development
- CRUD operations implementation
- Frontend development with Bulma CSS
- Form validation and error handling
- Data relationship management
- SQL query optimization
- Responsive web design
Want to learn more? Explore the codebase on GitHub!
Technologies
Platform:
Web
Stack:
HTML, Bulma CSS, JavaScript, Node.js, Express.js, SQLite3, EJS
Website:
N/A