Skip to content

Pistachio

v0.21.0 Feature

This release adds 2 notable features for engineering teams evaluating rollout.

Published 3mo Relational Databases
✓ No known CVEs patched
Read the diff → Tool health → What is this tool? →

✓ No known CVEs patched in this version

Topics

cli database-migration database-migrations db-migration ddl declarative
+7 more
declarative-migrations go postgresql schema-changes schema-management schema-migration schema-migrations

Summary

AI summary

Adds full support for materialized views including creation, alteration, dependency handling, and diff ordering via topological sort.

Full changelog

Changelog

  • 58f99402b40f0d4809ac5aedec2e07b91aa014d3 Merge pull request #88 from winebarrel/add-omit-schema-scenario-test
  • 1244268161d817d55f85b16ed1b220fc736dcc7d Guard pist commands with if-blocks in omit_schema scenario
  • b135cbde90544c0483c2b6a6b65a11abf62f0e86 Fix schemaless index definition missing schema qualification
  • 35fee270724332ba902fc1c02e98ecce9aaf0873 Add --omit-schema scenario test
  • 447f70a6f09e6fbb5f31024a0c8a63db30a9beaf Merge pull request #87 from winebarrel/add-matview-dependency-tests
  • 69eec3d0d63155ba0d25fafdb7fb8153df12632a Add materialized view dependency and filter tests
  • 5e949e19fab0b9b48690fc9457c18ec213ce1952 Merge pull request #86 from winebarrel/add-materialized-view-support
  • 03dc224f879c574c4a83f1eb04c24b27d23d87cd Clarify comment on recreated view comment handling
  • 5ae310c9c033c990c986b7da084f90bca4daeb52 Re-apply comment after materialized view DROP+CREATE
  • 33fbe1220f1d92e50bb16c4ffc175c5ae0317e98 Preserve table.* in ColumnRef stripping
  • 640e66030e3b1d2bbb05d09586f3f054359e828c Add nil guards for CreateTableAsStmt in deps.go
  • af81e9baae9b5e92cc97e4cf0babdba015729153 Improve parser coverage for materialized view paths
  • 4a338c5188f30fbe566c012ea4e58ac9e089d9d9 Fix grep regex portability in helper.sh
  • f0b1fd819ff5e02a8de0be8771586f85955cd86a Fix rename type mismatch and comment type consistency
  • 2926cd5319c013de53f990cfc0f91f2a4e327105 Handle VIEW ↔ MATERIALIZED VIEW type changes and add ALTER MATERIALIZED VIEW pattern
  • ae9aba2fe9dbe3cc53424eab24f83b99afabb3ef Add materialized view to drop_policy scenario tests
  • bd24c9453c09011145a9f2ecaeb531ac8b9f42bc Gate materialized view modify on drop policy
  • 9add684d0e3ec20feab91cc6ce6bcefd5e647ad1 Improve patch coverage for catalog and parser
  • 8e2d3b44aebff07d933227f3e3a719b2975dab35 Improve diff/views.go patch coverage with equalViewDef tests
  • a0098a72608721cb6c26265504f5f1f6cfe725c8 Add remaining materialized view test coverage
  • b5a2502c6e06ba92f1588c48fa507b7e6dce68f7 Add missing materialized view test patterns and fix bugs
  • 92842018b0145efacf531f14152352f4a9d0ce10 Add materialized view support
  • b5e48bae79fcb28488cf695a488c34ec41658e82 Merge pull request #85 from winebarrel/toposort-diff-ordering
  • 40f426993ffe5858bcd69224a4e175fb1549a289 Remove duplicated doc comment on extractViewDepsFallback
  • 648e0302652d6c912de3890938e5fd192de10ccd Address sixth round of Copilot review feedback
  • dcd89ad8890b6ac5bd40fcd94818a46691a96569 Address fifth round of Copilot review feedback
  • 84ce06b85bc819509e36dccf9e1cf3da663c644b Address fourth round of Copilot review feedback
  • 631638a7bfbe7935b479f000b713579d67f6c191 Add tests for third round review feedback
  • 7f221c8fa1f5b5c9c003dfcd608ea47b5be006c3 Address third round of Copilot review feedback
  • 8b701cf315eff8d2b92d9224446c24ec0f737576 Add FuncCall subquery and escaped-quote split test cases
  • 1f084cfe9b68c17f0d79d3519fd42a11dff874ee Add tests for remaining uncovered code paths
  • f924f651d4e09616daaada88adaf54c357f5bcbb Add missing tests and fix view dep parsing for review feedback
  • 289995d78326108db39ac20b973c8600e4783925 Address second round of Copilot review feedback
  • 937b3eb729926a003f0eaaab2f8665c0e39eed4e Address Copilot review feedback on toposort integration
  • 69b8ef8cff04ba90e208ec67a9638dfdd21c94a5 Improve toposort test coverage from 92.2% to 94.8%
  • add496c75f9a78eb67ba670701a23763cd36ff64 Replace hardcoded diff ordering with topological sort
  • 159e5ff6da34842e1450579e8f0e607c9be9b1d5 Merge pull request #84 from winebarrel/add-fmt-test-coverage
  • 09f8e96fc1922f7d544d225236a6c491a6ac570e Add fmt test coverage for domain, idempotency, and CLI scenario tests
View diff on GitHub

Weekly OSS security release digest.

The CVE patches and breaking changes that affected production tools this week. One email, every Sunday.

No spam, unsubscribe anytime.

Share this release

Share on X Share on Bluesky

Track Pistachio

Get notified when new releases ship.

Sign up free

About Pistachio

All releases →

Related context

Beta — feedback welcome: [email protected]