TourTools is built using the FileMaker platform. FileMaker is a cross-platform relational database application from Claris International, a subsidiary of Apple Inc. It integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. It is available in desktop, server, iOS and web-delivery configurations.
FileMaker Server allows centralized hosting of apps which can be used by clients running the desktop or mobile apps. It is also available hosted by Claris, called FileMaker Cloud.
This is the basic entity relationship diagram for TourTools v4 back office:
TourTools Online is built using PHP and Yii framework. It is an MVC based web application using the Bootstrap (twitter) framework to provide a compatible and accessible interface. Also, the use of standards compliant MVC/Front End architecture allows for TTO to be modified and enhanced as needed. All of the software used is open source and kept up to date as per client needs. The application is compatible with the most up to date version of PHP (currently, version 8).
The application acts as an interface to the backend FileMaker server application via the FileMaker/PHP API hosted either in-house or at an approved managed 3rd party hosting provider on a managed basis.
All libraries used in the web application are updated as per availability and the architecture (separated backend-database and front-end web application) allows for secure DMZ environments. The interface between the web application and the backend are implemented according to best practices and vendor specification.
Post your comment on this topic.