Changelog

Screenshot of Basedash showing Home page with numbers indicating record counts.

February 9, 2022

Home page

We created a new Home page that gives you quick access to your favorited views, and shows the number of records in each of them. We’ve found this to be really useful for tracking quick metrics like number of signups in the past week, or total number of workspaces.

You can favorite a view by opening the view and clicking the star in the header. This pins it to the top of your sidebar, and adds it to your Home page.

This is just the first iteration of content that we want to show on the Home page—let us know what else you want to see on this page by joining our Slack community.

Other improvements and fixes

  • Improved performance of scrolling on tables
  • Fixed favoriting a view not updating the icon in the header
  • Fixed view creation
  • Fixed setting primary attributes from the table header
  • Fixed searching on SQL Server databases
  • Fixed SQL views not loading on SQL Server databases
  • Fixed tables not loading in Data tab in some cases
  • Fixed self-referential foreign keys not showing values properly
  • Tightened account lockout policy
  • Added warning toast for tables with composite primary keys
  • Added various headers to improve security
Screenshots of the Basedash docs page showing an interactive demo of inviting a member.

January 31, 2022

Docs page

Today, we’re shipping a set of docs that go over all the core concepts of Basedash. It can be used as a guide to getting started with the tool, or a help center to learn about certain features of the product. You can access the docs at docs.basedash.com.

The docs are full of screenshots and videos showing off the product, and how to use specific features. Some sections include interactive demos to show off exactly how features work in the app.

We also include connection guides for all major hosting providers, with full videos showing where to find the data you need to connect your database to Basedash. For example, here’s our connection guide for DigitalOcean.

This is a living set of documents and will continue to evolve as we build the product. Let us know if there’s something you’d like to see added to the docs by joining our Slack community.

Other improvements and fixes

  • Improved performance of initial app load
  • Updated modal UIs for consistency
  • Updated data sources to default to expanded in the sidebar after initial connection
  • Eliminated loading time for data sources in the Data tab
  • Eliminated records reloading after changing attribute visibility in view builder
  • Eliminated records reloading after reordering attributes in view builder
  • Removed ability to select disconnected data sources when creating a view
  • Added a warning toast for tables with composite primary keys
  • Added loading spinner to data sources in sidebar when syncing
  • Added health indicator to data sources when creating a view
  • Fixed Slack notification switch not immediately appearing disabled after toggling
  • Fixed hiding attributes through the view builder sidebar removing that attribute permanently
  • Fixed enums not showing as dropdowns in raw tables
  • Fixed data sources not loading in Data tab in some cases
  • Fixed views being uneditable in some cases
  • Fixed dropdown cells not being editable in some cases
  • Fixed Slack notifications not sending in all cases
Screenshot of Basedash showing a table with 500 records.

January 24, 2022

New table rendering engine

We’ve completely changed the way that Basedash renders tables by implementing virtualization, a method for rendering only the cells that are visible on-screen. This means that we can now load arbitrarily large tables incredibly quickly, improving the initial load performance of tables across the app.

This allowed us to increase the page size from 25 to 100 records. We plan to revisit page size in the future, with the possibility of custom page sizes.

We plan to continue improving the performance and smoothness of table rendering over time. Let us know if you run into any issues with the new engine by joining our Slack community.

Other improvements and fixes

  • Added notification email for when a user is added to a workspace
  • Added button to remove attributes from the view builder sidebar
  • Added persistence to SQL view column widths
  • Removed search bar from Views page when no view have been created
  • Improved logic for disabling submission of the domain-based access form
  • Improved styling of “No records found” text in SQL views
  • Updated icon in view builder sidebar for removing filters and sorts from trash can to minus
  • Fixed enum columns not rendering in the right place
  • Fixed obscured data flickering after resizing window
  • Fixed background color of new record row
  • Fixed table header not being sticky to the top of the page
  • Fixed cell navigation keyboard shortcuts on sticky columns
  • Fixed inability to type ‘h’, ‘j’, ‘k’, ‘l’ in foreign key dropdown search input
  • Fixed transparency in new record row border
Screenshot of Basedash showing form to enable domain-based access.

January 19, 2022

Domain-based workspace access

You can now enable domain-based access to your workspace, allowing anyone from your team to join you on Basedash just by signing up with a company email.

Admins of a workspace can enable domain-based access in Settings. Once enabled, any existing Basedash users with matching email domains will be added as members to your workspace. Any new users who sign up with a matching email will also be automatically added. Users are required to verify their email before they will be added to a workspace. You can turn off domain-based access at any point in Settings.

Other improvements and fixes

  • Fixed “No records found” text overlapping new record row on tables
Screenshot of Basedash showing a user table with the address column being obscured.

January 10, 2022

Obscured personally identifiable information

At Basedash, our vision is to enable anyone within a company to be able to access and edit the data they need, without having to know the intricacies of how SQL databases work. Alongside that comes the responsibility of ensuring that personal user data remains private. We’ve seen countless examples of companies recklessly building internal tools that allow their employees to spy on their users with no restrictions.

Today we’re launching a feature which lets you obscure personally identifiable information in your database. This allows you to hide sensitive user data, while still allowing you to edit the values for your customer support or operations needs.

Admins can enable obscuring specific attributes in their data source configuration page. We currently support text and numeric columns, and have plans to support all data types moving forward. Once an admin enables obscuring, both the raw table and any views that include that attribute will become obscured in Basedash. In place of the actual value, we generate a random string of characters and render them using a custom font we developed: Basehash.

We think that this new tool will allow companies to build powerful internal tools within Basedash that preserve the privacy of their users.

Other improvements and fixes

  • Fixed boolean values not appearing in SQL views
  • Fixed markdown rich text editing
  • Fixed font size of rich text cells
  • Fixed Ctrl/Cmd + Enter keyboard shortcut for creating a new line in rich text cells
  • Added ability to set a password for users that signed up with Google
Diagram with Basedash connected to three nodes: Sign in with Google, Supabase Auth and Storage, and Sequin one-click connection.

December 20, 2021

Google sign in

You can now log in (and sign up) using your Google account. This works for new and existing users—just click “Sign in with Google” on the login page.

Supabase auth and storage

You can now view and edit data from your Supabase “auth” and “storage” schemas, as well as build views using the data in those tables. This allows you to build complex dashboards, charts, and internal tools using your Supabase authentication data and uploaded files.

Sequin one-click database connection

You can now connect your Sequin databases to Basedash in one click, with the new “Connect to Basedash” button. This is the fastest way to get your database into Basedash and start managing your data.

Other improvements and fixes

  • Added email verification
  • Fixed table header back button on mobile
  • Fixed table focus not returning after editing a cell
  • Redesigned our blog
  • Updated browser title to describe the current page
Screenshot of Basedash showing new fonts used across the app.

December 13, 2021

Updated fonts

This week we updated the fonts used across the app, to improve consistency, legibility, and flexibility moving forward.

Until now, we've been using the system default font wherever you're running Basedash. This meant that fonts would vary from device to device, causing inconsistency and sometimes leading to changes in layout due to small differences in letter sizing and spacing.

We're now using Inter across the board for all standard text. One nice benefit is that it supports variable weights which allows us to ship a single font file, reducing our bundle size and improving loading time.

We also switched our monospace font to JetBrains Mono. It similarly supports variable weight, plus 139 code-specific ligatures.


Reduced default text and component size

Along with these typeface changes, we also updated the default font size, and reduced the size of all components across the app. This gives you more screen real-estate to view and compare data while working in Basedash. You can control the zoom level of Basedash at any time by pressing "⌘+" to zoom in, or "⌘-" to zoom out.

Other improvements and fixes

  • Improved performance of loading tables by 45%
  • Added "go to Table" command in command bar
  • Updated symbols for keyboard shortcuts to use custom icons
  • Fixed links to tables in Activity page
  • Updated styling of command bar
  • Removed unnecessary data fetching in views
  • Improved performance of updating records
  • Fixed window closing after applying a filter
  • Fixed floating buttons being transparent on hover
  • Fixed records not reloading after updating a view

Screenshot of Basedash showing a list of root filters, each with a short description of what is being filtered.

December 8, 2021

Inline filter descriptions

We now show a description of your root filters inline in the view builder sidebar itself, so you know exactly which records are being included. You can click on the filter in the sidebar to edit the root filter on the view.

Change member roles

Admins can now change a member's role from the members page. This makes it easy to update permissions on the fly.

Other improvements and fixes

  • Updated redirection after connecting a data source to navigate to the data page
  • Improved performance of loading primary keys of tables
  • Fixed SQL view data not appearing on mobile
  • Fixed "Jump to" button appearing on mobile
  • Fixed temporary filters persisting after switching between tables

Screenshot of Basedash showing ability to enable "Restricted values" on attributes.

November 30, 2021

Edit text columns as dropdowns

You can now configure certain text columns in your database to be editable as a dropdown with a restricted set of values. This is very useful in cases where you don't want to use an enum, but have a limited set of allowed values. This improves the editing experiences, and prevents cases of typos and mistakes that could cause errors due to incorrect values.

You can enable this on a per-attribute basis in your data source settings. Just enable "Restrict values", then enter the allowed values, one per line.

Improved view and table search

We've updated the search functionality in the root Views and Data pages to let you quickly navigate to a specific page you're looking for. Now, when you open either the Views or Data page, you'll simply see a search bar, with a super performant and keyboard-navigable list of matching views or tables.

Hit '/' to select the search bar, use the arrow keys to navigate the list, then hit return to open the selected view or table.

Other improvements and fixes

  • Added ability for admins to change a member's role
  • Added workspace icons to all items in the workspace switcher
  • Added persistence to raw table column widths across workspaces
  • Added persistence to data source sidebar collapsed state for sections
  • Added loading indicator to data sidebar after connecting a new data source
  • Added primary attribute to "Visible in list" section in view builder
  • Improved the configuration of the global navbar
  • Eliminated unnecessary data reload when resizing columns in a view
  • Updated the "Jump to" bar to trigger the root command bar
  • Fixed CSV downloads showing numbers instead of column names
  • Fixed foreign keys of joined tables not showing values
  • Fixed newly joined table attributes not immediately appearing in view builder
  • Fixed inputs overlapping in filter popover
  • Fixed banner in demo workspace creating unnecessary scrollbars
  • Fixed null foreign keys showing as an empty chip
Screenshot of Basedash showing a new workspace switcher dropdown and back/forward navigation buttons in the top navbar.

November 23, 2021

Workspace switcher and desktop navigation

Expanding on our new global navbar from last week, we've added a workspace switcher, and back/forward navigation buttons (on desktop). This now makes the top navbar your hub for all top-level navigation around the app, with the sidebar acting as a way to jump between specific content.

We have more desktop-specific improvements planned for future releases. If you haven't already, you can download the Basedash desktop app for all platforms here: https://www.basedash.com/download

Other improvements and fixes

  • Added custom scrollbars
  • Added special text to indicate empty string cells
  • Removed view data refresh when resizing columns
  • Improved loading performance for self-hosted instances
  • Improved layout on mobile to prevent content being overlayed
  • Updated ordering of data sources in sidebar to prioritize connected, healthy data sources
  • Fixed joined table attributes not appearing in view builder until refreshing
  • Fixed primary attributes of joined tables not loading
  • Fixed disconnecting attributes
  • Fixed data sources not being removed from the sidebar after removing a data source
  • Fixed foreign keys not loading in SQL Server databases
  • Fixed updating data source name and connection status
  • Fixed enum cell padding being too big
Make your database collaborative in as little as 90 seconds

See how removing barriers can change the way your team works.

No credit card required