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 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:

• Subversion Web interface: https://guest@www.leader.it/wsvn/masonsql/
• Command line to downoad: svn checkout --username guest https://www.leader.it/svn/masonsql/

Current releases status

Release	Comment	Compatibility
/trunk	Most recent Rel. 2.0 patched branch	Ubuntu 20.04...22.04, Apache 2.4, PostgreSQL 12...14
/tags/2.0	Current 2.0 release	Ubuntu 20.04...22.04, Apache 2.4, PostgreSQL 12...14
/trunk_1.9	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	Current 1.9 release	Debian 10...12; Ubuntu 18.04...22.04, Apache 2.2,2.4, PostgreSQL 11...14
others	Very old versions

Current documentation refers to 2.0 release!

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
  • Duplicate Application to Ubuntu 12.04 LTS (Precise Pangolin) in VPS (OpenVZ).
• DeployUbuntuTrusty Installation on Ubuntu 14.04 LTS (Trusty)
• DeployUbuntuPrecise2Xenial Upgrade from Ubuntu Precise VPS to Xenial
• DeployUbuntuXenial Installation on Ubuntu 16.04 LTS (Xenial)
• DeployUbuntuXenial2Bionic Upgrade from Ubuntu 16.04 LTS (Xenial) to 18.04 (Bionic)
• DeployUbuntuBionic Installation on Ubuntu 18.04 LTS (Bionic)
• 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