Changelog

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
Screenshot of BaseDash.May 10, 2021

Performance improvements

We spend a lot of time thinking about how to improve the performance of BaseDash. Unlike most software, we not only have to connect to our own servers, but also to your database, which adds another step into each network request. This means that we're fundamentally challenged on performance. Despite this, with good software engineering, we believe that we can build BaseDash to feel faster than 99% of software.

We spent the past week overhauling all of the code that manages fetching data. This allowed us to eliminate unnecessary network requests, add smarter client-side data caching, and improve data-loading dependencies. Here are the results:

  • Up to 25% faster page load times
  • Up to 80% less data transferred
  • Up to 70% fewer API calls

We're really happy with these results, but we think there's always room to improve performance, so it'll continue to be a priority moving forward. If there's any part of the app that you feel is slow, let us know on our Slack community and we'll prioritize it.

Other improvements and fixes

  • Added a status page
  • Added a connection error indicator on databases in the sidebar
  • Improved search bar focus state
  • Improved record creation by automatically reloading data on creation
  • Fixed filters not being applied when loading a view
  • Fixed databases persisting in the sidebar after deletion
  • Fixed column widths in newly created views
  • Fixed "does not contain" filter
  • Removed expanded record modal
  • Removed column creation
Screenshot of BaseDash showing the views page with an item in the list selected.May 3, 2021

Views page keyboard navigation

We've improved the keyboard navigation on the views page to make it easier than ever to get to your data. You can now use the arrow keys or 'j' and 'k' to navigate through the list, 'return' to open the selected view, and 'f' to favorite a view, pinning it to the sidebar. You can also now press 'g' then 'v' to go to the views page. As before, you can press '/' to open search and jump straight to a view from anywhere.

We're big fans of keyboard navigation and aim to make the entire app keyboard navigable. We're currently about 90% of the way there.

Other improvements and fixes

  • Updated the styling of the views page
  • Fixed alignment of real-time avatars in the view header
  • Updated the "Save as view" button in tables to always be visible
  • Added favorite button to the view and query headers
  • Added an empty state for the favorites section in the sidebar
  • Switched the sort order for views using emojis
  • Updated header padding on desktop
Screenshot of BaseDash showing a new "Views" page that contains a list of views.April 26, 2021

New views page

Views are the base unit in BaseDash—they're how you organize data and share insights across your team. Until now, we've shown all your views directly in the sidebar. This works well when you just have a handful of views, but quickly gets out of control as your team generates many views.

To solve this, we created a dedicated page to see all your views in one place. Beyond just the name, we also show the database and table that the view pulls data from, and when it was created. From here, you can individually choose to favorite certain views that you use regularly to pin them to your sidebar for easy access. Favorites are unique to each user so they won't affect your teammates.

We also now sort views by their emoji first, then alphanumerically, which opens up another layer of organization to your views page.

We have big plans around how to let you organize views even more in the future—keep up to date by following us on Twitter.

Other improvements and fixes

  • Updated the action bar across tables, views, and queries
  • Added a dedicated page to view and add members to your workspace
  • Fixed enabling two-factor authentication
  • Fixed uneven line height of some links
  • Updated spacing of cards
  • Added record, table, and database chips on activity
  • Changed the cursor to arrow when hovering over most text
  • Added tooltips on table identifier chips to show the underlying value
  • Fixed native browser behaviour for Cmd + L shortcut
  • Fixed native browser behaviour for Cmd + Option + Left/Right shortcuts
  • Fixed getting logged out when connection to the server is temporarily lost
Screenshot of BaseDash showing a video of how to add BaseDash as a trusted source.April 16, 2021

Database connection instructions

Connecting to a database can be difficult, involving trusted sources, credentials, certificates, and more, depending on your setup. We've added inline instructions and videos on how to find some of this information while connecting a data source in BaseDash.

Specifically, we now show text and video instructions on:

  • Finding your database credentials
  • Adding BaseDash as a trusted source to your hosting provider
  • Connecting to a locally hosted database

We currently have videos for all major managed database hosting providers with plans to add more in the future.

Other improvements and fixes

  • Updated the icons for boolean and enum columns
  • Added a Security page
  • Fixed filters containing certain characters in their value
  • Fixed showing boolean values from queries
  • Added proper formatting for time columns
  • Fixed empty rows showing at the top of views in some cases
Screenshot of BaseDash showing a "Join Slack community" button.April 9, 2021

Slack community

BaseDash now has a public Slack community! We'll be using this to share tips and updates to the tool, and showing off some sneak peeks of product changes before they go live. It's a great place to chat with the team and other power users about the future of BaseDash, and how to use the tool to its full potential.

We try to be incredibly responsive to bug reports and feature requests. Let us know what's been bugging you in the #bugs channel, and what you'd like to see us add in #feature-requests.

Join the Slack community here—we're looking forward to meeting you!

Other improvements and fixes

  • Added custom tooltips across the app
  • Added an account dropdown to the sidebar to quickly access the changelog, Slack community, and support email
  • Fixed URL being persisted after logging in
  • Fixed crash after logging out and back in as a new user
  • Added hosting-provider-specific instructions on how to add BaseDash as a trusted source
  • Changed titles from uppercase to sentence case
  • Added a confirmation toast after connecting a data source
  • Updated the button icons on URL and foreign key cells
  • Added persistence to the email field when switching from the login to signup form
  • Fixed showing an infinite spinner instead of an error message when loading a view fails
  • Fixed real-time user avatars all showing your own avatar
  • Fixed cells randomly getting cleared while creating a new record
  • Fixed undoing boolean edits not showing the new value in the table

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