**New** - The table schema editor has been simplified. Columns and table constraints are now in a single table with section titles. Buttons for adding/removing items now have text labels for clarity. - You can now copy rows and cells from the data browser table from a right-click menu - 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 **Updated** - SQL autocomplete suggestions show less eagerly (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 - (v3.2.1): Fixed the table editor sometimes showing options for the wrong type of table constraint
**New** - The table schema editor has been simplified. Columns and table constraints are now in a single table with section titles. Buttons for adding/removing items now have text labels for clarity. - You can now copy rows and cells from the data browser table from a right-click menu - 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 **Updated** - SQL autocomplete suggestions show less eagerly (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
• Adopted the new Liquid Glass style • Updated SQLite to v3.50.4 • Added a button for clearing sorting & filtering in the data browser • Added a button to jump to a table in the database size inspector • Added an option to always enable foreign keys when opening a database • Added an option to hide shadow tables • Re-ordered filter predicates to put more commonly used ones at the top • When showing the table editor, the table name field is automatically selected • Slightly improved performance for some large tables • When importing or exporting finishes, the app will show a notification • Fixed a bug causing filter buttons to disappear from the data browser • Base will now sometimes, politely, ask for a review on the App Store
• The "show internal tables" option is no longer ignored • Using the tab key to switch between edited table cells no longer causes the selected row to be changed
• Documents now remember the last selected table and tab between launches • The database size inspector chart was missing a legend - it's back now • When entering numbers with leading zeros in a TEXT column, the leading zeros are not longer removed