May 17, 2021
Sticky columns
May 17, 2021
We've added the ability to designate a "primary attribute" on each table, which freezes the column to the left side of the table. The primary attribute defaults to the primary key of the table (i.e. the ID), but you can set it to any attribute by clicking the column header and selecting "Set as primary attribute".
In addition, the primary attribute will appear as the value in foreign key relationships. This means that you can easily read and set relationship values without having to know the record's ID. It's very useful for setting a user's primary attribute as their email or name.
Search in queries
We also added new search feature in queries that allows you to easily scan your SQL queries. It supports find-and-replace, regex, case-sensitivity, whole-word search, and search-in-selection. You can trigger it by pressing Ctrl/Command + F in a query.
Other improvements and fixes
Simplified onboarding flow
Fixed onboarding flow triggering twice in some cases
Fixed global search not showing tables if a database connection failed
Fixed sidebar flashing when navigating between pages
Fixed record deletion in MySQL
Fixed removing members from Basic workspaces
Added a link on the Views page to connect a data source in new workspaces
Updated table footer formatting
Fixed keyboard shortcut conflicts on Views page
Fixed columns widths not going below content size
Fixed table header not spanning page width
Fixed query values being cleared after setting an emoji
Adjusted filter dropdown alignment to prevent overflow