What's Changed

• fix(rust/sdk): remove schemamap.smo view and usage by @thenonameguy in #23

Full Changelog: v0.4.2...v0.4.3

What's Changed

• feat(sdk/cli): add more concepts from rule engine, add snapshot/restore command to CLI by @thenonameguy in #22

New status command:

Full Changelog: v0.4.1...v0.4.2

What's Changed

• fix: windows compilation, prompt for lack of --dev flag, fix Supabase init, status/refresh command by @thenonameguy in #21

Full Changelog: v0.4.0...v0.4.1

Features

• Reworked schemamap init SQL script to work on PGBouncer transaction mode Postgres DB (like Supabase)
• Updated Schema Metadata Overview view calculation to:
  • Exclude scanning schemas where there is no GRANT USAGE right
  • Track generated columns as constraints
  • Track index expressions in indexes jsonb
• Added Concepts abstraction, with 3 default concepts:
  • PII (columns) => (first_name, last_name, password, email, etc.)
  • Metadata (columns) => (created_at, updated_at, version)
  • Schema Migration Table (Flyway, Liquibase, schema_migrations, etc.)
  • Any more can be added easily with schemamap.define_concept
• Added schemamap.smo view for convenient shorthand along with automatically evaluated concept columns
• Added schemamap.tenants/schemamap.mdes as quicker to type aliases to list functions
• Added schemamap_dev DB (activated with schemamap init --dev=true) that adds the functionality of Stellar within PG itself

Chores

• Added Odoo CRM example folder to showcase SDK setup

Full Changelog: v0.3.0...v0.4.0

What's Changed

• feat: add schemamap Rust CLI by @thenonameguy in #19
  • track PK constraint backing sequences for schema_metadata_overview

Full Changelog: v0.2.1...v0.3.0

What's Changed

• feat(sdk): improve installer script idempotency and permissions grants by @thenonameguy in #16
• feat(sdk): add attnum (column ordinal, 1-based) to schemamap.schema_metadata_overview by @thenonameguy in #17

Full Changelog: v0.2.0...v0.2.1

TCP port forwading: ssh -> rathole

To provide a more reliable Postgres port forwarding experience to the platform, rathole has been introduced.

You can get the necessary configuration by reserving your private, project-specific tunnel at https://app.schemamap.io/

Simplified Developer Experience

The primary way to get started is via the official Docker image:
https://hub.docker.com/r/schemamap/postgres

docker run --rm -e POSTGRES_PASSWORD=postgres -p 5432:5432 --name=schemamap_postgres schemamap/postgres

For non-containerized Postgres servers, there is an installer script available:

curl -SL schemamap.dev/install_schemamap.sh | bash

What's Changed

• breakage: remove ssh port forwarding in favor of rathole, add docker image and SDK install script by @thenonameguy in #15

Full Changelog: v0.1.3...v0.2.0

What's Changed

• feat(sql): add grant_schemamap_usage.sql + release artifact by @thenonameguy in #14

Full Changelog: v0.1.2...v0.1.3

What's Changed

• fix(gha): rework GHA job to be tag push based by @thenonameguy in #13

Full Changelog: v0.1.1...v0.1.2

What's Changed

• feat(bash): add initial version of SDK by @thenonameguy in #10
• chore(docs): improve wording of README for clarity by @thenonameguy in #11
• feat(setup): add release GHA job with sql release artifacts by @thenonameguy in #12

Full Changelog: v0.1.0...v0.1.1