SQL Database (Postgres)
This is a client that only connects to non-Cosmonic, external services.
PostgreSQL is an incredibly popular, powerful open source relational database. In addition to communicating with Postgres databases, this provider can communicate with anything that supports the Postgres protocol. This includes cloud-managed, relational datastores like Amazon RDS in postgres mode.
To launch this provider, head to the logic view, click and input the following OCI reference URL in the launch provider dialog:
Configuring this capability provider is a little tricky during developer preview. You must construct a JSON payload, encode it in base64 and then set the
config_b64 field of the link definition. This experience will definitely improve as the developer preview moves forward.
JSON Configuration settings
|database connection string. Must begin with scheme |
|max size of connection pool. Default is 8.|
|minimum number of idle connections in pool. Default is 0. With this default, the provider does not consume resources until needed. If you need fast application startup time, you may wish to set this to 1 or more, and increase max_lifetime_secs to 86400.|
|when a connection has reached this age, after it has finished processing its current workload, it is closed instead of being returned to the pool. Default is 7200 (2 hours).|
|the amount of time a connection will remain idle in the pool before it is closed. This setting can be useful to reduce billing costs if your database is billed by connection-time. Default is 600 (10 minutes).|
For information on how to configure and manage this provider, please see the wasmCloud postgres provider documentation.