Advantages of open source databases.
Open source databases have developed rapidly in recent years. They are very popular with developers and increasingly used in companies of all sizes. They therefore offer a strong alternative to commercial databases such as Oracle Database. The advantages are apparent:
Overview of all databases that fall within our area of expertise
POSTGRESQL
Install on physical, virtual servers or even containers with little effort
PostgreSQL (alias Postgres) is an open source RDBMS that has been continuously developed for more than 30 years. Postgres offers features and tools for a robust and high-performance RDBMS. Several times a year, minor releases with some bug fixes are published by the Postgres community. Once a year there is a major release. In addition to the open source Postgres, there is a commercial offshoot of the EnterpriseDB company, EDB Postgres. This is completely based on the Community Postgres and supplements it, for example, with tools for high availability or backup and recovery.
We are happy to support you in using Postgres in a professional environment.
Deployment options
Postgres supports all common operating systems such as Windows, MacOS, and various Linux distributions. You can install Postgres classically on bare metal or virtualized, configure, and use it productively. However, cloud providers such as Amazon Web Services also offer a managed Postgres service. On containers with Kubernetes or OpenShift, you can operate your Postgres database cluster with high availability.
Overview of our database services
Proventa supports you in the whole spectrum of Postgres. As an EDB Platinum Partner, we can offer you German support for EDB Postgres. Be it the migration of your DBMS on Postgres, selected training for your employees, or advice on high availability and backup and restore. Proventa is there for you!
On our German blog you can also find additional information and tutorials on Postgres and Kubernetes.
Want more information?
I will be happy to advise you on all your questions about Open Source Database and Postgres and help you to find the right model to benefit from its advantages.
Dirk C. Aumueller
Associate Partner & Database Expert
Together with our partner, we are strengthening the digital transformation of companies in the database area. For this purpose, plusserver offers a managed database that supports companies, for example, when switching hardware to a European cloud.
In combination with our offer to migrate databases to Postgresql, we are able to offer customers an extensive package.
PostgreSQL and EDB Postgres
We are a Platinum Partner of EDB Postgres and have already supported many companies in changing licenses from commercial databases, such as Oracle to Postgres.
Get an overview of EDB Postgres, its features, and its services
- EDB is the largest PostgreSQL supplier with more 4.000 clients (100+ Fortune 500) and more than 300 employees
- Single OS RDMBS-supplier in Gartner-Magic Quadrant (OPDBMS)
- Largest footprint in PostgreSQL community
- Security Features: Password profiles, session tag auditing, auditing, data encryption, data masking, connectivity to authentication (LDAP, Kerberos etc.)
- Database Management: Management and migrationstools, high avalibility and backup/recovery
- Software Connectivity: Support for JDBC, ODBC, OCI etc.
- Oracle Compatibility: SQL extension, PL/SQL support, tools, drivers
- Multi-Deployment Options: Bare metal, virtualization, cloud, container, hybrid solutions, PaaS and DBaaS integration
- Fileformats/Foreign Data Wrapper: Links to all SQL/NoSQL systems and native support for JSONB, KVP and PostGIS
- Support: 24/7 service and support, remote-DBA, managed database
- License Model: One Licene, all features, core-based subscription model
- EDB Tools: includes backup/recovery, OCI-connection, monitoring tools etc.
Which Postgres option suits your company best?
Every company has its own needs and priorities. We have compared the classic Open Source variant and the EnterpriseDB variant.