Skip to content

v0.20.0

Choose a tag to compare

@github-actions github-actions released this 30 Jul 07:12
· 42 commits to main since this release

Added

  • Server panel listing live database sessions, with lock waits and their
    blockers marked and a guarded cancel/terminate per session; opens from the
    status-bar connection chip. The ClickHouse mutations list now lives here too.
  • Show DDL on any schema-tree object, in a read-only highlighted tab with Copy
    and "Open as query".
  • Schema comparison: diff the current schema against another, with type-aware
    column matching and additive reconciling DDL generated into a query tab.
  • Connection health report for SQL engines: sizes, unused indexes, missing
    keys and other per-engine checks, saved per connection.
  • Watch mode: re-run a tab's read-only query every few seconds, with changed
    cells flashing, a row-count delta, and the scroll position kept.
  • The schema tree now shows materialized views, functions, procedures,
    triggers, sequences and user-defined types, loaded lazily per group.
  • In-grid editing on ClickHouse, with per-change safety checks and honest
    per-statement outcomes instead of a claimed all-or-nothing success.
  • The ClickHouse submit confirmation shows the real statements and matched row
    counts; a change matching several rows needs explicit approval.
  • Mutations panel for ClickHouse listing background work still applying after
    a submit, with per-row cancel and a status-bar indicator.
  • Tables with a composite primary key are now editable on PostgreSQL, MySQL
    and SQLite.
  • Bulk import into a ClickHouse table from the result toolbar.
  • Search across every setting, with each row showing its settings.toml key,
    a modified marker, and a per-setting Reset.
  • Settings pages for Redis and MongoDB.
  • Stored routines can be written in the editor: a BEGIN … END body runs as
    the one statement it is, and DELIMITER $$ is honoured.
  • Groundwork for translating the interface: a Language setting under
    Appearance (English-only for now), with per-string fallback to English.

Changed

  • The app is now called RED, in capitals, everywhere it names itself; saved
    connections, settings and passwords carry over unchanged.
  • Settings are reorganised by topic: [grid] is now [data], [redis] is
    [kv], and [query] split into [sql] and [safety]; existing files
    migrate automatically.
  • Row density, page size and maximum cell size now apply to the Redis key
    browser and MongoDB document grid as well as SQL results.
  • The reference settings file documents every section again.
  • Editing affordances follow the table: a table the engine cannot modify shows
    a one-line reason instead of edit controls, and computed columns are never
    offered for editing.
  • The AI assistant no longer claims a multi-statement changeset always commits
    together or not at all, which was untrue on ClickHouse.

Fixed

  • Writes and DDL run from the editor now resolve unqualified names in the
    tab's database, fixing MySQL's "No database selected" on CREATE TRIGGER.
  • On MySQL 8, a query no longer leaves its database bound to the pooled
    connection for whatever runs next.
  • Views, triggers, functions and procedures can be edited from the tab showing
    their definition, through the usual confirmation and read-only lock.
  • Clicking a trigger, routine, sequence or type in the schema tree opens its
    definition, the way clicking a table opens its rows.
  • Creating a trigger, routine, sequence or type now refreshes the schema tree
    immediately instead of only after a reconnect.
  • The editor no longer underlines trigger and routine syntax as unknown
    columns, and highlights those words as keywords.
  • Staging more than six new rows no longer hides the ones past the sixth: the
    change-set zone below the grid scrolls through the whole set.