Skip to content

v1.0.2 — first public SQLAnvil release

Choose a tag to compare

View all tags
@ihistand ihistand released this 05 Jun 14:01
· 54 commits to main since this release
v1.0.2
5272295

SQLAnvil is an open-source SQL workflow tool for BigQuery, PostgreSQL, and Supabase — a fork of Dataform OSS (Apache-2.0) extended with first-class Postgres/Supabase support (upstream Dataform OSS dropped Postgres after Google's acquisition).

This is the first public GitHub release of the SQLAnvil 1.x line. Install:

npm install -g @sqlanvil/cli
sqlanvil init my-project --warehouse postgres   # or: supabase | bigquery

Highlights of the 1.0.x line

  • Three first-class warehouses — BigQuery, PostgreSQL, and Supabase. Postgres/Supabase generate idiomatic Postgres DDL/DML (native partitioning, INSERT … ON CONFLICT upserts, btree/gin/gist/brin indexes, materialized views), not translated BigQuery SQL.
  • Supabase-native action types — RLS policies, Realtime publications, and pgvector indexes, with RLS enforcement verified end-to-end against live Postgres.
  • Flat config + gitignored credentials — workflow_settings.yaml holds a flat warehouse: string and non-secret defaults; the connection (with secrets) lives in a gitignored .df-credentials.json. Unknown warehouse: values are rejected instead of silently defaulting to BigQuery.
  • Fail-fast connection probe — the Postgres/Supabase adapters verify the connection on create, so misconfigured hosts fail immediately with a clear error instead of hanging or tripping Supabase's pooler lockout.
  • Warehouse-aware init — sqlanvil init --warehouse {postgres,supabase,bigquery} scaffolds the right workflow_settings.yaml + .df-credentials.json template.
  • Decoupled versioning — SQLAnvil has its own SemVer line; sqlanvil --version also reports the upstream Dataform core it's synced to.

What's new in 1.0.2

  • npm packages (@sqlanvil/cli, @sqlanvil/core) now ship README.md, LICENSE, and NOTICE in the published tarball, so the npm package pages render the README and the Apache-2.0 license file is included in the artifact.

Docs

SQLAnvil is not affiliated with or endorsed by Google. The Dataform name and related marks are trademarks of Google LLC; see NOTICE for attribution.

Assets 2
Loading