Use cases
ADPG is a powerful relational database management system (RDBMS). ADPG is based on the object-relational Open Source DBMS PostgreSQL. ADPG can be used in business critical and non-critical applications in various industries.
ADPG is a good solution in the following cases:
-
Financial industry. ADPG is fully ACID compliant and suitable for OLTP (Online Transaction Processing) workloads. It is also an analytical database and can be integrated with math software.
-
Industrial manufactures. ADPG is a reliable long-term data warehouse that offers reliable storage at a low cost. ADPG is the good choice because it can be configured for automatic failover, full redundancy, and almost zero downtime upgrades.
-
GIS data. ADPG includes a powerful GIS extension — PostGIS, which provides hundreds of functions to process geographic data in various formats.
-
Web technologies and NoSQL workloads. Websites might require thousands or hundreds of thousands of requests per second to serve customers. ADPG meets this requirement and can be used as a storage backend in scalable applications. ADPG works with modern web frameworks including Django (Python), node.js (JavaScript), Hibernate (Java), Ruby on rails, PHP, and others.
Due to replication capabilities, websites can be scaled out to as many database servers as you need.
ADPG can also be used as a NoSQL-style data store.
-
Scientific data. Research and scientific projects can generate terabytes of data. ADPG has analytical capabilities and offers a powerful SQL engine that can easily process large amounts of data. ADPG can also be extended. You can write aggregation functions and implement your own business logic in the database.
-
Metric storage. You can install the TimescaleDB extension and use ADPG to store time series data. For example, currency rates, vehicle movement telemetry, statistics of server access or CPU load that change over time.
-
Storage for Arenadata products. Some Arenadata products use ADPG as their internal storage. For example, ADH saves meta-information in an ADPG cluster.