Zammad

It offers the connection of various channels like email, chat, telephone, Twitter, or Facebook.

Technologically, the user interface is implemented as a web application with CSS, JavaScript, and HTML5 (including WebSockets),[11] which means that the application runs in the browser – only data is exchanged over the network (in REST).

Thus the WebApp feels like a native application and is capable of real-time (information is updated in all clients immediately after creation/change without reloading the application/web page).

[13] The backend is realized in Ruby on Rails and communicates with the user interface via REST.

[14] MySQL, MariaDB, or PostgreSQL are supported as database servers up to Zammad version 6.