Changelog

Screenshot of Basedash showing a custom right-click context menu on the Views page.July 26, 2021

Custom context menus

We've added custom right-click context menus to the app which let you quickly take actions on certain items. To start, they're available on the Views page (to edit, favorite, and delete), and in the headers of tables (to set the primary attribute, and apply a sort). This also freed up left-click on table headers, which we're now using to quickly apply a sort on a column.

We plan to use context menus more heavily across the app as we keep building, to simplify the UI and make taking actions faster.

Search in SQL views

We've added text searching to SQL views to allow you to easily filter for records containing some text. We've had this functionality in Basic views for a while, but wanted to bring it over to SQL view too. This is the first step in bringing full feature-parity across both Basic and SQL views. We plan to add UI-based filtering and sorting to SQL views as well.

You can trigger a search on a SQL view by pressing Ctrl/Command+F. Note that we previously used Ctrl/Command+F for find and replace on the query—this has now switched to Ctrl/Command+Shift+F.

Other improvements and fixes

  • Added a link to invite a member while connecting a data source
  • Added live chat to app
  • Added a link to join a demo workspace after signing up
  • Added a banner to the demo workspace
  • Changed SQL view pagination to only load one page worth of data at a time
  • Fixed creating new records in some cases
  • Fixed removing data sources
  • Fixed connecting to databases through SSH
  • Fixed workspace switcher not updating immediately after creating a new workspace
  • Improved ability to copy substrings of text from uneditable cells
  • Improved error messages encountered while connecting a data source
  • Merged profile page into settings
Split-screen screenshot of BaseDash, comparing "Before" and "After", with the after image showing a darker color palette.July 19, 2021

Darker dark mode

What's better than dark mode? An even darker dark mode!

We've updated our color scheme across the app to use darker darks, and a higher-contrast primary color on both themes. Overall, we've simplified our color palette which should increase consistency across the app.

We have lots of ideas on how to expand our theme system in the future to improve customizability, accessibility, and fun. Keep your eyes out for future changelogs by following us on Twitter (@Basedash).

Other improvements and fixes

  • Merged the Profile page into Settings
  • Updated labels on the signup form
  • Updated styling of sidebar section titles
  • Updated sidebar sections to persist collapsed state across sessions
  • Added a "Done editing" button to view settings
  • Added sort buttons in the column dropdown on tables
  • Added an empty state to the views page
  • Added space for traffic light buttons on view settings on desktop
  • Replaced checkboxes with switches in the Available attributes popover in view settings
  • Updated styling of switches to use the primary color when active
  • Improved the back button behaviour on the connect data source page
  • Improved consistency of buttons across the app
  • Reduced default height of buttons
  • Fixed header not being visible on the activity page when no databases are connected
  • Fixed some disabled buttons being clickable
  • Fixed view settings being too tall when using some layouts
  • Fixed null booleans not being editable
  • Fixed sidebar button appearing on both headers in view settings on mobile
Screenshot of BaseDash showing the new view settings page.July 12, 2021

New view creation flow

This week we revamped the way you create, edit, and share views. We now have a full-page experience that allows you to configure and preview your view in real-time, across multiple layouts (table, list, and chart). This brings all view configuration options to one place, allowing you to craft your perfect view.

Newly created views are saved to Drafts which are only visible to admins. You can publish your view to the rest of your team in one click. This makes is easy to work on a view on your own time, then publish it when you're ready to share with your teammates.

Collaborators can still navigate views by searching and sorting, but only admins can edit the view to change core settings like filters and joins. Admins can access view settings by clicking the "..." menu in the header of a view, then clicking "Edit view".

We think this new format for creating and managing views simplifies the process for admins, and allows us to add more customization in the future without cluttering the view interface. We'd love to hear your thoughts and feedback in the BaseDash Slack community.

New view layout switcher

We also updated the layout switcher on views to use a newly designed segmented controller. This better-exposes your layout options for working with your data, and lets you switch your layout in one click.

Other improvements and fixes

  • Improved accessibility of the switch component
  • Fixed date column values being cut off in table layout
  • Fixed search term not being visible after applying a search
  • Fixed future date values showing as "Out of range"
  • Fixed foreign key popovers appearing behind sticky columns
  • Improved foreign key popover styling
  • Fixed undoing values not showing changes immediately on the form panel
  • Fixed toggling the enabled status of Slack notifications on views
  • Changed null values to display as a dash
  • Updated all list attributes to be left-aligned
  • Updated the data type icon for foreign keys
Screenshot showing a date picker to edit a date value.June 28, 2021

Date picker

This week we shipped a date picker that makes it easy to update date values by picking a date on a calendar. You can also type a value directly into the input field in a simple, human-readable format. It works for both simple dates, and date-time combos, in both table layout and list layout.

Other improvements and fixes

  • Updated our blog to be available at www.basedash.com/blog
  • Fixed a bug causing table cell values to not visually update
  • Fixed a bug causing list values to visually revert after leaving and returning to a record
Screenshot of BaseDash showing the new list layout.June 21, 2021

List layout

Today we're launching a new list layout for views, our second ever layout type after tables. You can now easily view records in a simple list, and edit values in a comprehensive form. This new view layout is available on all new and existing views through a toggle in the header—you can use this to easily switch the layout on a view-by-view basis depending on your needs for each view.

We believe that tables are great high-density interfaces for comparing and managing data in bulk, but they can be intimidating—especially for non-technical users—because they lack informational hierarchy. Our new list layout offers a more streamlined interface, surfacing the most important data in the list itself, with access to the rest of the record's data in a familiar, easily-editable form. The form panel also gives us more space to show data inline which is especially useful for data types like rich text and JSON.

List views, like existing table views, are highly customizable. You can choose which secondary attributes to display in the list, as well as which attributes are visible and editable in the form. Some settings like filters and sorts are shared between layout types, so you don't have to define them multiple times.

List layout is available to all users starting today. It's still under active development while we iron out some bugs and improve the experience, like adding mobile support and improving customizability. If you run into any issues, please let us know in the BaseDash Community Slack channel.

Other improvements and fixes

  • Updated "New update available" toast copy
  • Fixed bug that prevented deletion of favorited queries
  • Fixed bug that prevented foreign key selection dropdown from appearing
Screenshot of BaseDash showing real-time presence avatars.June 14, 2021

New avatars

We updated the way auto-generated user avatars look, and how they're rendered when used as real-time presence indicators on a view. Upon signup, each user is now assigned a color from a collection of hand-picked colors. This will appear as the accent color in your avatar, as the border in the top-bar, and as the border of your currently-selected cell to other users. Your color is persistent, allowing your teammates to easily recognize you by your color.

New blog

We also launched an updated site for our new blog! We'll be posting content about how we're designing, building, and growing the product. It's exclusively high-quality content written by the core team at BaseDash. We already have a couple posts up:

You can check out the full blog at https://blog.basedash.com.

Other improvements and fixes

  • Re-ordered table controls in preparation for an upcoming change 👀
Screenshot of the BaseDash sidebar showing a new "Related" section containing views.June 7, 2021

Related views section

We've been doing a lot of experimentation around navigation in the app. The latest change we're trying out is a "Related" section in the sidebar that intelligently shows views that are related to the page you're currently on. If you're on a view or raw table, this includes any views with the same base table. If you're on a query, it includes other queries based on the same data source. This should speed up navigation in the app, especially when exploring data.

We'd love to hear your thoughts as we build in public. Join our Slack community to chat with other power-users, as well as our designers and engineers—we're constantly updating BaseDash based on user feedback.

Other improvements and fixes

  • Updated positioning of sidebar items
  • Changed primary attribute column to not be sticky on smaller screen sizes
  • Fixed CSV downloads containing column names and values with certain characters
  • Fixed primary attribute becoming transparent when highlighted via search
  • Fixed column default values being detected incorrectly
Screenshot of BaseDash showing the "add member" form with 3 possible roles.May 31, 2021

Updated permission system

We reworked our permission system from the ground up to simplify the process of adding teammates, and to increase flexibility out of the box.

Our old permission system relied on defining read/write permissions upfront at the table level. This allowed for fine-grained permissioning, but required a huge time commitment to set up, and was hard to keep up-to-date as needs (and schemas) changes.

Our new system works off the existing power of views. We now have 3 roles:

  1. Admin. Has full access to data sources (including raw tables), and can create + publish views for others to use.
  2. Collaborator. Only has access to existing views which were created by admins.
  3. Read-only. Can only read data in existing views, but not make edits.

These new roles are specifically tuned towards the ability to craft views with limited access through filters and hidden attributes, ensuring that your teammates have access to the data they need, and nothing more. Collaborators still have the ability to search within views, and we're planning ways for them to organize data in new ways.

On top of these three roles, we also have the concept of Owners. Each workspace has at least one owner who, on top of their role permissions, gains access to billing and top-level settings like renaming the workspace. Right now, the creator of the workspace is designated owner, but we plan to let you transfer ownership and add new owners in the future.

Finally, the new Read-only role is free, so you can add as many teammates/investors/users as you'd like without affecting your billing.

Other improvements and fixes

  • Added the ability to filter on JSON columns
  • Fixed query results missing the final record on each page
  • Fixed number of collaborators being miscalculated by one
Two screenshots of BaseDash on mobile.May 24, 2021

Improved mobile experience

One of our core goals at BaseDash is to democratize data access within companies so that anyone can work with the data they need to, in the way that works best for them. We've noticed an increase in the number of people using BaseDash on mobile, so we decided to make some improvements to the experience on smaller screens.

We've always had basic support for mobile, but it's slowly gotten out-of-date with all the new changes we've introduced in the past months. This week, we implemented some changes that bring the experience closer to that on desktop, with design improvements that make it easier to keep feature parity as the product changes over time. We now have a persistent header across all pages—including on desktop—which includes a menu button to open the sidebar on smaller screen sizes. We also hide some information on smaller screens to maintain high information density.

Other improvements and fixes

  • Updated sidebar item styling
  • Updated sidebar search bar styling
  • Improved view footer responsiveness
  • Increased view search bar width
  • Fixed updating Slack integration settings
  • Fixed view deletion
  • Fixed enabling two-factor authentication
  • Fixed real-time avatars not showing in views
  • Fixed filter value field not appearing
  • Fixed reordering columns
  • Fixed loading the payment page when it's the initial page loaded
  • Fixed cell highlighting when searching
  • Fixed applying filter changes on text columns
  • Fixed app update toast not appearing
  • Fixed switching view visibility not updating the views page
Screenshot of BaseDash showing a sticky column representing the primary attribute.May 17, 2021

Sticky columns

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

The new standard for internal tools

Basedash replaces custom internal tools so you can focus on building your product.
Get started for free
Decorative graphic of two people in an office