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.
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.
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.
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.
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.
The search bar in tables and views is now in the action bar, and is faster than ever with updated keyboard shortcuts.