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 central-server.db, already included in .gitignore

db:
  debug: true
  driver_name: "libsql"
  primary_db_source: "file:central-server.db"
  run_migrations: true

Sqlite

1. This will write to a local file central-server.db, already included in .gitignore

db:
  debug: true
  driver_name: sqlite3
  primary_db_source: "central-server.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://central-server-central-server.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 GooseMigrations embed.FS

GooseMigrations contain an embedded filesystem with all the goose migration files

var Migrations embed.FS

Migrations contain an embedded filesystem with all the sql migration files