v5.0.0-beta.2 - Detail sidebar, ClickHouse, and more
Pre-release
Wow, a big day for Beekeeper Studio! Our first 5.x release, and our first beta channel release.
The Beekeeper Studio team has been working since May on a massive refactor 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.
Please help us test the 5.0-beta
This is new for us, but the beta version of the app will allow us to isolate and mitigate any problems before we push the app into general availability.
Highlights
100% of Beekeeper Studio is now either open source, or source available
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
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.
The experiment was a great success, and thousands of developers have purchased an ultimate edition license (thank you if you are one of them!).
However forking the app into two editions introduced many problems:
- Managing the development of two separate editions was hard and caused bugs.
- Having two editions was confusing to a lot of people.
- 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.
View any database record in JSON
Introducing the JSON Detail View that shows selected database table record in JSON format.
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.
Connect To 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 Aurora on Amazon RDS
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 we'll also be bringing it to MySQL and Redshift in the coming weeks.
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
- We upgraded Electron to v31 (all the way from v18)
- Removed minimal mode, because it wasn't very good and kept breaking the app for folks by mistake
- No more native titlebars, these were totally busted in Electron 30+, so we're using our client-side menus only on Linux and Windows
- Imports use streams rather than reading everything into memory (where possible)
- Upgraded NodeJS to v20 to align with Electron
- SSH tunnel fixes
- Loads of minor bugfixes
Merged Pull Requests
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