This topic provides an overview of the PolarDB for PostgreSQL (Compatible with Oracle) clients and drivers.
Clients
In addition to the PolarDB console, you can use clients to connect to PolarDB clusters. For more information, see Connect to a PolarDB for PostgreSQL (Compatible with Oracle) cluster.
PolarDB-Tools: a set of PolarDB client tools for all versions of Alibaba Cloud Linux, Rocky Linux, CentOS Stream, and CentOS.
PolarPlus: a client tool that is used to connect to PolarDB databases. PolarPlus is compatible with Oracle syntax.
Drivers
JDBC: a Java API that is used to connect Java applications to databases. The PolarDB for PostgreSQL (Compatible with Oracle) JDBC driver is developed based on the open-source PostgreSQL JDBC Driver and uses PostgreSQL protocols for communications. The JDBC driver allows Java applications to connect to databases by using standard Java code that is independent of the databases.
OCI: the native C language interface to databases of PolarDB for PostgreSQL (Compatible with Oracle). You can use PolarDB OCI to build other language-specific interfaces, including PolarDB Java Database Connectivity (JDBC), PolarDB .Net, and PolarDB Open Database Connectivity (ODBC). It allows you to execute query statements and make SQL function calls for PolarDB for PostgreSQL (Compatible with Oracle) databases.
ODBC: the driver used to connect a UNIX or Windows application to a PolarDB for PostgreSQL (Compatible with Oracle) cluster.
.NET: a driver that allows you to use programming languages such as C#, Visual Basic, and F# to connect to PolarDB databases. The PolarDB .NET driver (officially known as ADO.NET Data Provider for PolarDB) is compatible with Entity Framework Core and Entity Framework 6.x. You can use PolarDB .NET in conjunction with Entity Framework to develop applications in a quick way.
PHP: connects a PHP application to a PolarDB for PostgreSQL (Compatible with Oracle) cluster.
PolarDBO Flink CDC: the PolarDBO Flink CDC connector that supports PolarDB for PostgreSQL (Compatible with Oracle). The connector is packaged with minimal code changes based on the community Postgres CDC.