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

• Order Breads and Cakes NO LONGER AVAILABLE! User "guest" and password "MasonSQL1.9"
• GUI Framework & Demo Application Screenshots

Open Source code

The framework was distributed under two licenses:

• Affero G.P.L. rel.1 (only some versions)
• Commercial licence

Current releases status

⚠️ NOTICE – OBSOLETE SOFTWARE

*Last Published: Dic 2024*
Status: Obsolete / End-of-Life (EOL)

• The current online documentation refers to the old version 2.0!
  It remains accessible solely as a record of past activity for reference purposes and is not associated with any commercial activities.
  

Organisations that have previously adopted MasonSQL for internal use, manage its maintenance independently from this repository.

• [*] CRA (Cyper Resilient Act).
  • Internal use software does not require CRA compliance
  • Commercial licences were granted to organisations and companies prior to the implementation of the CRA.
  • Open-source software that is no longer maintained is excluded from CRA regulations and should no longer be used.

The MasonSQL Developer's Guide

Basic Information

• 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

• Turning On Debugs
• Testing Queries a couple of ways to test database queries.
• Using CRUD Interface describes usage of the MasonSQL CRUD implementation.
• Managing Groups how to manage groups, users and authorizations.
• Creating Application
  • Database Access advises how to access the internal database, explains how to set up framework's usernames.
  • Creating Table With Empty MQL File explains steps to create a new table, to add it as the menu option in your web application.
  • Creating Simple MQL File explains basic methods in a .mql file.
  • Adding Inherit Flag how to use inherit flag, how to change form.
  • Using Select and HtmlSelect Field how to use select and htmlselect widgets.
  • Using DivSelect Field how to use divselect widget.
  • Adding Child Frame how to configure the addition of a child frame.

Deployments

• MasonSQL Support Matrix
• DeployUbuntuPrecise Installation on Ubuntu 12.04 LTS (Precise Pangolin) on server Proxmox 2_01 - deprecated
  • Duplicate Application to Ubuntu 12.04 LTS (Precise Pangolin) in VPS (OpenVZ). - deprecated
• DeployUbuntuTrusty Installation on Ubuntu 14.04 LTS (Trusty) - deprecated
• DeployUbuntuPrecise2Xenial Upgrade from Ubuntu Precise VPS to Xenial - deprecated
• DeployUbuntuXenial Installation on Ubuntu 16.04 LTS (Xenial) - deprecated
• DeployUbuntuXenial2Bionic Upgrade from Ubuntu 16.04 LTS (Xenial) to 18.04 LTS (Bionic) - deprecated
• DeployUbuntuBionic Installation on Ubuntu 18.04 LTS (Bionic) - deprecated
• DeployBionic2Jammy Upgrade from Ubuntu 18.04 LTS (Bionic) to 22.04 LTS (Jammy) Last 2.0 release
• DeployUbuntuNoble Installation on Ubuntu 24.04 LTS (Noble) - Only 2.1+ releases
• LetsencryptSSL Deploy Let's Encrypt SSL certificates
• BackupPC Configure backup system to preserve database integrity

Essential Reference

• Autohandlers
  • global_autohandler

• library.comp

• frame.html

• dbms_library.comp provides database interface. Some of its methods are also used by frame.html.
  • Authorization Methods and Subroutines
  • Father, Child Methods
  • _Field Methods
  • Fields Methods
  • Find Methods
  • Query Methods and Subroutines
  • XLS Methods
  • Forms Methods
  • Report Methods, Subroutines and report.pdf Component
  • Universal Subroutines

• displaybinding.js (DisplayBinding Class)
• databinding.js (DataBinding Class)

• report.pdf Component
  • ODT Reportman Installation
  • ODT Reportman Library
  • ODT Reportman User's Guide
  • Report Manager (Deprecated)

• Input Widgets of the web graphical interface.
  • input.comp base widget component.

• Email and SMS Messages
  • /opt/masonsql/bin/cronjobs

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)

• PortingApache24 MasonSql porting to Apache 2.4
  (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)

• Recoding & optimizations
  (in progress)

Web Utilities

• - advanced search
• WebTopicList - all topics in alphabetical order
• WebChanges - recent topic changes in this web
• WebNotify - subscribe to an e-mail alert sent when topics change
• WebRss, WebAtom - RSS and ATOM news feeds of topic changes
• WebStatistics - listing popular topics and top contributors
• WebPreferences - preferences of this web