owncast/storage/sqlstorage

SQL Storage

This package contains the base SQL schema, migrations and queries. It should not need to be imported by any package other than the datstore.

SQL Migrations

Add migrations to migrations.go and use raw SQL make your required changes between schema versions.

SQL Queries

sqlc generates type-safe code from SQL. Here's how it works:

1. You define the schema in schema.sql.
2. You write your queries in query.sql using regular SQL.
3. You run sqlc generate to generate Go code with type-safe interfaces to those queries.
4. You write application code that calls the generated code.

Only those who need to create or update SQL queries will need to have sqlc installed on their system. It is not a dependency required to build the codebase.

Install sqlc

Snap

sudo snap install sqlc

Go install

go install github.com/kyleconroy/sqlc/cmd/sqlc@latest

macOS

brew install sqlc

Download a release

Visit https://github.com/kyleconroy/sqlc/releases to download a release for your environment.