Ajax-based CRUD automatic generator
Blogs20112011-07-21
Recently I implemented an automatic CRUD generator which is driven by Ajax. The following are the description and features:
- CRUD is create, read (retrieve), update, and delete. Which means data can be dynamically operated through web pages.
- The only requirement is a Data-driven source, which could be Database table(s), CVS file, XML file, etc. This data source is used as CRUD. For an example, the blogs data from worldpress.com, which is easily integrated and displayed by using my software.
- No need coding, all application is automatically generated by config file. The config file is simply a .txt file, more easily than Drupal’s config files.
- Based on the data source and config file, the software will do all the rest work automatically. Much easier, more high performance than Drupal CMS.
- The software is written by PHP, MySQL(as default source), jQuery and its plugins, Smarty Templates, PEAR MDB2 in Linux environment and Window’s XAMPP. It is universal designed and target to suit different environments.
- jQuery + Smarty templates give the ability to separate View from Business Logic; more easily change web skins (themes); enhance performance by refresh part instead of whole web page; avoid page reload and decrease server-side consume
- The software is very easy to extend, integrated with different existing systems.
By using this software, guess how long you can deploy an application? 10 - 20 minutes. It is amazing, and it is true. I deployed an application (a MySQL table with 45000 records), with the following features(but not limit): adding new record, list records, sorting, pagination, searching, generate CSV files, updating individual record, delete records, download selected records, column editing, auto refresh, AJAX, etc, it took me around 10 minutes, the webpage immediately displayed with all features running perfectly! All I did is write a .txt config file, and write 3 PHP arrays. That’s it.
