Changelog

Screenshot of Basedash showing toggles for "Creation allowed" and "Deletion allowed" on a view.

May 23, 2022

Creation and deletion permissions

You can now set permissions on individual views to prevent record creation and deletion. This lets you create views for members of your team that should only have access to certain actions on your data.

You also still set database-level permissions to limit view and edit access on specific tables or columns.

Other improvements and fixes

  • Fixed tabbing through records in the list layout
  • Fixed filtering on UUID columns
  • Fixed button styling when adding a connection
  • Fixed crash when navigating from one query to another
  • Fixed password in credentials page not showing the correct value
  • Improved error message when attempting to update credentials
  • Updated indentation on connections sidebar
  • Removed auto-focus on the first record in list layout
Screenshot of Basedash showing the newly improved list layout.

May 12, 2022

Improved list layout

We introduced the List layout last year, as our second ever layout type (after the humble table). This week, we’re shipping big improvements to the list layout that make it much more functional and beautiful.

First, we totally revamped the visuals of the list layout to make it look nicer. This includes better hierarchy, improved text styling, and cleaner element spacing.

Then, we improved the responsiveness of the list by allowing elements from a single record to stack. This makes the list layout experience much nicer on mobile, but also lets you expand the record details to take up the majority of the canvas on desktop.

Finally, we added the ability to select all records from the list layout for easier mass deletions.

Let us know what you think about the new list layout improvements in our Slack community here: https://www.basedash.com/community

UUID support

We also added better support for tables that use UUIDs as their primary key. Now, when creating a record in one of these tables, we’ll automatically generate a UUID to use as the primary key. You can always override the value with your own if need be.

Other improvements and fixes

  • Updated styling of the top bar on desktop
  • Fixed foreign keys and enums not loading when starting a session on a view
  • Added pagination to activity page
  • Updated “favorite” icon
  • Updated view layouts to be user-specific preferences, rather than tied to the view
  • Fixed deleted views & queries still showing in the sidebar
  • Improved performance of favoriting views & queries
  • Updated tables to show their display name in the header, rather than the raw name
  • Fixed some views not showing up when adding views to a role
  • Added the ability to edit values in views with joins
  • Improved email sequence showing off features for new users
  • Fixed link to record from edits in the activity feed
  • Changed ordering of views to put published before drafts
  • Added database-specific icons in the Connections page sidebar
  • Fixed icon on tables
  • Added icons to profile dropdown
  • Fixed boolean filters showing an unnecessary dropdown
  • Improved responsiveness of inputs in record details panel
  • Fixed redirection to welcome flow when trying to access the signup page while already authenticated
  • Fixed reloading records not showing a loading spinner
  • Fixed sidebar not showing tables immediately after connecting a database
  • Improved styling of list items in Roles settings
  • Added ability to add roles to a view from the view’s settings
  • Enabled SSL by default on Supabase databases
Screenshot of Basedash showing the new record creation form.

April 25, 2022

Record creation form

With the introduction of our new details panel last month, we decided to make use of it and improve the record creation experience.

The old method of creating records had a couple issues:

  1. It was only possible through the table layout
  2. It didn’t work for views where a required column was hidden
  3. It required a lot of horizontal scrolling for tables with many columns

Our new method puts the record creation experience in the details panel, in a simple form. We split the attributes into two sections: Required and Optional. This makes it easy to skim through just the required fields to quickly create records.

We also added the ability to “Create more”, which keeps the record creation form open, allowing you to create many records in quick succession.

As usual, the feature includes full keyboard navigation and was built with accessibility in mind.

Other improvements and fixes

  • Updated default for Supabase databases to have SSL enabled
  • Fixed alignment of tooltips with content
  • Fixed deleted views appearing in view creation UI
  • Fixed null booleans not being editable
Screenshot of Basedash showing filtering system.

April 18, 2022

New filtering system

We’ve implemented a new system for how filters are applied and persisted for views for different users. This involves a few different changes:

  • Filters applied from a view no longer alter the root filters on the view, they only apply for the current user
  • These non-root filters can be applied by any user, regardless of permission level (e.g. Admin, Can edit, Can view)
  • Non-root filters are persisted across sessions per-user
  • Non-root filters can be easily reset
  • Non-root filters are applied to the URL, so you can easily share your current filters with your teammates

Together, these changes mean that anyone can explore data on their own within Basedash, without inadvertently affecting what other users are seeing. We think that this will open up the ability for users to more freely explore and edit data as needed.

Other improvements and fixes

  • Added interface to show member limit when inviting a member
  • Updated demo database
  • Fixed Slack alerts
  • Fixed views not being able to be created in some cases
  • Fixed table layout UI for views with large row heights
  • Improved responsiveness in views and collections
  • Improved responsiveness of record details panel
  • Improved error messages when data fails to load
  • Improved filtering UI for enum columns
  • Improve error messages when connecting a database
  • Added Easter egg in changelog
Screenshot of Basedash showing the new Data page.

April 4, 2022

Improved Views and Data pages

Today we’re shipping a brand new experience to the Views and Data pages that shows you all of your views and collections in a searchable list, complete with full keyboard navigation. Before today, this list was only available after searching, but now the list will show up by default when you open the page.

You can take actions on views directly like favoriting, or right click on a view to quickly edit or delete it.

We’ve also added a Recents section so that you can quickly open up a view or collection that you had open recently.

Improved mobile responsiveness

From early on, we decided to build Basedash to support mobile devices, so that you can quickly monitor and make quick edits on-the-go. While mobile doesn’t make up the bulk of usage, it’s really important for use cases that come up every once in a while.

We just made a big update to our UI responsiveness to improve the experience on mobile. That includes:

  • Updated breakpoints for key UI changes
  • Full-width sidebar
  • Addition of workspace switcher

3x faster startup performance

After some deep digging into our app startup code, we managed to speed up the startup time for the app by 3x. This means that you’ll be able to jump into views and start editing way faster than before.

Performance is one of our top priorities while building Basedash. If you notice anything that doesn’t feel lightning fast, please let us know in our Slack community.

Other improvements and fixes

  • Added confirmation dialog before deleting records
  • Added record details panel to view settings
  • Added support for filtering on enum columns
  • Added support for tables with primary composite keys
  • Added support for tables with no primary key
  • Updated sizing of various UI elements across the app
  • Updated SQL views to reset pagination after re-running a query
  • Improved styling of JSON and rich text cells in table layout
  • Fixed bug preventing editing of the first cell when creating a new record in table layout
  • Fixed record details header appearing on view creation page
  • Fixed view limit callout not being shown when at the limit
  • Fixed “Connect a data source” CTA not being hidden immediately after connecting a data source
  • Fixed logging out causing a redirect loop
  • Fixed new record row not showing “default” on columns with default values
  • Fixed markdown cells removing consecutive line breaks
Screenshot of Basedash showing the improved details panel.

March 30, 2022

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
Screenshot of Basedash showing the roles configuration page.

March 14, 2022

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
Screenshot of Basedash showing the new Settings page.

March 7, 2022

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

Screenshot of the login page for Basedash.

February 14, 2022

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
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
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