db

README

Database Support

Dependencies

1. ent - insane entity mapping tool, definitely not an ORM but kind of an ORM
2. atlas - Schema generation and migration
3. entx - Wrapper to interact with the ent

Supported Drivers

1. libsql
2. sqlite
3. postgres

Local Development

Config Examples

Libsql

1. This will write to a local file datum.db, already included in .gitignore

db:
  debug: true
  driver_name: "libsql"
  primary_db_source: "file:datum.db"
  run_migrations: true

Sqlite

1. This will write to a local file datum.db, already included in .gitignore

db:
  debug: true
  driver_name: sqlite3
  primary_db_source: "datum.db"
  run_migrations: true

Postgres

1. Postgres is included in docker/docker-compose-fga.yml and the same instance can be used for development. The following connection string should work when using task docker:all:up

db:
  debug: true
  driver_name: postgres
  primary_db_source: "postgres://postgres:password@postgres:5432?sslmode=disable"
  run_migrations: true

Turso

1. Replace the url with your turso database url and token

db:
  debug: true
  driver_name: libsql
  primary_db_source: "https://datum-datum.turso.io?authToken=$TURSO_TOKEN"  # set TURSO_TOKEN to value
  run_migrations: false

Documentation

Overview

Package db provides an embedded filesystem containing all the database migrations

Index

• Variables

Variables

var GooseMigrationsPG embed.FS

GooseMigrationsPG contain an embedded filesystem with all the goose migration files for postgres

var GooseMigrationsSQLite embed.FS

GooseMigrationsSQLite contain an embedded filesystem with all the goose migration files for sqlite

var Migrations embed.FS

Migrations contain an embedded filesystem with all the sql migration files