January 12, 2024 By Matthew Rathbone

This was intended to be a small point release after the release of 4.0. I guess things got a little out of hand :-).

Headline features this month are thanks to the small group of part time contractors helping me build Beekeeper Studio on nights and weekends - @not-night-but, @azmy60, and @wmontgomery

Headline Features

Spreadsheet style table interactions!

You can do a bunch of stuff with tables that ‘just makes sense’ now including:

  • Selecting rows / columns
  • Selecting a range of cells
  • Copying data from the selected cells/columns/rows
  • Pasting data into a table across multiple cells
  • Navigating with the keyboard

It’s a huge improvement. @azmy60++ for all the work on this feature. We’ve also contributed this feature back to Tabulator.

Ever tried to edit JSON or HTML in a Beekeeper Studio table view? It’s horrible. Or rather it WAS horrible. It’s now a lot nicer.

Right click a cell and select edit in modal to edit the value in a larger editor.

If you’re editing JSON, Beekeeper Studio will automatically prettify it for you to make editing easier (and minify it for you when you save, if you so choose).

Wayland fractional scaling support

I’m a Linux user. Gnome now uses Wayland, so I use Wayland. Unfortunately my screen requires me to run at 150% fractional scaling. Up until now there was no real way to make Beekeeper Studio look right in this environment – the app would be blurry and hard to read.

This release includes proper support for Wayland, but it’s not enabled by default (due to remaining problems with NVIDIA), rather Wayland has to be enabled by setting a couple of flags in a configuration file.

Here is the user guide for enabling Wayland.

More changes

  • Beekeeper Studio docs moved into the repo under [docs]
  • Launch multiple tabs from the quicksearch menu
  • Arrays and complex objects edit & save correctly
  • Fixed some issues with not quoting table aliases in some situations
  • Restored SQL Server 2005 compatibility (Yes we support this for longer than MSFT)
  • Connection edit forms are colored according to the connection color
  • Fixed Nullifying a value and saving
  • Fixed columns not populating in the ‘relations’ tab for uncached tables
  • Improved SQL query identification in the editor

We improve other open source projects

Many of the improvements we have made in Beekeeper Studio have also been contributed to the upstream projects that we use. We think this is the right way to make software. If you do too, please support us by purchasing a copy of the full version of Beekeeper Studio.

If you can’t afford the full version, no worries, that’s why we make a free and open source community edition.

In this release we’ve submitted patches to Tabulator, and SQL Query Identifier.

PRs Merged

7a22a90a Merge pull request #1841 from beekeeper-studio/fix/language-editor
6ee968eb Merge pull request #1844 from beekeeper-studio/fix/spreadsheet
4feefabc Merge pull request #1826 from beekeeper-studio/fix/tabulator
6792d832 Merge pull request #1827 from beekeeper-studio/bugfix/the-nullening
8960c657 Merge pull request #1832 from beekeeper-studio/local-docs-again
32d86f2d Merge pull request #1825 from beekeeper-studio/fix/tabulator-styles
492458ac Merge pull request #1824 from beekeeper-studio/wayland-native
744d50a2 Merge pull request #1784 from beekeeper-studio/bugfix/1750_Relations-Tables
64feac0f Merge pull request #1803 from beekeeper-studio/language-editor
bd4df166 Merge pull request #1819 from beekeeper-studio/feat/paste-in-multiple-cells
4fcc2449 Merge pull request #1823 from beekeeper-studio/fix/sql-server-concat
d0f5fe63 Merge pull request #1820 from beekeeper-studio/fix/green-column-name
cc2645cf Merge pull request #1822 from beekeeper-studio/fix/broken-sure-dialog
99a8bbb4 Merge pull request #1817 from beekeeper-studio/bugfix/1807_array-arrfulness
28f82983 Merge pull request #1793 from Christof-P/feat/add-color-coding-to-edit-form
ab68e50b Merge pull request #1815 from beekeeper-studio/fix/sql-query-identifier
db939c4b Merge pull request #1812 from beekeeper-studio/fix/spreadsheet-navigation
cac86af2 Merge pull request #1794 from Christof-P/feat/multi-select-quick-search
93ed237b Merge pull request #1740 from beekeeper-studio/fix/quoted-alias
fa2b88a9 Merge pull request #1810 from beekeeper-studio/bugfix/1808_editing-issue
884a487a Merge pull request #1785 from jc00ke/update-linux-deb-install-docs
177307b7 Merge pull request #1777 from beekeeper-studio/dependabot/npm_and_yarn/axios-1.6.0
d64d685a Merge pull request #1802 from beekeeper-studio/fix/set-vim-mode
c51e75f6 Merge pull request #1797 from maxoliverbr/fix-translations
e475f5ad Merge pull request #1773 from beekeeper-studio/fix/non-reflective-table-columns
202709d7 Merge pull request #1781 from beekeeper-studio/fix/unuse-native-modals
bbeff863 Merge pull request #1799 from beekeeper-studio/fix/virtual-table-list
f5b5758b Merge pull request #1747 from beekeeper-studio/feat/initial-spreadsheet
24798bec Merge pull request #1800 from beekeeper-studio/fix/slow-column-resize
8491b141 Merge pull request #1745 from p-Jimenez/show-table-comments
7ac2da36 Merge pull request #1792 from beekeeper-studio/fix/persistent-bg-column
df1a2a36 Merge pull request #1764 from beekeeper-studio/sqlite-client-class
54476146 Merge pull request #1788 from beekeeper-studio/sweep/add-prefix-to-error-messages
eff24858 Merge pull request #1789 from MasterOdin/patch-1
a8a92439 Merge pull request #1771 from beekeeper-studio/fix/virtual-table-list
42b7ff3e Merge pull request #1776 from beekeeper-studio/fix/escape-view-names
b1579e5b Merge pull request #1770 from trivikr/remove-aws-sdk
2b85a154 Merge pull request #1763 from beekeeper-studio/dependabot/npm_and_yarn/browserify-sign-4.2.2
6f2dd3db Merge pull request #1744 from beekeeper-studio/dependabot/npm_and_yarn/babel/traverse-7.23.2
2a0ee5c8 Merge pull request #1736 from beekeeper-studio/fix/1735
a6f4b324 Merge pull request #1760 from beekeeper-studio/fix/illegible-conn-type
83e2a42f Merge pull request #1697 from mohamedelhefni/feature-1685
7e889e89 Merge pull request #1722 from beekeeper-studio/fix/1721
4dcad062 Merge pull request #1708 from azmy60/fix/invalid-array-in-copy
7a953d3f Merge pull request #1725 from beekeeper-studio/feature/Vue-Linter
ff385701 Merge pull request #1718 from beekeeper-studio/fix/debounce-filter-builder
5dc95adc Merge pull request #1711 from beekeeper-studio/fix/tabulator-bool-option
1d92b24e Merge pull request #1717 from austinwilcox/fixVimEsc
ead61f9f Merge pull request #1715 from iifawzi/feat/1714-compound-foreign-keys