The latest version of AMPLE Database Scaffolder offers a host of options beyond those of many standard CRUD applications. From bulk insert of random, type-specific records, to built-in client-side and server-side validation and auto-joining of lookup tables. The AMPLE Database Scaffolder recipe cooks a vast number of capabilities into a web-based, open source app that virtually anyone can use. The list below contains some of the more prominent highlights.
| Active Record Highlighting | Visually identifies the last record modified by a user |
|---|---|
| API Interface | Easy class instantiation makes for quick access to all public variables and functions |
| Auto-Generated Form Fields | Builds complete entry forms based on database specifications and field types |
| Auto-Generated Select Lists | Converts all reference tables, enums, sets, and boolean field types to user-friendly drop lists |
| Auto-Join Disabler | Provides users with the ability to enable / disable individual auto-join policies based on field type |
| Bulk-Insert Option | Allows developers to test database or front-end performance using randomly generated type-consistent values |
| Client-Side Validation | Enforces data type matching and non-null field types - alerts and highlights any form fields with errors |
| Controlled Access | Uses built-in MySQL permissions to control access to databases and tables |
| CSV Field Type Support | Provides users with the ability to automatically join a character field with comma-separated-values to corresponding records within a lookup table |
| Data Exporting | Capture all records from a table based on specific query criteria and save them to a Microsoft Excel spreadsheet for further analysis. |
| Data Type Matching | Ensures that values entered are correct based on the field type selected |
| Date Time Calendar | Eliminates formatting errors during date time field insertion and modification |
| Error Reporting | Tracks and reports on any internal object errors as well as MySQL errors and warnings |
| Extensive Field Types | Supports bigint, bit, bool, boolean, char, datetime, decimal, double, enum, float, int, longtext, mediumint, numeric, set, smallint, text, timestamp, tinyint, tinytext, and varchar |
| External Configuration Overrides | Allows administrators to lock down specific settings in the application based on individual security requirements |
| File Upload Support | Allows users to upload one or more files within a single database table while capturing all the standard file data such as path, name, type, size, and file extension. |
| Flexible and Intuitive | Works "auto-magically" out-of-the-box with most standard MySQL configurations. |
| Friendly GUI | Simple 3-tab interface makes option selection quick and easy |
| Full Paging and Sorting | Allows users to more easily work within larger tables and find the records they need |
| Help Docs | Helpful documentation is automatically compiled into the tool to help acclimate new users |
| HTML Tag Stripper | Allows or denies HTML tag support within field values during record inserts and updates |
| Individual Field Selection | Gives users the ability to individually select one or more specific fields from a table |
| Javascript Independent | Minimal Javascript requirements means no dependency on additional Javascript frameworks or libraries |
| Location Independent | Capable of accessing any local MySQL server with "localhost" or any remote server with a fully qualified domain name |
| Minimized Data Option | Enforces min/max row height in record display to assist users in accessing individual records and data |
| Multi-Referential Lookup Support | Allows multiple fields within a primary table to point to the same lookup table |
| No AJAX Complications | Relies on standard HTML form submissions to reduce complexity and file footprint required |
| Query Generator | Dynamic SQL queries based on user selections |
| Query Viewer | Allows users to view the final SQL output |
| Record Duplication | Duplicate an existing record in mere seconds using this feature. |
| Record Row Resizer | Allows users to expand or contract records displayed through the web interface to more easily view the data within. |
| Records Per Page Option | Allows users to select anywhere from 10 to 100 records at a time |
| Server-Side Validation | Provides a fall-back with default null, blank or numeric values, in the event of client-side validation failure |
| Single File Format | Releasable version is compiled and minified to reduce file size and make for easy deployment |
| Small Footprint | Total disk space usage of less than 150 kilobytes |
| Software Update Notification | Automatically checks for the latest version of the software and notifies developers when a newer version is available |
| Syntax Highlighting | Color-coded SQL syntax makes it easier to distinguish reserved words within queries and field data |
| Table and Field List Generator | Automatically provides users with a list of available resources on the server based on database permissions |
| User-Friendly Labels | Converts upper case, lower case, camel case and underscores to human readable headers and select options |
| Where Clause Generator | Allows users to specify an unlimited number of SQL query conditions using pre-validated values for all lookup tables, enum, set and datetime field types |