Changelog

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
Screenshot of BaseDash showing supported database types, including AirtableFebruary 12, 2021

Airtable integration

It's super common for early-stage startups to begin development with Airtable as their data store, before eventually migrating to a proper SQL database. Problem is, that migration step is a huge pain, from hosting the database, to generating the schema, to copying over any existing data.

We've partnered with Sync Inc to allow users to instantly migrate from Airtable to a fully-fledged SQL database in seconds. We handle everything from hosting to migrating, while providing the same great data editing experience you're used to. You'll get direct access to your new database's credentials so you can start integrating it into your codebase.

The underlying database runs on PostgreSQL, the industry standard for modern SQL databases—this means that you can write and share standard SQL queries to explore your data in new, complex ways.

Best part is, you don't need to migrate all at once—we'll constantly sync data from Airtable to the SQL database so that you can gradually move your systems over.

We're super excited to see what this new functionality enables. The feature is still early in development so expect lots of improvements in the coming weeks.

Other improvements and fixes

  • Improved behavior around how applying sorts works
  • Updated sort icon directions to improve legibility
  • Fixed enum column editing in certain browsers
  • Fixed welcome email sequence
  • Changed behavior of creating new views from a table to save existing filters and sorts
Screenshot of BaseDash with a "Slack settings" modal open showing configuration optionsFebruary 5, 2021

Slack notifications

We've added a Slack integration so that you can be notified whenever a new record is added to a table. These are linked to views, so you can easily apply a filter to only be notified when a specific kind of record is created. You can send notifications to different Slack channels for each view, and choose to receive notifications in real-time as records are created, or batch them in hourly or daily increments. You can enable notifications in the "..." menu in the top-right of any view.

Other improvements and fixes

  • Added a button to column headers to instantly sort by that column
  • Improved sidebar behaviour on mobile
  • Fixed navigation for return users who haven't yet created a workspace
  • Removed ability to create views in workspaces with no database
  • Improved styling of table action bar on small screens
  • Fixed databases from other workspaces showing in query database selector
  • Fixed capitalization of certain acronyms in column names
Screenshot of button with text "Back to Workspaces"January 29, 2021

Foreign key back button

We added a new button to return to the previous table or view after navigating through a foreign key. It's really common to jump to a record associated in a foreign key, grab some information or make a quick edit, then return to the original table. This new back button is the fastest and easiest way to do that.

Other improvements and fixes

  • Improved database dialect selection interface when adding a new database
  • Improved drag handle indicator for resizing columns
  • Improved drag handle indicator for resizing the sidebar
  • Fixed checkbox being hidden for null boolean cells when focusing the cell
  • Fixed signups not automatically redirecting to a logged in state in some cases
Screenshot of redesigned sidebar in BaseDashJanuary 22, 2021

Sidebar redesign

We changed the way the sidebar works to simplify navigation and improve organization of views. The new sidebar replaces the nav bar for high-level navigation, so it's now present across the entire app. It also includes some new icons to help you navigate around, including the ability to set custom emojis on your views. You can also now resize the sidebar.

Record search redesign

The search bar in tables and views is now in the action bar, and is faster than ever with updated keyboard shortcuts.

Other improvements and fixes

  • Improved reliability of search for special characters
  • Improved the theme picker, adding a Match system option
  • Locked editing of primary key columns
  • Improved visibility of uneditable columns with a different background color
  • Improved contrast on foreign key values
  • Improved table header styling
  • Updated action bar to increase window drag target on macOS
  • Fixed support for setting foreign keys when creating new records
  • Improved SQL-based views by persisting the View as chart setting across sessions
  • Improved checkbox styling for boolean columns
  • Added support for PostgreSQL array columns
  • Improved default column widths for tables
  • Updated icon set for column data types
  • Removed ability to delete columns

The new standard for internal tools

BaseDash replaces the need for custom internal tools, so you can focus on your product.
Get started for free
Decorative graphic of two people in an office