Beekeeper Studio Release Notes

I don’t usually make release posts for minor bug fix releases, but this one is near to my heart as a former Excel-developer (miss you VBA).

One of the goals for Beekeeper Studio is to be ‘intuitive’. That’s nice, but what does “intuitive” actually mean?

For data tables it means that they should behave like Google Sheets and Excel. Spreadsheet apps are so widespread and ingrained into our day to day lives that the memorized keyboard shortcuts and behaviors are just second nature to a lot of people, myself included.

Turns out in the 6.1 release we’d broken a few of these, so we spent some time really focusing on how our data tables work and ironing out the spreadsheet kinks, especially around multi-cell copying and pasting.

If you want the full list you can see this GitHub issue, or just watch the video below for a quick walkthrough.

Original source

What's Changed

• Fixes for table issues by @not-night-but in #4787
• tables don't use Command key in macOS by @azmy60 in #4789
• Start editing a cell by typing into it by @azmy60 in #4805
• upgrade tabulator 6.6.0 by @azmy60 in #4820
• Persist table copy highlights by @azmy60 in #4803
• enable selectableRangeFill by @azmy60 in #4806
• fix styles for edited cells when in a range selection by @not-night-but in #4817
• fix cannot paste with keyboard shortcut in result table by @azmy60 in #4822
• fix marking as edited when dragging a range by @not-night-but in #4826
• fix result table columns resizing by @not-night-but in #4829
• Fix more table issues by @not-night-but in #4831
• remove old readonly license check by @not-night-but in #4832
• Fix shortcut binding, but against rc-61 by @rathboma in #4836

Full Changelog: v6.1.4...v6.1.5

Original source

What's Changed

Merge rc-60 into master by @github-actions[bot] in #4659
Respect column visibility when generating table queries by @rathboma in #4663
fix(tabletable): make Add row reachable via right-click when table is full by @Fraianni in #4667
Block cloud workspace access for lifetime licenses by @rathboma in #4646
add updated by status to query editor by @azmy60 in #4660
Merge rc-60 into master by @github-actions[bot] in #4671
fix: add empty state to quick switcher panel (#4150) by @ChihebBENCHEIKH1 in #4155
Phantom tabs by @rathboma in #4675
SQLite and LibSQL flakiness fixes (hopefully) by @rathboma in #4679
Enhancements to Table Properties tab by @rathboma in #4670
Vim mode: fix focus, ex commands, and .beekeeper.vimrc by @rathboma in #4669
fix: show PostgreSQL details in drop errors by @bnquon in #4650
fix(ssh): treat agent errors as non-fatal so publickey auth can proceed by @stephaneminisini-fps in #4681
Small improvements: simplify keyboard hints & fix shortcuts modal by @azmy60 in #4685
add indentation markers for json sidebar by @azmy60 in #4680
Merge rc-60 into master by @github-actions[bot] in #4689
add ability to disable schema & keyword completion individually by @not-night-but in #4688
Upgrade modal, now with 100% less AI-pilled design by @rathboma in #4692
Create a query by right clicking a folder by @azmy60 in #4665
fix plugin shortcuts and type errors by @not-night-but in #4700
fix shortcut for switching tabs on mac by @gruberlu in #4226
Fix plugin theme does not sync with system theme by @azmy60 in #4705
feat(editor): Add active line background feedback and active line number highlighting by @Srijal-SS in #4697
Bump browserslist from 4.28.1 to 4.28.8 by @dependabot[bot] in #4724
Bump @xmldom/xmldom from 0.8.13 to 0.8.15 by @dependabot[bot] in #4720
Bump qs from 6.14.1 to 6.16.0 by @dependabot[bot] in #4719
Bump mysql2 from 3.11.5 to 3.23.1 by @dependabot[bot] in #4717
Bump fast-uri from 3.1.5 to 3.1.7 by @dependabot[bot] in #4716
Bump postcss-selector-parser from 6.1.2 to 6.1.4 by @dependabot[bot] in #4712
Merge rc-60 into master by @github-actions[bot] in #4703
bump @beekeeperstudio/ai-shell v3.3.3 by @azmy60 in #4726
bump @beekeeperstudio/ai-shell v3.3.4 by @azmy60 in #4727
Show the trial/license-expired dialogs at launch by @rathboma in #4733
Make readonly mode free by @not-night-but in #4737
Add tree for import from local workspace by @not-night-but in #4707
Load saved connections that are tied to used connections by @not-night-but in #4708
Connection import by @not-night-but in #4730
Make folders free by @not-night-but in #4736
Create a connection by right clicking a folder by @azmy60 in #4666

New Contributors

@Fraianni made their first contribution in #4667
@ChihebBENCHEIKH1 made their first contribution in #4155
@stephaneminisini-fps made their first contribution in #4681
@gruberlu made their first contribution in #4226
@Srijal-SS made their first contribution in #4697

Full Changelog: v6.0.5...v6.1.0-beta.0

Original source

What's Changed

• fix persistence guard by @azmy60 in #4645
• use config values instead of old globals by @not-night-but in #4642
• fix(sidebar): drag-and-drop reordering is discarded on the next render by @andreasarf in #4647
• Merge rc-60 into master by @github-actions[bot] in #4644
• Autocomplete defaults overhaul - restoring upper case by @rathboma in #4648
• table column widths are replaced by new tabs by @azmy60 in #4651
• only save persistence data if data has changed by @not-night-but in #4656
• Update bundled plugins when the app ships a newer version by @azmy60 in #4658

Full Changelog: v6.0.1...v6.0.4

Original source

What's Changed

• Use UI Kit Context Menu by @azmy60 in #4436
• Patch for share bugs by @azmy60 in #4626
• force folders to be alphabetically sorted by @azmy60 in #4625
• FEAT: Ask AI by @azmy60 in #4628
• fix ssh attempting to parse encrypted default keys by @not-night-but in #4622
• Decouple release publishing from build workflow by @rathboma in #4629
• Add per-path checkboxes to release publishing dispatch by @rathboma in #4635
• Merge rc-60 into master by @github-actions[bot] in #4623
• ci: never restore node_modules cache in release builds; key caches by runner image by @rathboma in #4638
• ugrade identifier in ui-kit by @not-night-but in #4634
• fix pageant on windows by @not-night-but in #4640
• fix save connection form showing up on new connection screen by @not-night-but in #4636
• remove duplicate import for config in utility.ts by @not-night-but in #4633
• Rc 60 by @rathboma in #4639

Full Changelog: v6.0.0...v6.0.1

Original source

🧚 Listen! Beekeeper Studio is a fast, modern, and open source database GUI

The standout feature for v6 is team collaboration v2! Full infinite depth folder trees, plus per-file and per-folder share settings make this the best Beekeeper Studio ever if you work on a team.

Hmm, what was that? Oh yes we are a little late releasing v6, it was due at the end of July, but you know what they say - good things come to those who wait.

Highlights

• Sharing and permissions for queries, connections, and folders.

  In a cloud workspace you can now decide who can view and who can edit each individual item, instead of a single team folder that everyone can edit. Set a general team access level (no access / can view / can edit), then add per-member grants on top. Access is inherited down the folder tree, owners always keep full access to their own items, and only owners (or workspace admins) can change sharing. Existing team items keep their old behavior and are upgraded seamlessly as you start using the new features.

• Folders infinite depth.

  Connections and saved queries use a new tree component with properly nested folders and simple drag-and-drop to move and reorder items. This combines with Beekeeper’s new sharing & permissions system to make a Google-Drive like experience, but for SQL. There’s nothing else like it available.

• StarRocks support.

  New StarRocks driver, so you can browse schemas and run queries against StarRocks the same way you do everywhere else.

Other Improvements

• Query edit history in local workspaces.

  Saved query version history — previously cloud-only — now works for local workspaces, so you can see past edits and restore an earlier version of a query.

• Import a directory of SQL files.

  The SQL import modal can now walk a whole directory recursively and recreate its folder structure as saved query folders, with an option to preserve or skip the root directory.

• Add a row from the grid itself.

  Right-click the empty space below the last row to add a new row, instead of hunting for the + button in the bottom corner.

• Kerberos (GSSAPI) authentication for MongoDB.

  Configured through the connection URL with authMechanism=GSSAPI, with friendlier errors when the ticket or SPN isn’t right. Requires a Business license and a working krb5 client.

• SSH config Include support.

  Include directives in ~/.ssh/config are now read in place, including glob patterns and paths relative to the config file. Thanks @Squidysquid1!

• “Select Top 100 Rows” in the table context menu.

  Right-click a table in the sidebar to drop a select top 100 query straight into the editor. Thanks @manos02!

• Plugin API: disabledFeatures on getConnectionInfo.

  Plugins (the ERD plugin especially) can now tell which features the connected database actually supports.

• Nicer tooltips.

  Keyboard shortcuts in tooltips are formatted properly, and connection and query tooltips show who created the item.

Everything Else

Another big thanks to the dozens of contributors who helped to make Beekeeper Studio better this month.

• Trino query errors are no longer swallowed and reported as empty results (#4499)
• Ctrl+Z no longer undoes several steps at once in the query editor (#4498)
• Postgres: SQL: Create now uses the selected overload for overloaded functions (#4551)
• Postgres dollar-quoted blocks are split correctly (sql-query-identifier 3.2.0) (#4592)
• Jump-to-last-page uses the filtered row count instead of the total (#4599)
• Manual table refresh re-fetches columns, so renames show up (#4590)
• SQL → SQL exports preserve the table’s column order (#4560)
• Row delete shortcuts work again on macOS (#4556)
• Grab/grabbing cursor on the column reorder handle (#4506)
• AND/OR operators repositioned in table filters (#4559)
• Fixed overlapping context menus in the data grid (#4539)
• Database dropdown hides the selected text while searching, and its icons no longer overlap on resize (#4532, #4507)
• Editor font size now applies to modal editors (#4510)
• Query elapsed timer shows the hours field at exactly one hour (#4612)
• JSON viewer escapes regex metacharacters when locating keys by path (#4613)
• Long error messages no longer make the status bar unusable (#4543)
• Delete confirmation shows the favorite’s title (#4547)
• Alert shown when folder creation is disabled (#4535)
• Folders that fail to load show an error instead of an empty “no items” state (#4610)
• Fixed sidebar overflow caused by tree item tooltips (#4619)
• Cloud sync fixes: only poll modules that are actually on screen, poll correctly on mount, don’t clear a new folder mid-poll, and handle remotely deleted items and merges (#4584, #4617)
• Fixed the import-from-local-workspace modals, and skip .git folders when importing (#4609, #4615)
• Fixed the last-used workspace not being restored (#4578)
• Azure CLI discovery and launch fixed on Windows (#4538). Thanks @jasonnutter!
• Improved AppImageLauncher detection (#4562)
• Swahili README translation (#4555). Thanks @cleven12!
• Docs: paste-as-new-rows, plugin view types, setDebugComms, plugin prerequisites, Snowflake moved to full support, SAP HANA listed as coming soon
• Dependency updates including Electron 39.8.10, dompurify, nanoid, js-yaml, axios, typeorm, tar, protobufjs, and undici

Original source

What's Changed

Workflow job to make sure we don't have rc branches with changes hidden from view by @rathboma in #4453

Merge rc-57 into master by @github-actions[bot] in #4454

ci: upgrade GitHub Actions off deprecated Node 20 runtime by @rathboma in #4458

chore(deps): bump js-yaml from 3.14.2 to 3.15.0 by @dependabot[bot] in #4445

Decouple snap publishing from build matrix by @rathboma in #4470

CI: Remove temporary branch from SQL Server Kerberos tests by @rathboma in #4473

Update ssh-config dependency to published version 5.2.0 by @rathboma in #4474

V5.9 release branch back to Master by @rathboma in #4452

Merge rc-59 into master by @github-actions[bot] in #4479

More kerberos by @rathboma in #4446

Query, connection, and folder sharing by @azmy60 in #4396

Move upgrading docs to /support/how-to-upgrade, keep old URL in the A/B funnel by @rathboma in #4496

Fix Ctrl+Z undoing multiple steps at once in the query editor by @muhammadusamahoyrr in #4498

Fix Trino query errors being swallowed as empty results by @muhammadusamahoyrr in #4499

fix: apply editor font size to modal editors (#4146) by @deeferentleeg in #4510

Position database dropdown icons absolutely by @manos02 in #4507

fix: show grab/grabbing cursor on table column reorder handle by @deeferentleeg in #4506

feat: query audit for the local workspace by @azmy60 in #4332

chore(deps): bump axios from 1.16.0 to 1.18.0 by @dependabot[bot] in #4514

Bump protobufjs from 7.6.4 to 7.6.5 by @dependabot[bot] in #4518

Bump brace-expansion from 1.1.12 to 1.1.16 by @dependabot[bot] in #4519

Bump brace-expansion from 1.1.11 to 2.1.2 in /apps/ui-kit/examples/react by @dependabot[bot] in #4521

Bump body-parser from 2.2.2 to 2.3.0 by @dependabot[bot] in #4523

Bump immutable from 4.3.8 to 4.3.9 by @dependabot[bot] in #4529

Bump tar from 7.5.16 to 7.5.21 by @dependabot[bot] in #4530

Bump fast-uri from 3.1.2 to 3.1.4 by @dependabot[bot] in #4531

chore(deps): bump shell-quote from 1.8.4 to 1.10.0 by @dependabot[bot] in #4533

Bump dompurify from 3.4.11 to 3.4.12 by @dependabot[bot] in #4527

Bump typeorm from 0.3.29 to 0.3.31 by @dependabot[bot] in #4528

chore(deps): bump postcss from 8.5.3 to 8.5.22 in /apps/ui-kit/examples/html by @dependabot[bot] in #4534

fix: hide selected dropdown text while searching by @AnandaBintang in #4532

Fix overlapping context menus in the data grid by @manos02 in #4539

Add "select top 100 rows: by @manos02 in #4524

show alert when folders are disabled by @azmy60 in #4535

Add support for ssh include directive by @Squidysquid1 in #4459

Add StarRocks by @azmy60 in #4367

fix too long error make status bar unusable by @kice in #4543

ui: change table edit trigger from double to single click by @mazzoccantelorenzo in #4504

ui: add context menu to table empty space for new row by @mazzoccantelorenzo in #4503

docs: document Paste as new rows by @drannonymousxx in #4544

fix: fix inability to discover or launch az cli on windows by @jasonnutter in #4538

fix: reposition AND/OR operators in table filters by @bnquon in #4559

chore(deps): bump brace-expansion from 1.1.16 to 1.1.18 by @dependabot[bot] in #4554

fix: show favorite title in delete confirmation by @ylyra in #4547

Fix/appimage launcher detection by @cynicalmindset in #4562

add disabledFeatures to getConnectionInfo by @azmy60 in #4561

feat: add Swahili (SW) README translation by @cleven12 in #4555

chore(deps): bump undici from 6.27.0 to 6.28.0 by @dependabot[bot] in #4566

fix: display formatted keybindings in tooltips by @bnquon in #4564

chore(deps): bump fast-uri from 3.1.4 to 3.1.5 by @dependabot[bot] in #4569

chore(deps): bump postcss from 8.5.22 to 8.5.25 in /apps/ui-kit/examples/html by @dependabot[bot] in #4568

fix(postgres): use selected overload for SQL: Create on overloaded functions by @AdityaBhosale22 in #4551

fix: preserve table column order in SQL->SQL exports by @bnquon in #4560

fix: restore table row delete shortcuts via config on macOS by @ylyra in #4556

Update prerequisites for creating a plugin by @Lucas-Tolle in #4574

Fix last used workspace, add author to connection and query tooltips by @azmy60 in #4578

Directory import by @not-night-but in #4571

Tree list for connections and queries by @azmy60 in #4502

Merge rc-60 into master by @github-actions[bot] in #4579

Update database support: Snowflake to full support, add SAP HANA by @rathboma in #4581

Enhance plugin views documentation with view types reference by @Lucas-Tolle in #4597

Enhance setDebugComms documentation by @Lucas-Tolle in #4596

fix: re-fetch table columns on manual table refresh to reflect renames by @YuriNachos in #4590

fix(table): use filtered count when jumping to last page by @ylyra in #4599

fix polling by @azmy60 in #4584

fix quick search connections and queries by @azmy60 in #4582

only poll cloud modules on the screen that shows them by @azmy60 in #4586

fix saving query payload and poll saved query by @not-night-but in #4588

fix tooltip display by @not-night-but in #4591

fix recursive import to local workspace by @not-night-but in #4593

add "no items" state to the folder by @azmy60 in #4587

fix new folder cleared by poll by @azmy60 in #4602

Polling breaks filtering by @azmy60 in #4603

Prevent users from restoring a version when there are pending remote by @azmy60 in #4604

fix save query title and folder by @not-night-but in #4605

Fix for being unable to close tabs by @rathboma in #4608

Fix import from local workspace modals by @not-night-but in #4609

skip .git folder in import by @not-night-but in #4615

fix query polling on mount if not active by @not-night-but in #4617

fix(deps): bump sql-query-identifier to ^3.2.0 for Postgres dollar-quote splitting by @YuriNachos in #4592

chore(deps): bump js-yaml from 3.15.0 to 3.15.1 by @dependabot[bot] in #4614

fix(editor): show hours field at exactly one hour in query elapsed timer by @YuriNachos in #4612

chore(deps): bump dompurify from 3.4.12 to 3.4.13 by @dependabot[bot] in #4601

chore(deps): bump nanoid from 3.3.12 to 3.3.18 by @dependabot[bot] in #4618

show error alert instead of "no items" by @azmy60 in #4610

rc-60 by @azmy60 in #4611

fix(json-viewer): escape regex metacharacters when locating keys by path by @YuriNachos in #4613

use title instead of v-tooltip to fix tree sidebar overflow by @azmy60 in #4619

chore(deps-dev): bump electron from 39.8.5 to 39.8.10 by @dependabot[bot] in #4580

New Contributors

@muhammadusamahoyrr made their first contribution in #4498

@deeferentleeg made their first contribution in #4510

@manos02 made their first contribution in #4507

@AnandaBintang made their first contribution in #4532

@kice made their first contribution in #4543

@mazzoccantelorenzo made their first contribution in #4504

@drannonymousxx made their first contribution in #4544

@jasonnutter made their first contribution in #4538

@bnquon made their first contribution in #4559

@ylyra made their first contribution in #4547

@cynicalmindset made their first contribution in #4562

@cleven12 made their first contribution in #4555

@AdityaBhosale22 made their first contribution in #4551

@Lucas-Tolle made their first contribution in #4574

@YuriNachos made their first contribution in #4590

Full Changelog: v5.9.3...v6.0.0

Original source