Skip to main content
Skip table of contents

Comparison of Database Types

NOT AVAILABLE IN SAAS


When installing the Ekran System Application Server, you can choose between two types of databases (the MS SQL database and the PostgreSQL database). These databases have the following differences:

Feature

MS SQL Server Database

PostgreSQL Database

General

Commercial/open-source

A commercial database from Microsoft.

An open-source product.

Free-of-charge

(error) (but has a limited free version).

NOTE: Using MS SQL Express does not guarantee the stable operation of the Application Server.

(tick)

Requires additional software installation

(tick)

(tick)

Scalability

Remote access to database

(tick) (a separate database engine that can be deployed on a separate server).

(tick) (a separate database engine that can be deployed on a separate server).

Support for clustering

(tick)

(tick) (Primary-Standby).

Support for network drives

(tick)

(tick) (if mounted as a drive).

Performance

Processing speed

High

High

Efficient caching algorithms

(tick)

(tick)

Index statistics update

Automatic

Manual

Memory/process usage

A separate process, more efficient memory usage, quotas can be applied.


A separate process, more efficient memory usage, quotas can be applied.

Additional features

Maintenance tasks can be executed by the engine independently.

• Optimization of complex execution plans.

• Cross-platform. It can be run on a variety of systems and platforms (Windows, Linux, macOS, BSD, Solaris).

• A lot of third-party solutions for replications and clustering are available.

Requires installation of additional software

(tick)

(tick)

Safety and Security

Security

High (keystroke encryption is supported).

High (keystroke encryption is supported).

Safety

• Database corruption is unlikely.

• Replications.

• Сan be managed via Microsoft native tools.

• Supports scheduled maintenance: reindexing, shrinking, etc. 

• Database corruption is unlikely.

• Replications                                                                                                                                                                                                      


Backup

Flexible backup logic (to learn more about MS SQL Server database backup, visit the Microsoft website at: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/full-database-backups-sql-server?view=sql-server-2017

Flexible backup logic (to learn more about PostgreSQL database backup, visit the PostgreSQL website at: https://www.postgresql.org/docs/9.1/static/backup.html

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.