Cake SQL Query Builder for Gleam

Package <a href="https://github.com/inoas/gleam-cake/releases"><img src="https://img.shields.io/github/release/inoas/gleam-cake" alt="GitHub release"></a> <a href="https://discord.gg/Fm8Pwmy"><img src="https://img.shields.io/discord/768594524158427167?color=blue" alt="Discord chat"></a> CI Version Hex Docs Erlang-compatible JavaScript Compatible test



Cake Logo


Cake is a library written in Gleam to compose SQL queries targeting SQL dialects PostgreSQL, SQLite, MariaDB and MySQL.



Installation

gleam add cake

Further documentation can be found on hexdocs.pm/cake.

Usage

Demos

See docs/demo-apps/README.md.

Code examples (from the demos)

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.

Intended aliases

Use the following aliases to make the library more ergonomic:

import cake/select as s // SELECT statements
import cake/where as w // WHERE clauses
import cake/join as j // JOIN clauses
import cake/update as u // UPDATE statements
import cake/insert as i // INSERT statements
import cake/delete as d // DELETE statements
import cake/combined as c // For combined queries such as UNION
import cake/fragment as f // For arbitrary SQL code including functions

Library Design

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

Non-goals

Tested targets

The tests run on Erlang but are generally target agnostic: While the primary use case is to run queries on servers, this library runs on any Gleam target and for example in conjunction with sqlite3 WASM/JS you may run queries composed with this library in browsers.

Development

Run test suite locally

bin/docker/attached
# wait a few seconds until everything is ready
# if you run gleam test too early, it will crash
gleam test

Helper commands

bin/docker/attached
bin/docker/detached
bin/docker/down

bin/test

bin/birdie/interactive-review
bin/birdie/accept-all
bin/birdie/reject-all

Library naming

The best part of working with CakePHP 3+ used to be its Query Builder. This library is inspired by that and thus the name.

Thank you @lorenzo and @markstory for creating and maintaining CakePHP and its awesome query builder over the years.

Search Document