Base 3.2.0 Released

Base 3.2 is now available for download.

This update contains mostly quality-of-life improvements, with improvements to the table schema editor, data browsing table and SQL autocompletion.

The full list of changes is as follows:

New features

  • The table schema editor has been simplified. Columns and table constraints are now presented in a single list with section titles dividing them. This more closely fits how tables are described in code. The buttons for adding/removing items now have text labels, making it easier to see what you’re changing.
  • You can now copy rows and cells from the data browser table from a right-click menu on the table
  • The data browser now has an “insert special” context menu for quickly inserting dates, UUIDs and NULL values
  • SQL autocompletions for SQLite functions has been expanded to cover all built-in functions
  • Added experimental options (opt-in from the settings window) for working with large tables:
    • Disabling the counting of rows in a table
    • Allow selecting which columns should be shown in the data browser

Changes and improvements

  • SQL autocomplete suggestions no longer automatically show when not needed (eg. after typing a semicolon or a complete keyword)
  • The sidebar now only shows database schema names when multiple non-empty databases are attached
  • The row editor preview column now resizes to fill available space

Fixed

  • The SQL editor no longer loses focus after executing a statement
  • Clicks in the space below text in the SQL editor now behave like other text views on macOS
  • Fixed the “Send to SQL” button not working
  • Database pragma values now update correctly after being changed
  • Tables containing columns with default value of a signed number are now displayed correctly
  • Fixed a UI misalignment in the autocomplete window

You can download Base directly, get it on the Mac App Store or via Setapp.