Skip to content

dbui v0.5.0

Choose a tag to compare

@JosueRhea JosueRhea released this 25 Sep 15:27
· 8 commits to main since this release

New

  • Connect through an SSH tunnel
  • Tag connections by environment, with a confirmation before writing to production
  • File connections into groups in the connection picker
  • EXPLAIN drawn as a plan tree, with ⌘⌥E to explain the current statement
  • ER diagram of a schema
  • Server activity panel that can cancel queries or end sessions
  • Functions, triggers, sequences, types and extensions in the sidebar tree
  • Dump a database to a SQL file, and run SQL files
  • :name parameters are asked for before a statement runs
  • Pin a query result as a tab of its own
  • Export a capped query result in full, streamed from the server
  • JSON cells open as a foldable tree in the row details
  • SQL completion opens as you type, next to the caret; ctrl-space opens it too
  • The SQL editor runs on one pinned connection and shows when a transaction is open
  • SQL editor results stop at 10,000 rows instead of loading everything

Fixes

  • Postgres enum, domain and array columns read correctly
  • A table can be opened again after a column is added to it
  • A statement after a large query no longer waits for the rest of its rows
  • SQL is split the way each engine reads it: backslashes in strings, procedure and trigger bodies, DELIMITER lines
  • A read-only connection refuses writes from the SQL editor
  • The connection sheet no longer carries a database name into SQLite's File field, and hides TLS for SQLite
  • A long file path stays inside its field, and Tab skips hidden fields

Installing

  1. Download dbui-0.5.0-universal.dmg and drag dbui to Applications.
  2. Run:
xattr -dr com.apple.quarantine /Applications/dbui.app

Updating from 0.2.8 or earlier: the in-app updater can't install this release. Download the .dmg and replace the app by hand once. Updates work from inside the app after that.