music.md

Music catalog

This Chinook-style example demonstrates several consecutive single links and an explicit playlist association object.

{{#include ../../examples/music.geli}}

Create data

cargo run -p gelite-cli -- schema apply examples/music.geli --database music.db
cargo run -p gelite-cli -- repl --database music.db

Insert an artist, album, two tracks, and a playlist in that order. Links use unique names and titles instead of copied generated IDs:

insert Artist { name := "Coco Sawatari", country := "Japan" }

insert Album {
  title := "Midnight Testimony",
  release_year := 2026,
  artist := (
    select Artist { id }
    filter .name = "Coco Sawatari"
  )
}

insert Track {
  title := "First Deduction",
  track_no := 1,
  duration_seconds := 214,
  genre := "mystery pop",
  album := (
    select Album { id }
    filter .title = "Midnight Testimony"
  )
}

insert Track {
  title := "After the Bell",
  track_no := 2,
  duration_seconds := 188,
  genre := "mystery pop",
  album := (
    select Album { id }
    filter .title = "Midnight Testimony"
  )
}

insert Playlist { name := "Sheri's Case Notes" }

insert PlaylistTrack {
  position := 1,
  playlist := (
    select Playlist { id }
    filter .name = "Sheri's Case Notes"
  ),
  track := (
    select Track { id }
    filter .title = "First Deduction"
  )
}

Query through the catalog

select PlaylistTrack {
  position,
  track: {
    label := concat(.title, " / ", .album.title),
    duration_seconds,
    genre,
    album: {
      title,
      artist: {
        name,
        country
      }
    }
  },
  playlist: {
    name
  }
}
filter .playlist.name = "Sheri's Case Notes"
  and .track.duration_seconds >= 180
order by .position asc
limit 20
offset 0

The filter and ordering traverse stored single links. Runtime nested result reconstruction remains deferred.