Changelog

Improved details panel

Last year, we introduced List layout to Basedash, which is an alternate way of viewing your data as a simple list, with a panel for viewing details and editing the record. Today, we’re shipping a suite of improvements to the details panel.

First, we’re adding the panel to the Table layout, and tables in the Data tab. With List layout, we were forced to design an interface for editing the data of a single record. After using it in List layout for a year, we realized that the form-based layout would be equally valuable in Table layout, where vertical screen real-estate is limited.

Next, we added the ability to resize and collapse the panel. We didn’t want to force the panel to take up horizontal screen real-estate on all views, so now you can decide when you want it open, and how much space you want it to take up.

Finally, we cleaned up the styling of the panel to make use of some of our new UI components and styles. The panel can also be opened on mobile devices now.

Here's a video of that panel in action:

Moving forward, this panel will act as a launch pad for a slew of upcoming features. We’re not ready to reveal these features yet, but if you’re interested, you can join the beta for them once they become ready by joining our Slack community.

Other improvements and fixes

• Reduced client bundle size to improve initial load performance
• Improved loading time performance on Safari
• Improved styling of permissions on the Members page
• Improved logic for when to show upgrade callout
• Added user emails to the Members page
• Removed back button from view builder header
• Updated icon in collection header from Database to Table
• Fixed joined table attributes not being available to add to a view until after refreshing the app
• Fixed SQL queries getting overwritten by other queries in some cases
• Fixed SQL queries containing colons or dollar signs failing
• Fixed icon colors on dark mode in role settings
• Fixed app crashing when opening views with rich text in list layout

Roles

Today we’re shipping a big new feature to help bigger teams manage access to views. Roles are custom groupings of users that can be assigned access to certain roles. Some ideas for roles that we’re using internally at Basedash are Engineering, Marketing, Support, Investors, Core team. The possibilities are endless.

Members are only be able to access views that are assigned a role they are part of. All other views are hidden and inaccessible. In a view, a member’s existing permissions (Can edit or Can view) determine whether they can make edits to the data.

Members of a workspace can be assigned multiple roles (e.g. Engineering + Support), and views can be assigned multiple roles too. By default, all new members are assigned the Everyone role, and you can choose to just use this if you don’t have complex access requirements.

We think that roles will make a big impact on how big teams use Basedash. You can try roles out now by opening the Roles page in your Basedash settings. Try creating a new role, assigning some members, and adding some views to it. You’ll probably also want to remove access to that view from the Everyone role.

Other improvements and fixes

• Added member limit progress bar to invite member modal
• Fixed theme picker styling
• Improved flow for downgrading plans
• Fixed rich text content overflowing beyond cells while editing
• Fixed rich text cells appearing below other cells while editing
• Fixed creating views on databases where the base table name exists in multiple schemas
• Fixed onboarding flow triggering twice for new users
• Fixed onboarding flow not triggering for users invited to a workspace
• Added page title to onboarding flow
• Fixed data sources not loading after switching workspaces for the first time

Settings page redesign

We redesigned our Settings page to use a new layout which allows for easier navigation, especially for admins of a workspace. There’s now a dedicated settings sidebar which includes pages to manage you Profile, Preferences, Workspace, and Billing. (There’s also a secret Roles page, but that’s for a future update).

These new settings will give us room to grow as we add more configuration and preferences to Basedash.

New Business plan

We introduced a new pricing plan called Business, which has ample limits on views, members, and data sources. It’s meant for companies that have out-scaled the Startup plan, but don’t need self-hosting on the Enterprise plan.

You can see the full pricing breakdown here: https://www.basedash.com/pricing

Or upgrade your workspace here: https://app.basedash.com/settings/billing

Custom select component

We built a custom select component which is used across the app in forms. It has great accessibility with keyboard shortcuts, typeahead support, and styling that matches the rest of the app.

You can check it out with the Role input on our signup page: https://app.basedash.com/signup

Other improvements and fixes

• Fixed non-admins not being able to load SQL views
• Fixed published views sometimes opening in edit mode by default
• Fixed data source loading spinners not disappearing
• Fixed checkboxes not visually updating in the table after toggling
• Fixed rich text editor appearing below new record row in tables
• Fixed workspace upgrade flow
• Fixed foreign key dropdowns not showing any values
• Fixed Sign In With Google on desktop
• Fixed typo in email verification banner
• Fixed database schema not syncing immediately after connecting a database
• Fixed app crashing when opening some views
• Fixed login inputs not being editable after entering an incorrect password
• Fixed two-factor login flow

‍

Improved security measures

We’re currently going through a self-imposed software penetration test to ensure that our app security is solid. As part of that process, we tightened up a number of security measures to ensure that your access to Basedash is secure.

We’re also currently going through a SOC-2 audit. If you’re interested in details this, send us an email at support@basedash.com.

For more details on our app’s security in general, check out our security page here.

Here’s a list of all the changes we implemented.

• Tightened password requirements
• Tightened login attempt lockout policy
• Enforced newer versions of TLS
• Switched from using JWT tokens to session tokens
• Switched from storing authentication tokens in local storage to HTTP-only cookies
• Added invalidation of session tokens on logout
• Changed login form error to show the same message if either email or password is incorrect
• Obscured server version header
• Added HSTS to enforce SSL on recurring uses of the app
• Disabled browser cacheing of HTTP responses
• Prevented framing of app
• Implemented content-sniffing prevention

Other improvements and fixes

• Updated chart colors to avoid similar colors appearing next to each other
• Added local cacheing of home page record counts for improved performance
• Added new empty state on Home page
• Improved performance of joining workspaces through domain-based access

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

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

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

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

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

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