WERP - Web Application Framework

Project Overview

SweetSoft developed WERP, a comprehensive web framework designed to quickly create database-oriented applications using flexible security models. The framework includes an integrated layout editor and convenient localization support, enabling developers to build sophisticated applications through model design and management, with all models stored within the same database as operational data.

Challenges

• Rapid Application Development: Need for a framework enabling quick creation of database-oriented applications
• Model-Driven Design: Building applications through model design rather than traditional coding
• Database Integration: Storing application models within the same database as operational data
• Flexible Security: Implementing adaptable security models suitable for various application types
• Automatic UI Generation: Creating user interfaces automatically based on defined models
• Data Type Definition: Enabling flexible data type definitions and rule configurations
• Layout Customization: Providing end-users with tools to create diverse data views
• Localization Support: Building convenient multi-language support into the framework
• Complex Requirements: Supporting bug tracking, analytics, project management, and activity monitoring

Our Solution

We developed a comprehensive web framework that empowers developers to create sophisticated applications through model-driven design, with built-in tools for layout customization, security management, and localization.

Key Features

Framework Capabilities:

• Model Design: Create application models with flexible data type definitions
• Database Integration: Models stored within the same database as operational data
• Automatic UI Generation: User interfaces generated automatically from model definitions
• Layout Editor: Integrated editor enabling diverse data view creation
• Security Models: Flexible security configurations adaptable to various applications
• Localization Support: Convenient multi-language support built into the framework
• Rule Configuration: Define business rules and data validation within models

Built-in Applications:

• Bug Tracking: Comprehensive bug tracking and issue management
• Time Tracking: Team activity and time tracking capabilities
• App Analytics: Download times, views, browser statistics, daily activity monitoring
• Activity Monitoring: Likes, comments, views tracking
• Project Management: Planning, reporting, invoicing functionality
• Technical Documentation: Integrated documentation management

Technical Highlights

• Model-driven architecture for rapid application development
• Database-agnostic design supporting multiple database systems
• Metadata-driven UI generation
• Role-based security framework with granular permissions
• Integrated layout editor for end-user customization
• Internationalization and localization engine
• RESTful API architecture
• Modular plugin system for extensibility
• Real-time data synchronization
• Caching mechanisms for improved performance
• Automated data validation and business rule enforcement
• Responsive design supporting web and mobile interfaces

Project Metrics

• Development Duration: 2018–2019
• Development Hours: 78,000+
• Platform: Web
• Services Delivered: Business Analytics, UI & UX Design, Web Development, Quality Assurance
• Project Type: Internal Product Development

Results

• Rapid Development: Framework enables quick creation of database-oriented applications
• Model-Driven Success: Developers can build applications through model design without extensive coding
• Flexible Security: Adaptable security models suitable for diverse application types
• Automatic Generation: UI automatically generated from model definitions, reducing development time
• End-User Empowerment: Layout editor allows users to create custom data views
• Comprehensive Tools: Built-in bug tracking, analytics, and project management
• Localization Support: Multi-language support streamlining international application development
• Reusable Framework: Internal tool enabling efficient development of multiple client projects

Client Impact

WERP has become a powerful internal tool for SweetSoft, dramatically accelerating the development of database-oriented applications for clients. The model-driven approach has reduced development time by enabling automatic UI generation and eliminating repetitive coding tasks. The flexible security models and integrated layout editor have made it possible to quickly adapt applications to specific client requirements without extensive customization. The built-in bug tracking, analytics, and project management capabilities have provided immediate value to clients, offering sophisticated features out-of-the-box. The framework’s localization support has streamlined the development of international applications, making it easier to serve clients in multiple markets. The 78,000+ hours invested in WERP development have paid dividends through improved efficiency across numerous client projects, establishing it as a cornerstone of SweetSoft’s development toolkit.