based

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:

• based_pg
• based_sqlite

gleam add based

import based
import based_pg
// import based_sqlite
import gleam/option.{None}

const sql = "DELETE FROM users WHERE id=$1;"

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

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

  // Swapping out the backend doesn't require rewriting the existing queries
  based.new_query(sql)
  |> based.with_args([based.int(1)])
  |> based.exec(db)
}

Further documentation can be found at https://hexdocs.pm/based.

Development

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