Introduction
PostgreSQL® is one of the most used open-source object-relational database systems. This ESF addon provides a client to interact with a PostgreSQL® server.
This ESF addon uses the PostgreSQL JDBC Driver to implement the following Kura APIs for managing databases:
BaseDbService
: provides means to acquire and release JDBC connections to this Postgres database.MessageStoreProvider
: allows to createMessageStore
instances that can be used in the DataService of a Cloud Connection.QueryableWireRecordStoreProvider
: allows to perform queries defined in Postgres SQL syntax and return the result in terms of a list ofWireRecord
s.WireRecordStoreProvider
: allows to open or create aWireRecordStore
instance with the given name.
Warning
PostgreSQL uses a different SQL syntax than the one used in the DB Store and DB Filter wire components. Hence, the addon will not work with such components. Use the Wire Record Query and Wire Record Store components instead.
The database instance can reside on the gateway itself, can be remote, or run on a container. Follow the PostgreSQL Documentation for server setup or check the Tutorials section for some use cases.
The com.eurotech.framework.postgresql.client.feature
addon is available as a Deployment Package (DP). It can be installed from the ESF web UI ("Packages" section) or remotely using Everyware Cloud. Once installed, it is possible to create a new PostgresClientService
, like in the pictures below.