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 |