{"repo":"ballerina-platform/module-ballerinax-postgresql","free":true,"listed":false,"github":"https://github.com/ballerina-platform/module-ballerinax-postgresql","clone":"git clone https://github.com/ballerina-platform/module-ballerinax-postgresql.git","description":"Ballerina PostgreSQL DB module","language":"Ballerina","stars":107,"topics":["ballerina","postgresql"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Ballerina PostgreSQL Library =================== This library provides the functionality required to access and manipulate data stored in a PostgreSQL database. Prerequisite Add the PostgreSQL driver as a dependency to the Ballerina project. Note : ballerinax/postgresql supports PostgrSQL driver versions above 42.2.18. You can achieve this by importing the ballerinax/postgresql.driver module, ballerinax/postgresql.driver package bundles the latest PostgreSQL driver JAR. Tip : GraalVM native build is supported when ballerinax/postgresql is used along with the ballerinax/postgresql.driver If you want to add a PostgreSQL driver of a specific version, you can add it as a dependency in Ballerina.toml. Follow one of the following ways to add the JAR in the file: Download the JAR and update the path Add JAR with a maven dependency params Setup guide Change data capture 1. Enable Logical Replication : - Add the following lines to the PostgreSQL configuration file ( postgresql.conf ): - Restart the PostgreSQL server to apply the changes: Client To access a database, you must first create a postgresql:Client object. The examples for creating a PostgreSQL client can be found below. Tip : The client should be used throughout the application lifetime. Create a client This example shows the different methods of creating a postgresql:Client . When the database is in the default username, the client can be created with an empty constructor, and thereby, the client will be initialized with th","default_branch":null,"files":null,"tree":[],"storefront":"/r/ballerina-platform","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ballerina-platform/module-ballerinax-postgresql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}