Scriptcase

ScriptCase is a development environment for creating web applications based on PHP and databases. It generates customizable PHP code compatible with multiple database management systems. The environment runs directly in web browsers and supports collaborative development among multiple programmers.

★★★★★

5.0(1 ratings)

• Form generation. Creation of web forms for inserting and editing records in databases. Includes automatic data validation, tabbed layout, multiple record editing and relationships between tables. Forms maintain referential integrity during update operations.
• Grid applications. Display of data in a table format with sorting, filtering and pagination capabilities. Support for CRUD operations directly from the grid interface. Configuration of calculated columns and specific display formats.
• Reporting system. Generation of reports in PDF, XLS and HTML formats with grouped and summarized data. Design of report structures with headers, footers and subtotals. Calculation of statistical metrics on datasets.
• Charting module. Creation of interactive graphical visualizations using JavaScript. Chart types include bars, lines, areas, pies and scatter. Configuration of dimensions and metrics via drag-and-drop interface.
• Control panels. Construction of dashboards with key performance indicators (KPIs). Aggregation of multiple visualizations in a single interface. Dynamic data update according to configured parameters.
• Interactive calendars. Calendar applications for managing events stored in databases. Drag-and-drop operations to modify event dates and durations. Bidirectional synchronization with Google Calendar.
• Menu system. Generation of horizontal, vertical and tree navigation structures. Permission configuration per menu item. Dynamic menus based on user roles and programmable conditions.
• Security module. Management of users, groups and access permissions. Authentication against databases or LDAP directories. Granular control of allowed operations per application and record.
• Internationalization. Support for over 50 languages in generated applications. Data dictionary for translating table and field names. Dynamic language switching based on user preferences.
• Programming environment. Incorporation of custom PHP code through events and macros. Integrated IDE for custom script development. Code debugging with execution traces and error handling.
• Database connections. Support for MySQL, PostgreSQL, Oracle, SQL Server and other management systems. Configuration of multiple simultaneous connections. Automatic generation of optimized SQL statements.
• Version control. Modification history in development projects. Comparison between application versions. Restoration of previous configurations via snapshot system.

ScriptCase was initially developed in the year 2000 by the Brazilian company NetMake. The program is primarily written in the PHP language with JavaScript components for the web interface. The founders created the tool to streamline the development of web-based corporate systems, evolving from previous code generation solutions. The architecture allows generating PHP applications that run on standard web servers without specific platform dependencies.

Alternatives to Scriptcase:

Metabase

Metabase is an analytics and business intelligence tool that allows teams to query, segment, and visualize datasets from multiple sources.

Price: Free   Size: 527 MB   Version: 0.59.4.2   OS: Windows

RAD Studio

RAD Studio is an integrated development environment that enables the creation of native applications for multiple operating systems, including Windows, macOS, iOS, and Android, from a single source code base.

Price: Free   Size: 274 MB   Version: 12.3   OS: Windows