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 Database

PostgreSQL Database

General

Commercial/open-source

A commercial database from Microsoft.

An open-source product.

Free                                                                                                                            

No (has a limited free version).

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

Yes

Requires additional software installation

Yes

Yes

Scalability

Remote access to database

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

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

Support for clustering

Yes

Yes (Primary-Standby).

Support for network drives

Yes

Yes (if mounted as a drive).

Performance

Processing speed

High

High

Efficient caching algorithms

Yes

Yes

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

Yes

Yes

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