CONTACT: João da Rocha Labrego — [email protected]
LINKEDIN: https://www.linkedin.com/in/jo%C3%A3o-rocha-labrego-6a9681335/
GITHUB: https://github.com/joaolabrego/SGSI_CRUDEX
The CRUDEX project, which is almost in its final development phase, was created to automate systems development as much as possible.
I even had to invent a new concept to define it: ISMS — Information Systems Management System.
Just as there are concepts of SQL DBMS and No-SQL DBMS, there is now also the concept of CRUDEX ISMS. If other standards emerge in the future, there will be CRUDEX ISMS and No-CRUDEX ISMS.
What's new in this?
In CRUDEX, the business analyst specifies the system directly, defining tables, validations, indexes, foreign keys, primary keys, etc.
Based on this metadata, CRUDEX automatically generates all the necessary DDL and DML scripts, as well as the stored procedures responsible for the CRUD operations of each table.
The system also provides a standard frontend — made in HTML, CSS and pure JavaScript (without frameworks) — in Single Page Application architecture and dynamically assembled in the browser according to the metadata configured for the system being executed.
With this, the business analyst can immediately execute and test the specified system, simply by creating the database with the automatically generated scripts.
In this way, all the system's intelligence resides in the database, including the business rules.
The business analyst no longer depends on the developer to validate their specifications and, if the standard frontend meets the needs, the system can already be considered ready for use.
If the client wants a more beautiful or customized frontend, the developer steps in only to build this interface, as long as the CRUD operations are performed via API — never directly in the database.
With this, the backend becomes the responsibility of the business analyst or DBA — and no longer of the developer.
The developer is only responsible for creating specific frontends, such as mobile applications or advanced interfaces, without interfering with the system's logic.
CRUDEX already has several additional features, but this is the essential one.
SOCIAL SHARE CARD GENERATOR