{"repo":"ballerina-platform/module-ballerina-sql","free":true,"listed":false,"github":"https://github.com/ballerina-platform/module-ballerina-sql","clone":"git clone https://github.com/ballerina-platform/module-ballerina-sql.git","description":"Ballerina SQL Module","language":"Java","stars":115,"topics":["ballerina","sql","hacktoberfest","database","integration","rdbms","wso2"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Ballerina SQL Library =================== This library provides the generic interface and functionality to interact with an SQL database. The corresponding database clients can be created by using specific database libraries such as mysql or using the Java Database Connectivity library jdbc . List of database libraries Ballerina now has the jdbc library as the generic DB connector library to connect to any relational database by simply providing the JDBC URL and the other related properties. Ballerina also provides specially designed various database-specific DB connectors so that you can work with different databases, and you can access their DB-specific functionalities. MySQL library PostgreSQL library MSSQL library OracleDB library Client A database client can be created using any of the above-listed database libraries. The operations and functionality explained below can be used with the newly created client. Tip : The client should be used throughout the application lifetime. Handle connection pools All database libraries share the same connection pooling concept and there are three possible scenarios for connection pool handling. For its properties and possible values, see the sql:ConnectionPool . Note : Connection pooling is used to optimize opening and closing connections to the database. However, the pool comes with an overhead. It is best to configure the connection pool properties as per the application need to get the best performance. 1. Global, shareable, defaul","default_branch":null,"files":null,"tree":[],"storefront":"/r/ballerina-platform","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ballerina-platform/module-ballerina-sql/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."}