Lots of great updates this week, but first...
♻️ A note on iteration
We're big champions of building iteratively — this means that we take your feedback very seriously as we incrementally add the Hex features that make your data life easier. (So a big thank you to everyone who's shared their thoughts!)
With that note, we're excited to (re)share two features which have had some big updates: the File uploader and Schema browser! Keep scrolling for more details.
🗃️ File uploader 2.0
Among the many things that a year+ of WFH has taught us is that home internet upload speeds are not great. We've revamped our File Uploader so that you can not only upload multiple files at once, you can do so in the background with no time limit! You can also download your files to your local computer.
👓 Schema browser 2.0
Our Schema Browser can now handle larger, chunkier schemas! We've also added the ability to search through your data, reference multiple databases within a data source, and manually trigger a schema refresh.
👟 Run mode options
We've unlocked more options for how cells execute while you're in Notebook view. "Cell + above", "Cell + below", & "All cells" are execution modes which can now be set as a project-wide default or triggered at the individual cell level. Check out the docs or the video below for a breakdown!
🧺 SQL goodie basket
We're making the SQL editing experience in Hex better and better. This batch of improvements includes:
- Type-ahead — use the suggested schema and table names without having to do all that typing! (See a sneak peek in the screenshot above)
- Better error messages — we've condensed SQL cell errors to make them more helpful
- SSH data connections — access databases on private networks with a secure SSH tunnel
- Compiled query — see the query you've written as a compiled prepared statement for easier debugging
Bugs squashed
- The item limit for dropdown menus has been increased to 1000 items and a warning when that limit is passed has been added.
- Some markdown cells were not automatically being added to Story mode apps, which has been resolved.
- Error message from cached queries are no longer suppressed.
- HTML outputs no longer have a fixed size.
- Auto highlighting of a project name has been added to the renaming project workflow.