Package Version Hex Docs

This package provides a unified interface for interacting SQL databases. With based, gleam code can remain mostly database-agnostic. SQL queries will need to be written for your chosen database (postgres, sqlite, etc), but execution of those queries isn’t tied to your chosen database.

Packages for different database backends can conform to the type and function definitions in this package. This can allow developers to quickly get started writing gleam programs using a sqlite backend, but change to postgres when needed without a large refactor.

Example packages that can be used with based

gleam add based
import based
import dynamic
import based_pg
// import based_sqlite

const sql = "SELECT name FROM users WHERE id=$1;"

pub type User {
  User(name: String)

pub fn main() {
  let config = load_config()

  use db <- based.register(based_pg.adapter(config))
  // use db <- based.register(based_sqlite.adapter(config))

  let decoder = dynamic.decode1(User, dynamic.element(0, dynamic.string))

  // Swapping out the backend doesn't require rewriting the existing queries
  |> based.with_values([])
  |>, decoder)

Further documentation can be found at


gleam run   # Run the project
gleam test  # Run the tests
gleam shell # Run an Erlang shell
Search Document