Seu primeiro banco, sem adivinhar etapas.

$release = Invoke-RestMethod "https://api.github.com/repos/notrevetecnologia/otsardb/releases" | Where-Object { -not $_.draft } | Select-Object -First 1
$package = $release.assets | Where-Object { $_.name -match "windows" } | Select-Object -First 1

if (-not $package) { throw "Pacote Windows não publicado na release atual." }

$installDir = "$env:LOCALAPPDATA\OtsarDB"
$archive = Join-Path $env:TEMP $package.name

New-Item -ItemType Directory -Force -Path $installDir | Out-Null
Invoke-WebRequest -Uri $package.browser_download_url -OutFile $archive
Expand-Archive -Path $archive -DestinationPath $installDir -Force

$otsardb = "$installDir\otsardb.exe"
& $otsardb --version

$settings = @{
  OTSARDB_S3_ENDPOINT   = "https://s3.us-east-1.amazonaws.com"
  OTSARDB_S3_REGION     = "us-east-1"
  OTSARDB_S3_ACCESS_KEY = "SUA-ACCESS-KEY"
  OTSARDB_S3_SECRET_KEY = "SUA-SECRET-KEY"
}

foreach ($name in $settings.Keys) {
  [Environment]::SetEnvironmentVariable($name, $settings[$name], "User")
  Set-Item -Path "Env:$name" -Value $settings[$name]
}

$bucket = "troque-por-um-bucket-seu"
$database = "s3://$bucket/apps/primeiro-banco"

& $otsardb --health $database

& $otsardb $database `
  "CREATE TABLE IF NOT EXISTS users (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    email TEXT NOT NULL
  );"

# INSERT
& $otsardb $database `
  "INSERT INTO users(name, email)
   VALUES('Ana', 'ana@example.com');"

# SELECT
& $otsardb $database `
  "SELECT id, name, email FROM users;"

# UPDATE
& $otsardb $database `
  "UPDATE users
   SET email = 'ana@otsardb.org'
   WHERE id = 1;"

# DELETE
& $otsardb $database `
  "DELETE FROM users WHERE id = 1;"