preloader

VENDOR RELATIONSHIPS

CLIENT CASE STUDIES

DB Administration, Security and Compliance for First Distribution

DB Administration, Security and Compliance for First Distribution

First Distribution’s Database Administration, Security and Compliance needs lead it to trusted advisor, Ascent Technology. For any large organisation, Database Administration (DBA) is a vital part of maintaining their Data Platform Operations effectively. As it has...

Ascent Technology helps Bidfood SA migrate to Microsoft Azure

When Bidfood SA chose to modernise and migrate its data platform to Microsoft Azure, it turned to Ascent Technology for help. In a world that is digitally transforming, it is more vital than ever to an organisation’s success to utilise the latest platforms to drive...

Ascent Technology helps migrate Phumelela Gaming to Azure

A Windows Server and SQL Server consolidation, optimisation and migration to Microsoft Azure enables the company to reduce costs, modernise its data platform and boost its innovation capabilities. As an operator running two distinct betting businesses, Phumelela...

CAMPAIGNS

Database System Health Check Service from Ascent Technology

Database System Health Check Service from Ascent Technology

A Database System Health Check assesses if your Database is running optimally, and can help diagnose challenges before performance issues, and/or down time affect your users. That’s where Ascent's Database Health Check Service comes in. Our Database Health Check...

Database Security and Compliance with DB Shield

The growing number of threats to databases and unauthorised access to the data within, is clearly creating on-going headaches for CIOs. Solving these headaches may not be easy, but by asking the right questions, CIOs can begin to overcome their Database Security and...

Database Administration and Support Service from Ascent Technology

Economic volatility is driving a greater number of organisations to consider cost cutting measures and to implement consolidation procedures. This situation is further compounded by the growing skills shortage that makes it more difficult for businesses to acquire and...

AWARDS AND ACCOLADES

Microsoft Data and Analytics Partner of the Year Finalist

Microsoft Data and Analytics Partner of the Year Finalist

Ascent Technology continues its strong showing in the Microsoft Partner of the Year awards, as a finalist in the Data and Analytics Partner of the Year award. Finalist Data and Analytics Partner of the Year "It is always gratifying to be recognised by Microsoft as one...

NEWSFLASHES

Ascent Technology’s clients benefit from Data Platform Modernisation

Ascent Technology’s clients benefit from Data Platform Modernisation

Facing platform ‘end of life’ issues together with increasing pressures to digitise processes, increase profitability and innovate on product and service, organisations are finding Data Platform Modernisation projects can deliver significant value by enabling IT cost...

FROM THE DESK OF THE MD

From the Desk of the MD – January 2019

From the Desk of the MD – January 2019

The start of another year inevitably brings with it the promise of change, and in wishing all our clients a happy New Year, we would like to suggest that 2019 is going to be a year of considerable and exciting change. After all, not only do we have what are sure to be...

PostgreSQL

PostgreSQL, now supported by Ascent Technology

15 Jun 2017

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.

It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, macOS, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages).

It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance.

It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting.

It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.

For more information visit PostgreSQL.org