Changelog

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
Screenshot of BaseDash showing the add database form.April 2, 2021

Redesigned add database flow

Adding a database is the first step of using BaseDash, yet it's one of the most difficult. We decided to totally redesigned the flow to make it simpler and to give more useful information while moving through the process.

We now ask you where your database is hosted so that we can automatically fill default values wherever possible, update form labels to match how they're presented by hosting providers, and link directly to your hosting provider's dashboard. We also plan to add inline videos showing how to find credentials for each hosting provider.

Other improvements and fixes

  • Updated toast animations
  • Fixed the cursor on checkboxes on the Activity page
  • Fixed queries layout on mobile
  • Fixed showing edits to or from a null value on the Activity page
  • Fixed setting date values using SQL functions like "now()"
Screenshot of BaseDash showing the activity page with a new "stories" feature.April 1, 2021

Stories

Expanding on last week's redesigned activity page, this week we decided to implement our most requested feature: stories. Stories let you quickly share snapshots of your views and queries from across your workspace. They're great for sharing wins like notable user signups and usage milestones. Stories disappear after 24 hours since they're meant to show relevant data in real time.

Of course, stories are fully keyboard-navigable—just press C then S to instantly create a story based off the page you're currently on. You can view active stories in your workspace on the Activity page along with your edit history.

We're excited to hear your feedback and see how you use stories to share insights across your team!

Other improvements and fixes

  • Migrated the codebase to WASM to improve performance
  • Added support for Figma as a data source
  • Removed Herobrine
Screenshot of BaseDash showing a list of edits made by teammates in the tool.March 26, 2021

Redesigned activity page

Being able to see activity within your workspace is incredibly valuable for teams using BaseDash. It lets you get a pulse for how your teammates are using the tool, and makes it easy to catch mistakes before they have an impact on your product.

We fully redesigned the activity page to show more context around edits, with things like checkboxes for booleans, nicely formatted dates, and properly indented JSON. This makes it much easier to quickly compare the before and after values of edits.

We have even more changes planned for the activity page that aren't quite ready to ship yet. Keep your eye out for future changelogs by following us on Twitter.

Other improvements and fixes

  • Improved the interface for queries, with the ability to toggle a fullscreen SQL editor
  • Improved the positioning of the callout on the add database page when connecting using SSH
  • Updated copy around data sources
  • Fixed the ability to add databases through SSH
  • Fixed the ability to copy a substring of text in a non-editable cell
Overview of plans and functionality for BaseDash, including Basic, Startup, and Enterprise.March 19, 2021

New pricing model

Our vision at BaseDash is to build the new standard for internal tools which enables everyone within a company to easily access the data they need to. Achieving this vision requires everybody from large companies, to early startups, to individuals working on side projects, to be able to use BaseDash. Our old pricing model was too prohibitive to certain small companies, so we decided to rethink it from the ground up.

Our new pricing model is designed to scale both functionality and cost in a way that makes sense for teams of all sizes. Our goal was to only include limitations for features that actually matter depending on your team size (e.g. unlimited edit history for startups, on-prem deployment for enterprise). Beyond that, we don't place any limits on the way you use the tool.

We also offer significant discounts/free access to non-profits and free open-source software projects on a case-by-case basis. Email us for more details.

We hope these changes allow more teams to use BaseDash to improve their internal tools.

Other improvements and fixes

  • Added support for custom SSL certificates when connecting a database
  • Added a toast notification whenever there's an update available to the app
  • Migrated our entire codebase to TypeScript which will increase development speed and reduce bugs going forward
Screenshot of BaseDash showing a toast popup containing 3 edits.March 12, 2021

Contextual toasts

We totally revamped our toast system to show context around each edit you make, with the value before and after each change. If you make multiple edits in quick succession, we'll group them together into a single toast with controls to individually undo edits as needed. We think that showing a quick snapshot of each edit you make will reduce errors and increase speed and confidence in taking actions.

This update also improves error messages by grouping them together into a single toast, saving you valuable screen real-estate.

Other improvements and fixes

  • Added Vim-style 'hjkl' keyboard shortcuts for table navigation
  • Migrated all icons across the app to our custom icon set
  • Added an internally shareable URL to the share menu in tables
  • Updated default user avatars to show initials
  • Fixed an issue where private views couldn't be created when at the limit for shared views
  • Fixed foreign key cells not showing updates immediately if they had a table identifier assigned
Screenshot of BaseDash showing a new "Search" button in the sidebar, and the command bar open with a list of views and tables.March 5, 2021

Global view search

This week we added a global search that allows you to jump to any view, query, or table in seconds. It's fully keyboard-navigable and can be opened from the sidebar, or by pressing '/' from anywhere. With this addition, you can now navigate to any page in BaseDash purely with the keyboard.

This is the first of a few updates we have planned to improve navigation and organization of views. We think that views are core to BaseDash, so we want to improve the ways that you can work with them. Keep an eye out for future updates by following us on Twitter.

Keyboard shortcut cheat sheet

Speed is core to BaseDash—we've got loads of keyboard shortcuts for navigation, creation, and manipulation. This week we added a central location to show all available shortcuts in an instant. It automatically detects which shortcuts are triggerable depending on where in the app you are, and lets you search to find specific actions.

You can open the cheat sheet by pressing '?', or by searching for "Keyboard shortcuts" in the command bar.

Other improvements and fixes

  • Updated styling of foreign key chips
  • Added an RSS feed for the weekly changelog
  • Fixed column loading for SQL Server databases
  • Reduced bundle size and improved performance across the app
Screenshot of BaseDash showing two folders within a database representing database schemas.February 26, 2021

Schema folders

We noticed that some users have large numbers of tables across multiple schemas in their database. Until now, we were organizing these in the sidebar by showing the full schema and table name for each list item in the sidebar (e.g. "public / Users"). This worked, but the repeated schema names looked ugly and often resulted in table names overflowing past the sidebar.

This week, we added a second level of organization in the sidebar for database schemas. We automatically detect any schemas in your database and create folders for them which can be individually expanded to show the tables within. This should greatly simplify navigation in big databases with multiple schemas.

If you only use a single schema (like "public"), you won't notice a difference since we flatten the structure to save you a click.

Other improvements and fixes

  • Added highlight to data type icon in column headers to indicate which column is the table identifier
  • Fixed views with specific column types crashing

Screenshot of BaseDash showing the query editor with a autocomplete suggestionsFebruary 19, 2021

Query autocomplete

We added autocomplete to our SQL query editor to make it easier than ever to quickly explore data in your database. It automatically suggests table and column names as you type—just hit Enter to fill the selected value. It also automatically quotes any values that use capital letters to ensure that your query runs correctly.

This should significantly speed up the process of writing queries and reduce the amount of debugging required to get your query to pull the data you want.

Other improvements and fixes

  • Added ⌘/Ctrl + Enter shortcut for submitting changes while editing JSON data
  • Fixed crash caused by opening a view that contained columns removed outside of BaseDash
  • Fixed incorrect data showing when switching between tables or views quickly

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