Loading...
 

 

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius' daughter, and "SQL", the abbreviation for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL is currently owned by Oracle Corporation. For proprietary use, several paid editions are available and offer additional functionality. MySQL is a central component of the LAMP open-source web application software stack. It is the most used DBMS system in the world.

vTiger is a powerful CRM built on top of a technological stack based on LAMP, which means PHP as the main programming language and MySQL relational database for data management. In the frontend, vTiger uses Bootstrap as the main presentation and content framework. vTiger has a lot of functionalities, including:

  • Powerful libraries for generation of invoices, shipping labels in PDF format.

  • Workflows that are based upon relational database Triggers, which execute on first save, on each save or delete of a DB record.

  • Actions basically are PHP or NodeJS scripts that are executed by clicking on the buttons.

  • Mass edit functionalities for mass updating hundreds or thousands of records, based on a user-provided condition

  • Filter management for list view of modules

  • The functionality of editing records directly in detail view through AngularJS functions

  • Robust security management which has two main directions - horizontal direction based on profiles (what the users have access to)

  • vertical direction based on roles (what the users can see according to the position they have in the organization structure).

vTiger CRM is highly customizable and configurable from CRM users. It is based on a modular software architectural approach, which makes it very light in terms of customizing existing modules and adding new ones. For this reason, vTiger can reflect the whole organizational structure and the business processes of the company, based on the different departments. In the GDPR Management system, we will use the basic modules of Corebos like Organization, Employee, Third Parties, Physical Areas. Also, we need to develop entirely new modules in vTiger like Personal Data Categories, Processing Activities, Cities and Risk Management modules like Threats and Threats Measures.   Node.js is an open-source, cross-platform JavaScript runtime environment for developing a diverse variety of server tools and applications. Although Node.js is not a JavaScript framework, many of its basic modules are written in JavaScript, and developers can write new modules in JavaScript. The runtime environment interprets JavaScript using Google's V8 JavaScript engine.

Node.js has an event-driven architecture capable of asynchronous I/O. These design choices aim to optimize throughput and scalability in Web applications with many input/output operations, as well as for real-time Web applications (e.g., real-time communication programs and browser games). The Node.js distributed development project, governed by the Node.js Foundation, is facilitated by the Linux Foundation' s Collaborative Projects program.

Node.js allows the creation of Web servers and networking tools using JavaScript and a collection of "modules" that handle various core functionality. Modules are provided for file system I/O, networking (DNS, HTTP, TCP, TLS/SSL, or UDP), binary data (buffers), cryptography functions, data streams, and other core functions.

 

Admin Manual
Developer Manual