Scriptcase
Scriptcase RAD is a development platform for PHP applications. It is web oriented and can be installed in a server in the internet. It acts as a platform for developers and allows them the use of a graphical interface directly through a web browser to automatically generate the codes. It was developed by NetMake in the year 2000. Can be used on Mac, Windows, and Linux operating system.

Using Scriptcase, PHP developers can generate complete online applications. Scriptcase is a rapid web development tool that aims to reduce development time and increase productivity.

Developers need an environment (web server like Apache + PHP and a database like MySQL) on their desktop (or accessible via network or internet) to develop applications, for hosting the applications the server needs a webserver (incl. PHP) + a database. After programs are finally developed and deployed, Scriptcase is no longer necessary to run the application.

Features
Scriptcase can be used to create CRUD (Create, Read, Update and Delete) applications. It also enables to add custom code to manage business rules and validation. Scriptcase lets you create  forms, queries in PHP, ranging from simple forms to forms having high level of complex elements to manipulate data from databases (MySQL, PostgreSQL, SQLite, Interbase, Firebird, Access, Oracle, MS SQLServer, DB2, SyBase, Informix and ODBC connections).

It permits development with JavaScript methods that can be used within the AJAX events and create applications with AJAX through a set of features and services with easy and fast hand coding, such as navigation between pages or sections, automatic validation of fields such as date, currency, zip code and social security number, among others.

The generated reports can be exported to MS Word, MS Excel, PDF or printed. Complex SQL statements can be used (sub-select, joins and even stored procedures). Scriptcase allows users to write PHP to handle exceptions and create more complex validation).

Scriptcase is Compatible with RTL (Right to Left) writing, support right to left writing prevalent on Arabic languages. It is also possible to create infrastructure such as menus, login screen and security system with authentication, create tabs to group forms or queries to be executed on the same page.

Platform development began in 2000. Since then, it has been receiving regular updates.

It addresses Web Application Developers (both for desktops and for mobiles) in two ways: it enables starting developers with limited knowledge of programming (PHP, Java) and basic knowledge of databases (SQL) to build applications that read and updates data in Web Databases. But it also aims at the experienced developer, who can with Scriptcase put a lot more focus on business logic rather than editing forms, build database connections etc.

The pricing model is about to shift from "buying the software" as till the end of 2016 to "lease as a service"  from 2016 (due to a publication from the CEO to subscribers and current users of scriptcase from Nov 14th, 2016). The current prices are 400-$600 for buying the software (depending on how many databases are supported) per developer.

Disadvantages

The official documentation is very basic and does not work to solve common problems.

The community of developers that can help you solve your problems is quite small.

The maintenance of applications with complex business logic becomes very complicated.

Versions
The platform development started in 2000. Since then, the tool has received periodic updates and improvements.

 1.0 - Released 2000 - "Fossil Version".
 Was sold only for some customers in beta mode.

 2.0 – 2003
 Big Changes in the interface.
 Theme and CSS Editor
 Creation of SQL builder
 Export PDF
 Macros
 Security Module 1.0

 3.0 - 2006
 Native support for AJAX
 Creation of the concept of Events
 Stored procedure

 4.0 - 2008
 Internationalization support
 Master-Detail Functionality
 Editable Grid
 HTML Editor
 Helpcase (documentation generator)
 New filter options
 Navigation using tabs on the internal interface of Scriptcase

 5.0 – 2009
 Graphics in Flash
 Creation of the container application
 Express applications Creation
 captcha security use
 dynamic menus
 Menu with "refresh" option
 Tree Menu
 New Security Module
 Logging module

 5.1 – 2010
 New implementations such as JQuery support
 Calendar
 Google Maps
 Quick Search
 bar codes
 flash graphics
 Container
 Field type YouTube
 New Themes

 5.2 – 2010
 Focused on editing and field types, creating the option "edit fields"
 Form: New field formatting, tabs, validation, among others.

 6.0 – 2012
 The biggest change was in performance, up to 5 times faster.
 New graphics module
 New security module
 New log module
 Database Manager

 7.0 – 2013
 Integration with PayPal
 Integrated social media Buttons,
 AJAX in Grids
 Mobile Menu
 New PDF generator
 Tool bar for menus
 Graphics in HTML 5

 7.1 – 2013
 Multi-Thread Processing
 Change in interface
 Graphics with navigation on the Toolbar
 Friendly URL

 8.0 – 2014  Scriptcase consolidation as one of the strongest tools of BI (Business Intelligence), migrating some features that help the end-user to make decisions. For that, we made some major changes on the Grid Application, such as the option for your end-users to create their own Group By within the application based on the fields defined by the developer, add totals and create their own graphics. In addition, there is a new graphic application, added to simplify the creation of such applications.
 New dynamic filter, and Group By Summary for Grid applications;
 Interface to message between Scriptcase users;
 Image Manager;
 Editor for graphics themes;
 A tool to import ACCESS, CSV and XLS in MySQL database, SQLite, Postgre and MSSQL;
 New interface for settings on applications such as Form and grid;
 Responsiveness to form and make the menu of mobile web applications;
 Support for the TCPDF class in the application Report PDF;
 Dynamic Research in form applications;
 Grouping of option buttons to applications with the option of the toolbar;
 Past, Present and Future new events in the calendar application.

 8.1 – 2015Implemented new filter functionality, and dynamic summary in Grid applications. Created a new Graphic application with support for user-defined combined final graphics. New refined Filter restricting values according to the universe that exists in the database. Group of buttons for the new chart in the toolbar button editor.
 New Tools
 Sending messages between users in Scriptcase;
 New tool for managing images in Scriptcase;
 Tool for creating to-do list among users;
 New tool for editing graphic themes;
 Tool for importing ACCESS, CSV and XLS for MySQL, Postgre, SQLite and MSSQL;
 New Library Manager;
 New HelpCase generator;
 New security module with listing of logged users and blocking by Brute Force;
 Scriptcase Interface
 Added new configuration interface of the form and Query applications;
 Added new parameters in the theme editor Refined Filter;
 Added new parameters in the theme editor for Menu tabs;
 Added new parameters in the theme editor to the navigation path of the Menu;
 Added option to background image in advanced settings for Menu theme;
 New Technologies
 Implemented mobile applications responsiveness form;
 Added TCPDF class support in the implementation Report PDF;
 Added new sc_webservice macro that supports soap services, curl, file_get_contents and sockets;
 Application resources
 Grouping of option buttons in applications that have toolbar;
 Implemented improvements in the implementation timetable;
 Added new path (breadcrumb) menu application browsing;
 Added macros sc_url_library () and sc_include_library ();
 Added new aggregation of type "weighted average";
 Added new field for accumulation of values of other fields;
 Added new Ajax type button.

 9.0 – 2017Comes with important implementations on Business Intelligence (with a complete redesign on the charts, grids, abstracts – Pivot Tables and Dashboards), significant improvements in security, PDF Report module, Menu, interface redesign development and improvement of performance with PHP7, among other implementations.
 Chart
 New aggregate functions to graph metrics;
 A new dimension of options for date fields;
 Possibility of an analytic and synthetic combination of different sizes in the same graph;
 Inclusion of a new type of filter (user filter)
 Inclusion of function LIMIT that can be used to rank the values within the graphics.
 New types of graphics: scatter and bubble, Gantt, semicircular and linear, funnel 2D and pyramid 2D;
 New customization options specific to the graphics bar, column, pie, and gauge;
 Possibility to export the graphs in PNG, JGP, PDF, SVG, and XLS;
 Dashboard
 New interface with drag and drop, for setting up widgets dynamically;
 Responsiveness in the presentation of the widgets in the Dashboard;
 New index widget to the presentation of KPIs (key performance indicators) within the dashboard;
 Application of Grids (Reports and Pivot Tables)
 New interface using drag and drop for defining the Grid breaks and the abstract;
 New aggregate functions to graph metrics: Count, Distinct count, variance and standard deviation;
 New dimension of options for date fields;
 Inclusion of a new filter to the summary (user filter);
 Inclusion of function LIMIT in the query and in the summary. Function can be used to rank the values.
 New configuration options within the aggregation of the summary;
 Layout application
 Allows integration of forms with customized HTML and CSS or imported in the form of external library;
 Body handling variables from HTML: visual can now be changed completely and adapted;
 Report PDF Drag & Drop
 New option of drawing with drag drop and dynamic configuration of & fields within the same interface;
 Menu application
 New option "menu structure" for customization of menu layout;
 Scriptcase Interface
 Great part of Scriptcase interface has been modified, thereby improving the usability of the tool for developers;
 New interface for creating projects with search option;
 New interface for creating application with multiple selection of tables, etc.
 Environment and safety
 PHP support 7.0;
 Update ODP drivers (SQL Server, MySQL);
 Addition of the PDO Dlib drive for SQL Server;
 Addition of the new MySQLi for MySQL connections drive;
 SSL for secure connections with MySQL;
 New version of Apache 2.4.25;
 Option to login with Google, Facebook and Twitter automatically by the safety module;
 New options for the encryption password login application field (MD5, SHA1, SHA256, SHA512);
 Security module Integration with the new option of free-form control with responsive templates.

Key features 
    AJAX
    Editable grid
    Master / Detail
    Forms
    Consultations
    Reports
    Menus
    Tabs
    Customizable Layouts
    Documentation generator
    Data Dictionary
    Language Editor
    Import HTML template
    jQuery
    JavaScript

Scriptcase still allows the advanced settings for the generated applications meet the requirements of complex systems. There is also a documentation generator that can integrate the whole team.

References 

  Scriptcase Official Site
  Samples
 Features
 Scriptcase Download
 Scriptcase Host

PHP
Web development software