{"repo":"inoas/gleam-cake","free":true,"listed":false,"github":"https://github.com/inoas/gleam-cake","clone":"git clone https://github.com/inoas/gleam-cake.git","description":"A Gleam library to compose SQL queries targeting SQL dialects PostgreSQL, SQLite, MariaDB and MySQL.","language":"Gleam","stars":132,"topics":["dynamic","mariadb","mysql","postgres","query-builder","sql","sqlite","gleam-language","gleam-library"],"license":"MPL-2.0","category":"databases-storage","readme_excerpt":"🎂 Cake SQL Query Builder for Gleam 🎂Cake is a library written in Gleam to compose SQL queries targeting SQL dialects 🐘PostgreSQL, 🪶SQLite, 🦭MariaDB and 🐬MySQL. Installation Further documentation can be found on cake.hexdocs.pm. Adapters - 🐘PostgreSQL on Erlang: hex.pm/packages/cake pog - 🪶SQLite on Erlang: hex.pm/packages/cake sqlight - 🦭MariaDB and 🐬MySQL on Erlang: hex.pm/packages/cake shork Usage Demos See examples/README.md. Code examples (from the demos) - cake\\ demo\\ select\\ and\\ decode.gleam - cake\\ demo\\ union\\ and\\ decode.gleam - cake\\ demo\\ insert.gleam - cake\\ demo\\ delete.gleam - cake\\ demo\\ update.gleam - cake\\ demo\\ insert\\ on\\ conflict\\ update.gleam - cake\\ demo\\ select\\ join.gleam - cake\\ demo\\ prepared\\ fragment.gleam Unit tests as examples See Cake's tests, especially the Setup sections in each test module. You may also compare the tests with the snapshots results. Scope This is an SQL query building library, thus it is not concerned about executing queries or decoding return values from queries, but merely about being a flexible and powerful tool to compose and craft SQL read and write queries. Goals - High degree of flexibility to compose queries: While the focus is on building queries there is also support for replacing or removing parts of queries. - General support on these 4 large RDBMS: 🐘PostgreSQL, 🪶SQLite, 🦭MariaDB and 🐬MySQL. - Not being tied to any specific dialect or dialect adapter library. - Documentation should be comprehensive. ","default_branch":null,"files":null,"tree":[],"storefront":"/r/inoas","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/inoas/gleam-cake/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."}