Used in...

The following countries:

• Argentina
• Australia
• Bangladesh
• Brazil
• Cambodia
• Chile
• Colombia
• Cuba
• Dominican Republic
• France
• India
• Indonesia
• Kenya
• Lebanon
• Nepal
• Pakistan
• Papua New Guinea
• Philippines
• South Africa
• Spain
• Sweden
• Syria
• Thailand
• Uganda
• United Arab Emirates
• United Kingdom
• United States
• Venezuela
• (incomplete list)

A powerful plug-in for web back-ends

CRUDDER is a web-based software component that simplifies development of web sites and systems. Almost every site requires a back-end administration tool that permits users to edit relevant database tables in an intuitive, ordered and secure way.

There are not so many out-of-the-box solutions available for solving this task. Here is where CRUDDER really excels. With a GNU GPL license, you can integrate it with your application in almost all cases. No more need to develop custom database CRUD (create, read, update, delete) modules. Advanced features allow you build the proper configuration according with your need.

CRUDDER main interfaces example (click to enlarge). Top-left: list of tables. Headers and footers are customizable. Metadata is stored in the four tables prefixed with "crudder_". A click on "Show" navigates to the list of fields for a specific table. Top-right: a table content display. Only a few fields are shown in order to maintain a clean interface. Ordering and sorting components are available. The typical buttons of a CRUD module are displayed: "New", "Update" and "Delete". Bottom-left: after a click on "Update", the table fields are shown for edition. Menus are dynamically built based on other tables content. Tooltips are available everywhere. Bottom-right: editing of a metatable. Here the CRUDDER is used to edit the tables that defines the application tables attributes (metatada).

CRUDDER is developed with both the PHP MVC framework CodeIgniter (from EllisLab) and Bootstrap (from Twitter). If you use CodeIgniter for your main application, just include two new classes and some views. If not, copy the CRUDDER code into a separate folder and join it with your application via URL separation.

The CRUDDER configuration derives from three sources. First, the CrudderConfig class, which decouples configuration from code. Second, through "metatables", that contain the CRUDDER parameters that should apply to each table and table field. And third, the views, decoupled as a rule when using the MVC approach (you can define different viewsets appart from the included with this distribution: Bootstraped and Raw).

CRUDDER allows edition of its own metatables through itself, which is a property known as "reflection" that if very unusual to find in user-level applications.

See the examples and get a broad view of what can be achieved with this component. Browse the metatables for catching the CRUDDER basic and advanced features in an easy way. If you download the package, you will get also a detailed PHPDoc-generated documentation.
Note: online demo tables are reset automatically each 30 minutes.

If you like, take a look on other free software solution I have developed. Called "lib_gg_orgchart", it's a Javascript library that does automatic drawing of organizational charts based tree-like definitions expressed in JSON format.

 

Features

• Complete CRUD solution.
• Easy, intuitive and well documented interface.
• MVC (model-view-controller) architecture.
• Pluggable with virtually all web applications.
• Multiple view sets supported for visual coherence with your application.
• Bootstrap-based view set included.
• Localizacion supported; currently includes english and spanish interfaces.
• Implementation encapsulated in only two PHP classes.
• Configuration completely decoupled from the component logic.
• Sort, filter and pagination when editing a table content.
• Read-only and hidden tables and attributes.
• Human-readable names and help texts for all tables and fields.
• Soft deletes with unique-index collision avoidance.
• Automatic menu-type form fields based on other tables values with filtering capability.
• Can trigger events when a value is changed in a form.
• Extended, complex CodeIgniter-style field validation rules can be implemented.
• CRUD permissions are specified table-by-table for each role in a compact way (regex).
• Full auditing available through external, pluggable logging mechanism.
• Main application doesn't need to be implemented with CodeIgniter.
• Doesn't rely on RDBMS metainformation; saves all parameters in its own metatables.
• Free software licensed under GNU GPL.

 

History

• v.1.0.1 beta 2 (2014.09.11): Introduces CRUD permissions table-by-table using regular expressions; fixes problem in the update operation when a field of a row is deleted the second time and an "unique" index is defined for a row that is not the primary key.
• v.1.0.1 beta 1 (N/R): Changed license from GNU LGPL to GNU GPL.
• v.1.0.0 beta 1 (2014.04.07): made publicly available.

[ NR == not released ] [ DNA == date not available ]

 

Contributors

In order of appearance:

• GG :: Gorka G LLONA.

 

License

This work is licensed under the GNU General Public License (GPL).
Portions are licensed under the Apache License v2.0.

 

Author

Gorka G LLona (profile).

 

Feedback

Please contact the author for improvements, suggestions and bugs.