{"repo":"babashka/babashka-sql-pods","free":true,"listed":false,"github":"https://github.com/babashka/babashka-sql-pods","clone":"git clone https://github.com/babashka/babashka-sql-pods.git","description":"Babashka pods for SQL databases","language":"Clojure","stars":101,"topics":["babashka","postgresql","hsqldb","jdbc","clojure"],"license":"EPL-1.0","category":"databases-storage","readme_excerpt":"Babashka sql pods Babashka pods for interacting with SQL databases. Supported databases: - HSQLDB - IBM DB2 - Microsoft SQL Server - MySQL - Oracle - PostgresQL PRs for other SQL databases are welcome. (Look at #15 + #20 for an example of adding a new DB.) Install The following installation methods are available: - Use the latest version from the pod-registry. This is done by calling load-pod with a qualified keyword: Babashka will automatically download the pod if it is not available on your system yet. - Download a binary from Github releases Compatibility Pods from this repo require babashka v0.4.3 or later. Available vars The pods expose these namespaces with vars, where must be substituted with the database type, either db2 , hsqldb , mssql , mysql , oracle , or postgresql : - pod.babashka. : - execute! : similar to next.jdbc/execute! - execute-one! : similar to next.jdbc/execute-one! - get-connection : returns connection serialized using maps with a unique identifier key - close-connection : closes a connection returned from get-connection - with-transaction : similar to next.jdbc/with-transaction - pod.babashka. .sql : - insert-multi! : similar to next.jdbc.sql/insert-multi! - pod.babashka. .transaction : - begin : marks the begin of a transaction, expects connection returned from get-connection - rollback : rolls back transaction, expects connection returned from get-connection - commit : commits transaction, expects connection returned from get-connection More functi","default_branch":null,"files":null,"tree":[],"storefront":"/r/babashka","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/babashka/babashka-sql-pods/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."}