Welcome to the MasonSQL Web
The MasonSQL is a Mason based web application framework.
In combination with the Linux platform, the Apache web server and Perl scripting language it forms a web stack.
- The framework is integrated with the PostgreSQL database.
- It provides a collection of useful Javascript widgets for a web GUI.
- A concise and an effective authorization of the default functionality is in place which can be easily extended to the functionality of a newly developed web application.
- An external applications can communicate with the framework using CRUD interface.
- A database reports can be obtained with the ODT Reportman.
- The framework is also integrated with the print server utility.
Demos and Screenshots
Open Source code
The framework is distributed under two licenses:
- Affero G.P.L. rel.1
- Commercial licence (please call to know conditions and prices)
The code can be downloaded from the SVN server:
Current releases status
/tags/2.1 |
Commercial |
? |
2.1 release |
Ubuntu 22.04...24.04, Apache 2.4, PostgreSQL 14..16 |
others |
Commercial |
- |
Very old versions |
|
/tags/2.0 |
Commercial or AGPL r1 |
dic 2026 |
Current 2.0 release |
Ubuntu 20.04...22.04, Apache 2.4, PostgreSQL 12...14 |
/trunk_1.9 |
Commercial or AGPL r1 |
dic 2024 |
Most recent Rel. 1.9 patched branch |
Debian 10...12; Ubuntu 18.04...22.04, Apache 2.2,2.4, PostgreSQL 11...14 |
/tags/1.9.3 |
Commercial or AGPL r1 |
dic 2024 |
Current 1.9 release |
Debian 10...12; Ubuntu 18.04...22.04, Apache 2.2,2.4, PostgreSQL 11...14 |
/trunk |
Internal |
- |
Most recent Rel. 2.0 patched branch |
Ubuntu 20.04...22.04, Apache 2.4, PostgreSQL 12...14 |
Release |
Licence |
EOL |
Comment |
Compatibility |
Current documentation refers to 2.0 release!
The MasonSQL Developer's Guide
- Mason Literature book about Mason, titled Embedding Perl in HTML with Mason, by Dave Rolsky and Ken Williams.
- Mason Configuration File describes where are the configuration files, a version information.
- Javascript Widgets describes which Javascript libraries, tools and toolkits are available.
- Database describes where are database related files, interfaces and types of the files.
- Additional Tools a print server utility and a list of included proprietary Perl classes.
Developing Application
Deployments
Essential Reference
Enhancement & Extensions
- PortingPSGICall Call for porting of MasonSQL framework from Apache2/mod_perl/Mason to Twiggy+Poet/PSGI/Mason2
(suspended)
- OdtReport ODT (OpenDocument Text) Report Manager
(released)
- POD2Foswiki Call for development of application to export POD documentation from SVN/GIT to Foswiki portal
(a first version released)
- SelfRegistration to allow new users to register themselves.
(a first version released)
- EmailGateway to filter and load the e-mail queues into the MasonSQL messages system.
(released)
- PsqlMessages managing system of asynchronous messages, based on PostgreSQL (LISTEN/NOTIFY).
In the future it will be used to communicate in real time between users (for example: a chat, to update the data in forms).
Currently MasonSQL does not use PsqlMessages inside.
(a first version released)
- SessionManagement to manage user connection from many workstation and mobiles
(a first version released)
- TableCopyAndPaste to implement Copy & Paste features in MasonSQL TABLE form
(a first version released)
- ImportXlsData to import data from XLS files and others formats (XLS, JSON, ...)
(suspended)
Web Utilities