github beekeeper-studio/beekeeper-studio v5.0.6
Beekeeper Studio 5.0

latest releases: v5.0.8, v5.0.7
4 days ago

Wow, a big day for Beekeeper Studio! Our first 5.x release.

release-5-json

The Beekeeper Studio team has been working since May on a massive upgrade of the Beekeeper Studio application to improve security and package compatibility, the culmination of those months of work is the 5.0 release.

This release doesn't just contain technical improvements though, there are a lot of changes and improvements to the app.

Highlights

One App To Rule Them All

Previously we had two versions of Beekeeper Studio - the Community Edition, and the Ultimate Edition. Now we just have one app, it's just called Beekeeper Studio. All the code is in our GitHub repository.

The premium features are still there -- but rather than downloading a separate application, you can now pay for premium features in-app.

Back in the olden times of 2022 I launched the Ultimate edition as a separate app because it was an easy way for me to see if paid features would help make the business sustainable.

However forking the app into two editions introduced many problems:

  1. Managing the development of two separate editions was hard and caused bugs.
  2. Having two editions was confusing to a lot of people.
  3. Moving between editions was really difficult for end users.

Whichever version of Beekeeper Studio you are on, you'll get upgraded to the new Unified version once 5.0 is released, and everything should 'just work'

View Rows As JSON

Introducing the JSON Detail View that shows the currently selected row as JSON.

release-5-json

The JSON Detail View also provides some quality of life features like an in-line foreign key data viewer, and a persistent field search.

Together this makes it much easier to scan and process very wide, or very complex data.

ClickHouse

An often-requested feature is ClickHouse compatibility. We're happy to introduce this for v5 of Beekeeper Studio.

Most Beekeeper Studio features are supported by the ClickHouse driver, so enjoy features like the JSON Detail View right away.

Amazon IAM Authentication for PostgreSQL and MySQL Connections

Many users have Amazon hosted databases with credentials tied to specific IAM profiles. Previously these were impossible to connect-to using Beekeeper Studio, but V5 provides the ability to use IAM credentials using a credentials file.

This feature is in Beta, but it works and is stable. We'll be expanding our IAM support over the coming months.

Major performance improvements

As part of hardening the application we moved database operations to a dedicated utility process. This frees up the renderer process (the UI JavaScript) for UI-only tasks, which makes the app feel 5x faster in many places.

This was a huge undertaking, but the result is a faster, more secure, and more extensible Beekeeper Studio.

Other features and notable changes

  1. Quick filters - right click a value and 'quick filter' the table by that value.
  2. We upgraded Electron to v31 (all the way from v18)
  3. Removed minimal mode, because it wasn't very good and kept breaking the app for folks by mistake
  4. No more native titlebars, these were totally busted in Electron 30+, so we're using our client-side menus only on Linux and Windows
  5. Imports use streams rather than reading everything into memory (where possible)
  6. Upgraded NodeJS to v20 to align with Electron
  7. SSH tunnel fixes
  8. Loads of minor bugfixes to everything from editor autofocus to range selection stability when scrolling

PRs Merged:
9e74c70 Merge pull request #2633 from beekeeper-studio/psql-ssl-fix
0a88c96 Merge pull request #2534 from ClarLabs/feat/aws-iam-support
38f92f5 Merge pull request #2606 from beekeeper-studio/dependabot/npm_and_yarn/cross-spawn-6.0.6
441d340 Merge pull request #2615 from beekeeper-studio/fix/switching-keymap
12f7470 Merge pull request #2611 from beekeeper-studio/fix/import-ui
2b67acb Merge pull request #2602 from beekeeper-studio/fix/release-channel-deb
5411d41 Merge pull request #2610 from beekeeper-studio/fix/identifier
93cf9ae Merge pull request #2608 from beekeeper-studio/fix/clickhouse-socket-timeout
e52c29f Merge pull request #2601 from beekeeper-studio/fix/modal-buttons
726b4c8 Merge pull request #2603 from beekeeper-studio/fix/double-conns-migration
2ec56ac Merge pull request #2555 from beekeeper-studio/fix/binary-columns
78cc46e Merge pull request #2537 from therealrinku/fix/edit-modal-overflow
aabadbf Merge pull request #2592 from beekeeper-studio/fix/url
dffcac1 Merge pull request #2590 from beekeeper-studio/fix/clickhouse-materialized-views
2f17ee6 Merge pull request #2593 from beekeeper-studio/fix/mat-views
c50259f Merge pull request #2589 from beekeeper-studio/fix/url-import
4ea06a6 Merge pull request #2588 from beekeeper-studio/fix/select-connection
e80f6c5 Merge pull request #2585 from beekeeper-studio/fix/tab-query-focus
174e0a9 Merge pull request #2584 from beekeeper-studio/fix/import-saved-queries
90a1420 Merge pull request #2583 from beekeeper-studio/fix/lightmode-json-viewer
e0baee1 Merge pull request #2580 from beekeeper-studio/fix/old-mysql-procedures
c151cfd Merge pull request #2554 from beekeeper-studio/fix/titlebar
f6b11ef Merge pull request #2566 from beekeeper-studio/fix/restore
d829ce6 Merge pull request #2567 from beekeeper-studio/fix/magics
464738c Merge pull request #2575 from beekeeper-studio/fix/default-ports
9dae329 Merge pull request #2576 from beekeeper-studio/fix/read-only-mode
631215b Merge pull request #2578 from beekeeper-studio/fix/bad-tooltip
0302543 Merge pull request #2579 from beekeeper-studio/fix/cockroach-iam
7ffd2ea Merge pull request #2558 from beekeeper-studio/fix/clickhouse-connection
99caac2 Merge pull request #2552 from beekeeper-studio/fix/text-editor-markers
b5773ab Merge branch 'master' of github.com:beekeeper-studio/beekeeper-studio
4bef006 Merge pull request #2541 from beekeeper-studio/fix/multi-window
11e8fd2 Merge pull request #2542 from beekeeper-studio/channel-version-fixes
9d503ca Merge pull request #2525 from beekeeper-studio/free-trial-upsell
382618f Merge pull request #2526 from beekeeper-studio/tabulator-debug-log
4b5a28a Merge pull request #2529 from beekeeper-studio/fix/text-editor-autofocus
4964a9a Merge pull request #2518 from beekeeper-studio/fix/workflows
33b0d4f Merge pull request #2517 from beekeeper-studio/fix/workspace-sign-in
d6f2be5 Merge pull request #2490 from beekeeper-studio/fix/titlebar
9fe755a Merge pull request #2382 from therealrinku/fix/query-editor-focus-lost
eb3e5cb Merge pull request #2488 from beekeeper-studio/fix/psql-int
87647bc Merge pull request #2487 from beekeeper-studio/community-detail-sidebar
bde8849 Merge pull request #2508 from beekeeper-studio/fix/detail-view-sidebar
d5c67cd Merge pull request #2507 from beekeeper-studio/one-platform-info-to-rule-them-all
d47667f Merge branch 'master' of github.com:beekeeper-studio/beekeeper-studio
52a433d Merge pull request #2454 from beekeeper-studio/fix/disable-minimal-mode
dd657ad Merge pull request #2411 from beekeeper-studio/feature/stream-imports
7a1c6fb Merge pull request #2463 from beekeeper-studio/feature/2176_Retain-Last-Workspace
05c8421 Merge pull request #2443 from beekeeper-studio/oneapp-workflows
879d41c Merge pull request #2458 from beekeeper-studio/dependabot/npm_and_yarn/rollup-4.22.4
7baf3bd Merge pull request #2472 from beekeeper-studio/feat/single-app-upgrade-flows
3e70feb Merge pull request #2477 from beekeeper-studio/feat/tabletable-sidebar
35b5c02 Merge pull request #2444 from beekeeper-studio/fix/multi-table-export
ee07c04 Merge pull request #2445 from beekeeper-studio/fix/result-table-goto
678f4b8 Merge pull request #2450 from beekeeper-studio/fix/query-editor
1d70e34 Merge pull request #2478 from beekeeper-studio/fix/add-database
bad966c Merge pull request #2345 from beekeeper-studio/feat/clickhouse
b4362da Merge pull request #2469 from beekeeper-studio/feat/single-app-upgrade-flows
e581fda Merge pull request #2436 from beekeeper-studio/feat/single-app-upgrade-flows
4ebd04d Merge pull request #2143 from beekeeper-studio/feature/2029_autocomplete-documentation
5ce9364 Merge pull request #2330 from ClarLabs/add-iam-authentication-support
84bce7b Merge pull request #2428 from bgb10/master
0bd1b3d Merge pull request #2437 from beekeeper-studio/fix/ultimate-bugs
e2ec33f Merge pull request #2441 from beekeeper-studio/dependabot/npm_and_yarn/vite-5.3.6
d97211c Merge branch 'community-4'
c8dc600 Merge pull request #2434 from skwent77/docs/node-version
cbb1c3a Merge pull request #2438 from beekeeper-studio/fix/single-table-export
cc41e11 Merge pull request #2440 from beekeeper-studio/fix/v5-workspaces
6ccdb32 Merge pull request #2427 from beekeeper-studio/quick-filters
35cec9c Merge pull request #2403 from therealrinku/fix/tab-shortcut
006c2b7 Merge pull request #2417 from luizfelipemacedo/master
afe8728 Merge pull request #2384 from beekeeper-studio/feature/1386_execution-time
796fe85 Merge pull request #2399 from beekeeper-studio/bugfix/table-icon
0b9251e Merge pull request #2398 from beekeeper-studio/fix/multi-range-selection-copy
8e97649 Merge pull request #2386 from beekeeper-studio/feat/tabletable-sidebar
e065e20 Merge pull request #2405 from beekeeper-studio/fix/stream-tests
1c69fd6 Merge pull request #2372 from beekeeper-studio/one-app-to-rule-them-all
77f7e4e Merge pull request #2394 from beekeeper-studio/dependabot/npm_and_yarn/micromatch-4.0.8
c115c62 Merge pull request #2400 from beekeeper-studio/fix/text-editor-search-bug
d00a67c Merge pull request #2381 from beekeeper-studio/fix-typeorm
01ca020 Merge pull request #2355 from beekeeper-studio/fix/read-file-sync
a8504c4 Merge pull request #2365 from beekeeper-studio/fix/missing-query-editor
24668e3 Merge pull request #2361 from beekeeper-studio/typeorm-upgrade
6214ec8 Merge pull request #2363 from beekeeper-studio/ssh-test-fix
7e5bcbd Merge pull request #2332 from beekeeper-studio/dependabot/npm_and_yarn/braces-3.0.3
507a67a Merge branch 'master' of github.com:beekeeper-studio/beekeeper-studio
ad5112a Merge pull request #2335 from beekeeper-studio/feat/loading-sso-modal-master
7483637 Merge pull request #2360 from beekeeper-studio/dependabot/npm_and_yarn/axios-1.7.4
663a190 Merge pull request #2334 from beekeeper-studio/electron-31
c3a5e26 Merge pull request #2351 from beekeeper-studio/platform-info-2.0-electric-boogaloo
3a343eb Merge pull request #2353 from beekeeper-studio/ci-testcontainers-fix
4ad4f21 Merge pull request #2352 from beekeeper-studio/fix/missing-setelementname
46f18f4 Merge pull request #2338 from beekeeper-studio/fix/sql-server-docker-health
7ac3a4c Merge pull request #2291 from beekeeper-studio/appdb-handlers
272ddc3 Merge pull request #2261 from beekeeper-studio/feature/import-scripts
5418ee0 Merge pull request #2304 from beekeeper-studio/feature/utilprocess-macos
143d95b Merge pull request #2218 from beekeeper-studio/utility-proc

Don't miss a new beekeeper-studio release

NewReleases is sending notifications on new releases.