Skip to content

v0.23.0

Choose a tag to compare

@github-actions github-actions released this 05 Sep 14:48
· 28 commits to main since this release

Schemaic v0.23.0 — schema compare, binary cells you can open and edit, and Export on every schema node.

Highlights

  • Schema compare. Compare two databases side by side from a database row's Compare with: differences grouped by kind, either side's CREATE as a line diff, and whatever you tick handed to the usual SQL preview as one migration — ordered by dependencies, and honest about what it leaves out. The right-hand side can live on another connection of the same engine.
  • Binary cells open now. A <n bytes> cell fetches its bytes on demand into a panel that previews images, and the same panel loads a file into the cell or saves one out — bytes as bytes, never round-tripped through text. Reachable from the keyboard, and offered only where a write could have been aimed.
  • Export ▸ on every schema node. All six formats, not just SQL: the other five write one file per table into a folder you choose, with the freshly-introspected schema, streamed rows and .part-until-whole guarantees the SQL dump already made. The results grid reports progress in one modal from launch to dismissal.

Performance

  • Data entry stays smooth in a wide grid. One edit used to rebuild every mounted cell — roughly a thousand on a maximised window, twice per Tab-hop. Now only the cell that actually changed.

Fixes

  • Set NULL in the row editor, and the Activity panel's lock-wait Kill, answer a mouse click again.
  • Large blobs no longer fail to load on MySQL's packet limit or PostgreSQL's protocol, and a small preview sits centred.
  • An export that was refused says so instead of finishing quietly.
  • Two tables whose names sanitize to one filename no longer overwrite each other in a folder export.
  • A stopped export no longer leaves 0-byte .part files behind.
  • A row's own data can no longer end a PostgreSQL string literal.